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 OKC_K_LINES_B

Line 191: okc_k_lines_b kle,

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,
194: okl_strm_elements ste -- SECHAWLA 21-APR-03 2925120 :Added this table
195: WHERE stm.khr_id = cp_chr_id

Line 224: okc_k_lines_b cle,

220: SELECT stm.kle_id contract_line_id,
221: stm.sty_id stream_type_id,
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,

Line 253: FROM okc_k_lines_b cle,

249: CURSOR l_total_payments_csr (
250: cp_cle_id NUMBER,
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

Line 475: okc_k_lines_b kle,

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
478: WHERE stm.khr_id = cp_chr_id
479: AND stm.active_yn = 'Y'

Line 541: okc_k_lines_b kle,

537: SELECT stm.kle_id contract_line_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

Line 772: ,okc_k_lines_b cle,

768: l.stream_type_id stream_type_id,
769: SUM (l.amount_due_remaining) amount_due
770: FROM okl_bpd_ar_inv_lines_v l
771: , OKC_K_HEADERS_B CHR
772: ,okc_k_lines_b cle,
773: okc_statuses_b sts
774: WHERE l.contract_id = cp_chr_id
775: and l.contract_line_id = cle.id
776: and sts.code = cle.sts_code

Line 794: ,okc_k_lines_b cle

790: l.stream_type_id stream_type_id,
791: SUM (l.amount_due_remaining) amount_due
792: FROM okl_bpd_ar_inv_lines_v l
793: , OKC_K_HEADERS_all_B CHR
794: ,okc_k_lines_b cle
795: WHERE l.contract_id = cp_chr_id
796: and l.contract_line_id = cle.id(+)
797: and ( cle.sts_code not in ('EXPIRED','TERMINATED','CANCELLED')
798: or cle.sts_code is null)