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_LINES

Line 73: po_lines pl,

69: , 0 rcv_transaction_id -- only need it for std_deliver
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

Line 138: po_lines pl,

134: IS
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

Line 216: po_lines pl,

212: , 0 rcv_transaction_id -- only need it for std_deliver
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

Line 286: po_lines pl,

282: IS
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

Line 368: po_lines pl,

364: , 0 rcv_transaction_id -- only need it for std_deliver
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

Line 433: po_lines pl,

429: IS
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

Line 511: po_lines pl,

507: , 0 rcv_transaction_id -- only need it for std_deliver
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

Line 581: po_lines pl,

577: IS
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

Line 662: po_lines_all pl

658: , nvl(pll.enforce_ship_to_location_code,'NONE') enforce_ship_to_location_code
659: , 0 rcv_transaction_id -- only need it for std_deliver
660: , pl.item_revision --only needed for std_deliver
661: from po_line_locations_all pll,
662: po_lines_all pl
663: -- For Bug 7440217
664: , mtl_parameters mp,
665: rcv_parameters rp
666: -- End for Bug 7440217

Line 735: po_lines_all pl

731:
732: IS
733: SELECT COUNT(*)
734: from po_line_locations_all pll,
735: po_lines_all pl
736: -- For Bug 7440217
737: , mtl_parameters mp,
738: rcv_parameters rp
739: -- End for Bug 7440217

Line 816: po_lines pl,

812: ,0 rcv_transaction_id -- only need it for std_deliver
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)

Line 869: po_lines pl

865: , v_organization_id NUMBER) is
866: select count(*)
867: from po_distributions pod,
868: po_line_locations pll,
869: po_lines pl
870: where pll.po_header_id = header_id
871: AND pod.po_line_id = Nvl(v_po_line_id, pod.po_line_id)
872: AND pod.line_location_id = Nvl(v_po_line_location_id, pod.line_location_id)
873: AND pod.po_distribution_id = Nvl(v_po_distribution_id, pod.po_distribution_id)

Line 942: po_lines pl,

938: ,rs.rcv_transaction_id
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,

Line 1042: po_lines pl,

1038: , v_organization_id NUMBER) IS
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,

Line 1153: po_lines pl,

1149: ,rs.rcv_transaction_id
1150: ,rs.item_revision
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'

Line 1240: po_lines pl,

1236: , v_organization_id NUMBER) IS
1237: SELECT count(*)
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'