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 RA_CUSTOMER_TRX_LINES_ALL

Line 2581: ra_customer_trx_lines_all ctl

2577: SELECT
2578: SUM(NVL(ps.AMOUNT_DUE_REMAINING,0))
2579: From
2580: ar_payment_schedules_all ps,
2581: ra_customer_trx_lines_all ctl
2582: WHERE
2583: ctl.INTERFACE_LINE_ATTRIBUTE6 = p_CONTRACT_NUMBER
2584: AND ctl.CUSTOMER_TRX_ID = ps.CUSTOMER_TRX_ID
2585: AND ps.AMOUNT_DUE_REMAINING > 0

Line 2596: ra_customer_trx_lines_all cust_trx_lines,

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
2599: AND cust_trx_lines.line_type = 'LINE'
2600: AND cust_trx_lines.interface_line_attribute1 IS NULL