APPS.OKL_VARIABLE_INTEREST_PVT dependencies on AP_INVOICE_PAYMENT_HISTORY_V

Line 2268: ap_invoice_payment_history_v iph

2264: sum(iph.amount) txn_amount,
2265: 'P' txn_type
2266: FROM ap_invoices_all ap_inv,
2267: okl_trx_ap_invoices_v okl_inv,
2268: ap_invoice_payment_history_v iph
2269: ,okl_cnsld_ap_invs_all cnsld
2270: ,okl_txl_ap_inv_lns_all_b okl_inv_ln
2271: ,fnd_application fnd_app
2272: WHERE okl_inv.id = okl_inv_ln.tap_id

Line 2312: ap_invoice_payment_history_v iph

2308: sum(iph.amount) txn_amount,
2309: 'P' txn_type
2310: FROM ap_invoices_all ap_inv,
2311: okl_trx_ap_invoices_v okl_inv,
2312: ap_invoice_payment_history_v iph
2313: ,okl_cnsld_ap_invs_all cnsld
2314: ,okl_txl_ap_inv_lns_all_b okl_inv_ln
2315: ,fnd_application fnd_app
2316: WHERE okl_inv.id = okl_inv_ln.tap_id

Line 4573: ap_invoice_payment_history_v iph

4569: CURSOR l_borrow_payment_csr(cp_khr_id NUMBER, cp_from_date DATE) IS
4570: SELECT 'Y' return_value
4571: FROM ap_invoices_all ap_inv,
4572: okl_trx_ap_invoices_v okl_inv,
4573: ap_invoice_payment_history_v iph
4574: ,okl_cnsld_ap_invs_all cnsld
4575: ,okl_txl_ap_inv_lns_all_b okl_inv_ln
4576: ,fnd_application fnd_app
4577: WHERE okl_inv.id = okl_inv_ln.tap_id

Line 4995: ap_invoice_payment_history_v iph

4991: SELECT iph.invoice_payment_id source_id
4992: , 'AP_INVOICE_PAYMENTS_ALL' source_table
4993: FROM ap_invoices_all ap_inv,
4994: okl_trx_ap_invoices_v okl_inv,
4995: ap_invoice_payment_history_v iph
4996: ,okl_cnsld_ap_invs_all cnsld
4997: ,okl_txl_ap_inv_lns_all_b okl_inv_ln
4998: ,fnd_application fnd_app
4999: WHERE okl_inv.id = okl_inv_ln.tap_id