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_EVERGREEN_BILLING_PVT dependencies on OKL_K_HEADERS_FULL_V

Line 102: FROM okl_k_headers_full_v khr,

98: SELECT khr.contract_number contract_number,
99: stm.kle_id, --added by pgomes
100: stm.id stm_id,
101: sty.stream_type_purpose sty_name
102: FROM okl_k_headers_full_v khr,
103: okl_streams stm,
104: okl_strm_type_v sty
105: WHERE khr.id = p_khr_id
106: AND stm.khr_id = khr.id

Line 373: ,okl_k_headers_full_v khr

369: CURSOR c_sec_strm_csr ( p_khr_id NUMBER, p_kle_id NUMBER, p_sty_id NUMBER, p_stream_element_date DATE) IS
370: select distinct khr.id khr_id
371: from okl_pool_contents_v pol
372: , OKL_POOLS pool
373: ,okl_k_headers_full_v khr
374: where pol.khr_id = p_khr_id
375: and nvl(pol.kle_id, -99) = nvl(p_kle_id, -99)
376: and pol.sty_id = p_sty_id
377: and trunc(p_stream_element_date) between trunc(pol.streams_from_date) and trunc(pol.streams_to_date)