589: SELECT ste.amount amount
590: FROM okc_k_lines_b kle,
591: okc_line_styles_b lse,
592: okc_k_items ite,
593: okl_strm_type_b sty1,
594: okl_streams stm,
595: okl_strm_type_b sty2,
596: okl_strm_elements ste
597: WHERE kle.chr_id = p_contract_id
591: okc_line_styles_b lse,
592: okc_k_items ite,
593: okl_strm_type_b sty1,
594: okl_streams stm,
595: okl_strm_type_b sty2,
596: okl_strm_elements ste
597: WHERE kle.chr_id = p_contract_id
598: AND lse.id = kle.lse_id
599: AND lse.lty_code = 'FEE'