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_TXL_AP_INV_LNS_ALL_B

Line 728: -- sjalasut, modified the cursor to include okl_txl_ap_inv_lns_all_b and

724: and cbl.termination_date between cp_from_date and cp_to_date
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

Line 731: -- transaction lines table (okl_txl_ap_inv_lns_all_b)

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
734: select iph.check_date borrower_payment_date
735: , sum(iph.amount) borrower_payment

Line 739: , okl_txl_ap_inv_lns_all_b okl_inv_ln

735: , sum(iph.amount) borrower_payment
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

Line 755: -- sjalasut, modified the cursor to include okl_txl_ap_inv_lns_all_b and

751: and iph.check_date BETWEEN cp_from_date AND NVL(cp_to_date, iph.check_date)
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

Line 758: -- transaction lines table (okl_txl_ap_inv_lns_all_b)

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
761: select sum(iph.amount) payment_amount
762: from ap_invoices_all ap_inv

Line 765: , okl_txl_ap_inv_lns_all_b okl_inv_ln

761: select sum(iph.amount) payment_amount
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