[Home] [Help]
423: okl_streams str,
424: --okl_strm_type_tl sty,
425: okl_strm_type_v sty,
426: okl_K_lines_full_v kle,
427: okc_statuses_b sts
428: WHERE sele.stm_id = str.id
429: AND str.sty_id = sty.id
430: --AND UPPER(sty.name) = 'RENT'
431: AND sty.stream_type_purpose = 'RENT'
472: okl_streams str,
473: --okl_strm_type_tl sty,
474: okl_strm_type_v sty,
475: okl_K_lines_full_v kle,
476: okc_statuses_b sts
477: WHERE sele.stm_id = str.id
478: AND str.sty_id = sty.id
479: --AND UPPER(sty.name) = 'RENT'
480: AND sty.stream_type_purpose = 'RENT'
623: FROM okl_strm_elements sele,
624: okl_streams str,
625: okl_strm_type_v sty,
626: okl_K_lines_full_v kle,
627: okc_statuses_b sts
628: WHERE sele.stm_id = str.id
629: AND str.sty_id = sty.id
630: AND UPPER(sty.name) = 'UNEARNED INCOME'
631: AND str.khr_id = p_chr_id
684: NVL(kle.residual_percentage,0) Percent
685: ,ls.lty_code lty_Code --added bug 7439724
686: FROM OKC_LINE_STYLES_B LS,
687: okl_K_lines_full_v kle,
688: okc_statuses_b sts
689: WHERE LS.ID = KLE.LSE_ID
690: --Modified bug 7439724
691: AND LS.LTY_CODE in ('FREE_FORM1',
692: 'FEE',
702: NVL(kle.residual_percentage,0) Percent
703: ,ls.lty_code lty_Code --added bug 7439724
704: FROM OKC_LINE_STYLES_B LS,
705: okl_K_lines_full_v kle,
706: okc_statuses_b sts
707: WHERE LS.ID = KLE.LSE_ID
708: --Modified bug 7439724
709: AND LS.LTY_CODE in ('FREE_FORM1',
710: 'FEE',
906: CURSOR lines_csr( chrId NUMBER ) IS
907: SELECT kle.id lineId
908: FROM OKC_LINE_STYLES_B LS,
909: okl_K_lines_full_v kle,
910: okc_statuses_b sts
911: WHERE LS.ID = KLE.LSE_ID
912: AND LS.LTY_CODE ='FREE_FORM1'
913: AND KLE.DNZ_CHR_ID = chrId
914: AND kle.sts_code = sts.code
919: CURSOR lines_nr_csr( chrId NUMBER, p_line_type VARCHAR2 ) IS
920: SELECT kle.id lineId
921: FROM OKC_LINE_STYLES_B LS,
922: okl_K_lines_full_v kle,
923: okc_statuses_b sts
924: WHERE LS.ID = KLE.LSE_ID
925: AND LS.LTY_CODE ='FREE_FORM1'
926: AND KLE.DNZ_CHR_ID = chrId
927: AND kle.sts_code = sts.code
1676: IF l_discount_incl_terminated THEN
1677: SELECT NVL(SUM(kle.tradein_amount),0) INTO l_tradeIn_value
1678: FROM OKC_LINE_STYLES_B LS,
1679: okl_K_lines_full_v kle,
1680: okc_statuses_b sts
1681: WHERE LS.ID = KLE.LSE_ID
1682: AND LS.LTY_CODE ='FREE_FORM1'
1683: AND KLE.dnz_chr_iD = p_chr_id
1684: AND kle.sts_code = sts.code
1689:
1690: SELECT NVL(SUM(kle.tradein_amount),0) INTO l_tradeIn_value
1691: FROM OKC_LINE_STYLES_B LS,
1692: okl_K_lines_full_v kle,
1693: okc_statuses_b sts
1694: WHERE LS.ID = KLE.LSE_ID
1695: AND LS.LTY_CODE ='FREE_FORM1'
1696: AND KLE.dnz_chr_iD = p_chr_id
1697: AND kle.sts_code = sts.code
1714:
1715: SELECT NVL(SUM(kle.tradein_amount),0) INTO l_tradeIn_value
1716: FROM OKC_LINE_STYLES_B LS,
1717: okl_K_lines_full_v kle,
1718: okc_statuses_b sts
1719: WHERE LS.ID = KLE.LSE_ID
1720: AND LS.LTY_CODE ='FREE_FORM1'
1721: AND KLE.dnz_chr_iD = p_chr_id
1722: AND kle.sts_code = sts.code
1725: ELSE
1726: SELECT NVL(SUM(kle.tradein_amount),0) INTO l_tradeIn_value
1727: FROM OKC_LINE_STYLES_B LS,
1728: okl_K_lines_full_v kle,
1729: okc_statuses_b sts
1730: WHERE LS.ID = KLE.LSE_ID
1731: AND LS.LTY_CODE ='FREE_FORM1'
1732: AND KLE.dnz_chr_iD = p_chr_id
1733: AND kle.sts_code = sts.code
1782: kle.dnz_chr_id chrId,
1783: kle.id lneId
1784: FROM OKC_LINE_STYLES_B LS,
1785: okl_K_lines_full_v kle,
1786: okc_statuses_b sts
1787: WHERE LS.ID = kLE.LSE_ID
1788: AND LS.LTY_CODE ='FREE_FORM1'
1789: AND kLE.dnz_chr_id = chrID
1790: AND kLE.ID = lineID
1796: kle.dnz_chr_id chrId,
1797: kle.id lneId
1798: FROM OKC_LINE_STYLES_B LS,
1799: okl_K_lines_full_v kle,
1800: okc_statuses_b sts
1801: WHERE LS.ID = kLE.LSE_ID
1802: AND LS.LTY_CODE ='FREE_FORM1'
1803: AND kLE.dnz_chr_id = chrID
1804: AND kLE.ID = lineID
1905: CURSOR l_lines_csr( chrId NUMBER ) IS
1906: SELECT kle.id
1907: FROM okc_line_styles_b ls,
1908: okl_K_lines_full_v kle,
1909: okc_statuses_b sts
1910: WHERE ls.id = kle.lse_id
1911: AND ls.lty_code = 'FREE_FORM1'
1912: AND kle.dnz_chr_id = chrId
1913: AND kle.sts_code = sts.code
1920: CURSOR l_lines_csr_incl_terminated( chrId NUMBER ) IS
1921: SELECT kle.id
1922: FROM okc_line_styles_b ls,
1923: okl_K_lines_full_v kle,
1924: okc_statuses_b sts
1925: WHERE ls.id = kle.lse_id
1926: AND ls.lty_code = 'FREE_FORM1'
1927: AND kle.dnz_chr_id = chrId
1928: AND kle.sts_code = sts.code
1936: CURSOR l_lines_nr_csr( chrId NUMBER, p_line_type VARCHAR2 ) IS
1937: SELECT kle.id
1938: FROM okc_line_styles_b ls,
1939: okl_K_lines_full_v kle,
1940: okc_statuses_b sts
1941: WHERE ls.id = kle.lse_id
1942: AND ls.lty_code = 'FREE_FORM1'
1943: AND kle.dnz_chr_id = chrId
1944: AND kle.sts_code = sts.code
1953: CURSOR l_lines_nr_csr_incl_term( chrId NUMBER, p_line_type VARCHAR2 ) IS
1954: SELECT kle.id
1955: FROM okc_line_styles_b ls,
1956: okl_K_lines_full_v kle,
1957: okc_statuses_b sts
1958: WHERE ls.id = kle.lse_id
1959: AND ls.lty_code = 'FREE_FORM1'
1960: AND kle.dnz_chr_id = chrId
1961: AND kle.sts_code = sts.code
2111: NVL(kle.CAPITALIZE_DOWN_PAYMENT_YN, 'N') CAPITALIZE_DOWN_PAYMENT_YN,
2112: sts.ste_code
2113: FROM OKC_LINE_STYLES_B LS,
2114: okl_K_lines_full_v kle,
2115: okc_statuses_b sts
2116: WHERE LS.ID = KLE.LSE_ID
2117: AND LS.LTY_CODE ='FREE_FORM1'
2118: AND KLE.dnz_chr_id = p_chr_id
2119: AND KLE.ID = p_line_id
2155: END LOOP;
2156: /* SELECT NVL(kle.capital_reduction,0) INTO l_capred_value
2157: FROM OKC_LINE_STYLES_B LS,
2158: okl_K_lines_full_v kle,
2159: okc_statuses_b sts
2160: WHERE LS.ID = KLE.LSE_ID
2161: AND LS.LTY_CODE ='FREE_FORM1'
2162: AND KLE.dnz_chr_id = p_chr_id
2163: AND KLE.ID = p_line_id
2176:
2177: /* SELECT NVL(kle.capital_reduction,0) INTO l_capred_value
2178: FROM OKC_LINE_STYLES_B LS,
2179: okl_K_lines_full_v kle,
2180: okc_statuses_b sts
2181: WHERE LS.ID = KLE.LSE_ID
2182: AND LS.LTY_CODE ='FREE_FORM1'
2183: AND KLE.dnz_chr_id = p_chr_id
2184: AND KLE.ID = p_line_id
2200:
2201: /* SELECT NVL(kle.capital_reduction_percent,0) INTO l_capred_percent
2202: FROM OKC_LINE_STYLES_B LS,
2203: okl_K_lines_full_v kle,
2204: okc_statuses_b sts
2205: WHERE LS.ID = KLE.LSE_ID
2206: AND LS.LTY_CODE ='FREE_FORM1'
2207: AND KLE.dnz_chr_id = p_chr_id
2208: AND KLE.ID = p_line_id
2221:
2222: /* SELECT NVL(kle.capital_reduction_percent,0) INTO l_capred_percent
2223: FROM OKC_LINE_STYLES_B LS,
2224: okl_K_lines_full_v kle,
2225: okc_statuses_b sts
2226: WHERE LS.ID = KLE.LSE_ID
2227: AND LS.LTY_CODE ='FREE_FORM1'
2228: AND KLE.dnz_chr_id = p_chr_id
2229: AND KLE.ID = p_line_id
2287: FROM OKC_LINE_STYLES_B LSEB,
2288: OKC_K_ITEMS CIM,
2289: OKL_K_LINES KLE_COV,
2290: OKC_K_LINES_B CLEB_COV,
2291: OKC_STATUSES_B STSB
2292: WHERE LSEB.ID = CLEB_COV.LSE_ID
2293: AND LSEB.lty_code = 'LINK_FEE_ASSET'
2294: AND CIM.jtot_object1_code = 'OKX_COVASST'
2295: AND CLEB_COV.id = CIM.cle_id
2304: FROM OKC_LINE_STYLES_B LSEB,
2305: OKC_K_ITEMS CIM,
2306: OKL_K_LINES KLE_COV,
2307: OKC_K_LINES_B CLEB_COV,
2308: OKC_STATUSES_B STSB
2309: WHERE LSEB.ID = CLEB_COV.LSE_ID
2310: AND LSEB.lty_code = 'LINK_FEE_ASSET'
2311: AND CIM.jtot_object1_code = 'OKX_COVASST'
2312: AND CLEB_COV.id = CIM.cle_id
2427: CURSOR l_lines_csr( chrId NUMBER ) IS
2428: SELECT kle.id
2429: FROM okc_line_styles_b ls,
2430: okl_K_lines_full_v kle,
2431: okc_statuses_b sts
2432: WHERE ls.id = kle.lse_id
2433: AND ls.lty_code = 'FREE_FORM1'
2434: AND kle.dnz_chr_id = chrId
2435: AND kle.sts_code = sts.code
2438: CURSOR l_lines_csr_incl_terminated( chrId NUMBER ) IS
2439: SELECT kle.id
2440: FROM okc_line_styles_b ls,
2441: okl_K_lines_full_v kle,
2442: okc_statuses_b sts
2443: WHERE ls.id = kle.lse_id
2444: AND ls.lty_code = 'FREE_FORM1'
2445: AND kle.dnz_chr_id = chrId
2446: AND kle.sts_code = sts.code
2451: CURSOR l_lines_nr_csr( chrId NUMBER, p_line_type VARCHAR2 ) IS
2452: SELECT kle.id
2453: FROM okc_line_styles_b ls,
2454: okl_K_lines_full_v kle,
2455: okc_statuses_b sts
2456: WHERE ls.id = kle.lse_id
2457: AND ls.lty_code = 'FREE_FORM1'
2458: AND kle.dnz_chr_id = chrId
2459: AND kle.sts_code = sts.code
2465: CURSOR l_lines_nr_csr_incl_term( chrId NUMBER, p_line_type VARCHAR2 ) IS
2466: SELECT kle.id
2467: FROM okc_line_styles_b ls,
2468: okl_K_lines_full_v kle,
2469: okc_statuses_b sts
2470: WHERE ls.id = kle.lse_id
2471: AND ls.lty_code = 'FREE_FORM1'
2472: AND kle.dnz_chr_id = chrId
2473: AND kle.sts_code = sts.code
2614: SELECT NVL(SUM(kle.capital_amount),0) CapAmountSubLines
2615: FROM OKC_LINE_STYLES_B LS,
2616: okc_k_items cim,
2617: okl_K_lines_full_v kle,
2618: okc_statuses_b sts
2619: WHERE LS.ID = KLE.LSE_ID
2620: AND ls.lty_code = 'LINK_SERV_ASSET'
2621: AND cim.jtot_object1_code = 'OKX_COVASST'
2622: AND kle.id = cim.cle_id
2630: FROM okl_strm_type_v sty,
2631: okc_k_items cim,
2632: okc_line_styles_b ls,
2633: okl_K_lines_full_v kle,
2634: okc_statuses_b sts
2635: WHERE cim.cle_id = kle.id
2636: AND ls.id = kle.lse_id
2637: AND ls.lty_code = 'SOLD_SERVICE'
2638: AND cim.object1_id1 = sty.id
7911: CURSOR capz_csr( chrId NUMBER ) IS
7912: SELECT NVL( SUM(kle.capitalized_interest), 0.0)
7913: FROM OKC_LINE_STYLES_B LS,
7914: OKL_K_LINES_FULL_V KLE,
7915: okc_statuses_b sts
7916: WHERE LS.ID = KLE.LSE_ID
7917: AND LS.LTY_CODE ='FREE_FORM1'
7918: AND KLE.DNZ_CHR_ID = chrId
7919: -- start: cklee 05/18/2004 fixed for bug#3625609
7926: CURSOR capz_nr_csr( chrId NUMBER, p_line_type VARCHAR2) IS
7927: SELECT NVL( SUM(kle.capitalized_interest), 0.0)
7928: FROM OKC_LINE_STYLES_B LS,
7929: OKL_K_LINES_FULL_V KLE,
7930: okc_statuses_b sts
7931: WHERE LS.ID = KLE.LSE_ID
7932: AND LS.LTY_CODE ='FREE_FORM1'
7933: AND KLE.DNZ_CHR_ID = chrId
7934: AND KLE.sts_code = sts.code
9117:
9118: --cursor to get line_sts
9119: CURSOR l_line_sts_csr (p_cle_id IN NUMBER) IS
9120: SELECT stsb.ste_code
9121: FROM okc_statuses_b stsb,
9122: okc_k_lines_b cleb
9123: WHERE stsb.code = cleb.sts_code
9124: AND cleb.id = p_cle_id;
9125:
9128: --cursor to get financial asset lines on a contract (without terminated lines)
9129: CURSOR l_cleb_csr (p_chr_id IN NUMBER) IS
9130: SELECT cleb.id
9131: FROM okc_k_lines_b cleb,
9132: okc_statuses_b stsb,
9133: okc_line_styles_b lseb
9134: WHERE cleb.chr_id = p_chr_id
9135: AND cleb.lse_id = lseb.id
9136: AND lseb.lty_code = 'FREE_FORM1'
9140: --cursor to get financial asset lines on a contract (with terminated lines)
9141: CURSOR l_cleb_termn_csr (p_chr_id IN NUMBER) IS
9142: SELECT cleb.id
9143: FROM okc_k_lines_b cleb,
9144: okc_statuses_b stsb,
9145: okc_line_styles_b lseb
9146: WHERE cleb.chr_id = p_chr_id
9147: AND cleb.lse_id = lseb.id
9148: AND lseb.lty_code = 'FREE_FORM1'
9153: -- Considers either new or re-leased assets of a Contract based on p_line_type parameter
9154: CURSOR l_cleb_nr_csr (p_chr_id IN NUMBER, p_line_type VARCHAR2) IS
9155: SELECT cleb.id
9156: FROM okc_k_lines_b cleb,
9157: okc_statuses_b stsb,
9158: okc_line_styles_b lseb,
9159: okl_k_lines kle
9160: WHERE cleb.chr_id = p_chr_id
9161: AND cleb.lse_id = lseb.id
9168: -- Considers either new or re-leased assets of a Contract based on p_line_type parameter
9169: CURSOR l_cleb_nr_termn_csr (p_chr_id IN NUMBER, p_line_type VARCHAR2) IS
9170: SELECT cleb.id
9171: FROM okc_k_lines_b cleb,
9172: okc_statuses_b stsb,
9173: okc_line_styles_b lseb,
9174: okl_k_lines kle
9175: WHERE cleb.chr_id = p_chr_id
9176: AND cleb.lse_id = lseb.id
9182:
9183: -- Considers either new or re-leased assets of a Contract based on p_line_type parameter
9184: CURSOR l_line_nr_sts_csr (p_cle_id IN NUMBER, p_line_type VARCHAR2) IS
9185: SELECT stsb.ste_code
9186: FROM okc_statuses_b stsb,
9187: okc_k_lines_b cleb,
9188: okl_k_lines kle
9189: WHERE stsb.code = cleb.sts_code
9190: AND cleb.id = p_cle_id
9520: okl_streams str,
9521: --okl_strm_type_tl sty,
9522: okl_strm_type_v sty,
9523: okl_K_lines_full_v kle,
9524: okc_statuses_b sts
9525: WHERE sele.stm_id = str.id
9526: AND str.sty_id = sty.id
9527: --AND UPPER(sty.name) = 'AMORTIZED EXPENSE'
9528: AND sty.stream_type_purpose = 'AMORTIZED_FEE_EXPENSE'
10564: SELECT SUM(ste.amount) amount
10565: FROM okl_streams stm,
10566: okl_strm_type_b sty,
10567: okc_k_lines_b kle,
10568: okc_statuses_b kls,
10569: okc_line_styles_b lse,
10570: okl_strm_elements ste,
10571: okl_k_lines cle
10572: WHERE stm.khr_id = cp_chr_id
10596: SELECT SUM(ste.amount) amount
10597: FROM okl_streams stm
10598: ,okl_strm_type_b sty
10599: ,okc_k_lines_b kle
10600: ,okc_statuses_b kls
10601: ,okc_line_styles_b lse
10602: ,okl_strm_elements ste
10603: ,okl_k_lines cle
10604: ,okc_k_lines_b cles
10630: SELECT SUM(ste.amount) amount
10631: FROM okl_streams stm
10632: ,okl_strm_type_b sty
10633: ,okc_k_lines_b kle
10634: ,okc_statuses_b kls
10635: ,okc_line_styles_b lse
10636: ,okl_strm_elements ste
10637: ,okl_k_lines cle
10638: ,okc_k_lines_b cles
11043: --okl_streams str, MGAAP 7263041
11044: okl_streams_rep_v str,
11045: okl_strm_type_v sty,
11046: okc_k_headers_b CHR,
11047: okc_statuses_b sts
11048: WHERE sele.stm_id = str.id
11049: AND str.sty_id = sty.id
11050: --AND UPPER(sty.name) = 'PRE-TAX INCOME'
11051: AND sty.stream_type_purpose = 'LEASE_INCOME'
11074: --okl_streams str, MGAAP 7263041
11075: okl_streams_rep_v str,
11076: okl_strm_type_v sty,
11077: okc_k_headers_b CHR,
11078: okc_statuses_b sts,
11079: okc_k_lines_b cle,
11080: okl_k_lines kle
11081: WHERE sele.stm_id = str.id
11082: AND str.sty_id = sty.id
11215: FROM
11216: OKL_K_LINES KLEB,
11217: OKC_K_LINES_B CLEB,
11218: OKC_LINE_STYLES_B LSEB,
11219: okc_statuses_b sts
11220: WHERE
11221: KLEB.ID = CLEB.ID AND
11222: CLEB.LSE_ID = LSEB.ID AND
11223: LSEB.LTY_CODE = 'FEE' AND
11274: FROM
11275: OKL_K_LINES KLEB,
11276: OKC_K_LINES_B CLEB,
11277: OKC_LINE_STYLES_B LSEB,
11278: okc_statuses_b sts
11279: WHERE
11280: KLEB.ID = CLEB.ID AND
11281: CLEB.LSE_ID = LSEB.ID AND
11282: LSEB.LTY_CODE = 'FEE' AND
11757: ,p_book_type_code IN VARCHAR2) IS
11758: SELECT fab.asset_id,
11759: fab.book_type_code
11760: FROM okc_k_lines_v fin_ast_cle,
11761: okc_statuses_b stsb,
11762: fa_additions fad,
11763: fa_book_controls fbc,
11764: fa_books fab
11765: WHERE fin_ast_cle.id = p_cle_id
11787: ,p_book_type_code IN VARCHAR2) IS
11788: SELECT fab.asset_id,
11789: fab.book_type_code
11790: FROM okc_k_lines_v fin_ast_cle,
11791: okc_statuses_b stsb,
11792: fa_additions fad,
11793: fa_book_controls fbc,
11794: fa_books fab
11795: WHERE fin_ast_cle.id = p_cle_id
11821: ,p_line_type IN VARCHAR2) IS
11822: SELECT fab.asset_id,
11823: fab.book_type_code
11824: FROM okc_k_lines_v fin_ast_cle,
11825: okc_statuses_b stsb,
11826: fa_additions fad,
11827: fa_book_controls fbc,
11828: fa_books fab,
11829: okl_k_lines_v kle
11854: ,p_line_type IN VARCHAR2) IS
11855: SELECT fab.asset_id,
11856: fab.book_type_code
11857: FROM okc_k_lines_v fin_ast_cle,
11858: okc_statuses_b stsb,
11859: fa_additions fad,
11860: fa_book_controls fbc,
11861: fa_books fab,
11862: okl_k_lines_v kle
12117: ,p_book_type_code IN VARCHAR2) IS
12118: SELECT fab.asset_id,
12119: fab.book_type_code
12120: FROM okc_k_lines_v fin_ast_cle,
12121: okc_statuses_b stsb,
12122: fa_additions fad,
12123: fa_book_controls fbc,
12124: fa_books fab
12125: WHERE fin_ast_cle.id = p_cle_id
12147: ,p_book_type_code IN VARCHAR2) IS
12148: SELECT fab.asset_id,
12149: fab.book_type_code
12150: FROM okc_k_lines_v fin_ast_cle,
12151: okc_statuses_b stsb,
12152: fa_additions fad,
12153: fa_book_controls fbc,
12154: fa_books fab
12155: WHERE fin_ast_cle.id = p_cle_id
12323: CURSOR l_finast_csr(p_chr_id IN NUMBER) IS
12324: SELECT fin_cle.id
12325: FROM okc_k_lines_b fin_cle,
12326: okc_line_styles_b lse,
12327: okc_statuses_b stsb
12328: WHERE fin_cle.dnz_chr_id = p_chr_id
12329: AND fin_cle.chr_id = p_chr_id
12330: AND fin_cle.lse_id = lse.id
12331: AND lse.lty_code = 'FREE_FORM1'
12335: CURSOR l_finast_csr_incl_terminated(p_chr_id IN NUMBER) IS
12336: SELECT fin_cle.id
12337: FROM okc_k_lines_b fin_cle,
12338: okc_line_styles_b lse,
12339: okc_statuses_b stsb
12340: WHERE fin_cle.dnz_chr_id = p_chr_id
12341: AND fin_cle.chr_id = p_chr_id
12342: AND fin_cle.lse_id = lse.id
12343: AND lse.lty_code = 'FREE_FORM1'
12441: CURSOR l_finast_csr(p_chr_id IN NUMBER) IS
12442: SELECT fin_cle.id
12443: FROM okc_k_lines_b fin_cle,
12444: okc_line_styles_b lse,
12445: okc_statuses_b stsb
12446: WHERE fin_cle.dnz_chr_id = p_chr_id
12447: AND fin_cle.chr_id = p_chr_id
12448: AND fin_cle.lse_id = lse.id
12449: AND lse.lty_code = 'FREE_FORM1'
12453: CURSOR l_finast_csr_incl_terminated(p_chr_id IN NUMBER) IS
12454: SELECT fin_cle.id
12455: FROM okc_k_lines_b fin_cle,
12456: okc_line_styles_b lse,
12457: okc_statuses_b stsb
12458: WHERE fin_cle.dnz_chr_id = p_chr_id
12459: AND fin_cle.chr_id = p_chr_id
12460: AND fin_cle.lse_id = lse.id
12461: AND lse.lty_code = 'FREE_FORM1'
12565: --+ NVL(SUM(kle.capitalized_interest),0) CapAmountLines
12566: FROM OKC_LINE_STYLES_B LSEB,
12567: OKL_K_LINES KLE,
12568: OKC_K_LINES_B CLEB,
12569: OKC_STATUSES_B STSB
12570: WHERE LSEB.ID = CLEB.LSE_ID
12571: AND LSEB.lty_code = 'FREE_FORM1'
12572: AND KLE.id = CLEB.ID
12573: AND CLEB.CHR_ID = ChrId
12583: FROM
12584: OKL_K_LINES KLEB,
12585: OKC_K_LINES_B CLEB,
12586: OKC_LINE_STYLES_B LSEB,
12587: OKC_STATUSES_B STS
12588: WHERE
12589: KLEB.ID = CLEB.ID AND
12590: CLEB.LSE_ID = LSEB.ID AND
12591: LSEB.LTY_CODE = 'FEE' AND
14571: FROM okl_strm_elements sele
14572: ,okl_streams str
14573: ,okl_strm_type_v sty
14574: ,okc_k_lines_v line
14575: ,okc_statuses_b sts
14576: ,okc_line_styles_b style
14577: WHERE sele.stm_id = str.id
14578: AND str.sty_id = sty.id
14579: AND sty.stream_type_purpose = 'RENT'
14629: ,okl_streams_rep_v str
14630: ,okl_strm_type_v sty
14631: ,okc_k_lines_b line
14632: ,okc_line_styles_b style
14633: ,okc_statuses_b sts
14634: WHERE sele.stm_id = str.id
14635: AND str.sty_id = sty.id
14636: AND UPPER(sty.stream_type_purpose) = 'LEASE_INCOME' -- pre-tax income has steam type purpose as lease_income
14637: AND str.say_code = 'CURR'
14677: FROM okl_strm_elements sele
14678: ,okl_streams str
14679: ,okl_strm_type_v sty
14680: ,okc_k_lines_v line
14681: -- ,okc_statuses_b sts
14682: ,okc_line_styles_b style
14683: WHERE sele.stm_id = str.id
14684: AND str.sty_id = sty.id
14685: AND sty.stream_type_purpose = 'RENT'
14736: ,okl_streams_rep_v str
14737: ,okl_strm_type_v sty
14738: ,okc_k_lines_b line
14739: ,okc_line_styles_b style
14740: -- ,okc_statuses_b sts
14741: WHERE sele.stm_id = str.id
14742: AND str.sty_id = sty.id
14743: AND UPPER(sty.stream_type_purpose) = 'LEASE_INCOME' -- pre-tax income has steam type purpose as lease_income
14744: AND str.say_code = 'CURR'
15257: ,p_book_type_code IN VARCHAR2) IS
15258: SELECT fab.asset_id,
15259: fab.book_type_code
15260: FROM okc_k_lines_v fin_ast_cle,
15261: okc_statuses_b stsb,
15262: fa_additions fad,
15263: fa_book_controls fbc,
15264: fa_books fab
15265: WHERE fin_ast_cle.id = p_cle_id
15676: FROM okc_line_styles_b lseb,
15677: okc_k_items cim,
15678: okl_k_lines kle_cov,
15679: okc_k_lines_b cleb_cov,
15680: okc_statuses_b stsb
15681: WHERE lseb.id = cleb_cov.lse_id
15682: AND lseb.lty_code = 'LINK_FEE_ASSET'
15683: AND cim.jtot_object1_code = 'OKX_COVASST'
15684: AND cleb_cov.id = cim.cle_id
15698: NVL(kle.capital_reduction_percent,0) capital_reduction_percent,
15699: kle.capitalize_down_payment_yn capitalize_down_payment_yn
15700: FROM okc_line_styles_b ls,
15701: okl_k_lines_full_v kle,
15702: okc_statuses_b sts
15703: WHERE kle.dnz_chr_id = p_dnz_chr_id
15704: AND kle.id = p_line_id
15705: AND ls.id = kle.lse_id
15706: AND ls.lty_code ='FREE_FORM1'
16273: OKC_K_ITEMS CIM,
16274: OKL_K_LINES KLE_COV,
16275: okl_k_lines fee_line,
16276: OKC_K_LINES_B CLEB_COV,
16277: OKC_STATUSES_B STSB
16278: WHERE LSEB.ID = CLEB_COV.LSE_ID
16279: AND LSEB.lty_code = 'LINK_FEE_ASSET'
16280: AND CIM.jtot_object1_code = 'OKX_COVASST'
16281: AND CLEB_COV.id = CIM.cle_id
16295: OKC_K_ITEMS CIM,
16296: OKL_K_LINES KLE_COV,
16297: okl_k_lines fee_line,
16298: OKC_K_LINES_B CLEB_COV,
16299: OKC_STATUSES_B STSB
16300: WHERE LSEB.ID = CLEB_COV.LSE_ID
16301: AND LSEB.lty_code = 'LINK_FEE_ASSET'
16302: AND CIM.jtot_object1_code = 'OKX_COVASST'
16303: AND CLEB_COV.id = CIM.cle_id
16397: OKC_K_ITEMS CIM,
16398: OKL_K_LINES KLE_COV,
16399: okl_k_lines fee_line,
16400: OKC_K_LINES_B CLEB_COV,
16401: OKC_STATUSES_B STSB
16402: WHERE LSEB.ID = CLEB_COV.LSE_ID
16403: AND LSEB.lty_code = 'LINK_FEE_ASSET'
16404: AND CIM.jtot_object1_code = 'OKX_COVASST'
16405: AND CLEB_COV.id = CIM.cle_id
16419: OKC_K_ITEMS CIM,
16420: OKL_K_LINES KLE_COV,
16421: okl_k_lines fee_line,
16422: OKC_K_LINES_B CLEB_COV,
16423: OKC_STATUSES_B STSB
16424: WHERE LSEB.ID = CLEB_COV.LSE_ID
16425: AND LSEB.lty_code = 'LINK_FEE_ASSET'
16426: AND CIM.jtot_object1_code = 'OKX_COVASST'
16427: AND CLEB_COV.id = CIM.cle_id