APPS.INV_RCV_TXN_INTERFACE dependencies on RCV_SHIPMENT_HEADERS

Line 946: rcv_shipment_headers rsh,

942: po_lines pl,
943: -- Bug 3444226 The Join with po_headers is unnecessary
944: -- po_headers ph,
945: rcv_supply rs,
946: rcv_shipment_headers rsh,
947: -- rcv_shipment_lines rsl,
948: rcv_transactions rt
949: where rsh.receipt_source_code = 'VENDOR'
950: -- Bug 3444226 The Join with po_headers is unnecessary

Line 1046: rcv_shipment_headers rsh,

1042: po_lines pl,
1043: -- Bug 3444226 The Join with po_headers is unnecessary
1044: -- po_headers ph,
1045: rcv_supply rs,
1046: rcv_shipment_headers rsh,
1047: -- rcv_shipment_lines rsl,
1048: rcv_transactions rt
1049: where rsh.receipt_source_code = 'VENDOR'
1050: -- Bug 3444226 The Join with po_headers is unnecessary

Line 1155: rcv_shipment_headers rsh,

1151: from po_distributions pod,
1152: po_line_locations pll,
1153: po_lines pl,
1154: rcv_supply rs,
1155: rcv_shipment_headers rsh,
1156: rcv_transactions rt
1157: where rsh.receipt_source_code = 'VENDOR'
1158: AND pod.po_line_id = Nvl(v_po_line_id, pod.po_line_id)
1159: AND pod.line_location_id = Nvl(v_po_line_location_id, pod.line_location_id)

Line 1242: rcv_shipment_headers rsh,

1238: FROM po_distributions pod,
1239: po_line_locations pll,
1240: po_lines pl,
1241: rcv_supply rs,
1242: rcv_shipment_headers rsh,
1243: rcv_transactions rt
1244: where rsh.receipt_source_code = 'VENDOR'
1245: AND pod.po_line_id = Nvl(v_po_line_id, pod.po_line_id)
1246: AND pod.line_location_id = Nvl(v_po_line_location_id, pod.line_location_id)

Line 1447: FROM RCV_SHIPMENT_HEADERS

1443: -- For Bug 7440217 Checking if doc is not LCM
1444: IF (p_shipment_header_id IS NOT NULL) THEN -- matching is called from ASN shipment matching
1445: SELECT ASN_TYPE
1446: INTO l_asn_type
1447: FROM RCV_SHIPMENT_HEADERS
1448: WHERE SHIPMENT_HEADER_ID = p_shipment_header_id;
1449: END IF;
1450: -- End for Bug 7440217
1451: IF l_asn_type = 'ASN' THEN