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_TRX_V

Line 73: po_lines_trx_v pl, -- CLM project, bug 9403291

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_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

Line 138: po_lines_trx_v pl, -- CLM project, bug 9403291

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

Line 216: po_lines_trx_v pl, -- CLM project, bug 9403291

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_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

Line 286: po_lines_trx_v pl, -- CLM project, bug 9403291

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

Line 368: po_lines_trx_v pl, -- CLM project, bug 9403291

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_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

Line 433: po_lines_trx_v pl, -- CLM project, bug 9403291

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

Line 511: po_lines_trx_v pl, -- CLM project, bug 9403291

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_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

Line 581: po_lines_trx_v pl, -- CLM project, bug 9403291

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

Line 663: po_lines_trx_v pl -- CLM project, bug 9403291

659: , nvl(pll.enforce_ship_to_location_code,'NONE') enforce_ship_to_location_code
660: , 0 rcv_transaction_id -- only need it for std_deliver
661: , pl.item_revision --only needed for std_deliver
662: from po_line_locations_trx_v pll, -- CLM project, bug 9403291
663: po_lines_trx_v pl -- CLM project, bug 9403291
664: -- For Bug 7440217
665: , mtl_parameters mp,
666: rcv_parameters rp
667: -- End for Bug 7440217

Line 737: po_lines_trx_v pl -- CLM project, bug 9403291

733:
734: IS
735: SELECT COUNT(*)
736: from po_line_locations_trx_v pll, -- CLM project, bug 9403291
737: po_lines_trx_v pl -- CLM project, bug 9403291
738: -- For Bug 7440217
739: , mtl_parameters mp,
740: rcv_parameters rp
741: -- End for Bug 7440217

Line 820: po_lines_trx_v pl, -- CLM project, bug 9403291

816: ,0 rcv_transaction_id -- only need it for std_deliver
817: ,pl.item_revision --only needed for std_deliver
818: from po_distributions_trx_v pod, -- CLM project, bug 9403291
819: po_line_locations_trx_v pll, -- CLM project, bug 9403291
820: po_lines_trx_v pl, -- CLM project, bug 9403291
821: po_headers_trx_v ph -- CLM project, bug 9403291
822: where ph.po_header_id = header_id
823: and pod.po_header_id = header_id
824: AND pod.po_line_id = Nvl(v_po_line_id, pod.po_line_id)

Line 875: po_lines_trx_v pl -- CLM project, bug 9403291

871: , v_organization_id NUMBER) is
872: select count(*)
873: from po_distributions_trx_v pod, -- CLM project, bug 9403291
874: po_line_locations_trx_v pll, -- CLM project, bug 9403291
875: po_lines_trx_v pl -- CLM project, bug 9403291
876: where pll.po_header_id = header_id
877: AND pod.po_line_id = Nvl(v_po_line_id, pod.po_line_id)
878: AND pod.line_location_id = Nvl(v_po_line_location_id, pod.line_location_id)
879: AND pod.po_distribution_id = Nvl(v_po_distribution_id, pod.po_distribution_id)

Line 948: po_lines_trx_v pl, -- CLM project, bug 9403291

944: ,rs.rcv_transaction_id
945: ,rs.item_revision
946: from po_distributions_trx_v pod, -- CLM project, bug 9403291
947: po_line_locations_trx_v pll, -- CLM project, bug 9403291
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,

Line 1048: po_lines_trx_v pl, -- CLM project, bug 9403291

1044: , v_organization_id NUMBER) IS
1045: SELECT count(*)
1046: FROM po_distributions_trx_v pod, -- CLM project, bug 9403291
1047: po_line_locations_trx_v pll, -- CLM project, bug 9403291
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,

Line 1159: po_lines_trx_v pl, -- CLM project, bug 9403291

1155: ,rs.rcv_transaction_id
1156: ,rs.item_revision
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'

Line 1246: po_lines_trx_v pl, -- CLM project, bug 9403291

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