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.

[Home] [Help]

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.clm_document_number
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.clm_document_number||'-'||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 421: po_distributions_all pd,

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

Line 430: po_distributions_all pd,

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