SELECT
si.secondary_inventory_name     subinv, 
si.description                         subinv_desc,
msi.description            item_description,
moh.revision                item_revision, 
moh.locator_id             locator_id,
msi.inventory_item_id        item_id,
msi.primary_uom_code      uom_code, 
nvl(moh.transaction_quantity,0)  item_qty
FROM 
   MTL_SYSTEM_ITEMS            msi,   
   MTL_ONHAND_QUANTITIES moh,
   MTL_SECONDARY_INVENTORIES si,
   MTL_ITEM_LOCATIONS mil
WHERE 
si.secondary_inventory_name = moh.subinventory_code(+)
and si.organization_id = moh.organization_id (+)
and moh.organization_id = msi.organization_id(+)
and moh.inventory_item_id = msi.inventory_item_id (+)
and moh.locator_id = mil.inventory_location_id(+) 
and moh.organization_id = mil.organization_id(+)
and si.quantity_tracked = 1
and si.organization_id = 
and msi.inventory_item_id =
ORDER BY 
si.secondary_inventory_name