SELECT esi.inventory_item_id
,esi.item_number
,esi.organization_id
,iop.organization_code
,esi.description
,uomt.unit_of_measure
,esi.item_type
,esi.enabled_flag
,esi.planner_code planner
,esi.safety_stock_planning_method
FROM inv_org_parameters iop
,egp_system_items esi
,inv_units_of_measure_tl uomt
,inv_units_of_measure_b uomb
WHERE 1=1
AND iop.organization_id = esi.organization_id
AND uomb.uom_code = esi.primary_uom_code
AND uomt.unit_of_measure_id (+)= uomb.unit_of_measure_id
AND uomt.language = 'US'
AND esi.item_number = 'ITEM_NUM_001'
