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_SEEDED_FUNCTIONS_PVT dependencies on AR_PAYMENT_SCHEDULES

Line 6023: AR_PAYMENT_SCHEDULES_ALL APS,

6019: l_unpaid_inv NUMBER := 0;
6020: CURSOR c_unpaid_inv(p_contract_line_id IN NUMBER) IS
6021: SELECT SUM(APS.AMOUNT_DUE_REMAINING)
6022: FROM
6023: AR_PAYMENT_SCHEDULES_ALL APS,
6024: /*
6025: 16-Aug-2007, ankushar Bug# 5499193
6026: start changes, modified the cursor to replace reference to okl_cnsld_ar_strms_b
6027: */

Line 6083: AR_PAYMENT_SCHEDULES_ALL APS,

6079: l_unapplied_credit NUMBER :=0;
6080: CURSOR c_unapplied_credit(p_contract_line_id IN NUMBER) IS
6081: SELECT SUM(APS.AMOUNT_DUE_REMAINING)
6082: FROM
6083: AR_PAYMENT_SCHEDULES_ALL APS,
6084: /*
6085: 16-Aug-2007, ankushar Bug# 5499193
6086: start changes, modified the cursor to replace reference to okl_cnsld_ar_strms_b
6087: */

Line 8288: ,ar_payment_schedules aps

8284: CURSOR c_amount_past_due(p_contract_id IN NUMBER,
8285: p_grace_days IN NUMBER) IS
8286: SELECT SUM(NVL(aps.amount_due_remaining, 0)) past_due_amount
8287: FROM okl_cnsld_ar_strms_b ocas
8288: ,ar_payment_schedules aps
8289: , okl_strm_type_v sm
8290: WHERE ocas.khr_id = p_contract_id
8291: AND ocas.receivables_invoice_id = aps.customer_trx_id
8292: AND aps.class ='INV'

Line 8302: ,ar_payment_schedules aps

8298: CURSOR c_amount_past_due(p_contract_id IN NUMBER,
8299: p_grace_days IN NUMBER) IS
8300: SELECT SUM(NVL(aps.amount_due_remaining, 0)) past_due_amount
8301: FROM okl_bpd_tld_ar_lines_v ocas
8302: ,ar_payment_schedules aps
8303: , okl_strm_type_v sm
8304: WHERE ocas.khr_id = p_contract_id
8305: AND ocas.customer_trx_id = aps.customer_trx_id
8306: AND aps.class ='INV'