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 880: -- okl_cnsld_ap_invs_all. khr_id now will be stored at the internal transaction

876: group by trunc(cbl.termination_date);
877:
878: --get payments for revolving loans for receipt date range
879: -- sjalasut, modified the cursor to include okl_txl_ap_inv_lns_all_b and
880: -- okl_cnsld_ap_invs_all. khr_id now will be stored at the internal transaction
881: -- line table and consolidated invoice id is also stored at the internal
882: -- transaction lines table (okl_txl_ap_inv_lns_all_b)
883: -- changes made as part of OKLR12B disbursements project
884: Cursor c_borrower_payment_csr(cp_khr_id IN NUMBER, cp_from_date IN DATE, cp_to_date IN DATE) IS

Line 891: , okl_cnsld_Ap_invs_all okl_cnsld

887: from ap_invoices_all ap_inv
888: , okl_trx_ap_invoices_v okl_inv
889: , ap_invoice_payment_history_v iph
890: , okl_txl_ap_inv_lns_all_b okl_inv_ln
891: , okl_cnsld_Ap_invs_all okl_cnsld
892: , fnd_application fnd_app
893: where okl_inv.id = okl_inv_ln.tap_id
894: and okl_inv_ln.khr_id = cp_khr_id
895: and ap_inv.application_id = fnd_app.application_id

Line 899: and ap_inv.product_table = 'OKL_CNSLD_AP_INVS_ALL'

895: and ap_inv.application_id = fnd_app.application_id
896: and fnd_app.application_short_name = 'OKL'
897: and okl_inv_ln.cnsld_ap_inv_id = okl_cnsld.cnsld_ap_inv_id
898: and okl_cnsld.cnsld_ap_inv_id = to_number(ap_inv.reference_key1)
899: and ap_inv.product_table = 'OKL_CNSLD_AP_INVS_ALL'
900: and okl_inv.funding_type_code = 'BORROWER_PAYMENT'
901: and ap_inv.invoice_id = iph.invoice_id
902: and iph.check_date BETWEEN cp_from_date AND NVL(cp_to_date, iph.check_date)
903: group by iph.check_date;

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

903: group by iph.check_date;
904:
905: --get sum of payments upto a date
906: -- sjalasut, modified the cursor to include okl_txl_ap_inv_lns_all_b and
907: -- okl_cnsld_ap_invs_all. khr_id now will be stored at the internal transaction
908: -- line table and consolidated invoice id is also stored at the internal
909: -- transaction lines table (okl_txl_ap_inv_lns_all_b)
910: -- changes made as part of OKLR12B disbursements project
911: Cursor c_payment_amount_csr(cp_khr_id IN NUMBER, cp_from_date IN DATE) IS

Line 917: , okl_cnsld_Ap_invs_all okl_cnsld

913: from ap_invoices_all ap_inv
914: , okl_trx_ap_invoices_v okl_inv
915: , ap_invoice_payment_history_v iph
916: , okl_txl_ap_inv_lns_all_b okl_inv_ln
917: , okl_cnsld_Ap_invs_all okl_cnsld
918: , fnd_application fnd_app
919: where okl_inv.id = okl_inv_ln.tap_id
920: and okl_inv_ln.khr_id = cp_khr_id
921: and ap_inv.application_id = fnd_app.application_id

Line 925: and ap_inv.product_table = 'OKL_CNSLD_AP_INVS_ALL'

921: and ap_inv.application_id = fnd_app.application_id
922: and fnd_app.application_short_name = 'OKL'
923: and okl_inv_ln.cnsld_ap_inv_id = okl_cnsld.cnsld_ap_inv_id
924: and okl_cnsld.cnsld_ap_inv_id = to_number(ap_inv.reference_key1)
925: and ap_inv.product_table = 'OKL_CNSLD_AP_INVS_ALL'
926: and ap_inv.invoice_num = okl_inv.vendor_invoice_number
927: and okl_inv.funding_type_code = 'BORROWER_PAYMENT'
928: and ap_inv.invoice_id = iph.invoice_id
929: and iph.check_date <= cp_from_date;