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_HEADERS_ALL

Line 26: po_headers_all ph

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
30: AND ph.type_lookup_code = 'STANDARD'

Line 35: po_headers_all ph,

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
39: AND pr.po_release_id = pd.po_release_id

Line 403: po_headers_all ph

399: CURSOR po_info_cursor IS
400: --using invoice lines
401: select distinct ph.clm_document_number, ph.po_header_id, null
402: from ap_invoice_lines_all ail,
403: po_headers_all ph
404: where ail.invoice_id = l_invoice_id and
405: ail.po_release_id is null and
406: ph.po_header_id = ail.po_header_id and
407: ph.type_lookup_code = 'STANDARD'

Line 411: po_headers_all ph,

407: ph.type_lookup_code = 'STANDARD'
408: union all
409: select distinct (ph.clm_document_number||'-'||pr.release_num), ph.po_header_id, pr.po_release_id
410: from ap_invoice_lines_all ail,
411: po_headers_all ph,
412: po_releases_all pr
413: WHERE ail.invoice_id = l_invoice_id and
414: pr.po_release_id = ail.po_release_id and
415: ph.po_header_id = ail.po_header_id and

Line 422: po_headers_all ph

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
426: AND ph.type_lookup_code = 'STANDARD'

Line 431: po_headers_all ph,

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
435: AND pr.po_release_id = pd.po_release_id