eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKL_K_LINES

Line 427: okl_K_lines_full_v kle,

423: FROM okl_strm_elements sele,
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'

Line 553: okl_K_lines_full_v kle,

549: SELECT NVL(SUM(sele.amount),0) INTO l_income
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'

Line 613: okl_K_lines_full_v kle,

609: CURSOR residual_csr( chrId NUMBER, lineId NUMBER ) IS
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

Line 626: okl_K_lines_full_v kle,

622: CURSOR residual_csr_incl_terminated( chrId NUMBER, lineId NUMBER ) IS
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

Line 823: okl_K_lines_full_v kle,

819:
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

Line 933: ln_contract_oec OKL_K_LINES_V.OEC%TYPE := 0;

929: G_LEASE_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LEASE';
930: G_LOAN_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LOAN';
931: l_return_status VARCHAR2(3) := Okl_Api.G_RET_STS_SUCCESS;
932: l_api_name CONSTANT VARCHAR2(30) := 'FUNCTION_OEC_CALC';
933: ln_contract_oec OKL_K_LINES_V.OEC%TYPE := 0;
934: lv_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
935: ln_model_line_oec OKL_K_LINES_V.OEC%TYPE := 0;
936: ln_addon_line_oec OKL_K_LINES_V.OEC%TYPE := 0;
937: ln_total_line_oec OKL_K_LINES_V.OEC%TYPE := 0;

Line 935: ln_model_line_oec OKL_K_LINES_V.OEC%TYPE := 0;

931: l_return_status VARCHAR2(3) := Okl_Api.G_RET_STS_SUCCESS;
932: l_api_name CONSTANT VARCHAR2(30) := 'FUNCTION_OEC_CALC';
933: ln_contract_oec OKL_K_LINES_V.OEC%TYPE := 0;
934: lv_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
935: ln_model_line_oec OKL_K_LINES_V.OEC%TYPE := 0;
936: ln_addon_line_oec OKL_K_LINES_V.OEC%TYPE := 0;
937: ln_total_line_oec OKL_K_LINES_V.OEC%TYPE := 0;
938: l_capred_incl_terminated BOOLEAN := FALSE;
939: -- Cursor to get the lty_code

Line 936: ln_addon_line_oec OKL_K_LINES_V.OEC%TYPE := 0;

932: l_api_name CONSTANT VARCHAR2(30) := 'FUNCTION_OEC_CALC';
933: ln_contract_oec OKL_K_LINES_V.OEC%TYPE := 0;
934: lv_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
935: ln_model_line_oec OKL_K_LINES_V.OEC%TYPE := 0;
936: ln_addon_line_oec OKL_K_LINES_V.OEC%TYPE := 0;
937: ln_total_line_oec OKL_K_LINES_V.OEC%TYPE := 0;
938: l_capred_incl_terminated BOOLEAN := FALSE;
939: -- Cursor to get the lty_code
940: CURSOR get_lty_code(p_cle_id IN OKC_K_LINES_V.ID%TYPE) IS

Line 937: ln_total_line_oec OKL_K_LINES_V.OEC%TYPE := 0;

933: ln_contract_oec OKL_K_LINES_V.OEC%TYPE := 0;
934: lv_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
935: ln_model_line_oec OKL_K_LINES_V.OEC%TYPE := 0;
936: ln_addon_line_oec OKL_K_LINES_V.OEC%TYPE := 0;
937: ln_total_line_oec OKL_K_LINES_V.OEC%TYPE := 0;
938: l_capred_incl_terminated BOOLEAN := FALSE;
939: -- Cursor to get the lty_code
940: CURSOR get_lty_code(p_cle_id IN OKC_K_LINES_V.ID%TYPE) IS
941: SELECT lse.lty_code

Line 949: FROM OKL_K_LINES_V kle,

