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 44: AND EXISTS (SELECT 1 FROM okl_strm_type_v sty

40: AND okch.scs_code IN ('LEASE', 'LOAN')
41: AND okch.sts_code = 'EVERGREEN'
42: AND khs.code = okch.sts_code
43: AND oklh.id = stm.khr_id
44: AND EXISTS (SELECT 1 FROM okl_strm_type_v sty
45: WHERE stm.sty_id = sty.id
46: --change for User Defined Streams, by pjgomes, on 18 Oct 2004
47: --AND sty.name IN ('RENT', 'SERVICE AND MAINTENANCE', 'ESTIMATED PERSONAL PROPERTY TAX'))
48: AND sty.stream_type_purpose IN ('RENT', 'SERVICE_PAYMENT', 'ESTIMATED_PROPERTY_TAX', 'FEE_PAYMENT'))

Line 79: AND EXISTS (SELECT 1 FROM okl_strm_type_v sty

75: AND okch.scs_code IN ('LEASE', 'LOAN')
76: AND okch.sts_code = 'EVERGREEN'
77: AND khs.code = okch.sts_code
78: AND oklh.id = stm.khr_id
79: AND EXISTS (SELECT 1 FROM okl_strm_type_v sty
80: WHERE stm.sty_id = sty.id
81: AND sty.stream_type_purpose IN ('RENT', 'SERVICE_PAYMENT', 'ESTIMATED_PROPERTY_TAX', 'FEE_PAYMENT'))
82: AND (stm.kle_id is not null and EXISTS ( SELECT 1
83: FROM OKC_K_LINES_B CLE

Line 104: okl_strm_type_v sty

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

Line 121: okl_strm_type_v sty

117: ------------------------------------------------------------
118: CURSOR c_stm_count_csr ( p_khr_id NUMBER, p_kle_id NUMBER) IS
119: SELECT count(*)
120: FROM okl_streams stm,
121: okl_strm_type_v sty
122: WHERE stm.khr_id = p_khr_id
123: AND NVL(stm.kle_id, -99) = NVL(p_kle_id, -99)
124: AND stm.sty_id = sty.id
125: --change for User Defined Streams, by pjgomes, on 18 Oct 2004

Line 137: okl_strm_type_v sty

133: ------------------------------------------------------------
134: CURSOR c_sty_count_csr ( p_khr_id NUMBER, p_kle_id NUMBER, p_sty_purpose VARCHAR2 ) IS
135: SELECT count(*)
136: FROM okl_streams stm,
137: okl_strm_type_v sty
138: WHERE stm.khr_id = p_khr_id
139: AND NVL(stm.kle_id, -99) = NVL(p_kle_id, -99)
140: AND stm.sty_id = sty.id
141: AND stm.say_code = 'CURR'

Line 151: okl_strm_type_v sty

147: ------------------------------------------------------------
148: /*CURSOR c_copy_params_csr ( p_khr_id NUMBER) IS
149: SELECT stm.kle_id, stm.say_code, stm.active_yn
150: FROM okl_streams stm,
151: okl_strm_type_v sty
152: WHERE stm.khr_id = p_khr_id
153: AND stm.sty_id = sty.id
154: AND stm.say_code = 'CURR'
155: AND stm.active_yn = 'Y'

Line 163: FROM okl_strm_type_v

159: -- Get Sty Id
160: ------------------------------------------------------------
161: /*CURSOR get_sty_id_csr ( p_sty_purpose VARCHAR2 ) IS
162: SELECT id
163: FROM okl_strm_type_v
164: WHERE stream_type_purpose = p_sty_purpose; */
165:
166: ------------------------------------------------------------
167: -- Get Sty Id for a line and purpose

Line 172: okl_strm_type_v sty

168: ------------------------------------------------------------
169: CURSOR get_prim_sty_id_csr( p_khr_id NUMBER, p_kle_id NUMBER, p_sty_purpose VARCHAR2 ) IS
170: SELECT stm.sty_id
171: FROM okl_streams stm,
172: okl_strm_type_v sty
173: WHERE stm.khr_id = p_khr_id
174: AND NVL(stm.kle_id, -99) = NVL(p_kle_id, -99)
175: AND stm.sty_id = sty.id
176: AND stm.say_code = 'CURR'

Line 186: okl_strm_type_v sty

182: ------------------------------------------------------------
183: /*CURSOR get_stm_attrs_csr ( p_khr_id NUMBER, p_sty_name VARCHAR2 ) IS
184: SELECT stm.kle_id
185: FROM okl_streams stm,
186: okl_strm_type_v sty
187: WHERE stm.khr_id = p_khr_id
188: AND stm.sty_id = sty.id
189: AND stm.say_code = 'CURR'
190: AND stm.active_yn = 'Y'

Line 202: okl_strm_type_v sty

198: FROM okl_strm_elements ste
199: WHERE ste.stm_id IN (
200: SELECT stm.id
201: FROM okl_streams stm,
202: okl_strm_type_v sty
203: WHERE stm.khr_id = p_khr_id
204: AND NVL(stm.kle_id, -99) = NVL(p_kle_id, -99)
205: AND stm.sty_id = sty.id
206: AND stm.say_code = 'CURR'

Line 220: okl_strm_type_v sty

216: WHERE ste.stream_element_date <= p_max_date
217: AND ste.stm_id IN (
218: SELECT stm.id
219: FROM okl_streams stm,
220: okl_strm_type_v sty
221: WHERE stm.khr_id = p_khr_id
222: AND NVL(stm.kle_id, -99) = NVL(p_kle_id, -99)
223: AND stm.sty_id = sty.id
224: AND stm.say_code = 'CURR'

Line 244: okl_strm_type_v sty

240: SELECT stm.id, to_number(rule_information6) amt
241: FROM okc_rules_b a,
242: okc_rule_groups_b b,
243: okl_streams stm,
244: okl_strm_type_v sty
245: WHERE a.dnz_chr_id = p_khr_id
246: AND a.rgp_id = b.id
247: AND b.rgd_code = 'LALEVL'
248: AND a.rule_information_category = 'LASLL'

Line 269: okl_strm_type_v sty

265: FROM okl_strm_elements ste
266: WHERE ste.stm_id IN (
267: SELECT stm.id
268: FROM okl_streams stm,
269: okl_strm_type_v sty
270: WHERE stm.khr_id = p_khr_id
271: AND NVL(stm.kle_id, -99) = NVL(p_kle_id, -99)
272: AND stm.sty_id = sty.id
273: AND stm.say_code = 'CURR'

Line 287: okl_strm_type_v sty

283: FROM okl_strm_elements ste
284: WHERE ste.stm_id IN (
285: SELECT stm.id
286: FROM okl_streams stm,
287: okl_strm_type_v sty
288: WHERE stm.khr_id = p_khr_id
289: AND NVL(stm.kle_id, -99) = NVL(p_kle_id, -99)
290: AND stm.sty_id = sty.id
291: AND stm.say_code = 'CURR'

Line 356: ,okl_strm_type_v sty

352: ,stm.kle_id
353: ,stm.sty_id
354: FROM okl_strm_elements_v ste
355: ,okl_streams_v stm
356: ,okl_strm_type_v sty
357: WHERE ste.stm_id = stm.id
358: AND stm.khr_id = p_khr_id
359: AND NVL(stm.kle_id, -99) = NVL(p_kle_id, -99)
360: AND stm.sty_id = sty.id

Line 456: l_sty_id okl_strm_type_v.id%TYPE;

452: ------------------------------------------------------------
453:
454: l_khr_id okl_k_headers.id%TYPE;
455: l_kle_id okl_streams.kle_id%TYPE;
456: l_sty_id okl_strm_type_v.id%TYPE;
457: l_evrgrn_strm_purpose okl_strm_type_v.stream_type_purpose%TYPE;
458: l_evrgrn_prim_strm_purpose okl_strm_type_v.stream_type_purpose%TYPE;
459: l_se_line_number OKL_STRM_ELEMENTS_V.SE_LINE_NUMBER%TYPE;
460: l_stm_id OKL_STREAMS_V.ID%TYPE;

Line 457: l_evrgrn_strm_purpose okl_strm_type_v.stream_type_purpose%TYPE;

453:
454: l_khr_id okl_k_headers.id%TYPE;
455: l_kle_id okl_streams.kle_id%TYPE;
456: l_sty_id okl_strm_type_v.id%TYPE;
457: l_evrgrn_strm_purpose okl_strm_type_v.stream_type_purpose%TYPE;
458: l_evrgrn_prim_strm_purpose okl_strm_type_v.stream_type_purpose%TYPE;
459: l_se_line_number OKL_STRM_ELEMENTS_V.SE_LINE_NUMBER%TYPE;
460: l_stm_id OKL_STREAMS_V.ID%TYPE;
461: l_sel_id Okl_strm_elements_v.sel_id%TYPE;

Line 458: l_evrgrn_prim_strm_purpose okl_strm_type_v.stream_type_purpose%TYPE;

454: l_khr_id okl_k_headers.id%TYPE;
455: l_kle_id okl_streams.kle_id%TYPE;
456: l_sty_id okl_strm_type_v.id%TYPE;
457: l_evrgrn_strm_purpose okl_strm_type_v.stream_type_purpose%TYPE;
458: l_evrgrn_prim_strm_purpose okl_strm_type_v.stream_type_purpose%TYPE;
459: l_se_line_number OKL_STRM_ELEMENTS_V.SE_LINE_NUMBER%TYPE;
460: l_stm_id OKL_STREAMS_V.ID%TYPE;
461: l_sel_id Okl_strm_elements_v.sel_id%TYPE;
462:

Line 526: okl_strm_type_v sty

522: WHERE EXISTS(
523: SELECT 1
524: FROM OKL_POOLS pool,
525: okl_pool_contents_v poc,
526: okl_strm_type_v sty
527: WHERE pool.khr_id = p_khr_id AND
528: pool.id = poc.pol_id AND
529: poc.sty_id = sty.id AND
530: sty.stream_type_purpose = 'RESIDUAL_VALUE'