eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_RCV_TXN_INTERFACE dependencies on RCV_SHIPMENT_HEADERS

Line 952: rcv_shipment_headers rsh,

948: po_lines_trx_v pl, -- CLM project, bug 9403291
949: -- Bug 3444226 The Join with po_headers is unnecessary
950: -- po_headers ph,
951: rcv_supply rs,
952: rcv_shipment_headers rsh,
953: -- rcv_shipment_lines rsl,
954: rcv_transactions rt
955: where rsh.receipt_source_code = 'VENDOR'
956: -- Bug 3444226 The Join with po_headers is unnecessary

Line 1052: rcv_shipment_headers rsh,

1048: po_lines_trx_v pl, -- CLM project, bug 9403291
1049: -- Bug 3444226 The Join with po_headers is unnecessary
1050: -- po_headers ph,
1051: rcv_supply rs,
1052: rcv_shipment_headers rsh,
1053: -- rcv_shipment_lines rsl,
1054: rcv_transactions rt
1055: where rsh.receipt_source_code = 'VENDOR'
1056: -- Bug 3444226 The Join with po_headers is unnecessary

Line 1161: rcv_shipment_headers rsh,

1157: from po_distributions_trx_v pod, -- CLM project, bug 9403291
1158: po_line_locations_trx_v pll, -- CLM project, bug 9403291
1159: po_lines_trx_v pl, -- CLM project, bug 9403291
1160: rcv_supply rs,
1161: rcv_shipment_headers rsh,
1162: rcv_transactions rt
1163: where rsh.receipt_source_code = 'VENDOR'
1164: AND pod.po_line_id = Nvl(v_po_line_id, pod.po_line_id)
1165: AND pod.line_location_id = Nvl(v_po_line_location_id, pod.line_location_id)

Line 1248: rcv_shipment_headers rsh,

1244: FROM po_distributions_trx_v pod, -- CLM project, bug 9403291
1245: po_line_locations_trx_v pll, -- CLM project, bug 9403291
1246: po_lines_trx_v pl, -- CLM project, bug 9403291
1247: rcv_supply rs,
1248: rcv_shipment_headers rsh,
1249: rcv_transactions rt
1250: where rsh.receipt_source_code = 'VENDOR'
1251: AND pod.po_line_id = Nvl(v_po_line_id, pod.po_line_id)
1252: AND pod.line_location_id = Nvl(v_po_line_location_id, pod.line_location_id)

Line 1478: FROM RCV_SHIPMENT_HEADERS

1474: -- For Bug 7440217 Checking if doc is not LCM
1475: IF (p_shipment_header_id IS NOT NULL) THEN -- matching is called from ASN shipment matching
1476: SELECT ASN_TYPE
1477: INTO l_asn_type
1478: FROM RCV_SHIPMENT_HEADERS
1479: WHERE SHIPMENT_HEADER_ID = p_shipment_header_id;
1480: END IF;
1481: -- End for Bug 7440217
1482: IF l_asn_type = 'ASN' THEN

Line 2191: FROM rcv_shipment_headers rsh,

2187: AND (x_cascaded_table(n).shipment_header_id is null)) THEN
2188:
2189: SELECT COUNT(*)
2190: INTO l_asn_count
2191: FROM rcv_shipment_headers rsh,
2192: rcv_shipment_lines rsl
2193: WHERE rsh.shipment_header_id = rsl.shipment_header_id
2194: AND NVL(rsh.asn_type, 'STD') IN ('ASN','ASBN')
2195: AND NVL(rsl.shipment_line_status_code, 'EXPECTED') NOT IN('CANCELLED', 'FULLY RECEIVED')