ECC Inventory Management, Inventory Trace Inbound and On-Hand

select
x.*
from
(
 SELECT * FROM (SELECT  /*+ leading(map,mstl) use_nl(map mstl) cardinality(map 10) index(map) */ ecc_spec_id
      , map.item_id
      , map.organization_id
      , lot_number
      , item_inbound
      , item_receiving
      , lot_receiving
      , item_onhand
      , lot_onhand
      , item
      , mstl.description item_description
      , supplier_lot_number
      , vendor_name
      , flv2.meaning document_type
      , hu.name organization_name
      , lot_control_code
      , transaction_id
      , organization_code
      , onhand_enable
      , lot_receiving_enable
      , hu.language
FROM    inv_ecc_inboundonhand_map map
      , mtl_system_items_tl mstl
      , hr_all_organization_units_tl hu
      , fnd_lookup_values flv1
      , fnd_lookup_values flv2
WHERE   map.item_id = mstl.inventory_item_id
AND     map.organization_id = mstl.organization_id
AND     map.organization_id = hu.organization_id
AND     hu.language in ('US')
AND     hu.language = mstl.language
AND     flv1.lookup_type = 'INV_ECC_TRACK_TRACE_NODETYPE'
AND     flv1.view_application_id = 700
AND     flv1.meaning = map.document_type
AND     flv1.language = 'US'
AND     mstl.organization_id = nvl('',mstl.organization_id)
AND     flv2.lookup_type = 'INV_ECC_TRACK_TRACE_NODETYPE'
AND     flv2.view_application_id = 700
AND     flv2.lookup_code = flv1.lookup_code
AND     flv2.language = hu.language
AND     map.process_flag='N')
  PIVOT (
                        MAX ( ITEM_DESCRIPTION ) AS ITEM_DESCRIPTION , MAX( DOCUMENT_TYPE) AS DOCUMENT_TYPE   , MAX(ORGANIZATION_NAME) AS ORGANIZATION_NAME
						FOR language  IN ('US' "US")) 
) x
where
2=2