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 RA_TERMS_B

Line 731: ra_terms_b rt,

727: sum(decode(ps.class, 'INV',decode(nvl(ra.unearned_discount_taken,0),0,null,1),null)) unedisc_count,
728: sum(decode(ps.class, 'INV',
729: (ra.apply_date - ps.due_date)* ra.amount_applied, null)) app_amt_days_late
730: from ar_payment_schedules_all ps,
731: ra_terms_b rt,
732: ar_receivable_applications_all ra
733: where ps.payment_schedule_id = ra.applied_payment_schedule_id
734: and ps.customer_id > 0
735: and ps.term_id = rt.term_id(+)

Line 1943: ra_terms_b rt,

1939: sum(decode(ps.class, 'INV',decode(nvl(ra.unearned_discount_taken,0),0,null,1),null)) unedisc_count,
1940: sum(decode(ps.class, 'INV',
1941: (ra.apply_date - ps.due_date) * ra.amount_applied, null)) app_amt_days_late
1942: from ar_payment_schedules_all ps,
1943: ra_terms_b rt,
1944: ar_receivable_applications_all ra
1945: where ps.payment_schedule_id = ra.applied_payment_schedule_id
1946: and ps.customer_id = p_cust_id(i)
1947: and ps.term_id = rt.term_id(+)