APPS.OKL_LA_STREAM_PVT dependencies on OKC_K_ITEMS

Line 8688: okc_k_items cim,

8684: stl.pricing_name pricing_name,
8685: kle.id line_id,
8686: stl.id styp_id
8687: FROM OKL_STRM_TMPT_LINES_UV stl,
8688: okc_k_items cim,
8689: okl_k_lines_full_v kle,
8690: okc_line_styles_b ls
8691: WHERE cim.cle_id = kle.id
8692: AND ls.id = kle.lse_id

Line 9478: okc_k_items cim,

9474: IS
9475: SELECT crl.rule_information2 amount,
9476: styt.name strm_name
9477: FROM okl_strm_type_tl styt,
9478: okc_k_items cim,
9479: okc_rule_groups_b crg,
9480: okc_rules_b crl
9481: WHERE crl.rgp_id = crg.id
9482: AND crg.RGD_CODE = 'LAFEXP'

Line 9527: okc_k_items cim,

9523: styt.name strm_name,
9524: kle.fee_purpose_code fee_purpose_code,
9525: styt.id sty_id
9526: FROM okl_strm_type_tl styt,
9527: okc_k_items cim,
9528: okc_k_lines_b cle,
9529: okl_k_lines kle
9530: WHERE cle.dnz_chr_id = p_chr_d
9531: AND cle.id = p_cle_id

Line 22160: okc_k_items cim,

22156: IS
22157: SELECT NVL(kle.amount, 0) total_cap_fee
22158: FROM okl_k_lines kle,
22159: okc_k_lines_b cle,
22160: okc_k_items cim,
22161: okl_strm_type_b sty
22162: WHERE cle.dnz_chr_id = p_chr_id
22163: AND cle.id = kle.id
22164: AND cle.id = cim.cle_id