APPS.OKL_CNTRCT_FIN_EXTRACT_PVT dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 2595: ra_customer_trx_lines_all ctl

2591: SELECT
2592: SUM(NVL(ps.AMOUNT_DUE_REMAINING,0))
2593: From
2594: ar_payment_schedules_all ps,
2595: ra_customer_trx_lines_all ctl
2596: WHERE
2597: ctl.INTERFACE_LINE_ATTRIBUTE6 = p_CONTRACT_NUMBER
2598: AND ctl.CUSTOMER_TRX_ID = ps.CUSTOMER_TRX_ID
2599: AND ps.AMOUNT_DUE_REMAINING > 0

Line 2610: ra_customer_trx_lines_all cust_trx_lines,

2606: p_to_days number) IS
2607: SELECT
2608: 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
2609: FROM ra_customer_trx_all cust_trx,
2610: ra_customer_trx_lines_all cust_trx_lines,
2611: ar_payment_schedules_all ar
2612: WHERE cust_trx.customer_trx_id = cust_trx_lines.customer_trx_id
2613: AND cust_trx_lines.line_type = 'LINE'
2614: AND cust_trx_lines.interface_line_attribute1 IS NULL