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 AP_INVOICES

Line 384: FROM OKL_TRX_AP_INVOICES_B oklinv,

380: v_start_date DATE,
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,

Line 387: AP_INVOICES inv,

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,
390: fnd_application fnd_app
391: WHERE oklinv.id = tpl.tap_id

Line 423: FROM OKL_TRX_AP_INVOICES_B oklinv,

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
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,

Line 426: AP_INVOICES inv,

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,
429: fnd_application fnd_app
430: WHERE oklinv.id = okl_inv_ln.tap_id

Line 748: FROM OKL_TRX_AP_INVOICES_B oklinv,

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
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,

Line 751: AP_INVOICES inv,

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,
754: fnd_application fnd_app
755: WHERE oklinv.id = okl_inv_ln.tap_id

Line 1010: FROM OKL_TRX_AP_INVOICES_B oklinv,

1006: -- Changed the select statement by Santonyr on 04-Aug-2004 to improve the performance
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,

Line 1013: AP_INVOICES inv,

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,
1016: fnd_application fnd_app
1017: WHERE oklinv.id = okl_inv_ln.tap_id