APPS.OKL_VARIABLE_INTEREST_PVT dependencies on OKL_TRX_AP_INVOICES_V

Line 3944: okl_trx_ap_invoices_v okl_inv,

3940: SELECT iph.check_date txn_date,
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

Line 4828: okl_trx_ap_invoices_v okl_inv,

4824: SELECT iph.check_date txn_date,
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

Line 4869: okl_trx_ap_invoices_v okl_inv,

4865: SELECT iph.check_date txn_date,
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

Line 7879: okl_trx_ap_invoices_v okl_inv,

7875: -- sjalasut, modified the cursor to have khr_id be passed from okl_txl_ap_inv_lns_all_b
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

Line 8172: okl_trx_ap_invoices_v okl_inv,

8168: CURSOR l_borrow_payment_csr(cp_khr_id NUMBER, cp_from_date DATE, cp_to_date DATE) IS
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