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.IEX_CUST_OVERVIEW_PVT dependencies on AR_CASH_RECEIPT_HISTORY

Line 1121: ar_cash_receipt_history acrh,

1117: ARPT_SQL_FUNC_UTIL.get_lookup_meaning('CHECK_STATUS', acr.status)
1118: FROM ar_payment_schedules apsa,
1119: ar_cash_receipts acr,
1120: ar_receivable_applications ara,
1121: ar_cash_receipt_history acrh,
1122: iex_delinquencies del
1123: WHERE ara.cash_receipt_id = acr.cash_receipt_id
1124: AND ara.applied_payment_schedule_id = apsa.payment_schedule_id
1125: AND apsa.payment_schedule_id = del.payment_schedule_id

Line 1403: ar_cash_receipt_history acrh,

1399: ARPT_SQL_FUNC_UTIL.get_lookup_meaning('CHECK_STATUS', acr.status)
1400: FROM ar_payment_schedules apsa,
1401: ar_cash_receipts acr,
1402: ar_receivable_applications ara,
1403: ar_cash_receipt_history acrh,
1404: iex_delinquencies del
1405: WHERE ara.cash_receipt_id = acr.cash_receipt_id
1406: AND ara.applied_payment_schedule_id = apsa.payment_schedule_id
1407: AND apsa.payment_schedule_id = del.payment_schedule_id

Line 1420: -- ar_cash_receipt_history c

1416: --AND ACR.receipt_date =
1417: -- (SELECT max(a.receipt_date)
1418: -- FROM ar_cash_receipts a,
1419: -- ar_receivable_applications b,
1420: -- ar_cash_receipt_history c
1421: -- WHERE a.cash_receipt_id = b.cash_receipt_id
1422: -- AND b.applied_payment_schedule_id = apsa.payment_schedule_id
1423: -- AND a.reversal_date is null
1424: -- AND nvl(a.confirmed_flag, 'Y') = 'Y'