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 6621: AR_PAYMENT_SCHEDULES_ALL APS,

6617: l_unpaid_inv NUMBER := 0;
6618: CURSOR c_unpaid_inv(p_contract_line_id IN NUMBER) IS
6619: SELECT SUM(APS.AMOUNT_DUE_REMAINING)
6620: FROM
6621: AR_PAYMENT_SCHEDULES_ALL APS,
6622: /*
6623: 16-Aug-2007, ankushar Bug# 5499193
6624: start changes, modified the cursor to replace reference to okl_cnsld_ar_strms_b
6625: */

Line 6681: AR_PAYMENT_SCHEDULES_ALL APS,

6677: l_unapplied_credit NUMBER :=0;
6678: CURSOR c_unapplied_credit(p_contract_line_id IN NUMBER) IS
6679: SELECT SUM(APS.AMOUNT_DUE_REMAINING)
6680: FROM
6681: AR_PAYMENT_SCHEDULES_ALL APS,
6682: /*
6683: 16-Aug-2007, ankushar Bug# 5499193
6684: start changes, modified the cursor to replace reference to okl_cnsld_ar_strms_b
6685: */

Line 8962: ,ar_payment_schedules aps

8958: CURSOR c_amount_past_due(p_contract_id IN NUMBER,
8959: p_grace_days IN NUMBER) IS
8960: SELECT SUM(NVL(aps.amount_due_remaining, 0)) past_due_amount
8961: FROM okl_cnsld_ar_strms_b ocas
8962: ,ar_payment_schedules aps
8963: , okl_strm_type_v sm
8964: WHERE ocas.khr_id = p_contract_id
8965: AND ocas.receivables_invoice_id = aps.customer_trx_id
8966: AND aps.class ='INV'

Line 8976: ,ar_payment_schedules aps

8972: CURSOR c_amount_past_due(p_contract_id IN NUMBER,
8973: p_grace_days IN NUMBER) IS
8974: SELECT SUM(NVL(aps.amount_due_remaining, 0)) past_due_amount
8975: FROM okl_bpd_tld_ar_lines_v ocas
8976: ,ar_payment_schedules aps
8977: , okl_strm_type_v sm
8978: WHERE ocas.khr_id = p_contract_id
8979: AND ocas.customer_trx_id = aps.customer_trx_id
8980: AND aps.class ='INV'