[Home] [Help]
125: select cle.id kle_id
126: from
127: okc_k_headers_b chr,
128: okc_k_lines_b cle,
129: okc_line_styles_b lse,
130: okc_k_items cim,
131: okl_strm_type_b sty
132: where
133: chr.id = p_khr_id
1060: IS
1061: SELECT 1
1062: FROM OKC_K_HEADERS_B KHR,
1063: OKC_K_LINES_B CLE,
1064: OKC_LINE_STYLES_B LSE
1065: WHERE CLE.CHR_ID = KHR.ID
1066: AND KHR.ID = p_khr_id
1067: AND CLE.LSE_ID = LSE.ID
1068: AND LSE.LTY_CODE IN ('SOLD_SERVICE','LINK_SERV_ASSET');