SELECT MSI.SEGMENT1, MOQ.TRANSACTION_QUANTITY, MOQ.SUBINVENTORY_CODE, MIL.SEGMENT1||’.’||MIL.SEGMENT2||’.’||MIL.SEGMENT3||’.’||MIL.SEGMENT4 ITEM_LOCATOR_NAME
FROM APPS.MTL_SYSTEM_ITEMS_B MSI,
APPS.MTL_ONHAND_QUANTITIES MOQ,
APPS.MTL_ITEM_LOCATIONS MIL
WHERE MSI.INVENTORY_ITEM_ID = MOQ.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = MOQ.ORGANIZATION_ID
AND MOQ.INVENTORY_ITEM_ID = MIL.INVENTORY_ITEM_ID
AND MOQ.ORGANIZATION_ID = MIL.ORGANIZATION_ID
AND MOQ.LOCATOR_ID = MIL.INVENTORY_LOCATION_ID
AND MSI.INVENTORY_ITEM_ID IN ();