ITEM ONHAND QUANTITY DETAILS QUERY

This query is used to identify the item details

SELECT MOQ.INVENTORY_ITEN_ID ITEM_ID
               MSI.DESCRIPTION,
               SUM(MOQ.TRANSACTION_QUANTOTY) TRMQTY
FROM MTL_MATERIAL_TRANSACTIONS MOQ.
            MTL_SYSTEM_ITEMS MSI
WHERE
              MOQ.INVENTORY_ITEM_ID=MSI.INVENTORY_ITEM_ID
AND
              MOQ.ORGANIZATION_ID=MSI.ORGANIZATION_ID
GROUP BY
                     MOQ.INVENTORY_ITEM_ID,MSI.DESCRIPTION
ORDER BY 1;