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_DISTRIBUTIONS_TRX_V

Line 108: ( select pod.line_location_id from po_distributions_trx_v pod -- CLM project, bug 9403291

104: 2,
105: 1)
106: )
107: AND pll.line_location_id in
108: ( select pod.line_location_id from po_distributions_trx_v pod -- CLM project, bug 9403291
109: where (v_project_id is null or
110: (v_project_id = -9999 and pod.project_id is null) or --Bug# 2669021
111: pod.project_id = v_project_id
112: )

Line 174: from po_distributions_trx_v pod -- CLM project, bug 9403291

170: 1)
171: )
172: AND pll.line_location_id in
173: ( select pod.line_location_id
174: from po_distributions_trx_v pod -- CLM project, bug 9403291
175: where ( v_project_id is null or
176: (v_project_id = -9999 and pod.project_id is null) or --Bug# 2669021
177: pod.project_id = v_project_id
178: )

Line 255: from po_distributions_trx_v pod -- CLM project, bug 9403291

251: 1)
252: )
253: AND pll.line_location_id in
254: ( select pod.line_location_id
255: from po_distributions_trx_v pod -- CLM project, bug 9403291
256: where ( v_project_id is null or
257: (v_project_id = -9999 and pod.project_id is null) or --Bug# 2669021
258: pod.project_id = v_project_id
259: )

Line 325: from po_distributions_trx_v pod -- CLM projrect, bug 9403291

321: 1)
322: )
323: AND pll.line_location_id in
324: ( select pod.line_location_id
325: from po_distributions_trx_v pod -- CLM projrect, bug 9403291
326: where ( v_project_id is null or
327: (v_project_id = -9999 and pod.project_id is null) or --Bug# 2669021
328: pod.project_id = v_project_id
329: )

Line 403: ( select pod.line_location_id from po_distributions_trx_v pod -- CLM project, bug 9403291

399: 2,
400: 1)
401: )
402: AND pll.line_location_id in
403: ( select pod.line_location_id from po_distributions_trx_v pod -- CLM project, bug 9403291
404: where (v_project_id is null or
405: (v_project_id = -9999 and pod.project_id is null) or --Bug# 2669021
406: pod.project_id = v_project_id
407: )

Line 469: from po_distributions_trx_v pod -- CLM project, bug 9403291

465: 1)
466: )
467: AND pll.line_location_id in
468: ( select pod.line_location_id
469: from po_distributions_trx_v pod -- CLM project, bug 9403291
470: where ( v_project_id is null or
471: (v_project_id = -9999 and pod.project_id is null) or --Bug# 2669021
472: pod.project_id = v_project_id
473: )

Line 550: from po_distributions_trx_v pod -- CLM project, bug 9403291

546: 1)
547: )
548: AND pll.line_location_id in
549: ( select pod.line_location_id
550: from po_distributions_trx_v pod -- CLM project, bug 9403291
551: where ( v_project_id is null or
552: (v_project_id = -9999 and pod.project_id is null) or --Bug# 2669021
553: pod.project_id = v_project_id
554: )

Line 620: from po_distributions_trx_v pod -- CLM project, bug 9403291

616: 1)
617: )
618: AND pll.line_location_id in
619: ( select pod.line_location_id
620: from po_distributions_trx_v pod -- CLM project, bug 9403291
621: where ( v_project_id is null or
622: (v_project_id = -9999 and pod.project_id is null) or --Bug# 2669021
623: pod.project_id = v_project_id
624: )

Line 708: from po_distributions_trx_v pod -- CLM project, bug 9403291

704: 1)
705: )
706: AND pll.line_location_id in
707: ( select pod.line_location_id
708: from po_distributions_trx_v pod -- CLM project, bug 9403291
709: where (v_project_id is null
710: or ((v_project_id = -9999 and pod.project_id is null)--Bug# 2669021
711: or (nvl(pod.project_id,-99) = v_project_id )))
712: and (v_task_id is null or nvl(pod.task_id,-9999) = v_task_id)

Line 780: from po_distributions_trx_v pod -- CLM project, bug 9403291

776: 1)
777: )
778: AND pll.line_location_id in
779: ( select pod.line_location_id
780: from po_distributions_trx_v pod -- CLM project, bug 9403291
781: where (v_project_id is null
782: or ((v_project_id = -9999 and pod.project_id is null)--Bug# 2669021
783: or (nvl(pod.project_id,-99) = v_project_id )))
784: and (v_task_id is null or nvl(pod.task_id,-9999) = v_task_id)

Line 818: from po_distributions_trx_v pod, -- CLM project, bug 9403291

814: ,pll.ship_to_location_id
815: ,nvl(pll.enforce_ship_to_location_code,'NONE') enforce_ship_to_location_code
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

Line 873: from po_distributions_trx_v pod, -- CLM project, bug 9403291

869: , v_project_id NUMBER
870: , v_task_id NUMBER
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)

Line 946: from po_distributions_trx_v pod, -- CLM project, bug 9403291

942: ,pll.ship_to_location_id
943: ,nvl(pll.enforce_ship_to_location_code,'NONE') enforce_ship_to_location_code
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,

Line 1046: FROM po_distributions_trx_v pod, -- CLM project, bug 9403291

1042: , v_lpn_id_to_match NUMBER
1043: ,v_parent_txn_id_to_match NUMBER
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,

Line 1157: from po_distributions_trx_v pod, -- CLM project, bug 9403291

1153: ,pll.ship_to_location_id
1154: ,nvl(pll.enforce_ship_to_location_code,'NONE') enforce_ship_to_location_code
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,

Line 1244: FROM po_distributions_trx_v pod, -- CLM project, bug 9403291

1240: , v_lpn_id_to_match NUMBER
1241: ,v_parent_txn_id_to_match NUMBER
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,