APPS.POR_RCV_TRANSACTION_SV dependencies on RCV_SHIPMENT_HEADERS

Line 748: rcv_shipment_headers rh,

744: rt.job_id,
745: pol.matching_basis
746: from rcv_transactions rt,
747: rcv_shipment_lines rl,
748: rcv_shipment_headers rh,
749: mtl_system_items msi,
750: po_Lines_all pol
751: where transaction_id = p_parent_transaction_id
752: and rt.shipment_line_id = rl.shipment_line_id

Line 802: rcv_shipment_headers rsh,

798: CURSOR c_req_shipment (c_req_line_id NUMBER) IS
799: SELECT
800: rsh.shipment_num, rsh.shipment_header_id
801: FROM
802: rcv_shipment_headers rsh,
803: rcv_shipment_lines rsl
804: WHERE
805: rsh.shipment_header_id = rsl.shipment_header_id and
806: rsl.requisition_line_id = c_req_line_id;

Line 812: rcv_shipment_headers rsh,

808: CURSOR c_po_shipment (c_line_location_id NUMBER) IS
809: SELECT
810: rsh.shipment_num, rsh.shipment_header_id
811: FROM
812: rcv_shipment_headers rsh,
813: rcv_shipment_lines rsl
814: WHERE
815: rsh.shipment_header_id = rsl.shipment_header_id and
816: rsl.po_line_location_id = c_line_location_id and