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 AR_PAYMENT_SCHEDULES_ALL

Line 399: ,ar_payment_schedules_all aps

395: /*CURSOR c_amount_past_due(p_contract_id IN NUMBER,
396: p_grace_days IN NUMBER) IS
397: SELECT count(*)
398: FROM okl_cnsld_ar_strms_b ocas
399: ,ar_payment_schedules_all aps
400: WHERE ocas.khr_id = p_contract_id
401: AND ocas.receivables_invoice_id = aps.customer_trx_id
402: AND aps.class ='INV'
403: AND (aps.actual_date_closed + p_grace_days) < sysdate

Line 420: ,ar_payment_schedules_all aps

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'
424: AND (aps.actual_date_closed + p_grace_days) < sysdate

Line 574: from ar_payment_schedules_all ps

570:
571:
572: /*cursor c_get_noof_cures(p_contract_id IN NUMBER) is
573: select count( ps.payment_schedule_id)
574: from ar_payment_schedules_all ps
575: ,okl_cnsld_ar_strms_b stream
576: ,okl_xtl_sell_invs_v xls
577: ,okl_txl_ar_inv_lns_v til
578: ,okl_trx_ar_invoices_v tai

Line 591: from ar_payment_schedules_all ps

587:
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

Line 623: ,ar_payment_schedules_all aps

619:
620: /*cursor l_days_past_due_cur (p_contract_id IN NUMBER) is
621: SELECT min(aps.due_date)
622: FROM okl_cnsld_ar_strms_b ocas
623: ,ar_payment_schedules_all aps
624: ,okc_k_headers_b chr
625: WHERE
626: ocas.khr_id = p_contract_id
627: AND ocas.receivables_invoice_id = aps.customer_trx_id

Line 645: ,ar_payment_schedules_all aps

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
649: AND ocas.customer_trx_id = aps.customer_trx_id