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 PO_HEADERS

Line 74: -- Bug 3444226 The Join with po_headers is unnecessary

70: , pl.item_revision --only needed for std_deliver
71: FROM
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

Line 75: -- po_headers ph,

71: FROM
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

Line 139: -- Bug 3444226 The Join with po_headers is unnecessary

135: SELECT COUNT(*)
136: FROM
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

Line 140: -- po_headers ph,

136: FROM
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

Line 217: -- Bug 3444226 The Join with po_headers is unnecessary

213: , pl.item_revision --only needed for std_deliver
214: FROM
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

Line 218: -- po_headers ph,

214: FROM
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

Line 223: -- Bug 3444226 The condition with po_headers is unnecessary

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
224: -- WHERE ph.po_header_id = header_id
225: WHERE pll.po_header_id = header_id
226: AND pll.po_line_id = Nvl(v_po_line_id, pll.po_line_id)
227: AND pll.line_location_id = Nvl(v_po_line_location_id, pll.line_location_id)

Line 287: -- Bug 3444226 The Join with po_headers is unnecessary

283: SELECT COUNT(*)
284: FROM
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

Line 288: -- po_headers ph,

284: FROM
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

Line 293: -- Bug 3444226 The Join with po_headers is unnecessary

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
294: -- WHERE ph.po_header_id = header_id
295: WHERE pll.po_header_id = header_id
296: AND pll.po_line_id = Nvl(v_po_line_id, pll.po_line_id)
297: AND pll.line_location_id = Nvl(v_po_line_location_id, pll.line_location_id)

Line 369: -- Bug 3444226 The Join with po_headers is unnecessary

365: , pl.item_revision --only needed for std_deliver
366: FROM
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

Line 370: -- po_headers ph,

366: FROM
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

Line 434: -- Bug 3444226 The Join with po_headers is unnecessary

430: SELECT COUNT(*)
431: FROM
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

Line 435: -- po_headers ph,

431: FROM
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

Line 512: -- Bug 3444226 The Join with po_headers is unnecessary

508: , pl.item_revision --only needed for std_deliver
509: FROM
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

Line 513: -- po_headers ph,

509: FROM
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

Line 518: -- Bug 3444226 The condition with po_headers is unnecessary

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
519: -- WHERE ph.po_header_id = header_id
520: WHERE pll.po_header_id = header_id
521: AND pll.po_line_id = Nvl(v_po_line_id, pll.po_line_id)
522: AND pll.line_location_id = Nvl(v_po_line_location_id, pll.line_location_id)

Line 582: -- Bug 3444226 The Join with po_headers is unnecessary

578: SELECT COUNT(*)
579: FROM
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

Line 583: -- po_headers ph,

579: FROM
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

Line 588: -- Bug 3444226 The Join with po_headers is unnecessary

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
589: -- WHERE ph.po_header_id = header_id
590: WHERE pll.po_header_id = header_id
591: AND pll.po_line_id = Nvl(v_po_line_id, pll.po_line_id)
592: AND pll.line_location_id = Nvl(v_po_line_location_id, pll.line_location_id)

Line 667: -- Bug 3444226 The Join with po_headers is unnecessary

663: -- For Bug 7440217
664: , mtl_parameters mp,
665: rcv_parameters rp
666: -- End for Bug 7440217
667: -- Bug 3444226 The Join with po_headers is unnecessary
668: -- po_headers_all ph
669: -- where ph.po_header_id = header_id
670: where pll.po_header_id = header_id
671: -- For Bug 7440217

Line 668: -- po_headers_all ph

664: , mtl_parameters mp,
665: rcv_parameters rp
666: -- End for Bug 7440217
667: -- Bug 3444226 The Join with po_headers is unnecessary
668: -- po_headers_all ph
669: -- where ph.po_header_id = header_id
670: where pll.po_header_id = header_id
671: -- For Bug 7440217
672: AND mp.organization_id = v_organization_id

Line 817: po_headers ph

813: ,pl.item_revision --only needed for std_deliver
814: from po_distributions pod,
815: po_line_locations pll,
816: po_lines pl,
817: po_headers ph
818: where ph.po_header_id = header_id
819: and pod.po_header_id = header_id
820: AND pod.po_line_id = Nvl(v_po_line_id, pod.po_line_id)
821: AND pod.line_location_id = Nvl(v_po_line_location_id, pod.line_location_id)

Line 943: -- Bug 3444226 The Join with po_headers is unnecessary

939: ,rs.item_revision
940: from po_distributions pod,
941: po_line_locations pll,
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,

Line 944: -- po_headers ph,

940: from po_distributions pod,
941: po_line_locations pll,
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

Line 950: -- Bug 3444226 The Join with po_headers is unnecessary

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
952: AND pod.po_line_id = Nvl(v_po_line_id, pod.po_line_id)
953: AND pod.line_location_id = Nvl(v_po_line_location_id, pod.line_location_id)
954: AND pod.po_distribution_id = Nvl(v_po_distribution_id, pod.po_distribution_id)

Line 1043: -- Bug 3444226 The Join with po_headers is unnecessary

1039: SELECT count(*)
1040: FROM po_distributions pod,
1041: po_line_locations pll,
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,

Line 1044: -- po_headers ph,

1040: FROM po_distributions pod,
1041: po_line_locations pll,
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

Line 1050: -- Bug 3444226 The Join with po_headers is unnecessary

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
1052: AND pod.po_line_id = Nvl(v_po_line_id, pod.po_line_id)
1053: AND pod.line_location_id = Nvl(v_po_line_location_id, pod.line_location_id)
1054: AND pod.po_distribution_id = Nvl(v_po_distribution_id, pod.po_distribution_id)