DBA Data[Home] [Help]

APPS.OKL_LTE_INT_PVT dependencies on OKL_POOL_CONTENTS_V

Line 345: , okl_pool_contents_v pk

341: pol.khr_id,lsm.kle_id
342: from okl_cnsld_ar_strms_b lsm
343: , okl_cnsld_ar_hdrs_b cnr
344: , okl_cnsld_ar_lines_b lln
345: , okl_pool_contents_v pk
346: , okl_pools pol
347: where lsm.RECEIVABLES_INVOICE_ID = l_cons_rec_inv_id
348: and lln.cnr_id = cnr.id
349: and lsm.lln_id = lln.id

Line 365: ,okl_pool_contents_v pk

361: SELECT arl.id cnsld_strm_id
362: ,pol.khr_id, pk.kle_id kle_id
363: FROM okl_bpd_ar_inv_lines_v arl
364: ,okl_bpd_ar_invoices_v arv
365: ,okl_pool_contents_v pk
366: ,okl_pools pol
367: WHERE arl.RECEIVABLES_INVOICE_ID = cp_con_rec_inv_id
368: AND arl.contract_id = cp_contract_id
369: AND arl.contract_id = pk.khr_id