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 358: AND pk.status_code = Okl_Pool_Pvt.G_POC_STS_ACTIVE; --Added by VARANGAN -Pool Contents Impact(Bug#6658065)

354: and pk.pol_id = pol.id
355: and pol.status_code='ACTIVE' -- Added vdamerla for bug 6064374
356: and pk.status_code = 'ACTIVE' --Added by bkatraga for bug 6983321
357: and trunc(cnr.date_consolidated) between trunc(pk.streams_from_date) and trunc(pk.streams_to_date)
358: AND pk.status_code = Okl_Pool_Pvt.G_POC_STS_ACTIVE; --Added by VARANGAN -Pool Contents Impact(Bug#6658065)
359:
360: CURSOR c_sec_strm_AR_csr(cp_contract_id in number, cp_con_rec_inv_id IN VARCHAR2) IS
361: SELECT arl.id cnsld_strm_id
362: ,pol.khr_id, pk.kle_id kle_id

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

373: and pol.status_code='ACTIVE' -- Added vdamerla for bug 6064374
374: and pk.status_code = 'ACTIVE' --Added by bkatraga for bug 6983321
375: AND arv.invoice_id = arl.invoice_id
376: AND trunc(arv.date_consolidated) between trunc(pk.streams_from_date) and trunc(pk.streams_to_date)
377: AND pk.status_code = Okl_Pool_Pvt.G_POC_STS_ACTIVE; --Added by VARANGAN -Pool Contents Impact(Bug#6658065)
378:
379: ------------------------------------------------------------
380: -- Source id of stream element of Late Invoice Cursor
381: ------------------------------------------------------------