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_POOL_PVT

Line 482: AND pk.status_code = Okl_Pool_Pvt.G_POC_STS_ACTIVE; --Added by VARANGAN -Pool Contents Impact(Bug#6658065)

478: and pk.pol_id = pol.id
479: and pol.status_code='ACTIVE' -- Added vdamerla for bug 6064374
480: and pk.status_code = 'ACTIVE' --Added by bkatraga for bug 6983321
481: and trunc(cnr.date_consolidated) between trunc(pk.streams_from_date) and trunc(pk.streams_to_date)
482: AND pk.status_code = Okl_Pool_Pvt.G_POC_STS_ACTIVE; --Added by VARANGAN -Pool Contents Impact(Bug#6658065)
483:
484: CURSOR c_sec_strm_AR_csr(cp_contract_id in number, cp_con_rec_inv_id IN VARCHAR2) IS
485: SELECT arl.id cnsld_strm_id
486: ,pol.khr_id, pk.kle_id kle_id

Line 501: AND pk.status_code = Okl_Pool_Pvt.G_POC_STS_ACTIVE; --Added by VARANGAN -Pool Contents Impact(Bug#6658065)

497: and pol.status_code='ACTIVE' -- Added vdamerla for bug 6064374
498: and pk.status_code = 'ACTIVE' --Added by bkatraga for bug 6983321
499: AND arv.invoice_id = arl.invoice_id
500: AND trunc(arv.date_consolidated) between trunc(pk.streams_from_date) and trunc(pk.streams_to_date)
501: AND pk.status_code = Okl_Pool_Pvt.G_POC_STS_ACTIVE; --Added by VARANGAN -Pool Contents Impact(Bug#6658065)
502:
503: ------------------------------------------------------------
504: -- Source id of stream element of Late Invoice Cursor
505: ------------------------------------------------------------