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

Line 528: -- sjalasut, modified the cursor to refer consolidated invoice id from okl_cnsld_ap_invs_all

524: AND okl.effective_to_date IS NULL
525: AND okl.interest_index_id = idx.id;
526:
527: -- Changed the select statementby Santonyr on 04-Aug-2004 to improve the performance
528: -- sjalasut, modified the cursor to refer consolidated invoice id from okl_cnsld_ap_invs_all
529: -- added okl_txl_ap_inv_lns_all_b in the from clause as khr_id now moves to the
530: -- transaction line level.
531: -- changes made as part of OKLR12B disbursements project.
532: CURSOR change_csr(v_khr_id NUMBER,

Line 539: okl_cnsld_ap_invs_all okl_cnsld,

535: v_name OKL_INDICES.NAME%TYPE) IS
536: SELECT ac.check_date change_date
537: FROM OKL_TRX_AP_INVOICES_B oklinv,
538: okl_txl_ap_inv_lns_all_b tpl,
539: okl_cnsld_ap_invs_all okl_cnsld,
540: AP_INVOICES inv,
541: AP_INVOICE_PAYMENTS pay,
542: AP_CHECKS AC,
543: fnd_application fnd_app

Line 549: AND inv.product_table = 'OKL_CNSLD_AP_INVS_ALL'

545: AND tpl.khr_id = v_khr_id
546: AND tpl.cnsld_ap_inv_id = okl_cnsld.cnsld_ap_inv_id
547: AND inv.application_id = fnd_app.application_id
548: AND fnd_app.application_short_name = 'OKL'
549: AND inv.product_table = 'OKL_CNSLD_AP_INVS_ALL'
550: AND okl_cnsld.cnsld_ap_inv_id = to_number(inv.reference_key1)
551: AND oklinv.funding_type_code = 'PREFUNDING'
552: AND oklinv.vendor_invoice_number = inv.invoice_num -- sjalasut, is this required now?
553: AND inv.invoice_id = pay.invoice_id

Line 571: -- okl consolidation table okl_cnsld_ap_invs_all to join the consolidated invoices

567:
568: -- Changed the select statement by Santonyr on 04-Aug-2004 to improve the performance
569: -- sjalasut, modified the below cursor to have included okl_txl_ap_inv_lns_all_b
570: -- so that khr_id now refers from this table and also introduced the new
571: -- okl consolidation table okl_cnsld_ap_invs_all to join the consolidated invoices
572: -- from the transaction lines table.
573: CURSOR princ_csr(v_date IN DATE, v_khr_id IN NUMBER) IS
574: SELECT SUM(pay.amount)
575: FROM OKL_TRX_AP_INVOICES_B oklinv,

Line 577: okl_cnsld_ap_invs_all okl_cnsld,

573: CURSOR princ_csr(v_date IN DATE, v_khr_id IN NUMBER) IS
574: SELECT SUM(pay.amount)
575: FROM OKL_TRX_AP_INVOICES_B oklinv,
576: okl_txl_ap_inv_lns_all_b okl_inv_ln,
577: okl_cnsld_ap_invs_all okl_cnsld,
578: AP_INVOICES inv,
579: AP_INVOICE_PAYMENTS pay,
580: AP_CHECKS AC,
581: fnd_application fnd_app

Line 587: AND inv.product_table = 'OKL_CNSLD_AP_INVS_ALL'

583: AND okl_inv_ln.khr_id = v_khr_id
584: AND okl_inv_ln.cnsld_ap_inv_id = okl_cnsld.cnsld_ap_inv_id
585: AND inv.application_id = fnd_app.application_id
586: AND fnd_app.application_short_name = 'OKL'
587: AND inv.product_table = 'OKL_CNSLD_AP_INVS_ALL'
588: AND okl_cnsld.cnsld_ap_inv_id = to_number(inv.reference_key1)
589: AND oklinv.funding_type_code = 'PREFUNDING'
590: AND oklinv.vendor_invoice_number = inv.invoice_num -- sjalasut, is this required now?
591: AND inv.invoice_id = pay.invoice_id

Line 894: -- okl consolidation table okl_cnsld_ap_invs_all to join the consolidated invoices

890: -- Changed the invoice_number to vendor_invoice_number in the where condition
891: -- Changed the select statement by Santonyr on 04-Aug-2004 to improve the performance
892: -- sjalasut, modified the below cursor to have included okl_txl_ap_inv_lns_all_b
893: -- so that khr_id now refers from this table and also introduced the new
894: -- okl consolidation table okl_cnsld_ap_invs_all to join the consolidated invoices
895: -- from the transaction lines table.
896: CURSOR fund_csr(v_khr_id NUMBER) IS
897: SELECT MIN(ac.check_date)
898: FROM OKL_TRX_AP_INVOICES_B oklinv,

Line 900: okl_cnsld_ap_invs_all okl_cnsld,

896: CURSOR fund_csr(v_khr_id NUMBER) IS
897: SELECT MIN(ac.check_date)
898: FROM OKL_TRX_AP_INVOICES_B oklinv,
899: okl_txl_ap_inv_lns_all_b okl_inv_ln,
900: okl_cnsld_ap_invs_all okl_cnsld,
901: AP_INVOICES inv,
902: AP_INVOICE_PAYMENTS pay,
903: AP_CHECKS AC,
904: fnd_application fnd_app

Line 910: AND inv.product_table = 'OKL_CNSLD_AP_INVS_ALL'

906: AND okl_inv_ln.khr_id = v_khr_id
907: AND okl_inv_ln.cnsld_ap_inv_id = okl_cnsld.cnsld_ap_inv_id
908: AND inv.application_id = fnd_app.application_id
909: AND fnd_app.application_short_name = 'OKL'
910: AND inv.product_table = 'OKL_CNSLD_AP_INVS_ALL'
911: AND okl_cnsld.cnsld_ap_inv_id = to_number(inv.reference_key1)
912: AND oklinv.funding_type_code = 'PREFUNDING'
913: AND oklinv.vendor_invoice_number = inv.invoice_num -- sjalasut, is this required now?
914: AND oklinv.ipvs_id = inv.vendor_site_id

Line 1161: okl_cnsld_ap_invs_all okl_cnsld,

1157: CURSOR fund_csr(v_khr_id NUMBER) IS
1158: SELECT MIN(ac.check_date)
1159: FROM OKL_TRX_AP_INVOICES_B oklinv,
1160: okl_txl_ap_inv_lns_all_b okl_inv_ln,
1161: okl_cnsld_ap_invs_all okl_cnsld,
1162: AP_INVOICES inv,
1163: AP_INVOICE_PAYMENTS pay,
1164: AP_CHECKS AC,
1165: fnd_application fnd_app

Line 1171: AND inv.product_table = 'OKL_CNSLD_AP_INVS_ALL'

1167: AND okl_inv_ln.khr_id = v_khr_id
1168: AND okl_inv_ln.cnsld_ap_inv_id = okl_cnsld.cnsld_ap_inv_id
1169: AND inv.application_id = fnd_app.application_id
1170: AND fnd_app.application_short_name = 'OKL'
1171: AND inv.product_table = 'OKL_CNSLD_AP_INVS_ALL'
1172: AND okl_cnsld.cnsld_ap_inv_id = to_number(inv.reference_key1)
1173: AND oklinv.funding_type_code = 'PREFUNDING'
1174: AND oklinv.vendor_invoice_number = inv.invoice_num -- sjalasut, is this required now?
1175: AND oklinv.ipvs_id = inv.vendor_site_id