DBA Data[Home] [Help]

APPS.OKL_LTE_INT_PVT dependencies on OKL_POOL_CONTENTS_V

Line 469: , okl_pool_contents_v pk

465: pol.khr_id,lsm.kle_id
466: from okl_cnsld_ar_strms_b lsm
467: , okl_cnsld_ar_hdrs_b cnr
468: , okl_cnsld_ar_lines_b lln
469: , okl_pool_contents_v pk
470: , okl_pools pol
471: where lsm.RECEIVABLES_INVOICE_ID = l_cons_rec_inv_id
472: and lln.cnr_id = cnr.id
473: and lsm.lln_id = lln.id

Line 489: ,okl_pool_contents_v pk

485: SELECT arl.id cnsld_strm_id
486: ,pol.khr_id, pk.kle_id kle_id
487: FROM okl_bpd_ar_inv_lines_v arl
488: ,okl_bpd_ar_invoices_v arv
489: ,okl_pool_contents_v pk
490: ,okl_pools pol
491: WHERE arl.RECEIVABLES_INVOICE_ID = cp_con_rec_inv_id
492: AND arl.contract_id = cp_contract_id
493: AND arl.contract_id = pk.khr_id