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

Line 419: FROM okl_bpd_tld_ar_lines_v ocas

415: CURSOR c_amount_past_due(p_contract_id IN NUMBER,
416: p_grace_days IN NUMBER)
417: IS
418: SELECT count(*)
419: FROM okl_bpd_tld_ar_lines_v ocas
420: ,ar_payment_schedules_all aps
421: WHERE ocas.khr_id = p_contract_id
422: AND ocas.customer_trx_id = aps.customer_trx_id
423: AND aps.class = 'INV'

Line 592: ,okl_bpd_tld_ar_lines_v stream

588:
589: cursor c_get_noof_cures(p_contract_id IN NUMBER) is
590: select count( ps.payment_schedule_id)
591: from ar_payment_schedules_all ps
592: ,okl_bpd_tld_ar_lines_v stream
593: --,okl_xtl_sell_invs_v xls
594: ,okl_txd_ar_ln_dtls_b tld
595: ,okl_txl_ar_inv_lns_v til
596: ,okl_trx_ar_invoices_v tai

Line 644: FROM okl_bpd_tld_ar_lines_v ocas

640: xls1.lsm_id =ocas.id);*/
641:
642: cursor l_days_past_due_cur (p_contract_id IN NUMBER) is
643: SELECT min(aps.due_date)
644: FROM okl_bpd_tld_ar_lines_v ocas
645: ,ar_payment_schedules_all aps
646: ,okc_k_headers_b chr
647: WHERE
648: ocas.khr_id = p_contract_id