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.POS_AP_INVOICES_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 25: po_distributions_all pd,

21: --changed org specific views to _all tables
22: CURSOR po_number_cursor IS
23: SELECT DISTINCT ph.segment1
24: FROM ap_invoice_distributions_all aid,
25: po_distributions_all pd,
26: po_headers_all ph
27: WHERE aid.invoice_id = l_invoice_id
28: AND aid.po_distribution_id = pd.po_distribution_id
29: AND pd.po_header_id = ph.po_header_id

Line 34: po_distributions_all pd,

30: AND ph.type_lookup_code = 'STANDARD'
31: UNION ALL
32: SELECT DISTINCT (ph.segment1||'-'||pr.release_num)
33: FROM ap_invoice_distributions_all aid,
34: po_distributions_all pd,
35: po_headers_all ph,
36: po_releases_all pr
37: WHERE aid.invoice_id = l_invoice_id
38: AND aid.po_distribution_id = pd.po_distribution_id

Line 85: po_distributions_all pd,

81:
82: CURSOR packing_slip_cursor IS
83: select DISTINCT RSH.PACKING_SLIP packing_slip
84: FROM ap_invoice_distributions_all aid,
85: po_distributions_all pd,
86: rcv_shipment_headers rsh,
87: rcv_shipment_lines rsl
88: WHERE aid.invoice_id = l_invoice_id
89: AND aid.po_distribution_id = pd.po_distribution_id

Line 96: po_distributions_all pd,

92: AND rsh.packing_slip is not null
93: union
94: select DISTINCT RSL.PACKING_SLIP packing_slip
95: FROM ap_invoice_distributions_all aid,
96: po_distributions_all pd,
97: rcv_shipment_headers rsh,
98: rcv_shipment_lines rsl
99: WHERE aid.invoice_id = l_invoice_id
100: AND aid.po_distribution_id = pd.po_distribution_id

Line 147: po_distributions_all pd,

143:
144: CURSOR packing_slip_cursor IS
145: select DISTINCT RSH.PACKING_SLIP packing_slip
146: FROM ap_invoice_distributions_all aid,
147: po_distributions_all pd,
148: rcv_shipment_headers rsh,
149: rcv_shipment_lines rsl
150: WHERE aid.invoice_id = l_invoice_id
151: AND aid.po_distribution_id = pd.po_distribution_id

Line 158: po_distributions_all pd,

154: AND rsh.packing_slip is not null
155: union
156: select DISTINCT RSL.PACKING_SLIP packing_slip
157: FROM ap_invoice_distributions_all aid,
158: po_distributions_all pd,
159: rcv_shipment_headers rsh,
160: rcv_shipment_lines rsl
161: WHERE aid.invoice_id = l_invoice_id
162: AND aid.po_distribution_id = pd.po_distribution_id

Line 419: po_distributions_all pd,

415:
416: --using invoice distributions
417: /* SELECT DISTINCT ph.segment1,ph.po_header_id,null
418: FROM ap_invoice_distributions_all aid,
419: po_distributions_all pd,
420: po_headers_all ph
421: WHERE aid.invoice_id = l_invoice_id
422: AND aid.po_distribution_id = pd.po_distribution_id
423: AND pd.po_header_id = ph.po_header_id

Line 428: po_distributions_all pd,

424: AND ph.type_lookup_code = 'STANDARD'
425: UNION ALL
426: SELECT DISTINCT (ph.segment1||'-'||pr.release_num),ph.po_header_id, pr.po_release_id
427: FROM ap_invoice_distributions_all aid,
428: po_distributions_all pd,
429: po_headers_all ph,
430: po_releases_all pr
431: WHERE aid.invoice_id = l_invoice_id
432: AND aid.po_distribution_id = pd.po_distribution_id