DBA Data[Home] [Help]

APPS.OKL_VARIABLE_INTEREST_PVT dependencies on OKL_CNSLD_AP_INVS_ALL

Line 2269: ,okl_cnsld_ap_invs_all cnsld

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
2273: AND okl_inv_ln.khr_id = p_contract_id

Line 2313: ,okl_cnsld_ap_invs_all cnsld

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
2317: AND okl_inv_ln.khr_id = p_contract_id

Line 4574: ,okl_cnsld_ap_invs_all cnsld

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
4578: AND okl_inv_ln.khr_id = cp_khr_id

Line 4996: ,okl_cnsld_ap_invs_all cnsld

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
5000: AND okl_inv_ln.khr_id = cp_khr_id