APPS.OKL_QA_DATA_INTEGRITY dependencies on OKC_K_ITEMS

Line 257: okc_k_items cim,

253: cim.number_of_items,
254: kle.name
255: from okl_k_lines_full_v kle,
256: OKC_LINE_STYLES_B LS,
257: okc_k_items cim,
258: okl_k_lines_full_v kle1
259: where LS.ID = KLE.LSE_ID
260: and ls.lty_code = 'ITEM'
261: and kle.id = cim.cle_id

Line 266: okc_k_items cim

262: and kle.id = kle1.id
263: and kle1.cle_id = (select cim.object1_id1
264: from okl_k_lines_full_v kle,
265: OKC_LINE_STYLES_B LS,
266: okc_k_items cim
267: where LS.ID = KLE.LSE_ID
268: and ls.lty_code = 'LINK_SERV_ASSET'
269: and kle.id = cim.cle_id
270: and kle.id = kleId);

Line 278: okc_k_items cim

274: okx.quantity
275: from csi_item_instances okx,
276: okc_k_lines_b kle,
277: OKC_LINE_STYLES_B LS,
278: okc_k_items cim
279: where okx.instance_ID = cim.object1_id1
280: and LS.ID = KLE.LSE_ID
281: and ls.lty_code = 'COVER_PROD'
282: and kle.id = cim.cle_id

Line 325: From okc_K_items cim,

321:
322: Cursor l_itms_csr( ltycode VARCHAR2, kleId NUMBER, chrId NUMBER ) IS
323: Select cim.object1_id1 FinAssetId,
324: cim.number_of_items number_of_items
325: From okc_K_items cim,
326: okl_K_lines_full_v kle,
327: okc_line_styles_b lse
328: Where kle.lse_id = lse.id
329: and lse.lty_code = ltycode

Line 345: okc_k_items cim,

341: sty.id styp_id,
342: sty.stream_type_class stream_type_class
343: from okl_strm_type_tl tl,
344: okl_strm_type_v sty,
345: okc_k_items cim,
346: okl_k_lines_full_v kle,
347: okc_line_styles_b ls
348: where tl.id = sty.id
349: and tl.language = USERENV('LANG')

Line 375: from okc_k_items cim,

371: --cursor to check usage line instance quantities
372: Cursor asst_qty_csr (FinAsstid NUMBER) is
373: select cim.number_of_items,
374: fa.id fa_id
375: from okc_k_items cim,
376: okc_k_lines_b fa,
377: okc_line_styles_b fa_lse
378: where cim.cle_id = fa.id
379: and cim.dnz_chr_id = fa.dnz_chr_id