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_DAILY_INTEREST_CALC_PVT dependencies on OKL_CNSLD_AP_INVS_ALL

Line 729: -- okl_cnsld_ap_invs_all. khr_id now will be stored at the internal transaction

725: group by trunc(cbl.termination_date);
726:
727: --get payments for revolving loans for receipt date range
728: -- sjalasut, modified the cursor to include okl_txl_ap_inv_lns_all_b and
729: -- okl_cnsld_ap_invs_all. khr_id now will be stored at the internal transaction
730: -- line table and consolidated invoice id is also stored at the internal
731: -- transaction lines table (okl_txl_ap_inv_lns_all_b)
732: -- changes made as part of OKLR12B disbursements project
733: Cursor c_borrower_payment_csr(cp_khr_id IN NUMBER, cp_from_date IN DATE, cp_to_date IN DATE) IS

Line 740: , okl_cnsld_Ap_invs_all okl_cnsld

736: from ap_invoices_all ap_inv
737: , okl_trx_ap_invoices_v okl_inv
738: , ap_invoice_payment_history_v iph
739: , okl_txl_ap_inv_lns_all_b okl_inv_ln
740: , okl_cnsld_Ap_invs_all okl_cnsld
741: , fnd_application fnd_app
742: where okl_inv.id = okl_inv_ln.tap_id
743: and okl_inv_ln.khr_id = cp_khr_id
744: and ap_inv.application_id = fnd_app.application_id

Line 748: and ap_inv.product_table = 'OKL_CNSLD_AP_INVS_ALL'

744: and ap_inv.application_id = fnd_app.application_id
745: and fnd_app.application_short_name = 'OKL'
746: and okl_inv_ln.cnsld_ap_inv_id = okl_cnsld.cnsld_ap_inv_id
747: and okl_cnsld.cnsld_ap_inv_id = to_number(ap_inv.reference_key1)
748: and ap_inv.product_table = 'OKL_CNSLD_AP_INVS_ALL'
749: and okl_inv.funding_type_code = 'BORROWER_PAYMENT'
750: and ap_inv.invoice_id = iph.invoice_id
751: and iph.check_date BETWEEN cp_from_date AND NVL(cp_to_date, iph.check_date)
752: group by iph.check_date;

Line 756: -- okl_cnsld_ap_invs_all. khr_id now will be stored at the internal transaction

752: group by iph.check_date;
753:
754: --get sum of payments upto a date
755: -- sjalasut, modified the cursor to include okl_txl_ap_inv_lns_all_b and
756: -- okl_cnsld_ap_invs_all. khr_id now will be stored at the internal transaction
757: -- line table and consolidated invoice id is also stored at the internal
758: -- transaction lines table (okl_txl_ap_inv_lns_all_b)
759: -- changes made as part of OKLR12B disbursements project
760: Cursor c_payment_amount_csr(cp_khr_id IN NUMBER, cp_from_date IN DATE) IS

Line 766: , okl_cnsld_Ap_invs_all okl_cnsld

762: from ap_invoices_all ap_inv
763: , okl_trx_ap_invoices_v okl_inv
764: , ap_invoice_payment_history_v iph
765: , okl_txl_ap_inv_lns_all_b okl_inv_ln
766: , okl_cnsld_Ap_invs_all okl_cnsld
767: , fnd_application fnd_app
768: where okl_inv.id = okl_inv_ln.tap_id
769: and okl_inv_ln.khr_id = cp_khr_id
770: and ap_inv.application_id = fnd_app.application_id

Line 774: and ap_inv.product_table = 'OKL_CNSLD_AP_INVS_ALL'

770: and ap_inv.application_id = fnd_app.application_id
771: and fnd_app.application_short_name = 'OKL'
772: and okl_inv_ln.cnsld_ap_inv_id = okl_cnsld.cnsld_ap_inv_id
773: and okl_cnsld.cnsld_ap_inv_id = to_number(ap_inv.reference_key1)
774: and ap_inv.product_table = 'OKL_CNSLD_AP_INVS_ALL'
775: and ap_inv.invoice_num = okl_inv.vendor_invoice_number
776: and okl_inv.funding_type_code = 'BORROWER_PAYMENT'
777: and ap_inv.invoice_id = iph.invoice_id
778: and iph.check_date <= cp_from_date;