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_AM_CALC_QUOTE_STREAM_PVT dependencies on OKL_STRM_ELEMENTS

Line 194: okl_strm_elements ste -- SECHAWLA 21-APR-03 2925120 :Added this table

190: okl_strm_type_b sty,
191: okc_k_lines_b kle,
192: okc_statuses_b kls,
193: okc_line_styles_b lse,
194: okl_strm_elements ste -- SECHAWLA 21-APR-03 2925120 :Added this table
195: WHERE stm.khr_id = cp_chr_id
196: AND stm.active_yn = 'Y'
197: AND stm.say_code = 'CURR'
198: AND ste.stm_id = stm.id -- SECHAWLA 21-APR-03 2925120 : Added this condition

Line 229: okl_strm_elements ste -- SECHAWLA 21-APR-03 2925120 :Added this table

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
232: AND lse.id = cle.lse_id
233: AND lse.lty_code = cp_link_style

Line 445: okl_strm_elements ste,

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
449: AND stm.active_yn = 'Y'

Line 473: okl_strm_elements ste,

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,
477: okc_line_styles_b lse

Line 507: okl_strm_elements ste,

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
511: AND stm.active_yn = 'Y'

Line 545: okl_strm_elements ste

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
548: AND lse.id = kle.lse_id
549: AND cp_exclude_styles NOT LIKE