[Home] [Help]
5018: tl.name
5019: FROM okl_k_lines_full_v kle,
5020: okc_line_styles_b lse,
5021: okc_k_lines_tl tl,
5022: okc_statuses_b sts
5023: WHERE kle.lse_id = lse.id
5024: AND lse.lty_code in ( 'FREE_FORM1', 'FEE', 'SOLD_SERVICE', 'LINK_SERV_ASSET')--bug# 3343133 (ssiruvol)
5025: AND tl.id = kle.id
5026: AND tl.language = USERENV('LANG')
6850: , TRUNC(CLE.DATE_TERMINATED) TERMINATION_DATE
6851: FROM OKL_K_HEADERS KHR
6852: , OKC_K_LINES_B CLE
6853: , OKC_LINE_STYLES_B LSE
6854: , OKC_STATUSES_B STS
6855: WHERE CLE.DNZ_CHR_ID = KHR.ID
6856: AND LSE.ID = CLE.LSE_ID
6857: AND LSE.LTY_CODE ='FREE_FORM1'
6858: AND STS.CODE = CLE.STS_CODE
7017: SELECT CLE.ID LINE_ID
7018: FROM OKL_K_HEADERS KHR
7019: , OKC_K_LINES_B CLE
7020: , OKC_LINE_STYLES_B LSE
7021: , OKC_STATUSES_B STS
7022: WHERE CLE.DNZ_CHR_ID = KHR.ID
7023: AND LSE.ID = CLE.LSE_ID
7024: AND LSE.LTY_CODE ='FREE_FORM1'
7025: AND STS.CODE = CLE.STS_CODE
7201: --okl_strm_type_v sty,
7202: OKL_STRM_TMPT_LINES_UV sty,
7203: okl_k_lines_full_v kle,
7204: okc_line_styles_b lse,
7205: okc_statuses_b sts
7206: Where ele.stm_id = str.id
7207: and str.khr_id = chrId
7208: and str.kle_id = kle.id
7209: and str.sty_id = sty.primary_sty_id
7859: FROM OKC_K_LINES_B LNK_CLE
7860: , OKC_LINE_STYLES_B LNK_LSE
7861: , OKL_K_LINES FEE_KLE
7862: , OKC_K_LINES_B FEE_CLE
7863: , OKC_STATUSES_B STS
7864: WHERE LNK_CLE.CLE_ID = FEE_CLE.ID
7865: AND LNK_CLE.DNZ_CHR_ID = cp_chr_id
7866: AND FEE_CLE.DNZ_CHR_ID = cp_chr_id
7867: AND LNK_LSE.ID = LNK_CLE.LSE_ID
7880: , CLE.DATE_TERMINATED
7881: FROM OKL_K_HEADERS KHR
7882: , OKC_K_LINES_B CLE
7883: , OKC_LINE_STYLES_B LSE
7884: , OKC_STATUSES_B STS
7885: WHERE CLE.DNZ_CHR_ID = KHR.ID
7886: AND LSE.ID = CLE.LSE_ID
7887: AND LSE.LTY_CODE ='FREE_FORM1'
7888: AND STS.CODE = CLE.STS_CODE
8691: AND (NVL( str.kle_id, -1) = -1 OR
8692: str.kle_id IN (SELECT kle.id
8693: FROM okl_k_lines_full_v kle,
8694: okc_line_styles_b lse,
8695: okc_statuses_b sts
8696: WHERE KLE.LSE_ID = LSE.ID
8697: AND kle.dnz_chr_id = p_chr_id
8698: AND sts.code = kle.sts_code
8699: AND lse.lty_code NOT IN ('INSURANCE')));
9612: IS
9613: SELECT cle.id
9614: FROM okc_k_lines_b cle,
9615: okc_line_styles_b lse,
9616: okc_statuses_b sts
9617: WHERE cle.dnz_chr_id = chrid
9618: AND cle.lse_id = lse.id
9619: AND lse.lty_code = 'FREE_FORM1'
9620: AND sts.code = cle.sts_code
9626: SELECT kle.fee_type
9627: FROM okl_k_lines kle,
9628: okc_k_lines_b cle,
9629: okc_line_styles_b lse,
9630: okc_statuses_b sts
9631: WHERE cle.lse_id = lse.id
9632: AND lse.lty_code = 'FEE'
9633: AND cle.dnz_chr_id = chrid
9634: AND cle.id = kle.id
9644: SELECT cle.id fin_id
9645: FROM okc_k_lines_b cle,
9646: okc_line_styles_b lse,
9647: okl_k_lines kle,
9648: okc_statuses_b sts
9649: WHERE cle.dnz_chr_id = chrId
9650: AND cle.lse_id = lse.id
9651: AND lse.lty_code = 'FEE'
9652: AND cle.id = kle.id
9660: SELECT cle.id fin_id
9661: FROM okc_k_lines_b cle,
9662: okc_line_styles_b lse,
9663: okl_k_lines kle,
9664: okc_statuses_b sts
9665: WHERE cle.dnz_chr_id = chrId
9666: AND cle.lse_id = lse.id
9667: AND lse.lty_code = 'FEE'
9668: AND cle.id = kle.id
9692: FROM okl_sgn_translations sgn,
9693: okl_strm_type_b sty,
9694: okl_subsidies_v sub,
9695: okl_k_lines kle,
9696: okc_statuses_b sts,
9697: okc_line_styles_b lse,
9698: okc_k_lines_b cle
9699: WHERE cle.dnz_chr_id = p_dnz_chr_id
9700: AND cle.lse_id = lse.id
9716: --srsreeni Bug5699923 End
9717: FROM okl_k_lines kle,
9718: okc_k_lines_b cle,
9719: okl_subsidies_v sub,
9720: okc_statuses_b sts,
9721: okc_line_styles_b lse
9722: WHERE cle.dnz_chr_id = p_dnz_chr_id
9723: AND cle.lse_id = lse.id
9724: AND lse.lty_code = 'SUBSIDY'
10184: kle.orig_contract_line_id --sechawla 15-jul-09 PRB ESG Enhancements : added orig_contract_line_id
10185: from okl_k_lines_full_v kle,
10186: okc_line_styles_b lse,
10187: okc_k_lines_tl tl,
10188: okc_statuses_b sts
10189: where KLE.LSE_ID = LSE.ID
10190: and lse.lty_code = lnetype
10191: and tl.id = kle.id
10192: and tl.language = userenv('LANG')
11039: kle.orig_contract_line_id --sechawla 15-jul-09 ESG PRB Enhancements : added orig_contract_line_id
11040: FROM okl_k_lines_full_v kle,
11041: okc_line_styles_b lse,
11042: okc_k_lines_tl tl,
11043: okc_statuses_b sts
11044: WHERE kle.lse_id = lse.id
11045: AND lse.lty_code = 'LINK_FEE_ASSET'
11046: AND tl.id = kle.id
11047: AND kle.cle_id = p_cle_id
11093: okc.start_date --11-Sep-09 sechawla 8798556 : added
11094: FROM okc_k_lines_b okc,
11095: okl_k_lines kle ,
11096: okc_line_styles_b lse
11097: ,okc_statuses_b sts
11098: WHERE okc.cle_id = cleId
11099: AND okc.lse_id = lse.id
11100: AND okc.id = kle.id
11101: AND lty_code = 'LINK_FEE_ASSET'
20274: kle.capital_reduction_percent
20275: FROM okl_k_lines_full_v kle,
20276: okc_line_styles_b lse,
20277: okc_k_lines_tl tl,
20278: okc_statuses_b sts
20279: WHERE kle.lse_id = lse.id
20280: AND lse.lty_code = lnetype
20281: AND tl.id = kle.id
20282: AND tl.language = userenv('LANG')
24794: tl.name
24795: FROM okl_k_lines_full_v kle,
24796: okc_line_styles_b lse,
24797: okc_k_lines_tl tl,
24798: okc_statuses_b sts
24799: WHERE kle.lse_id = lse.id
24800: AND lse.lty_code = lnetype
24801: AND tl.id = kle.id
24802: AND tl.language = userenv('LANG')
24829: tl.name
24830: FROM okl_k_lines_full_v kle,
24831: okc_line_styles_b lse,
24832: okc_k_lines_tl tl,
24833: okc_statuses_b sts
24834: WHERE kle.lse_id = lse.id
24835: AND lse.lty_code = 'SO_PAYMENT'
24836: AND kle.id = p_cle_id
24837: AND tl.id = kle.id