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.AR_TP_STMT_PKG dependencies on AR_CASH_RECEIPT_HISTORY_ALL

Line 232: ,ar_cash_receipt_history_all acrh

228: UNION ALL
229: SELECT 'R' trx_type
230: ,SUM(NVL(acr.amount * NVL(acr.exchange_rate,1),0)) accounted_amount
231: FROM ar_cash_receipts acr
232: ,ar_cash_receipt_history_all acrh
233: WHERE acr.cash_receipt_id = acrh.cash_receipt_id
234: AND acr.org_id = acrh.org_id
235: AND acrh.first_posted_record_flag = 'Y'
236: AND acrh.gl_date < TO_DATE(P_FROM_GL_DATE,'RRRR/MM/DD HH24:MI:SS')

Line 248: ,ar_cash_receipt_history_all acrh

244: UNION ALL
245: SELECT 'RE' trx_type
246: ,SUM(NVL(acr.amount * NVL(acr.exchange_rate,1),0)) accounted_amount
247: FROM ar_cash_receipts acr
248: ,ar_cash_receipt_history_all acrh
249: WHERE acr.cash_receipt_id = acrh.cash_receipt_id
250: AND acr.org_id = acrh.org_id
251: AND acr.reversal_date IS NOT NULL
252: AND acrh.current_record_flag = 'Y'