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_LINES

Line 76: rcv_shipment_lines rsl,

72: po_line_locations_trx_v pll, -- CLM project, bug 9403291
73: po_lines_trx_v pl, -- CLM project, bug 9403291
74: -- Bug 3444226 The Join with po_headers is unnecessary
75: -- po_headers ph,
76: rcv_shipment_lines rsl,
77: (SELECT DISTINCT source_line_id
78: FROM wms_lpn_contents
79: WHERE parent_lpn_id = v_lpn_id) wlc
80: WHERE pll.po_line_id = Nvl(v_po_line_id, pll.po_line_id)

Line 141: rcv_shipment_lines rsl,

137: po_line_locations_trx_v pll, -- CLM project, bug 9403291
138: po_lines_trx_v pl, -- CLM project, bug 9403291
139: -- Bug 3444226 The Join with po_headers is unnecessary
140: -- po_headers ph,
141: rcv_shipment_lines rsl,
142: (SELECT DISTINCT source_line_id
143: FROM wms_lpn_contents
144: WHERE parent_lpn_id = v_lpn_id) wlc
145: WHERE pll.po_line_id = Nvl(v_po_line_id, pll.po_line_id)

Line 219: rcv_shipment_lines rsl,

215: po_line_locations_trx_v pll, -- CLM project, bug 9403291
216: po_lines_trx_v pl, -- CLM project, bug 9403291
217: -- Bug 3444226 The Join with po_headers is unnecessary
218: -- po_headers ph,
219: rcv_shipment_lines rsl,
220: (SELECT DISTINCT source_line_id
221: FROM wms_lpn_contents
222: WHERE parent_lpn_id = v_lpn_id) wlc
223: -- Bug 3444226 The condition with po_headers is unnecessary

Line 289: rcv_shipment_lines rsl,

285: po_line_locations_trx_v pll, -- CLM project, bug 9403291
286: po_lines_trx_v pl, -- CLM project, bug 9403291
287: -- Bug 3444226 The Join with po_headers is unnecessary
288: -- po_headers ph,
289: rcv_shipment_lines rsl,
290: (SELECT DISTINCT source_line_id
291: FROM wms_lpn_contents
292: WHERE parent_lpn_id = v_lpn_id) wlc
293: -- Bug 3444226 The Join with po_headers is unnecessary

Line 371: rcv_shipment_lines rsl,

367: po_line_locations_trx_v pll, -- CLM project, bug 9403291
368: po_lines_trx_v pl, -- CLM project, bug 9403291
369: -- Bug 3444226 The Join with po_headers is unnecessary
370: -- po_headers ph,
371: rcv_shipment_lines rsl,
372: (SELECT DISTINCT source_line_id
373: FROM wms_lpn_contents
374: WHERE parent_lpn_id = v_lpn_id) wlc
375: WHERE pll.po_line_id = Nvl(v_po_line_id, pll.po_line_id)

Line 436: rcv_shipment_lines rsl,

432: po_line_locations_trx_v pll, -- CLM project, bug 9403291
433: po_lines_trx_v pl, -- CLM project, bug 9403291
434: -- Bug 3444226 The Join with po_headers is unnecessary
435: -- po_headers ph,
436: rcv_shipment_lines rsl,
437: (SELECT DISTINCT source_line_id
438: FROM wms_lpn_contents
439: WHERE parent_lpn_id = v_lpn_id) wlc
440: WHERE pll.po_line_id = Nvl(v_po_line_id, pll.po_line_id)

Line 514: rcv_shipment_lines rsl,

510: po_line_locations_trx_v pll, -- CLM project, bug 9403291
511: po_lines_trx_v pl, -- CLM project, bug 9403291
512: -- Bug 3444226 The Join with po_headers is unnecessary
513: -- po_headers ph,
514: rcv_shipment_lines rsl,
515: (SELECT DISTINCT source_line_id
516: FROM wms_lpn_contents
517: WHERE parent_lpn_id = v_lpn_id) wlc
518: -- Bug 3444226 The condition with po_headers is unnecessary

Line 584: rcv_shipment_lines rsl,

580: po_line_locations_trx_v pll, -- CLM project, bug 9403291
581: po_lines_trx_v pl, -- CLM project, bug 9403291
582: -- Bug 3444226 The Join with po_headers is unnecessary
583: -- po_headers ph,
584: rcv_shipment_lines rsl,
585: (SELECT DISTINCT source_line_id
586: FROM wms_lpn_contents
587: WHERE parent_lpn_id = v_lpn_id) wlc
588: -- Bug 3444226 The Join with po_headers is unnecessary

Line 953: -- rcv_shipment_lines rsl,

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
957: -- AND ph.po_header_id = header_id

Line 1053: -- rcv_shipment_lines rsl,

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
1057: -- AND ph.po_header_id = header_id

Line 2192: rcv_shipment_lines rsl

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')
2196: AND rsl.po_line_location_id = x_shipmentdistributionrec.line_location_id;