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.JE_ITWHYE_AP_PKG dependencies on AP_INVOICE_PAYMENTS_ALL

Line 289: ap_invoice_payments_all aip,

285: AND dist1.line_type_lookup_code = 'ITEM'
286: -- AND dist1.awt_group_id IS NULL
287: group by dist1.invoice_id)dist
288: ,ap_invoices_all inv,
289: ap_invoice_payments_all aip,
290: ap_checks_all checks,
291: zx_party_tax_profile zpt --Bug 14136822
292: WHERE inv.legal_entity_id = p_legal_entity_id
293: AND inv.invoice_id = dist.invoice_id

Line 310: FROM ap_invoice_payments_all aip_sub

306: AND checks.void_date IS NULL
307: AND aip.accounting_date BETWEEN cp_year_start_date AND cp_year_end_date
308: AND aip.invoice_payment_id =
309: (SELECT MAX (aip_sub.invoice_payment_id)
310: FROM ap_invoice_payments_all aip_sub
311: WHERE aip_sub.invoice_id = inv.invoice_id
312: AND aip_sub.accounting_date BETWEEN cp_year_start_date
313: AND cp_year_end_date
314: GROUP BY aip_sub.invoice_id)

Line 317: FROM ap_invoice_payments_all aip_sub2,

313: AND cp_year_end_date
314: GROUP BY aip_sub.invoice_id)
315: AND EXISTS (
316: SELECT 1
317: FROM ap_invoice_payments_all aip_sub2,
318: ap_invoice_distributions_all dist
319: WHERE aip_sub2.invoice_payment_id =
320: DECODE (dist.line_type_lookup_code,
321: 'AWT', dist.awt_invoice_payment_id,