TO FIND THE ONHAND QUANTITY (INVENTORY)

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 = 110
            and msib.INVENTORY_ITEM_ID = moqd.INVENTORY_ITEM_ID
            AND MSIB.ORGANIZATION_ID =MOQD.ORGANIZATION_ID
         and moqd.SUBINVENTORY_CODE = 'ASRS-1'
           AND milkfv.INVENTORY_LOCATION_ID = moqd.LOCATOR_ID
          AND MSIB.SEGMENT1 = 'Z3NTCRS008002100297010'
            GROUP BY MSIB.SEGMENT1,MOQD.SUBINVENTORY_CODE,MILKFV.CONCATENATED_SEGMENTS