2486: IS
2487: SELECT 1
2488: FROM po_distributions_all pda,
2489: rcv_shipment_lines rsl,
2490: po_headers_all pha
2491: where pha.po_header_id = rsl.po_header_id
2492: and pda.po_header_id = pha.po_header_id
2493: and rsl.shipment_line_id = cp_shipment_line_id
2494: and rsl.shipment_header_id = cp_shipment_header_id