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_ELEMENTS

Line 152: FROM okl_strm_elements ste

148: -- Upper Bound for Rental/S And M Date
149: ------------------------------------------------------------
150: CURSOR upper_rental_date_csr ( p_khr_id NUMBER, p_kle_id NUMBER, p_sty_purpose VARCHAR2) IS
151: SELECT TRUNC(MAX( ste.STREAM_ELEMENT_DATE )) upper_stream_date
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

Line 169: FROM okl_strm_elements ste

165: -- Lower Bound for Rental/S And M Date
166: ------------------------------------------------------------
167: CURSOR lower_rental_date_csr ( p_khr_id NUMBER, p_kle_id NUMBER, p_sty_purpose VARCHAR2, p_max_date DATE) IS
168: SELECT TRUNC(MAX( ste.STREAM_ELEMENT_DATE )) lower_stream_date
169: FROM okl_strm_elements ste
170: WHERE ste.stream_element_date <= p_max_date
171: AND ste.stm_id IN (
172: SELECT stm.id
173: FROM okl_streams stm,

Line 192: FROM okl_strm_elements ste,

188: contract line. Ordered the stream element dates in descending order and picked the
189: the amount for the max stream element date excluding the stream element for stub
190: payment */
191: SELECT ste.amount
192: FROM okl_strm_elements ste,
193: (
194: SELECT stm.id, to_number(rule_information6) amt
195: FROM okc_rules_b a,
196: okc_rule_groups_b b,

Line 219: FROM okl_strm_elements ste

215:
216: /*
217: CURSOR bill_amt_csr ( p_khr_id NUMBER, p_kle_id NUMBER, p_sty_purpose VARCHAR2) IS
218: SELECT MIN (ste.amount) amount
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

Line 237: FROM okl_strm_elements ste

233: -- Check Evergreen elements exist
234: ------------------------------------------------------------
235: CURSOR evergreen_element_csr ( p_khr_id NUMBER, p_kle_id NUMBER, p_sty_purpose VARCHAR2) IS
236: SELECT MAX( ste.STREAM_ELEMENT_DATE ) evergreen_element_date
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

Line 275: FROM okl_strm_elements

271: -- Max Line Number
272: ------------------------------------------------------------
273: CURSOR max_line_num_csr (p_stm_id NUMBER) IS
274: SELECT max(se_line_number)
275: FROM okl_strm_elements
276: WHERE stm_id = p_stm_id;
277:
278: ------------------------------------------------------------
279: -- To Check if a stream element already exists

Line 283: FROM okl_strm_elements

279: -- To Check if a stream element already exists
280: ------------------------------------------------------------
281: CURSOR stm_rec_exists_csr (p_stm_id NUMBER, p_sel_date DATE) IS
282: SELECT count(*)
283: FROM okl_strm_elements
284: WHERE stm_id = p_stm_id
285: AND trunc(STREAM_ELEMENT_DATE) = trunc(p_sel_date);
286:
287: ------------------------------------------------------------

Line 292: FROM okl_strm_elements

288: -- To Check if previously unbilled stream elements exist
289: ------------------------------------------------------------
290: CURSOR prev_unbilled_csr (p_stm_id NUMBER, p_sel_date DATE) IS
291: SELECT count(*)
292: FROM okl_strm_elements
293: WHERE stm_id = p_stm_id
294: AND trunc(STREAM_ELEMENT_DATE) <= trunc(p_sel_date)
295: AND date_billed is NULL;
296:

Line 308: FROM okl_strm_elements_v ste

304: ,ste.stream_element_date
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

Line 355: FROM okl_strm_elements_v

351: -- Stream Element Line Number Cursor
352: ------------------------------------------------------------
353: CURSOR l_stream_line_nbr_csr(cp_stm_id IN NUMBER) IS
354: SELECT max(se_line_number) se_line_number
355: FROM okl_strm_elements_v
356: WHERE stm_id = cp_stm_id;
357:
358: ------------------------------------------------------------
359: -- Initialise constants

Line 413: l_se_line_number OKL_STRM_ELEMENTS_V.SE_LINE_NUMBER%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:
417: l_amount NUMBER;

Line 415: l_sel_id Okl_strm_elements_v.sel_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:
419: l_billing_frequency NUMBER;