APPS.OKL_QA_DATA_INTEGRITY dependencies on OKL_K_LINES_FULL_V

Line 167: FROM OKL_K_LINES_FULL_V kle,

163: AND khr.pdt_id = pdt.id;
164:
165: CURSOR l_line_name ( n VARCHAR2 ) IS
166: Select count(*) cnt
167: FROM OKL_K_LINES_FULL_V kle,
168: OKC_LINE_STYLES_B ls
169: WHERE kle.lse_id = ls.id
170: AND ls.lty_code = 'FREE_FORM1'
171: AND kle.name = n;

Line 215: FROM OKL_K_LINES_FULL_V kle,

211: kle.residual_code,
212: kle.residual_grnty_amount,
213: sub_kle.capital_amount amount,
214: sub_kle.line_number
215: FROM OKL_K_LINES_FULL_V kle,
216: OKL_K_LINES_FULL_V sub_kle,
217: OKC_LINE_STYLES_B ls,
218: OKC_STATUSES_B sts
219: WHERE kle.lse_id = ls.id

Line 216: OKL_K_LINES_FULL_V sub_kle,

212: kle.residual_grnty_amount,
213: sub_kle.capital_amount amount,
214: sub_kle.line_number
215: FROM OKL_K_LINES_FULL_V kle,
216: OKL_K_LINES_FULL_V sub_kle,
217: OKC_LINE_STYLES_B ls,
218: OKC_STATUSES_B sts
219: WHERE kle.lse_id = ls.id
220: AND ls.lty_code = ltycode

Line 244: FROM OKL_K_LINES_FULL_V kle,

240: -- bug 5034519
241: kle.start_date,
242: --Bug# 4631549
243: kle.expected_asset_cost
244: FROM OKL_K_LINES_FULL_V kle,
245: OKC_LINE_STYLES_B ls,
246: OKC_STATUSES_B sts
247: WHERE kle.lse_id = ls.id
248: AND ls.lty_code = ltycode

Line 257: from okl_k_lines_full_v kle,

253: cursor l_subline_csr( kleId NUMBER) is
254: select cim.object1_id1,
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

Line 260: okl_k_lines_full_v kle1

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
264: and kle.id = kle1.id

Line 266: from okl_k_lines_full_v kle,

262: and ls.lty_code = 'ITEM'
263: and kle.id = cim.cle_id
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'

Line 328: okl_K_lines_full_v kle,

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
332: and cim.jtot_object1_code = 'OKX_COVASST'

Line 348: okl_k_lines_full_v kle,

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')
352: and cim.cle_id = kle.id