APPS.OKL_QA_DATA_INTEGRITY dependencies on OKC_K_ITEMS

Line 259: okc_k_items cim,

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

Line 268: okc_k_items cim

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

Line 280: okc_k_items cim

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

Line 327: From okc_K_items cim,

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

Line 347: okc_k_items cim,

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

Line 377: from okc_k_items cim,

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