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_PREPAYMENTS dependencies on RA_CUSTOMER_TRX

Line 1584: FROM ra_customer_trx_lines ctl

1580: ) IS
1581:
1582: CURSOR paymentset_cur(c_customer_trx_id NUMBER) IS
1583: SELECT distinct ctl.payment_set_id
1584: FROM ra_customer_trx_lines ctl
1585: WHERE ctl.payment_set_id is not null
1586: AND ctl.customer_trx_id= c_customer_trx_id;
1587:
1588: CURSOR prepayapp_cur(c_payment_set_id NUMBER) IS

Line 1624: ra_customer_trx ct

1620: BEGIN
1621: SELECT 'Y'
1622: INTO l_prepayment_exist_flag
1623: FROM ar_payment_schedules ps,
1624: ra_customer_trx ct
1625: WHERE ps.customer_trx_id =ct.customer_trx_id
1626: AND NVL(ct.prepayment_flag,'N') = 'Y'
1627: AND ps.payment_schedule_id=l_payment_schedule_id;
1628:

Line 2151: ra_customer_trx ct,

2147: SELECT
2148: ps.payment_schedule_id,
2149: ps.amount_due_remaining
2150: FROM
2151: ra_customer_trx ct,
2152: ar_payment_schedules ps
2153: WHERE ps.status = 'OP'
2154: AND ps.amount_due_remaining > 0
2155: AND ps.gl_date_closed = TO_DATE('4712/12/31', 'YYYY/MM/DD')