INV - Inventory On Hand

SELECT 
     si.inventory_item_id, 
     si.item_number, 
     si.organization_id, 
     inv.organization_code, 
     si.enabled_flag, 
     si.end_date_active, 
     ohq.transaction_quantity ON_HAND 
 FROM 
     fusion.EGP_SYSTEM_ITEMS_B si, 
     fusion.INV_ORG_PARAMETERS inv, 
     fusion.INV_ONHAND_QUANTITIES_DETAIL ohq 
 WHERE 
     inv.organization_id = si.organization_id 
     AND inv.organization_id = ohq.organization_id 
     AND si.inventory_item_id = ohq.inventory_item_id 
     AND si.item_number LIKE 'AS54888%';