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

Line 108: ( select pod.line_location_id from po_distributions pod

104: 2,
105: 1)
106: )
107: AND pll.line_location_id in
108: ( select pod.line_location_id from po_distributions pod
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 pod

170: 1)
171: )
172: AND pll.line_location_id in
173: ( select pod.line_location_id
174: from po_distributions pod
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 pod

251: 1)
252: )
253: AND pll.line_location_id in
254: ( select pod.line_location_id
255: from po_distributions pod
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 pod

321: 1)
322: )
323: AND pll.line_location_id in
324: ( select pod.line_location_id
325: from po_distributions pod
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 pod

399: 2,
400: 1)
401: )
402: AND pll.line_location_id in
403: ( select pod.line_location_id from po_distributions pod
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 pod

465: 1)
466: )
467: AND pll.line_location_id in
468: ( select pod.line_location_id
469: from po_distributions pod
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 pod

546: 1)
547: )
548: AND pll.line_location_id in
549: ( select pod.line_location_id
550: from po_distributions pod
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 pod

616: 1)
617: )
618: AND pll.line_location_id in
619: ( select pod.line_location_id
620: from po_distributions pod
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 707: from po_distributions pod

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

Line 778: from po_distributions pod

774: 1)
775: )
776: AND pll.line_location_id in
777: ( select pod.line_location_id
778: from po_distributions pod
779: where (v_project_id is null
780: or ((v_project_id = -9999 and pod.project_id is null)--Bug# 2669021
781: or (nvl(pod.project_id,-99) = v_project_id )))
782: and (v_task_id is null or nvl(pod.task_id,-9999) = v_task_id)

Line 814: from po_distributions pod,

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

Line 867: from po_distributions pod,

863: , v_project_id NUMBER
864: , v_task_id NUMBER
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)

Line 940: from po_distributions pod,

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

Line 1040: FROM po_distributions pod,

1036: , v_lpn_id_to_match NUMBER
1037: ,v_parent_txn_id_to_match NUMBER
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,

Line 1151: from po_distributions pod,

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

Line 1238: FROM po_distributions pod,

1234: , v_lpn_id_to_match NUMBER
1235: ,v_parent_txn_id_to_match NUMBER
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,