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 pll,
73: po_lines pl,
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 pll,
138: po_lines pl,
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 pll,
216: po_lines pl,
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 pll,
286: po_lines pl,
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 pll,
368: po_lines pl,
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 pll,
433: po_lines pl,
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 pll,
511: po_lines pl,
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 pll,
581: po_lines pl,
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 947: -- rcv_shipment_lines rsl,

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

Line 1047: -- rcv_shipment_lines rsl,

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