945: AND cle.lse_id = lse.id;
946: -- Cursor to sum up oec for contract
947: CURSOR c_contract_oec_calc(p_dnz_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
948: SELECT SUM(kle.oec) oec
949: FROM OKL_K_LINES_V kle,
950: OKC_K_LINES_V cle,
951: OKC_K_HEADERS_V CHR
952: WHERE CHR.id = p_dnz_chr_id
953: AND CHR.id = cle.dnz_chr_id

Line 959: FROM OKL_K_LINES_V kle,

955: AND cle.id = kle.id;
956:
957: CURSOR c_contract_oec_calc_incl_term(p_dnz_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
958: SELECT SUM(kle.oec) oec
959: FROM OKL_K_LINES_V kle,
960: OKC_K_LINES_V cle,
961: OKC_K_HEADERS_V CHR
962: WHERE CHR.id = p_dnz_chr_id
963: AND CHR.id = cle.dnz_chr_id

Line 1035: FROM OKL_K_LINES kle,

1031:
1032: --cursor to get expected asset value for contract
1033: cursor l_chr_expcost_trmn_csr(p_chr_id in number) is
1034: SELECT SUM(kle.expected_asset_cost) expected_asset_cost
1035: FROM OKL_K_LINES kle,
1036: OKC_K_LINES_B cleb
1037: WHERE kle.id = cleb.id
1038: AND cleb.dnz_chr_id = p_chr_id
1039: AND cleb.lse_id = 33

Line 1044: FROM OKL_K_LINES kle,

1040: AND cleb.sts_code NOT IN ( 'ABANDONED', 'EXPIRED', 'CANCELLED', 'HOLD');
1041:
1042: cursor l_chr_expcost_csr(p_chr_id in number) is
1043: SELECT SUM(kle.expected_asset_cost) expected_asset_cost
1044: FROM OKL_K_LINES kle,
1045: OKC_K_LINES_B cleb
1046: WHERE kle.id = cleb.id
1047: AND cleb.dnz_chr_id = p_chr_id
1048: AND cleb.lse_id = 33

Line 1055: from okl_k_lines kle

1051:
1052: --cursor to get expected asset value for asset
1053: cursor l_cle_expcost_csr (p_cle_id in number) is
1054: Select nvl(kle.expected_asset_cost,0) expected_asset_cost
1055: from okl_k_lines kle
1056: where kle.id = p_cle_id;
1057:
1058:
1059: ----------------------------------------------------------------------------------------------------

Line 1414: okl_K_lines_full_v kle,

1410: -- rmunjulu 4042892
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

Line 1424: okl_K_lines_full_v kle,

1420: AND sts.ste_code NOT IN ('EXPIRED', 'CANCELLED', 'HOLD');
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

Line 1481: okl_K_lines_full_v kle,

1477: SELECT NVL(kle.tradein_amount,0.0) amnt,
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

Line 1495: okl_K_lines_full_v kle,

1491: SELECT NVL(kle.tradein_amount,0.0) amnt,
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

Line 1596: okl_K_lines_full_v kle,

1592:
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

Line 1611: okl_K_lines_full_v kle,

1607:
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

Line 1723: okl_K_lines_full_v kle,

1719: NVL(kle.capital_reduction_percent,0) capital_reduction_percent,
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

Line 1767: okl_K_lines_full_v kle,

1763: END IF;
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

Line 1788: okl_K_lines_full_v kle,

1784: END LOOP;
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

Line 1812: okl_K_lines_full_v kle,

1808: END LOOP;
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

Line 1833: okl_K_lines_full_v kle,

1829: END LOOP;
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

Line 1898: OKL_K_LINES KLE_COV,

1894: CURSOR l_fee_csr( kleId NUMBER) IS
1895: SELECT NVL(SUM(kle_cov.capital_amount),0) CapAmountLines
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'

Line 1915: OKL_K_LINES KLE_COV,

1911: CURSOR l_fee_csr_incl_terminated( kleId NUMBER) IS
1912: SELECT NVL(SUM(kle_cov.capital_amount),0) CapAmountLines
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'

Line 2039: okl_K_lines_full_v kle,

2035:
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

Line 2050: okl_K_lines_full_v kle,

2046:
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

Line 2153: okl_K_lines_full_v kle,

2149: CURSOR l_srvcline_csr ( kleId NUMBER ) IS
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'

Line 2169: okl_K_lines_full_v kle,

2165: sty.name
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'

Line 2632: FROM OKL_K_LINES_FULL_V A

2628:
2629: CURSOR C (p_contract_id NUMBER)
2630: IS
2631: SELECT NVL(SUM(A.amount),0)
2632: FROM OKL_K_LINES_FULL_V A
2633: WHERE A.dnz_chr_id = p_contract_id
2634: AND A.credit_nature = 'NEW'
2635: AND NVL(TRUNC(A.start_date),TRUNC(SYSDATE)) <= TRUNC(SYSDATE) -- fixed trunc issues
2636: ;

Line 2681: FROM OKL_K_LINES_FULL_V A

2677:
2678: CURSOR C (p_contract_id NUMBER)
2679: IS
2680: SELECT NVL(SUM(A.amount),0)
2681: FROM OKL_K_LINES_FULL_V A
2682: WHERE A.dnz_chr_id = p_contract_id
2683: AND A.credit_nature = 'ADD'
2684: AND NVL(TRUNC(A.start_date),TRUNC(SYSDATE)) <= TRUNC(SYSDATE) -- fixed trunc issues
2685: ;

Line 2730: FROM OKL_K_LINES_FULL_V A

2726:
2727: CURSOR C (p_contract_id NUMBER)
2728: IS
2729: SELECT NVL(SUM(A.amount),0)
2730: FROM OKL_K_LINES_FULL_V A
2731: WHERE A.dnz_chr_id = p_contract_id
2732: AND A.credit_nature = 'REDUCE'
2733: AND NVL(TRUNC(A.start_date),TRUNC(SYSDATE)) <= TRUNC(SYSDATE) -- fixed trunc issues
2734: ;

Line 3814: FROM OKL_K_LINES_FULL_V

3810: WHERE id = p_ctr_id;
3811:
3812: CURSOR get_ung_res_csr(p_ctr_id NUMBER) IS
3813: SELECT SUM(NVL(RESIDUAL_VALUE,0)) - SUM(NVL(RESIDUAL_GRNTY_AMOUNT, 0))
3814: FROM OKL_K_LINES_FULL_V
3815: WHERE DNZ_CHR_ID = p_ctr_id;
3816:
3817: BEGIN
3818: OPEN contract_num_csr(p_khr_id);

Line 5491: FROM okl_k_lines_full_v

5487: CURSOR C (p_contract_id NUMBER)
5488:
5489: IS
5490: SELECT NVL(SUM(RESIDUAL_VALUE),0)
5491: FROM okl_k_lines_full_v
5492: WHERE dnz_chr_id= p_contract_id
5493: AND sts_code <> 'TERMINATED';
5494:
5495: --Commented this code by rvaduri for bug 3487920

Line 5515: FROM okl_k_lines

5511:
5512: CURSOR line(p_contract_line_id NUMBER)
5513: IS
5514: SELECT NVL(RESIDUAL_VALUE,0)
5515: FROM okl_k_lines
5516: WHERE id = p_contract_line_id;
5517:
5518:
5519: BEGIN

Line 6299: okl_k_lines sub_kle,

6295: -- passing accounting method as input parameter
6296: CURSOR l_sub_csr(c_contract_id IN NUMBER,c_accounting_method IN VARCHAR2) IS
6297: SELECT NVL(SUM(NVL(sub_kle.subsidy_override_amount, sub_kle.amount)),0)
6298: FROM okl_subsidies_b subb,
6299: okl_k_lines sub_kle,
6300: okc_k_lines_b sub_cle,
6301: okc_line_styles_b sub_lse
6302: WHERE subb.id = sub_kle.subsidy_id
6303: AND subb.accounting_method_code = NVL(UPPER(c_accounting_method),subb.accounting_method_code)

Line 7316: OKL_K_LINES_FULL_V KLE,

7312:
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

Line 7379: OKL_K_LINES_FULL_V KLE

7375:
7376: CURSOR capz_csr( chrId NUMBER, kleId NUMBER ) IS
7377: SELECT NVL( kle.capitalized_interest, 0.0)
7378: FROM OKC_LINE_STYLES_B LS,
7379: OKL_K_LINES_FULL_V KLE
7380: WHERE LS.ID = KLE.LSE_ID
7381: AND LS.LTY_CODE ='FREE_FORM1'
7382: AND KLE.DNZ_CHR_ID = chrId
7383: AND KLE.id = kleId;

Line 7622: FROM okl_k_lines kleb,

7618: */
7619: CURSOR l_okl_percent_stake_csr(p_sty_subclass IN VARCHAR2)
7620: IS
7621: SELECT DISTINCT kleb.percent_stake,clet.id
7622: FROM okl_k_lines kleb,
7623: okc_k_lines_b clet,
7624: okc_k_lines_b cles
7625: WHERE kleb.id = cles.id
7626: AND cles.cle_id = clet.id

Line 7940: OKL_K_LINES KLEB,

7936: CURSOR c_amt_stake(p_contract_id okc_k_headers_b.id%TYPE) IS
7937: SELECT
7938: NVL(SUM(NVL(KLEB.AMOUNT,0)),0)
7939: FROM
7940: OKL_K_LINES KLEB,
7941: OKC_K_LINES_B CLEB,
7942: OKC_LINE_STYLES_B LSEB
7943: WHERE
7944: CLEB.ID = KLEB.ID AND

Line 7955: OKL_K_LINES KLEB,

7951: CURSOR c_add_amt_stake(p_contract_id okc_k_headers_b.id%TYPE) IS
7952: SELECT
7953: NVL(SUM(NVL(KLEB.AMOUNT_STAKE,0)),0)
7954: FROM
7955: OKL_K_LINES KLEB,
7956: OKC_K_LINES_B CLEB,
7957: OKC_LINE_STYLES_B LSEB
7958: WHERE
7959: CLEB.ID = KLEB.ID AND

Line 8044: FROM okl_k_lines kleb,

8040: -- get revenue share by subclass
8041: CURSOR l_okl_percent_stake_csr(p_sty_subclass IN VARCHAR2)
8042: IS
8043: SELECT DISTINCT kleb.percent_stake,clet.id
8044: FROM okl_k_lines kleb,
8045: okc_k_lines_b clet,
8046: okc_k_lines_b cles
8047: WHERE kleb.id = cles.id
8048: AND cles.cle_id = clet.id

Line 8239: OKL_K_LINES KLEB,

8235: CURSOR sum_idc_csr(l_dnz_chr_id okc_k_headers_b.id%TYPE) IS
8236: SELECT
8237: NVL(SUM(NVL(KLEB.initial_direct_cost,0)),0)
8238: FROM
8239: OKL_K_LINES KLEB,
8240: OKC_K_LINES_B CLEB,
8241: OKC_LINE_STYLES_B LSEB
8242: WHERE
8243: KLEB.ID = CLEB.ID AND

Line 8673: okl_K_lines_full_v kle,

8669: FROM okl_strm_elements sele,
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'

Line 9714: okl_k_lines cle

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
9716: AND stm.active_yn = 'Y'
9717: AND stm.say_code = 'CURR'
9718: AND ste.stm_id = stm.id

Line 9746: ,okl_k_lines cle

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
9748: WHERE stm.khr_id = cp_chr_id
9749: AND stm.active_yn = 'Y'
9750: AND stm.say_code = 'CURR'

Line 9780: ,okl_k_lines cle

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
9782: ,okc_k_items cim
9783: WHERE stm.khr_id = cp_chr_id
9784: AND stm.active_yn = 'Y'

Line 9972: okl_k_lines kle,

9968: when ROUND(MONTHS_BETWEEN(chr.end_date, cle.start_date)) <= 12 then NVL(kle.oec,0) * .2
9969: else NVL(kle.oec,0) * .1
9970: end) subsidy_amount
9971: from okc_k_lines_b cle,
9972: okl_k_lines kle,
9973: okc_k_headers_b chr
9974: where chr.id = cle.dnz_chr_id
9975: and kle.id = cle.id
9976: and cle.id = p_cle_id -- FREE_FORM1 (FIN)

Line 9983: okl_k_lines kle,

9979: CURSOR c_subsidy_amount(p_cle_id okc_k_lines_b.id%TYPE) IS
9980: SELECT ROUND(MONTHS_BETWEEN(CHR.end_date, cle.start_date)) months,
9981: NVL(kle.oec,0) oec
9982: FROM okc_k_lines_b cle,
9983: okl_k_lines kle,
9984: okc_k_headers_b CHR
9985: WHERE CHR.id = cle.dnz_chr_id
9986: AND kle.id = cle.id
9987: AND cle.id = p_cle_id -- FREE_FORM1 (FIN)

Line 10050: okl_k_lines sub_kle,

10046: sub_kle.sty_id sty_id, /* Bug 6353756 */
10047: top_cle.dnz_chr_id chr_id
10048: FROM --okl_sgn_translations sgn,
10049: okl_subsidies_b sub,
10050: okl_k_lines sub_kle,
10051: okc_k_lines_b sub_cle,
10052: okc_k_lines_b top_cle
10053: WHERE --sgn.jtot_object1_code = 'OKL_STRMTYP'
10054: --AND sgn.object1_id1 = TO_CHAR(sub_kle.sty_id) AND

Line 10279: OKL_K_LINES KLEB,

10275: CURSOR sum_fin_fee_csr(l_dnz_chr_id okc_k_headers_b.id%TYPE) IS
10276: SELECT
10277: NVL(SUM(NVL(KLEB.amount,0)),0)
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

Line 10338: OKL_K_LINES KLEB,

10334: CURSOR sum_abs_fee_csr(l_dnz_chr_id okc_k_headers_b.id%TYPE) IS
10335: SELECT
10336: NVL(SUM(NVL(KLEB.amount,0)),0)
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

Line 11479: OKL_K_LINES KLE,

11475: SELECT NVL(SUM(kle.capital_amount),0)
11476: --bug# 4899328
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'

Line 11496: OKL_K_LINES KLEB,

11492: CURSOR l_rollover_fee_csr(l_dnz_chr_id okc_k_headers_b.id%TYPE) IS
11493: SELECT
11494: NVL(SUM(NVL(KLEB.amount,0)),0) ROLLOVER_AMOUNT
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

Line 12583: okl_k_lines kle,

12579: CURSOR c_fin_fees IS
12580: SELECT cle.id
12581: FROM
12582: okc_k_lines_b cle,
12583: okl_k_lines kle,
12584: okc_k_headers_b chr
12585: WHERE
12586: chr.id = p_contract_id
12587: AND cle.chr_id = chr.id

Line 12631: okl_k_lines kle,

12627: CURSOR c_fin_fees IS
12628: SELECT cle.id
12629: FROM
12630: okc_k_lines_b cle,
12631: okl_k_lines kle,
12632: okc_k_headers_b chr
12633: WHERE
12634: chr.id = p_contract_id
12635: AND cle.chr_id = chr.id

Line 12897: FROM OKL_K_LINES KLE

12893: RETURN NUMBER IS
12894:
12895: CURSOR get_asset_residual_csr (p_kle_id IN NUMBER) IS
12896: SELECT nvl(KLE.residual_value,0) residual_value
12897: FROM OKL_K_LINES KLE
12898: WHERE KLE.id = p_kle_id;
12899:
12900: CURSOR get_asset_sales_proceeds_csr (p_retirement_id IN NUMBER) IS
12901: SELECT nvl(RET.proceeds_of_sale,0) sales_proceeds

Line 14446: okl_k_lines kle_cov,

14442: p_dnz_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
14443: SELECT SUM(kle_cov.capital_amount) Cap_fee
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'

Line 14469: okl_k_lines_full_v kle,

14465: NVL(kle.tradein_amount,0) tradein_amount,
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

Line 14814: okl_k_lines sub_kle,

14810: p_fin_asset_line_id IN NUMBER,
14811: p_accounting_method IN VARCHAR2) IS
14812: SELECT NVL(SUM(sub_kle.amount),0)
14813: FROM okl_subsidies_b subb,
14814: okl_k_lines sub_kle,
14815: okc_k_lines_b sub_cle,
14816: okc_line_styles_b sub_lse
14817: WHERE subb.id = sub_kle.subsidy_id
14818: AND subb.accounting_method_code = NVL(UPPER(p_accounting_method),subb.accounting_method_code)

