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_CHRG_PVT dependencies on OKL_POOL_PVT

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

561: and ps.status = 'OP'
562: and lsm.sel_id = sel.id
563: and pk.status_code = 'ACTIVE' --Added by bkatraga for bug 6983321
564: and pk.stm_id = sel.stm_id
565: AND pk.status_code = Okl_Pool_Pvt.G_POC_STS_ACTIVE; --Added by VARANGAN -Pool Contents Impact(Bug#6658065)
566:
567:
568: CURSOR c_sec_strm_AR_csr(cp_contract_id in number, cp_con_inv_number IN VARCHAR2) IS
569: SELECT arl.id cnsld_strm_id

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

579: AND arl.sty_id = pk.sty_id
580: AND pk.pol_id = pol.id
581: AND arv.invoice_id = arl.invoice_id
582: AND trunc(arv.date_consolidated) between trunc(pk.streams_from_date) and trunc(pk.streams_to_date)
583: AND pk.status_code = Okl_Pool_Pvt.G_POC_STS_ACTIVE; --Added by VARANGAN -Pool Contents Impact(Bug#6658065)
584:
585: ------------------------------------------------------------
586: -- Stream Type of Late Invoice Cursor
587: ------------------------------------------------------------