Query for onhand quantity in inventory in oracle apps

Query for onhand quantity in inventory in oracle apps

 

In this post , We will discuss about query to find onhand quantity in oracle apps r12. This is the complete query for onhand quantity in inventory in oracle apps.

SQL query for onhand quantity in inventory in oracle apps.

SELECT

 msib.segment1 item_code  ,

                moqd.SUBINVENTORY_CODE

,moqd.LOCATOR_ID

 ,SUM(moqd.TRANSACTION_QUANTITY)  onhand_quantity ,

                milkfv.CONCATENATED_SEGMENTS LOCATORS      

           FROM APPS.MTL_SYSTEM_ITEMS_B msib,

                APPS.MTL_ONHAND_QUANTITIES_DETAIL moqd ,

                APPS.mtl_item_locations_kfv milkfv

          WHERE msib.organization_id = 910

            and msib.INVENTORY_ITEM_ID = moqd.INVENTORY_ITEM_ID

            AND MSIB.ORGANIZATION_ID =MOQD.ORGANIZATION_ID

         and moqd.SUBINVENTORY_CODE = :P_SUBINVENTORY

           AND milkfv.INVENTORY_LOCATION_ID = moqd.LOCATOR_ID

          AND MSIB.SEGMENT1 = :P_ITEM

            GROUP BY MSIB.SEGMENT1,MOQD.SUBINVENTORY_CODE,MILKFV.CONCATENATED_SEGMENTS;