[Home] [Help]
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;
170: l_ln l_line_name%ROWTYPE;
173: SELECT cle.id,
174: sub_kle.price_negotiated amount
175: FROM OKC_K_LINES_B cle,
176: OKC_K_LINES_B sub_kle,
177: OKC_LINE_STYLES_B ls,
178: OKC_STATUSES_B sts
179: WHERE cle.lse_id = ls.id
180: AND ls.lty_code = ltycode
181: AND cle.dnz_chr_id = chrid
187: CURSOR l_svclne_csr(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE) IS
188: SELECT cle.id,
189: cle.price_negotiated amount
190: FROM OKC_K_LINES_B cle,
191: OKC_LINE_STYLES_B ls,
192: OKC_STATUSES_B sts
193: WHERE cle.lse_id = ls.id
194: AND ls.lty_code = ltycode
195: AND cle.dnz_chr_id = chrid
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
219: AND kle.dnz_chr_id = chrid
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
247: AND kle.dnz_chr_id = chrid
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
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'
269: and kle.id = cim.cle_id
273: select okx.inventory_item_id,
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'
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'
331: and cim.cle_id = kle.id
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
351: and ls.id = kle.lse_id
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
380: and fa.lse_id = fa_lse.id
381: and fa_lse.lty_code = 'FIXED_ASSET'
384:
385: Cursor ib_qty_csr (FinAsstid NUMBER) is
386: select count(inst.id)
387: from okc_k_lines_b inst,
388: okc_line_styles_b inst_lse
389: where inst.cle_id = FinAsstId
390: and inst.lse_id = inst_lse.id
391: and inst_lse.lty_code = 'FREE_FORM2';
392: