eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_LTE_INT_PVT dependencies on OKL_POOLS

Line 470: , okl_pools pol

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
474: and lsm.khr_id = l_khr_id

Line 490: ,okl_pools pol

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
494: AND nvl(arl.contract_line_id, -99) = nvl(pk.kle_id, -99)