SQL Query to get Item Details in Oracle Fusion

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'