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_RECEIPTS

Line 231: FROM ar_cash_receipts acr

227: OR (P_ACCOUNTED = 'BOTH'))
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'

Line 247: FROM ar_cash_receipts acr

243: OR (P_ACCOUNTED = 'BOTH'))
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

Line 286: FROM ar_cash_receipts acr

282: OR (P_ACCOUNTED = 'BOTH'))
283: UNION ALL
284: SELECT 'RE' trx_type
285: ,SUM(ara.acctd_amount_applied_from) accounted_amount
286: FROM ar_cash_receipts acr
287: ,ar_receivable_applications_all ara
288: ,ar_receivables_trx_all art
289: WHERE acr.cash_receipt_id = ara.cash_receipt_id
290: AND acr.org_id = ara.org_id