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,
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'
222: kle.capital_amount line_payment
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
251: cp_link_style VARCHAR2) IS
252: SELECT sum (kle.capital_amount) total_payment
253: FROM okc_k_lines_b cle,
254: okl_k_lines_v kle,
255: okc_line_styles_b lse
256: WHERE cle.cle_id = cp_cle_id
257: AND lse.id = cle.lse_id
258: AND lse.lty_code = cp_link_style
259: AND kle.id = cle.id;
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
478: WHERE stm.khr_id = cp_chr_id
479: AND stm.active_yn = 'Y'
480: AND stm.say_code = 'CURR'
481: AND ste.stm_id = stm.id
538: stm.sty_id stream_type_id,
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