Line 14934: okl_k_lines sub_kle,

14930: p_fin_asset_line_id IN NUMBER,
14931: p_accounting_method IN VARCHAR2) IS
14932: SELECT NVL(SUM(sub_kle.subsidy_override_amount),0)
14933: FROM okl_subsidies_b subb,
14934: okl_k_lines sub_kle,
14935: okc_k_lines_b sub_cle,
14936: okc_line_styles_b sub_lse
14937: WHERE subb.id = sub_kle.subsidy_id
14938: AND subb.accounting_method_code = NVL(UPPER(p_accounting_method),subb.accounting_method_code)

Line 15042: OKL_K_LINES KLE_COV,

15038: CURSOR l_fee_csr( c_chr_id IN NUMBER, c_fin_asset_line_id IN NUMBER) IS
15039: SELECT sum(kle_cov.amount) asset_fin_fee_amt
15040: FROM OKC_LINE_STYLES_B LSEB,
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

Line 15043: okl_k_lines fee_line,

15039: SELECT sum(kle_cov.amount) asset_fin_fee_amt
15040: FROM OKC_LINE_STYLES_B LSEB,
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'

Line 15064: OKL_K_LINES KLE_COV,

15060: CURSOR l_fee_csr_incl_terminated( c_chr_id IN NUMBER, c_fin_asset_line_id IN NUMBER) IS
15061: SELECT sum(kle_cov.amount) asset_fin_fee_amt
15062: FROM OKC_LINE_STYLES_B LSEB,
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

Line 15065: okl_k_lines fee_line,

15061: SELECT sum(kle_cov.amount) asset_fin_fee_amt
15062: FROM OKC_LINE_STYLES_B LSEB,
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'

Line 15166: OKL_K_LINES KLE_COV,

15162: CURSOR l_fee_csr( c_chr_id IN NUMBER, c_fin_asset_line_id IN NUMBER) IS
15163: SELECT sum(kle_cov.amount) asset_roll_fee_amt
15164: FROM OKC_LINE_STYLES_B LSEB,
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

Line 15167: okl_k_lines fee_line,

15163: SELECT sum(kle_cov.amount) asset_roll_fee_amt
15164: FROM OKC_LINE_STYLES_B LSEB,
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'

Line 15188: OKL_K_LINES KLE_COV,

15184: CURSOR l_fee_csr_incl_terminated( c_chr_id IN NUMBER, c_fin_asset_line_id IN NUMBER) IS
15185: SELECT sum(kle_cov.amount) asset_roll_fee_amt
15186: FROM OKC_LINE_STYLES_B LSEB,
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

Line 15189: okl_k_lines fee_line,

15185: SELECT sum(kle_cov.amount) asset_roll_fee_amt
15186: FROM OKC_LINE_STYLES_B LSEB,
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'