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_STRM_TYPE_V

Line 35: AND EXISTS (SELECT 1 FROM okl_strm_type_v sty

31: AND okch.scs_code IN ('LEASE', 'LOAN')
32: AND okch.sts_code = 'EVERGREEN'
33: AND khs.code = okch.sts_code
34: AND oklh.id = stm.khr_id
35: AND EXISTS (SELECT 1 FROM okl_strm_type_v sty
36: WHERE stm.sty_id = sty.id
37: --change for User Defined Streams, by pjgomes, on 18 Oct 2004
38: --AND sty.name IN ('RENT', 'SERVICE AND MAINTENANCE', 'ESTIMATED PERSONAL PROPERTY TAX'))
39: AND sty.stream_type_purpose IN ('RENT', 'SERVICE_PAYMENT', 'ESTIMATED_PROPERTY_TAX', 'FEE_PAYMENT'))

Line 58: okl_strm_type_v sty

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
61: AND NVL(stm.kle_id, -99) = NVL(p_kle_id, -99)
62: AND stm.sty_id = sty.id

Line 75: okl_strm_type_v sty

71: ------------------------------------------------------------
72: CURSOR c_stm_count_csr ( p_khr_id NUMBER, p_kle_id NUMBER) IS
73: SELECT count(*)
74: FROM okl_streams stm,
75: okl_strm_type_v sty
76: WHERE stm.khr_id = p_khr_id
77: AND NVL(stm.kle_id, -99) = NVL(p_kle_id, -99)
78: AND stm.sty_id = sty.id
79: --change for User Defined Streams, by pjgomes, on 18 Oct 2004

Line 91: okl_strm_type_v sty

87: ------------------------------------------------------------
88: CURSOR c_sty_count_csr ( p_khr_id NUMBER, p_kle_id NUMBER, p_sty_purpose VARCHAR2 ) IS
89: SELECT count(*)
90: FROM okl_streams stm,
91: okl_strm_type_v sty
92: WHERE stm.khr_id = p_khr_id
93: AND NVL(stm.kle_id, -99) = NVL(p_kle_id, -99)
94: AND stm.sty_id = sty.id
95: AND stm.say_code = 'CURR'

Line 105: okl_strm_type_v sty

101: ------------------------------------------------------------
102: /*CURSOR c_copy_params_csr ( p_khr_id NUMBER) IS
103: SELECT stm.kle_id, stm.say_code, stm.active_yn
104: FROM okl_streams stm,
105: okl_strm_type_v sty
106: WHERE stm.khr_id = p_khr_id
107: AND stm.sty_id = sty.id
108: AND stm.say_code = 'CURR'
109: AND stm.active_yn = 'Y'

Line 117: FROM okl_strm_type_v

113: -- Get Sty Id
114: ------------------------------------------------------------
115: /*CURSOR get_sty_id_csr ( p_sty_purpose VARCHAR2 ) IS
116: SELECT id
117: FROM okl_strm_type_v
118: WHERE stream_type_purpose = p_sty_purpose; */
119:
120: ------------------------------------------------------------
121: -- Get Sty Id for a line and purpose

Line 126: okl_strm_type_v sty

122: ------------------------------------------------------------
123: CURSOR get_prim_sty_id_csr( p_khr_id NUMBER, p_kle_id NUMBER, p_sty_purpose VARCHAR2 ) IS
124: SELECT stm.sty_id
125: FROM okl_streams stm,
126: okl_strm_type_v sty
127: WHERE stm.khr_id = p_khr_id
128: AND NVL(stm.kle_id, -99) = NVL(p_kle_id, -99)
129: AND stm.sty_id = sty.id
130: AND stm.say_code = 'CURR'

Line 140: okl_strm_type_v sty

136: ------------------------------------------------------------
137: /*CURSOR get_stm_attrs_csr ( p_khr_id NUMBER, p_sty_name VARCHAR2 ) IS
138: SELECT stm.kle_id
139: FROM okl_streams stm,
140: okl_strm_type_v sty
141: WHERE stm.khr_id = p_khr_id
142: AND stm.sty_id = sty.id
143: AND stm.say_code = 'CURR'
144: AND stm.active_yn = 'Y'

Line 156: okl_strm_type_v sty

152: FROM okl_strm_elements ste
153: WHERE ste.stm_id IN (
154: SELECT stm.id
155: FROM okl_streams stm,
156: okl_strm_type_v sty
157: WHERE stm.khr_id = p_khr_id
158: AND NVL(stm.kle_id, -99) = NVL(p_kle_id, -99)
159: AND stm.sty_id = sty.id
160: AND stm.say_code = 'CURR'

Line 174: okl_strm_type_v sty

170: WHERE ste.stream_element_date <= p_max_date
171: AND ste.stm_id IN (
172: SELECT stm.id
173: FROM okl_streams stm,
174: okl_strm_type_v sty
175: WHERE stm.khr_id = p_khr_id
176: AND NVL(stm.kle_id, -99) = NVL(p_kle_id, -99)
177: AND stm.sty_id = sty.id
178: AND stm.say_code = 'CURR'

Line 198: okl_strm_type_v sty

194: SELECT stm.id, to_number(rule_information6) amt
195: FROM okc_rules_b a,
196: okc_rule_groups_b b,
197: okl_streams stm,
198: okl_strm_type_v sty
199: WHERE a.dnz_chr_id = p_khr_id
200: AND a.rgp_id = b.id
201: AND b.rgd_code = 'LALEVL'
202: AND a.rule_information_category = 'LASLL'

Line 223: okl_strm_type_v sty

219: FROM okl_strm_elements ste
220: WHERE ste.stm_id IN (
221: SELECT stm.id
222: FROM okl_streams stm,
223: okl_strm_type_v sty
224: WHERE stm.khr_id = p_khr_id
225: AND NVL(stm.kle_id, -99) = NVL(p_kle_id, -99)
226: AND stm.sty_id = sty.id
227: AND stm.say_code = 'CURR'

Line 241: okl_strm_type_v sty

237: FROM okl_strm_elements ste
238: WHERE ste.stm_id IN (
239: SELECT stm.id
240: FROM okl_streams stm,
241: okl_strm_type_v sty
242: WHERE stm.khr_id = p_khr_id
243: AND NVL(stm.kle_id, -99) = NVL(p_kle_id, -99)
244: AND stm.sty_id = sty.id
245: AND stm.say_code = 'CURR'

Line 310: ,okl_strm_type_v sty

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)
314: AND stm.sty_id = sty.id

Line 410: l_sty_id okl_strm_type_v.id%TYPE;

406: ------------------------------------------------------------
407:
408: l_khr_id okl_k_headers.id%TYPE;
409: l_kle_id okl_streams.kle_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;

Line 411: l_evrgrn_strm_purpose okl_strm_type_v.stream_type_purpose%TYPE;

407:
408: l_khr_id okl_k_headers.id%TYPE;
409: l_kle_id okl_streams.kle_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;

Line 412: l_evrgrn_prim_strm_purpose okl_strm_type_v.stream_type_purpose%TYPE;

408: l_khr_id okl_k_headers.id%TYPE;
409: l_kle_id okl_streams.kle_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:

Line 480: okl_strm_type_v sty

476: WHERE EXISTS(
477: SELECT 1
478: FROM OKL_POOLS pool,
479: okl_pool_contents_v poc,
480: okl_strm_type_v sty
481: WHERE pool.khr_id = p_khr_id AND
482: pool.id = poc.pol_id AND
483: poc.sty_id = sty.id AND
484: sty.stream_type_purpose = 'RESIDUAL_VALUE'