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.AP_TP_STMT_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 255: ,ap_invoice_distributions_all aid

251: UNION ALL
252: SELECT 'A' transaction_type
253: ,SUM((NVL(aid.amount,0)* NVL(ai.exchange_rate,1))*-1) amount_applied
254: FROM ap_invoices ai
255: ,ap_invoice_distributions_all aid
256: ,ap_invoices aipre
257: ,ap_invoice_distributions_all aidpre
258: WHERE ai.invoice_id = aid.invoice_id
259: AND aid.prepay_distribution_id = aidpre.invoice_distribution_id

Line 257: ,ap_invoice_distributions_all aidpre

253: ,SUM((NVL(aid.amount,0)* NVL(ai.exchange_rate,1))*-1) amount_applied
254: FROM ap_invoices ai
255: ,ap_invoice_distributions_all aid
256: ,ap_invoices aipre
257: ,ap_invoice_distributions_all aidpre
258: WHERE ai.invoice_id = aid.invoice_id
259: AND aid.prepay_distribution_id = aidpre.invoice_distribution_id
260: AND aipre.invoice_id = aidpre.invoice_id
261: AND aid.accounting_date < TO_DATE(P_FROM_GL_DATE,'RRRR/MM/DD HH24:MI:SS')