APPS.OKL_LA_STREAM_PVT dependencies on OKC_LINE_STYLES_B

Line 306: okc_line_styles_b lse,

302: -- Added by RGOOTY: ESG Down Payment
303: kle.capital_reduction,
304: kle.capitalize_down_payment_yn
305: FROM okl_k_lines_full_v kle,
306: okc_line_styles_b lse,
307: okc_k_lines_tl tl,
308: okc_statuses_b sts
309: WHERE kle.lse_id = lse.id
310: AND lse.lty_code = lnetype

Line 332: okc_line_styles_b LS,

328: kle.price_negotiated,
329: kle.start_date,
330: kle.capital_amount
331: FROM okl_k_lines_full_v kle,
332: okc_line_styles_b LS,
333: okc_k_items cim
334: WHERE ls.id = kle.lse_id
335: AND ls.lty_code = lnetype
336: AND cim.jtot_object1_code = obcode

Line 352: okc_line_styles_b ls

348: FROM okl_strm_type_tl tl,
349: okl_strm_type_v sty,
350: okc_k_items cim,
351: okl_k_lines_full_v kle,
352: okc_line_styles_b ls
353: WHERE tl.id = sty.id
354: AND tl.language = 'US'
355: AND cim.cle_id = kle.id
356: AND ls.id = kle.lse_id

Line 383: okc_line_styles_b lse_ib,

379: FROM hz_locations hl,
380: hz_party_sites hps,
381: hz_party_site_uses hpsu,
382: okl_txl_itm_insts iti,
383: okc_line_styles_b lse_ib,
384: okc_k_lines_b cle_ib
385: WHERE cle_ib.dnz_chr_id = chrId
386: AND cle_ib.lse_id = lse_ib.id
387: AND lse_ib.lty_code = 'INST_ITEM'

Line 452: okc_line_styles_b lse,

448: AND str.khr_id = chrId
449: AND (NVL( str.kle_id, -1) = -1 OR
450: str.kle_id IN (SELECT kle.id
451: FROM okl_k_lines_full_v kle,
452: okc_line_styles_b lse,
453: okc_statuses_b sts
454: WHERE KLE.LSE_ID = LSE.ID
455: AND kle.dnz_chr_id = chrId
456: AND sts.code = kle.sts_code

Line 475: okc_line_styles_b lse,

471: CURSOR total_oec_csr(p_chr_id NUMBER)
472: IS
473: SELECT sum(kle.oec) total_oec
474: FROM okl_k_lines_full_v kle,
475: okc_line_styles_b lse,
476: okc_k_lines_tl tl,
477: okc_statuses_b sts
478: WHERE kle.lse_id = lse.id
479: AND lse.lty_code = 'FREE_FORM1'