DBA Data[Home] [Help]

APPS.OKL_AM_CALC_QUOTE_STREAM_PVT dependencies on OKL_STREAMS

Line 189: FROM okl_streams stm,

185: cp_link_style VARCHAR2,
186: cp_quote_eff_date DATE) IS
187: SELECT stm.kle_id contract_line_id,
188: stm.sty_id stream_type_id
189: FROM okl_streams stm,
190: okl_strm_type_b sty,
191: okc_k_lines_b kle,
192: okc_statuses_b kls,
193: okc_line_styles_b lse,

Line 227: okl_streams stm,

223: FROM okc_k_items ite,
224: okc_k_lines_b cle,
225: okl_k_lines_v kle,
226: okc_line_styles_b lse,
227: okl_streams stm,
228: okl_strm_type_b sty,
229: okl_strm_elements ste -- SECHAWLA 21-APR-03 2925120 :Added this table
230: WHERE ite.object1_id1 = cp_cle_id
231: AND cle.id = ite.cle_id

Line 444: FROM okl_streams stm,

440: cp_quote_eff_date DATE) IS
441: SELECT stm.kle_id contract_line_id,
442: stm.sty_id stream_type_id,
443: SUM (ste.amount) amount_due
444: FROM okl_streams stm,
445: okl_strm_elements ste,
446: okl_strm_type_b sty
447: WHERE stm.khr_id = cp_chr_id
448: AND stm.kle_id IS NULL

Line 472: FROM okl_streams stm,

468: cp_quote_eff_date DATE) IS
469: SELECT stm.kle_id contract_line_id,
470: stm.sty_id stream_type_id,
471: SUM (ste.amount) amount_due
472: FROM okl_streams stm,
473: okl_strm_elements ste,
474: okl_strm_type_b sty,
475: okc_k_lines_b kle,
476: okc_statuses_b kls,

Line 506: FROM okl_streams stm,

502: cp_quote_eff_date DATE) IS
503: SELECT stm.kle_id contract_line_id,
504: stm.sty_id stream_type_id,
505: SUM (ste.amount) amount_due
506: FROM okl_streams stm,
507: okl_strm_elements ste,
508: okl_strm_type_b sty
509: WHERE stm.khr_id = cp_chr_id
510: AND stm.kle_id = cp_cle_id

Line 543: okl_streams stm,

539: SUM (ste.amount) amount_due
540: FROM okc_k_items ite,
541: okc_k_lines_b kle,
542: okc_line_styles_b lse,
543: okl_streams stm,
544: okl_strm_type_b sty,
545: okl_strm_elements ste
546: WHERE ite.object1_id1 = to_char(cp_cle_id) -- rmunjulu bug 5129653 need to_char as object1_id1 can be alphanumeric
547: AND kle.id = ite.cle_id