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 56: FROM okl_k_headers_full_v khr,

52: SELECT khr.contract_number contract_number,
53: stm.kle_id, --added by pgomes
54: stm.id stm_id,
55: sty.stream_type_purpose sty_name
56: FROM okl_k_headers_full_v khr,
57: okl_streams stm,
58: okl_strm_type_v sty
59: WHERE khr.id = p_khr_id
60: AND stm.khr_id = khr.id

Line 327: ,okl_k_headers_full_v khr

323: CURSOR c_sec_strm_csr ( p_khr_id NUMBER, p_kle_id NUMBER, p_sty_id NUMBER, p_stream_element_date DATE) IS
324: select distinct khr.id khr_id
325: from okl_pool_contents_v pol
326: , OKL_POOLS pool
327: ,okl_k_headers_full_v khr
328: where pol.khr_id = p_khr_id
329: and nvl(pol.kle_id, -99) = nvl(p_kle_id, -99)
330: and pol.sty_id = p_sty_id
331: and trunc(p_stream_element_date) between trunc(pol.streams_from_date) and trunc(pol.streams_to_date)