[Home] [Help]
1403: select
1404: ms.rowid
1405: , ms.intransit_owning_org_id
1406: from mtl_supply ms,
1407: rcv_shipment_headers rsh
1408: where rsh.shipment_num = l_shipment_number
1409: and ms.shipment_header_id = rsh.shipment_header_id
1410: and ms.supply_type_code = 'SHIPMENT'
1411: and ms.intransit_owning_org_id is not null