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_STREAMS_V

Line 309: ,okl_streams_v stm

305: ,stm.khr_id
306: ,stm.kle_id
307: ,stm.sty_id
308: FROM okl_strm_elements_v ste
309: ,okl_streams_v stm
310: ,okl_strm_type_v sty
311: WHERE ste.stm_id = stm.id
312: AND stm.khr_id = p_khr_id
313: AND NVL(stm.kle_id, -99) = NVL(p_kle_id, -99)

Line 343: FROM okl_streams_v stm

339: CURSOR l_stream_csr(cp_khr_id IN NUMBER
340: ,cp_kle_id IN NUMBER
341: ,cp_sty_id IN NUMBER) IS
342: SELECT stm.id
343: FROM okl_streams_v stm
344: WHERE stm.khr_id = cp_khr_id
345: AND nvl(stm.kle_id, -99) = nvl(cp_kle_id, -99)
346: AND stm.sty_id = cp_sty_id
347: AND stm.say_code = 'CURR'

Line 414: l_stm_id OKL_STREAMS_V.ID%TYPE;

410: l_sty_id okl_strm_type_v.id%TYPE;
411: l_evrgrn_strm_purpose okl_strm_type_v.stream_type_purpose%TYPE;
412: l_evrgrn_prim_strm_purpose okl_strm_type_v.stream_type_purpose%TYPE;
413: l_se_line_number OKL_STRM_ELEMENTS_V.SE_LINE_NUMBER%TYPE;
414: l_stm_id OKL_STREAMS_V.ID%TYPE;
415: l_sel_id Okl_strm_elements_v.sel_id%TYPE;
416:
417: l_amount NUMBER;
418: