APPS.OKL_LA_STREAM_PVT dependencies on OKC_K_ITEMS

Line 8133: , OKC_K_ITEMS LNK_ITM

8129: FROM okc_k_headers_b CHR,
8130: okl_trx_contracts ktrx,
8131: okl_trx_contracts trx,
8132: okl_txl_quote_lines_b txl
8133: , OKC_K_ITEMS LNK_ITM
8134: WHERE CHR.ID = p_chr_id
8135: AND ktrx.KHR_ID = chr.id
8136: AND ktrx.tsu_code = 'ENTERED'
8137: AND ktrx.rbr_code IS NOT NULL

Line 10210: okc_k_items cim,

10206: stl.pricing_name pricing_name,
10207: kle.id line_id,
10208: stl.id styp_id
10209: FROM OKL_STRM_TMPT_LINES_UV stl,
10210: okc_k_items cim,
10211: okl_k_lines_full_v kle,
10212: okc_line_styles_b ls
10213: WHERE cim.cle_id = kle.id
10214: AND ls.id = kle.lse_id

Line 11064: okc_k_items cim,

11060: IS
11061: SELECT crl.rule_information2 amount,
11062: styt.name strm_name
11063: FROM okl_strm_type_tl styt,
11064: okc_k_items cim,
11065: okc_rule_groups_b crg,
11066: okc_rules_b crl
11067: WHERE crl.rgp_id = crg.id
11068: AND crg.RGD_CODE = 'LAFEXP'

Line 11115: okc_k_items cim,

11111: styt.name strm_name,
11112: kle.fee_purpose_code fee_purpose_code,
11113: styt.id sty_id
11114: FROM okl_strm_type_tl styt,
11115: okc_k_items cim,
11116: okc_k_lines_b cle,
11117: okl_k_lines kle
11118: WHERE cle.dnz_chr_id = p_chr_d
11119: AND cle.id = p_cle_id

Line 25003: okc_k_items cim,

24999: IS
25000: SELECT NVL(kle.amount, 0) total_cap_fee
25001: FROM okl_k_lines kle,
25002: okc_k_lines_b cle,
25003: okc_k_items cim,
25004: okl_strm_type_b sty
25005: WHERE cle.dnz_chr_id = p_chr_id
25006: AND cle.id = kle.id
25007: AND cle.id = cim.cle_id