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_VARIABLE_INTEREST_PVT dependencies on AP_INVOICE_PAYMENT_HISTORY_V

Line 3894: ap_invoice_payment_history_v iph

3890: sum(iph.amount) txn_amount,
3891: 'P' txn_type
3892: FROM ap_invoices_all ap_inv,
3893: okl_trx_ap_invoices_b okl_inv,
3894: ap_invoice_payment_history_v iph
3895: ,okl_cnsld_ap_invs_all cnsld
3896: ,okl_txl_ap_inv_lns_all_b okl_inv_ln
3897: ,fnd_application fnd_app
3898: WHERE okl_inv.id = okl_inv_ln.tap_id

Line 3945: ap_invoice_payment_history_v iph

3941: sum(iph.amount) txn_amount,
3942: 'P' txn_type
3943: FROM ap_invoices_all ap_inv,
3944: okl_trx_ap_invoices_v okl_inv,
3945: ap_invoice_payment_history_v iph
3946: ,okl_cnsld_ap_invs_all cnsld
3947: ,okl_txl_ap_inv_lns_all_b okl_inv_ln
3948: ,fnd_application fnd_app
3949: WHERE okl_inv.id = okl_inv_ln.tap_id

Line 4829: ap_invoice_payment_history_v iph

4825: sum(iph.amount) txn_amount,
4826: 'P' txn_type
4827: FROM ap_invoices_all ap_inv,
4828: okl_trx_ap_invoices_v okl_inv,
4829: ap_invoice_payment_history_v iph
4830: ,okl_cnsld_ap_invs_all cnsld
4831: ,okl_txl_ap_inv_lns_all_b okl_inv_ln
4832: ,fnd_application fnd_app
4833: WHERE okl_inv.id = okl_inv_ln.tap_id

Line 4870: ap_invoice_payment_history_v iph

4866: sum(iph.amount) txn_amount,
4867: 'P' txn_type
4868: FROM ap_invoices_all ap_inv,
4869: okl_trx_ap_invoices_v okl_inv,
4870: ap_invoice_payment_history_v iph
4871: ,okl_cnsld_ap_invs_all cnsld
4872: ,okl_txl_ap_inv_lns_all_b okl_inv_ln
4873: ,fnd_application fnd_app
4874: WHERE okl_inv.id = okl_inv_ln.tap_id

Line 7880: ap_invoice_payment_history_v iph

7876: CURSOR l_borrow_payment_csr(cp_khr_id NUMBER, cp_from_date DATE) IS
7877: SELECT 'Y' return_value
7878: FROM ap_invoices_all ap_inv,
7879: okl_trx_ap_invoices_v okl_inv,
7880: ap_invoice_payment_history_v iph
7881: ,okl_cnsld_ap_invs_all cnsld
7882: ,okl_txl_ap_inv_lns_all_b okl_inv_ln
7883: ,fnd_application fnd_app
7884: WHERE okl_inv.id = okl_inv_ln.tap_id

Line 8173: ap_invoice_payment_history_v iph

8169: SELECT iph.invoice_payment_id source_id
8170: , 'AP_INVOICE_PAYMENTS_ALL' source_table
8171: FROM ap_invoices_all ap_inv,
8172: okl_trx_ap_invoices_v okl_inv,
8173: ap_invoice_payment_history_v iph
8174: ,okl_cnsld_ap_invs_all cnsld
8175: ,okl_txl_ap_inv_lns_all_b okl_inv_ln
8176: ,fnd_application fnd_app
8177: WHERE okl_inv.id = okl_inv_ln.tap_id