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_TXL_AP_INV_LNS_ALL_B

Line 376: -- added okl_txl_ap_inv_lns_all_b in the from clause as khr_id now moves to the

372: AND rgp.chr_id = p_chr_id;
373:
374: -- Changed the select statementby Santonyr on 04-Aug-2004 to improve the performance
375: -- sjalasut, modified the cursor to refer consolidated invoice id from okl_cnsld_ap_invs_all
376: -- added okl_txl_ap_inv_lns_all_b in the from clause as khr_id now moves to the
377: -- transaction line level.
378: -- changes made as part of OKLR12B disbursements project.
379: CURSOR change_csr(v_khr_id NUMBER,
380: v_start_date DATE,

Line 385: okl_txl_ap_inv_lns_all_b tpl,

381: v_end_date DATE,
382: v_name OKL_INDICES.NAME%TYPE) IS
383: SELECT ac.check_date change_date
384: FROM OKL_TRX_AP_INVOICES_B oklinv,
385: okl_txl_ap_inv_lns_all_b tpl,
386: okl_cnsld_ap_invs_all okl_cnsld,
387: AP_INVOICES inv,
388: AP_INVOICE_PAYMENTS pay,
389: AP_CHECKS AC,

Line 417: -- sjalasut, modified the below cursor to have included okl_txl_ap_inv_lns_all_b

413:
414: -- This Cursor will Return Principal Funding Amount on any Particular Day
415:
416: -- Changed the select statement by Santonyr on 04-Aug-2004 to improve the performance
417: -- sjalasut, modified the below cursor to have included okl_txl_ap_inv_lns_all_b
418: -- so that khr_id now refers from this table and also introduced the new
419: -- okl consolidation table okl_cnsld_ap_invs_all to join the consolidated invoices
420: -- from the transaction lines table.
421: CURSOR princ_csr(v_date IN DATE, v_khr_id IN NUMBER) IS

Line 424: okl_txl_ap_inv_lns_all_b okl_inv_ln,

420: -- from the transaction lines table.
421: CURSOR princ_csr(v_date IN DATE, v_khr_id IN NUMBER) IS
422: SELECT SUM(pay.amount)
423: FROM OKL_TRX_AP_INVOICES_B oklinv,
424: okl_txl_ap_inv_lns_all_b okl_inv_ln,
425: okl_cnsld_ap_invs_all okl_cnsld,
426: AP_INVOICES inv,
427: AP_INVOICE_PAYMENTS pay,
428: AP_CHECKS AC,

Line 742: -- sjalasut, modified the below cursor to have included okl_txl_ap_inv_lns_all_b

738:
739: -- Changed by Santonyr on 12 Mar 2004
740: -- Changed the invoice_number to vendor_invoice_number in the where condition
741: -- Changed the select statement by Santonyr on 04-Aug-2004 to improve the performance
742: -- sjalasut, modified the below cursor to have included okl_txl_ap_inv_lns_all_b
743: -- so that khr_id now refers from this table and also introduced the new
744: -- okl consolidation table okl_cnsld_ap_invs_all to join the consolidated invoices
745: -- from the transaction lines table.
746: CURSOR fund_csr(v_khr_id NUMBER) IS

Line 749: okl_txl_ap_inv_lns_all_b okl_inv_ln,

745: -- from the transaction lines table.
746: CURSOR fund_csr(v_khr_id NUMBER) IS
747: SELECT MIN(ac.check_date)
748: FROM OKL_TRX_AP_INVOICES_B oklinv,
749: okl_txl_ap_inv_lns_all_b okl_inv_ln,
750: okl_cnsld_ap_invs_all okl_cnsld,
751: AP_INVOICES inv,
752: AP_INVOICE_PAYMENTS pay,
753: AP_CHECKS AC,

Line 1011: okl_txl_ap_inv_lns_all_b okl_inv_ln,

1007:
1008: CURSOR fund_csr(v_khr_id NUMBER) IS
1009: SELECT MIN(ac.check_date)
1010: FROM OKL_TRX_AP_INVOICES_B oklinv,
1011: okl_txl_ap_inv_lns_all_b okl_inv_ln,
1012: okl_cnsld_ap_invs_all okl_cnsld,
1013: AP_INVOICES inv,
1014: AP_INVOICE_PAYMENTS pay,
1015: AP_CHECKS AC,