[Home] [Help]
424: okl_streams str,
425: --okl_strm_type_tl sty,
426: okl_strm_type_v sty,
427: okl_K_lines_full_v kle,
428: okc_statuses_b sts
429: WHERE sele.stm_id = str.id
430: AND str.sty_id = sty.id
431: --AND UPPER(sty.name) = 'RENT'
432: AND sty.stream_type_purpose = 'RENT'
550: FROM okl_strm_elements sele,
551: okl_streams str,
552: okl_strm_type_v sty,
553: okl_K_lines_full_v kle,
554: okc_statuses_b sts
555: WHERE sele.stm_id = str.id
556: AND str.sty_id = sty.id
557: AND UPPER(sty.name) = 'UNEARNED INCOME'
558: AND str.khr_id = p_chr_id
610: SELECT NVL(kle.residual_value,0) Value,
611: NVL(kle.residual_percentage,0) Percent
612: FROM OKC_LINE_STYLES_B LS,
613: okl_K_lines_full_v kle,
614: okc_statuses_b sts
615: WHERE LS.ID = KLE.LSE_ID
616: AND LS.LTY_CODE ='FREE_FORM1'
617: AND KLE.ID = lineId
618: AND KLE.DNZ_CHR_ID = chrId
623: SELECT NVL(kle.residual_value,0) Value,
624: NVL(kle.residual_percentage,0) Percent
625: FROM OKC_LINE_STYLES_B LS,
626: okl_K_lines_full_v kle,
627: okc_statuses_b sts
628: WHERE LS.ID = KLE.LSE_ID
629: AND LS.LTY_CODE ='FREE_FORM1'
630: AND KLE.ID = lineId
631: AND KLE.DNZ_CHR_ID = chrId
820: CURSOR lines_csr( chrId NUMBER ) IS
821: SELECT kle.id lineId
822: FROM OKC_LINE_STYLES_B LS,
823: okl_K_lines_full_v kle,
824: okc_statuses_b sts
825: WHERE LS.ID = KLE.LSE_ID
826: AND LS.LTY_CODE ='FREE_FORM1'
827: AND KLE.DNZ_CHR_ID = chrId
828: AND kle.sts_code = sts.code
1411: IF l_discount_incl_terminated THEN
1412: SELECT NVL(SUM(kle.tradein_amount),0) INTO l_tradeIn_value
1413: FROM OKC_LINE_STYLES_B LS,
1414: okl_K_lines_full_v kle,
1415: okc_statuses_b sts
1416: WHERE LS.ID = KLE.LSE_ID
1417: AND LS.LTY_CODE ='FREE_FORM1'
1418: AND KLE.dnz_chr_iD = p_chr_id
1419: AND kle.sts_code = sts.code
1421: ELSE
1422: SELECT NVL(SUM(kle.tradein_amount),0) INTO l_tradeIn_value
1423: FROM OKC_LINE_STYLES_B LS,
1424: okl_K_lines_full_v kle,
1425: okc_statuses_b sts
1426: WHERE LS.ID = KLE.LSE_ID
1427: AND LS.LTY_CODE ='FREE_FORM1'
1428: AND KLE.dnz_chr_iD = p_chr_id
1429: AND kle.sts_code = sts.code
1478: kle.dnz_chr_id chrId,
1479: kle.id lneId
1480: FROM OKC_LINE_STYLES_B LS,
1481: okl_K_lines_full_v kle,
1482: okc_statuses_b sts
1483: WHERE LS.ID = kLE.LSE_ID
1484: AND LS.LTY_CODE ='FREE_FORM1'
1485: AND kLE.dnz_chr_id = chrID
1486: AND kLE.ID = lineID
1492: kle.dnz_chr_id chrId,
1493: kle.id lneId
1494: FROM OKC_LINE_STYLES_B LS,
1495: okl_K_lines_full_v kle,
1496: okc_statuses_b sts
1497: WHERE LS.ID = kLE.LSE_ID
1498: AND LS.LTY_CODE ='FREE_FORM1'
1499: AND kLE.dnz_chr_id = chrID
1500: AND kLE.ID = lineID
1593: CURSOR l_lines_csr( chrId NUMBER ) IS
1594: SELECT kle.id
1595: FROM okc_line_styles_b ls,
1596: okl_K_lines_full_v kle,
1597: okc_statuses_b sts
1598: WHERE ls.id = kle.lse_id
1599: AND ls.lty_code = 'FREE_FORM1'
1600: AND kle.dnz_chr_id = chrId
1601: AND kle.sts_code = sts.code
1608: CURSOR l_lines_csr_incl_terminated( chrId NUMBER ) IS
1609: SELECT kle.id
1610: FROM okc_line_styles_b ls,
1611: okl_K_lines_full_v kle,
1612: okc_statuses_b sts
1613: WHERE ls.id = kle.lse_id
1614: AND ls.lty_code = 'FREE_FORM1'
1615: AND kle.dnz_chr_id = chrId
1616: AND kle.sts_code = sts.code
1720: NVL(kle.CAPITALIZE_DOWN_PAYMENT_YN, 'N') CAPITALIZE_DOWN_PAYMENT_YN,
1721: sts.ste_code
1722: FROM OKC_LINE_STYLES_B LS,
1723: okl_K_lines_full_v kle,
1724: okc_statuses_b sts
1725: WHERE LS.ID = KLE.LSE_ID
1726: AND LS.LTY_CODE ='FREE_FORM1'
1727: AND KLE.dnz_chr_id = p_chr_id
1728: AND KLE.ID = p_line_id
1764: END LOOP;
1765: /* SELECT NVL(kle.capital_reduction,0) INTO l_capred_value
1766: FROM OKC_LINE_STYLES_B LS,
1767: okl_K_lines_full_v kle,
1768: okc_statuses_b sts
1769: WHERE LS.ID = KLE.LSE_ID
1770: AND LS.LTY_CODE ='FREE_FORM1'
1771: AND KLE.dnz_chr_id = p_chr_id
1772: AND KLE.ID = p_line_id
1785:
1786: /* SELECT NVL(kle.capital_reduction,0) INTO l_capred_value
1787: FROM OKC_LINE_STYLES_B LS,
1788: okl_K_lines_full_v kle,
1789: okc_statuses_b sts
1790: WHERE LS.ID = KLE.LSE_ID
1791: AND LS.LTY_CODE ='FREE_FORM1'
1792: AND KLE.dnz_chr_id = p_chr_id
1793: AND KLE.ID = p_line_id
1809:
1810: /* SELECT NVL(kle.capital_reduction_percent,0) INTO l_capred_percent
1811: FROM OKC_LINE_STYLES_B LS,
1812: okl_K_lines_full_v kle,
1813: okc_statuses_b sts
1814: WHERE LS.ID = KLE.LSE_ID
1815: AND LS.LTY_CODE ='FREE_FORM1'
1816: AND KLE.dnz_chr_id = p_chr_id
1817: AND KLE.ID = p_line_id
1830:
1831: /* SELECT NVL(kle.capital_reduction_percent,0) INTO l_capred_percent
1832: FROM OKC_LINE_STYLES_B LS,
1833: okl_K_lines_full_v kle,
1834: okc_statuses_b sts
1835: WHERE LS.ID = KLE.LSE_ID
1836: AND LS.LTY_CODE ='FREE_FORM1'
1837: AND KLE.dnz_chr_id = p_chr_id
1838: AND KLE.ID = p_line_id
1896: FROM OKC_LINE_STYLES_B LSEB,
1897: OKC_K_ITEMS CIM,
1898: OKL_K_LINES KLE_COV,
1899: OKC_K_LINES_B CLEB_COV,
1900: OKC_STATUSES_B STSB
1901: WHERE LSEB.ID = CLEB_COV.LSE_ID
1902: AND LSEB.lty_code = 'LINK_FEE_ASSET'
1903: AND CIM.jtot_object1_code = 'OKX_COVASST'
1904: AND CLEB_COV.id = CIM.cle_id
1913: FROM OKC_LINE_STYLES_B LSEB,
1914: OKC_K_ITEMS CIM,
1915: OKL_K_LINES KLE_COV,
1916: OKC_K_LINES_B CLEB_COV,
1917: OKC_STATUSES_B STSB
1918: WHERE LSEB.ID = CLEB_COV.LSE_ID
1919: AND LSEB.lty_code = 'LINK_FEE_ASSET'
1920: AND CIM.jtot_object1_code = 'OKX_COVASST'
1921: AND CLEB_COV.id = CIM.cle_id
2036: CURSOR l_lines_csr( chrId NUMBER ) IS
2037: SELECT kle.id
2038: FROM okc_line_styles_b ls,
2039: okl_K_lines_full_v kle,
2040: okc_statuses_b sts
2041: WHERE ls.id = kle.lse_id
2042: AND ls.lty_code = 'FREE_FORM1'
2043: AND kle.dnz_chr_id = chrId
2044: AND kle.sts_code = sts.code
2047: CURSOR l_lines_csr_incl_terminated( chrId NUMBER ) IS
2048: SELECT kle.id
2049: FROM okc_line_styles_b ls,
2050: okl_K_lines_full_v kle,
2051: okc_statuses_b sts
2052: WHERE ls.id = kle.lse_id
2053: AND ls.lty_code = 'FREE_FORM1'
2054: AND kle.dnz_chr_id = chrId
2055: AND kle.sts_code = sts.code
2150: SELECT NVL(SUM(kle.capital_amount),0) CapAmountSubLines
2151: FROM OKC_LINE_STYLES_B LS,
2152: okc_k_items cim,
2153: okl_K_lines_full_v kle,
2154: okc_statuses_b sts
2155: WHERE LS.ID = KLE.LSE_ID
2156: AND ls.lty_code = 'LINK_SERV_ASSET'
2157: AND cim.jtot_object1_code = 'OKX_COVASST'
2158: AND kle.id = cim.cle_id
2166: FROM okl_strm_type_v sty,
2167: okc_k_items cim,
2168: okc_line_styles_b ls,
2169: okl_K_lines_full_v kle,
2170: okc_statuses_b sts
2171: WHERE cim.cle_id = kle.id
2172: AND ls.id = kle.lse_id
2173: AND ls.lty_code = 'SOLD_SERVICE'
2174: AND cim.object1_id1 = sty.id
7313: CURSOR capz_csr( chrId NUMBER ) IS
7314: SELECT NVL( SUM(kle.capitalized_interest), 0.0)
7315: FROM OKC_LINE_STYLES_B LS,
7316: OKL_K_LINES_FULL_V KLE,
7317: okc_statuses_b sts
7318: WHERE LS.ID = KLE.LSE_ID
7319: AND LS.LTY_CODE ='FREE_FORM1'
7320: AND KLE.DNZ_CHR_ID = chrId
7321: -- start: cklee 05/18/2004 fixed for bug#3625609
8443:
8444: --cursor to get line_sts
8445: CURSOR l_line_sts_csr (p_cle_id IN NUMBER) IS
8446: SELECT stsb.ste_code
8447: FROM okc_statuses_b stsb,
8448: okc_k_lines_b cleb
8449: WHERE stsb.code = cleb.sts_code
8450: AND cleb.id = p_cle_id;
8451:
8454: --cursor to get financial asset lines on a contract (without terminated lines)
8455: CURSOR l_cleb_csr (p_chr_id IN NUMBER) IS
8456: SELECT cleb.id
8457: FROM okc_k_lines_b cleb,
8458: okc_statuses_b stsb,
8459: okc_line_styles_b lseb
8460: WHERE cleb.chr_id = p_chr_id
8461: AND cleb.lse_id = lseb.id
8462: AND lseb.lty_code = 'FREE_FORM1'
8466: --cursor to get financial asset lines on a contract (with terminated lines)
8467: CURSOR l_cleb_termn_csr (p_chr_id IN NUMBER) IS
8468: SELECT cleb.id
8469: FROM okc_k_lines_b cleb,
8470: okc_statuses_b stsb,
8471: okc_line_styles_b lseb
8472: WHERE cleb.chr_id = p_chr_id
8473: AND cleb.lse_id = lseb.id
8474: AND lseb.lty_code = 'FREE_FORM1'
8670: okl_streams str,
8671: --okl_strm_type_tl sty,
8672: okl_strm_type_v sty,
8673: okl_K_lines_full_v kle,
8674: okc_statuses_b sts
8675: WHERE sele.stm_id = str.id
8676: AND str.sty_id = sty.id
8677: --AND UPPER(sty.name) = 'AMORTIZED EXPENSE'
8678: AND sty.stream_type_purpose = 'AMORTIZED_FEE_EXPENSE'
9707: SELECT SUM(ste.amount) amount
9708: FROM okl_streams stm,
9709: okl_strm_type_b sty,
9710: okc_k_lines_b kle,
9711: okc_statuses_b kls,
9712: okc_line_styles_b lse,
9713: okl_strm_elements ste,
9714: okl_k_lines cle
9715: WHERE stm.khr_id = cp_chr_id
9739: SELECT SUM(ste.amount) amount
9740: FROM okl_streams stm
9741: ,okl_strm_type_b sty
9742: ,okc_k_lines_b kle
9743: ,okc_statuses_b kls
9744: ,okc_line_styles_b lse
9745: ,okl_strm_elements ste
9746: ,okl_k_lines cle
9747: ,okc_k_lines_b cles
9773: SELECT SUM(ste.amount) amount
9774: FROM okl_streams stm
9775: ,okl_strm_type_b sty
9776: ,okc_k_lines_b kle
9777: ,okc_statuses_b kls
9778: ,okc_line_styles_b lse
9779: ,okl_strm_elements ste
9780: ,okl_k_lines cle
9781: ,okc_k_lines_b cles
10186: --okl_streams str, MGAAP 7263041
10187: okl_streams_rep_v str,
10188: okl_strm_type_v sty,
10189: okc_k_headers_b CHR,
10190: okc_statuses_b sts
10191: WHERE sele.stm_id = str.id
10192: AND str.sty_id = sty.id
10193: --AND UPPER(sty.name) = 'PRE-TAX INCOME'
10194: AND sty.stream_type_purpose = 'LEASE_INCOME'
10278: FROM
10279: OKL_K_LINES KLEB,
10280: OKC_K_LINES_B CLEB,
10281: OKC_LINE_STYLES_B LSEB,
10282: okc_statuses_b sts
10283: WHERE
10284: KLEB.ID = CLEB.ID AND
10285: CLEB.LSE_ID = LSEB.ID AND
10286: LSEB.LTY_CODE = 'FEE' AND
10337: FROM
10338: OKL_K_LINES KLEB,
10339: OKC_K_LINES_B CLEB,
10340: OKC_LINE_STYLES_B LSEB,
10341: okc_statuses_b sts
10342: WHERE
10343: KLEB.ID = CLEB.ID AND
10344: CLEB.LSE_ID = LSEB.ID AND
10345: LSEB.LTY_CODE = 'FEE' AND
10806: ,p_book_type_code IN VARCHAR2) IS
10807: SELECT fab.asset_id,
10808: fab.book_type_code
10809: FROM okc_k_lines_v fin_ast_cle,
10810: okc_statuses_b stsb,
10811: fa_additions fad,
10812: fa_book_controls fbc,
10813: fa_books fab
10814: WHERE fin_ast_cle.id = p_cle_id
10836: ,p_book_type_code IN VARCHAR2) IS
10837: SELECT fab.asset_id,
10838: fab.book_type_code
10839: FROM okc_k_lines_v fin_ast_cle,
10840: okc_statuses_b stsb,
10841: fa_additions fad,
10842: fa_book_controls fbc,
10843: fa_books fab
10844: WHERE fin_ast_cle.id = p_cle_id
11029: ,p_book_type_code IN VARCHAR2) IS
11030: SELECT fab.asset_id,
11031: fab.book_type_code
11032: FROM okc_k_lines_v fin_ast_cle,
11033: okc_statuses_b stsb,
11034: fa_additions fad,
11035: fa_book_controls fbc,
11036: fa_books fab
11037: WHERE fin_ast_cle.id = p_cle_id
11059: ,p_book_type_code IN VARCHAR2) IS
11060: SELECT fab.asset_id,
11061: fab.book_type_code
11062: FROM okc_k_lines_v fin_ast_cle,
11063: okc_statuses_b stsb,
11064: fa_additions fad,
11065: fa_book_controls fbc,
11066: fa_books fab
11067: WHERE fin_ast_cle.id = p_cle_id
11235: CURSOR l_finast_csr(p_chr_id IN NUMBER) IS
11236: SELECT fin_cle.id
11237: FROM okc_k_lines_b fin_cle,
11238: okc_line_styles_b lse,
11239: okc_statuses_b stsb
11240: WHERE fin_cle.dnz_chr_id = p_chr_id
11241: AND fin_cle.chr_id = p_chr_id
11242: AND fin_cle.lse_id = lse.id
11243: AND lse.lty_code = 'FREE_FORM1'
11247: CURSOR l_finast_csr_incl_terminated(p_chr_id IN NUMBER) IS
11248: SELECT fin_cle.id
11249: FROM okc_k_lines_b fin_cle,
11250: okc_line_styles_b lse,
11251: okc_statuses_b stsb
11252: WHERE fin_cle.dnz_chr_id = p_chr_id
11253: AND fin_cle.chr_id = p_chr_id
11254: AND fin_cle.lse_id = lse.id
11255: AND lse.lty_code = 'FREE_FORM1'
11353: CURSOR l_finast_csr(p_chr_id IN NUMBER) IS
11354: SELECT fin_cle.id
11355: FROM okc_k_lines_b fin_cle,
11356: okc_line_styles_b lse,
11357: okc_statuses_b stsb
11358: WHERE fin_cle.dnz_chr_id = p_chr_id
11359: AND fin_cle.chr_id = p_chr_id
11360: AND fin_cle.lse_id = lse.id
11361: AND lse.lty_code = 'FREE_FORM1'
11365: CURSOR l_finast_csr_incl_terminated(p_chr_id IN NUMBER) IS
11366: SELECT fin_cle.id
11367: FROM okc_k_lines_b fin_cle,
11368: okc_line_styles_b lse,
11369: okc_statuses_b stsb
11370: WHERE fin_cle.dnz_chr_id = p_chr_id
11371: AND fin_cle.chr_id = p_chr_id
11372: AND fin_cle.lse_id = lse.id
11373: AND lse.lty_code = 'FREE_FORM1'
11477: --+ NVL(SUM(kle.capitalized_interest),0) CapAmountLines
11478: FROM OKC_LINE_STYLES_B LSEB,
11479: OKL_K_LINES KLE,
11480: OKC_K_LINES_B CLEB,
11481: OKC_STATUSES_B STSB
11482: WHERE LSEB.ID = CLEB.LSE_ID
11483: AND LSEB.lty_code = 'FREE_FORM1'
11484: AND KLE.id = CLEB.ID
11485: AND CLEB.CHR_ID = ChrId
11495: FROM
11496: OKL_K_LINES KLEB,
11497: OKC_K_LINES_B CLEB,
11498: OKC_LINE_STYLES_B LSEB,
11499: OKC_STATUSES_B STS
11500: WHERE
11501: KLEB.ID = CLEB.ID AND
11502: CLEB.LSE_ID = LSEB.ID AND
11503: LSEB.LTY_CODE = 'FEE' AND
13339: FROM okl_strm_elements sele
13340: ,okl_streams str
13341: ,okl_strm_type_v sty
13342: ,okc_k_lines_v line
13343: ,okc_statuses_b sts
13344: ,okc_line_styles_b style
13345: WHERE sele.stm_id = str.id
13346: AND str.sty_id = sty.id
13347: AND sty.stream_type_purpose = 'RENT'
13397: ,okl_streams_rep_v str
13398: ,okl_strm_type_v sty
13399: ,okc_k_lines_b line
13400: ,okc_line_styles_b style
13401: ,okc_statuses_b sts
13402: WHERE sele.stm_id = str.id
13403: AND str.sty_id = sty.id
13404: AND UPPER(sty.stream_type_purpose) = 'LEASE_INCOME' -- pre-tax income has steam type purpose as lease_income
13405: AND str.say_code = 'CURR'
13445: FROM okl_strm_elements sele
13446: ,okl_streams str
13447: ,okl_strm_type_v sty
13448: ,okc_k_lines_v line
13449: -- ,okc_statuses_b sts
13450: ,okc_line_styles_b style
13451: WHERE sele.stm_id = str.id
13452: AND str.sty_id = sty.id
13453: AND sty.stream_type_purpose = 'RENT'
13504: ,okl_streams_rep_v str
13505: ,okl_strm_type_v sty
13506: ,okc_k_lines_b line
13507: ,okc_line_styles_b style
13508: -- ,okc_statuses_b sts
13509: WHERE sele.stm_id = str.id
13510: AND str.sty_id = sty.id
13511: AND UPPER(sty.stream_type_purpose) = 'LEASE_INCOME' -- pre-tax income has steam type purpose as lease_income
13512: AND str.say_code = 'CURR'
14025: ,p_book_type_code IN VARCHAR2) IS
14026: SELECT fab.asset_id,
14027: fab.book_type_code
14028: FROM okc_k_lines_v fin_ast_cle,
14029: okc_statuses_b stsb,
14030: fa_additions fad,
14031: fa_book_controls fbc,
14032: fa_books fab
14033: WHERE fin_ast_cle.id = p_cle_id
14444: FROM okc_line_styles_b lseb,
14445: okc_k_items cim,
14446: okl_k_lines kle_cov,
14447: okc_k_lines_b cleb_cov,
14448: okc_statuses_b stsb
14449: WHERE lseb.id = cleb_cov.lse_id
14450: AND lseb.lty_code = 'LINK_FEE_ASSET'
14451: AND cim.jtot_object1_code = 'OKX_COVASST'
14452: AND cleb_cov.id = cim.cle_id
14466: NVL(kle.capital_reduction_percent,0) capital_reduction_percent,
14467: kle.capitalize_down_payment_yn capitalize_down_payment_yn
14468: FROM okc_line_styles_b ls,
14469: okl_k_lines_full_v kle,
14470: okc_statuses_b sts
14471: WHERE kle.dnz_chr_id = p_dnz_chr_id
14472: AND kle.id = p_line_id
14473: AND ls.id = kle.lse_id
14474: AND ls.lty_code ='FREE_FORM1'
15041: OKC_K_ITEMS CIM,
15042: OKL_K_LINES KLE_COV,
15043: okl_k_lines fee_line,
15044: OKC_K_LINES_B CLEB_COV,
15045: OKC_STATUSES_B STSB
15046: WHERE LSEB.ID = CLEB_COV.LSE_ID
15047: AND LSEB.lty_code = 'LINK_FEE_ASSET'
15048: AND CIM.jtot_object1_code = 'OKX_COVASST'
15049: AND CLEB_COV.id = CIM.cle_id
15063: OKC_K_ITEMS CIM,
15064: OKL_K_LINES KLE_COV,
15065: okl_k_lines fee_line,
15066: OKC_K_LINES_B CLEB_COV,
15067: OKC_STATUSES_B STSB
15068: WHERE LSEB.ID = CLEB_COV.LSE_ID
15069: AND LSEB.lty_code = 'LINK_FEE_ASSET'
15070: AND CIM.jtot_object1_code = 'OKX_COVASST'
15071: AND CLEB_COV.id = CIM.cle_id
15165: OKC_K_ITEMS CIM,
15166: OKL_K_LINES KLE_COV,
15167: okl_k_lines fee_line,
15168: OKC_K_LINES_B CLEB_COV,
15169: OKC_STATUSES_B STSB
15170: WHERE LSEB.ID = CLEB_COV.LSE_ID
15171: AND LSEB.lty_code = 'LINK_FEE_ASSET'
15172: AND CIM.jtot_object1_code = 'OKX_COVASST'
15173: AND CLEB_COV.id = CIM.cle_id
15187: OKC_K_ITEMS CIM,
15188: OKL_K_LINES KLE_COV,
15189: okl_k_lines fee_line,
15190: OKC_K_LINES_B CLEB_COV,
15191: OKC_STATUSES_B STSB
15192: WHERE LSEB.ID = CLEB_COV.LSE_ID
15193: AND LSEB.lty_code = 'LINK_FEE_ASSET'
15194: AND CIM.jtot_object1_code = 'OKX_COVASST'
15195: AND CLEB_COV.id = CIM.cle_id