92: FROM rcv_shipment_lines rsl,
93: rcv_shipment_headers rsh,
94: po_headers_all poh,
95: po_lines_all pol,
96: po_line_types_b plb
97: WHERE
98: rsh.shipment_header_id = p_shipment_header_id
99: AND (rsl.shipment_line_id = p_shipment_line_id OR p_shipment_line_id IS NULL)
100: AND rsl.shipment_header_id = rsh.shipment_header_id