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 STANDARD

Line 30: AND ph.type_lookup_code = 'STANDARD'

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'
31: UNION ALL
32: SELECT DISTINCT (ph.segment1||'-'||pr.release_num)
33: FROM ap_invoice_distributions_all aid,
34: po_distributions_all pd,

Line 405: ph.type_lookup_code = 'STANDARD'

401: po_headers_all ph
402: where ail.invoice_id = l_invoice_id and
403: ail.po_release_id is null and
404: ph.po_header_id = ail.po_header_id and
405: ph.type_lookup_code = 'STANDARD'
406: union all
407: select distinct (ph.segment1||'-'||pr.release_num), ph.po_header_id, pr.po_release_id
408: from ap_invoice_lines_all ail,
409: po_headers_all ph,

Line 424: AND ph.type_lookup_code = 'STANDARD'

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
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,