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.OKL_CNTRCT_FIN_EXTRACT_PVT dependencies on OKL_BILLING_UTIL_PVT

Line 2594: sum(nvl(okl_billing_util_pvt.invoice_line_amount_remaining(cust_trx.customer_trx_id, cust_trx_lines.customer_trx_line_id), 0)) Amount_Due_remaining

2590: p_CONTRACT_NUMBER VARCHAR2,
2591: p_from_days number,
2592: p_to_days number) IS
2593: SELECT
2594: sum(nvl(okl_billing_util_pvt.invoice_line_amount_remaining(cust_trx.customer_trx_id, cust_trx_lines.customer_trx_line_id), 0)) Amount_Due_remaining
2595: FROM ra_customer_trx_all cust_trx,
2596: ra_customer_trx_lines_all cust_trx_lines,
2597: ar_payment_schedules_all ar
2598: WHERE cust_trx.customer_trx_id = cust_trx_lines.customer_trx_id