APPS.OKL_QA_DATA_INTEGRITY dependencies on OKL_K_LINES_FULL_V

Line 165: FROM OKL_K_LINES_FULL_V kle,

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

Line 213: FROM OKL_K_LINES_FULL_V kle,

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

Line 214: OKL_K_LINES_FULL_V sub_kle,

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

Line 242: FROM OKL_K_LINES_FULL_V kle,

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

Line 255: from okl_k_lines_full_v kle,

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

Line 258: okl_k_lines_full_v kle1

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

Line 264: from okl_k_lines_full_v kle,

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

Line 326: okl_K_lines_full_v kle,

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

Line 346: okl_k_lines_full_v kle,

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