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 346: , okl_pools pol

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

Line 366: ,okl_pools pol

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