[Home] [Help]
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;
172: l_ln l_line_name%ROWTYPE;
175: SELECT cle.id,
176: sub_kle.price_negotiated amount
177: FROM OKC_K_LINES_B cle,
178: OKC_K_LINES_B sub_kle,
179: OKC_LINE_STYLES_B ls,
180: OKC_STATUSES_B sts
181: WHERE cle.lse_id = ls.id
182: AND ls.lty_code = ltycode
183: AND cle.dnz_chr_id = chrid
189: CURSOR l_svclne_csr(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE) IS
190: SELECT cle.id,
191: cle.price_negotiated amount
192: FROM OKC_K_LINES_B cle,
193: OKC_LINE_STYLES_B ls,
194: OKC_STATUSES_B sts
195: WHERE cle.lse_id = ls.id
196: AND ls.lty_code = ltycode
197: AND cle.dnz_chr_id = chrid
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
221: AND kle.dnz_chr_id = chrid
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
249: AND kle.dnz_chr_id = chrid
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
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'
271: and kle.id = cim.cle_id
275: select okx.inventory_item_id,
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'
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'
333: and cim.cle_id = kle.id
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
353: and ls.id = kle.lse_id
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
382: and fa.lse_id = fa_lse.id
383: and fa_lse.lty_code = 'FIXED_ASSET'
386:
387: Cursor ib_qty_csr (FinAsstid NUMBER) is
388: select count(inst.id)
389: from okc_k_lines_b inst,
390: okc_line_styles_b inst_lse
391: where inst.cle_id = FinAsstId
392: and inst.lse_id = inst_lse.id
393: and inst_lse.lty_code = 'FREE_FORM2';
394: