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_TRX_SUMMARY_PKG dependencies on AR_CASH_RECEIPT_HISTORY_ALL

Line 269: AR_CASH_RECEIPT_HISTORY_ALL CRH,

265: TO_DATE(NULL) LAST_RECEIPT_DATE,
266: NULL LAST_RECEIPT_NUMBER,
267: 0 PENDING_ADJ_AMT
268: FROM AR_CASH_RECEIPTS_ALL CR,
269: AR_CASH_RECEIPT_HISTORY_ALL CRH,
270: AR_RECEIVABLE_APPLICATIONS_ALL RAP
271: WHERE NVL(CR.CONFIRMED_FLAG, 'Y') = 'Y'
272: AND CR.REVERSAL_DATE IS NULL
273: AND CR.CASH_RECEIPT_ID = CRH.CASH_RECEIPT_ID

Line 549: ar_cash_receipt_history_all crh

545: 0 app_amt_days_late,
546: 0 adj_amount,
547: 0 adj_count
548: from ar_cash_receipts_all cr,
549: ar_cash_receipt_history_all crh
550: where cr.cash_receipt_id = crh.cash_receipt_id
551: and crh.current_record_flag = 'Y'
552: and crh.status = 'REVERSED'
553: and crh.creation_date <= l_program_start_date