437: and rsl.asn_lpn_id = lpn.lpn_id
438: AND rsh.asn_type = 'ASN'
439: ) all_lpn
440: , po_headers_all pha
441: , po_lines_all pol
442: , rcv_shipment_headers rsh
443: , po_line_locations_all pll
444: WHERE pha.po_header_id(+) = all_lpn.po_header_id
445: AND rsh.shipment_header_id(+) = all_lpn.shipment_header_id