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.ARP_BILLS_RECEIVABLE_MAIN dependencies on RA_CUSTOMER_TRX_LINES

Line 2354: FROM ra_customer_trx_lines ctl,

2350: -- ps.payment_schedule_id,
2351: -- g_ae_sys_rec.set_of_books_id)) exchange_date
2352: ps.exchange_date exchange_date
2353: --}
2354: FROM ra_customer_trx_lines ctl,
2355: ar_payment_schedules ps,
2356: ar_payment_schedules assignment_ps,
2357: ar_adjustments adj,
2358: ( SELECT distinct ctl_in.customer_trx_line_id customer_trx_line_id,

Line 2360: FROM ra_customer_trx_lines ctl_in

2356: ar_payment_schedules assignment_ps,
2357: ar_adjustments adj,
2358: ( SELECT distinct ctl_in.customer_trx_line_id customer_trx_line_id,
2359: connect_by_root(br_ref_customer_trx_id) br_ref_customer_trx_id
2360: FROM ra_customer_trx_lines ctl_in
2361: WHERE ctl_in.br_ref_customer_trx_id is not null
2362: START WITH ctl_in.customer_trx_id = l_customer_trx_id
2363: CONNECT BY PRIOR ctl_in.br_ref_customer_trx_id = ctl_in.customer_trx_id) cnt
2364: WHERE assignment_ps.payment_schedule_id = ctl.br_ref_payment_schedule_id