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_CURE_CALC_PVT dependencies on OKL_BPD_TLD_AR_LINES_V

Line 164: okl_bpd_tld_ar_lines_v st1

160:
161: cursor c_get_received_amounts (p_cure_amount_id IN NUMBER) is
162: select sum(ara.amount_applied)
163: from ar_payment_schedules ps1,
164: okl_bpd_tld_ar_lines_v st1
165: ,ar_receivable_applications ara
166: --,okl_xtl_sell_invs_v xls
167: ,okl_txl_ar_inv_lns_v til
168: ,okl_trx_ar_invoices_v tai

Line 531: FROM okl_bpd_tld_ar_lines_v ocas

527:
528: CURSOR c_amount_past_due(p_contract_id IN NUMBER,
529: p_grace_days IN NUMBER) IS
530: SELECT SUM(NVL(aps.amount_due_remaining, 0)) past_due_amount
531: FROM okl_bpd_tld_ar_lines_v ocas
532: ,ar_payment_schedules aps
533: WHERE ocas.khr_id = p_contract_id
534: AND ocas.customer_trx_id = aps.customer_trx_id
535: AND aps.class ='INV'

Line 661: FROM okl_bpd_tld_ar_lines_v ocas

657:
658: CURSOR c_amount_past_due(p_contract_id IN NUMBER,
659: p_grace_days IN NUMBER) IS
660: SELECT SUM(NVL(aps.amount_due_remaining, 0)) past_due_amount
661: FROM okl_bpd_tld_ar_lines_v ocas
662: ,ar_payment_schedules aps
663: WHERE ocas.khr_id = p_contract_id
664: AND ocas.customer_trx_id = aps.customer_trx_id
665: AND aps.class ='INV'

Line 1174: FROM okl_bpd_tld_ar_lines_v ocas

1170:
1171: CURSOR c_amount_past_due(p_contract_id IN NUMBER,
1172: p_grace_days IN NUMBER) IS
1173: SELECT SUM(NVL(aps.amount_due_remaining, 0)) past_due_amount
1174: FROM okl_bpd_tld_ar_lines_v ocas
1175: ,ar_payment_schedules aps
1176: WHERE ocas.khr_id = p_contract_id
1177: AND ocas.customer_trx_id = aps.customer_trx_id
1178: AND aps.class ='INV'

Line 1331: ,okl_bpd_tld_ar_lines_v stream

1327: cursor c_get_noof_cures(p_contract_id IN NUMBER)
1328: is
1329: select count( ps.payment_schedule_id)
1330: from ar_payment_schedules ps
1331: ,okl_bpd_tld_ar_lines_v stream
1332: --,okl_xtl_sell_invs_v xls
1333: ,okl_txd_ar_ln_dtls_b tld
1334: ,okl_txl_ar_inv_lns_v til
1335: ,okl_trx_ar_invoices_v tai

Line 1375: FROM okl_bpd_tld_ar_lines_v ocas

1371:
1372: cursor l_days_past_due_cur (p_contract_id IN NUMBER)
1373: is
1374: SELECT min(aps.due_date)
1375: FROM okl_bpd_tld_ar_lines_v ocas
1376: ,ar_payment_schedules aps
1377: ,okc_k_headers_b chr
1378: ,OKL_STRM_TYPE_TL SM
1379: WHERE ocas.khr_id = p_contract_id