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 1231: ar_cash_receipt_history acrh,

1227: ARPT_SQL_FUNC_UTIL.get_lookup_meaning('CHECK_STATUS', acr.status)
1228: FROM ar_payment_schedules apsa,
1229: ar_cash_receipts acr,
1230: ar_receivable_applications ara,
1231: ar_cash_receipt_history acrh,
1232: iex_delinquencies del
1233: WHERE ara.cash_receipt_id = acr.cash_receipt_id
1234: AND ara.applied_payment_schedule_id = apsa.payment_schedule_id
1235: AND apsa.payment_schedule_id = del.payment_schedule_id

Line 1518: ar_cash_receipt_history acrh,

1514: ARPT_SQL_FUNC_UTIL.get_lookup_meaning('CHECK_STATUS', acr.status)
1515: FROM ar_payment_schedules apsa,
1516: ar_cash_receipts acr,
1517: ar_receivable_applications ara,
1518: ar_cash_receipt_history acrh,
1519: iex_delinquencies del
1520: WHERE ara.cash_receipt_id = acr.cash_receipt_id
1521: AND ara.applied_payment_schedule_id = apsa.payment_schedule_id
1522: AND apsa.payment_schedule_id = del.payment_schedule_id

Line 1535: -- ar_cash_receipt_history c

1531: --AND ACR.receipt_date =
1532: -- (SELECT max(a.receipt_date)
1533: -- FROM ar_cash_receipts a,
1534: -- ar_receivable_applications b,
1535: -- ar_cash_receipt_history c
1536: -- WHERE a.cash_receipt_id = b.cash_receipt_id
1537: -- AND b.applied_payment_schedule_id = apsa.payment_schedule_id
1538: -- AND a.reversal_date is null
1539: -- AND nvl(a.confirmed_flag, 'Y') = 'Y'