[Home] [Help]
969: SELECT SUM(cle.price_unit * cim.number_of_items) oec
970: FROM okc_subclass_top_line stl,
971: okc_line_styles_b lse2,
972: okc_line_styles_b lse1,
973: okc_k_items_v cim,
974: okc_k_lines_v cle
975: WHERE cle.cle_id = p_top_cle_id
976: AND cle.dnz_chr_id = p_dnz_chr_id
977: AND cle.id = cim.cle_id
989: FROM okc_subclass_top_line stl,
990: okc_line_styles_b lse3,
991: okc_line_styles_b lse2,
992: okc_line_styles_b lse1,
993: okc_k_items_v cim,
994: okc_k_lines_b cle
995: WHERE cle.dnz_chr_id = p_dnz_chr_id
996: AND cle.dnz_chr_id = cim.dnz_chr_id
997: AND cle.id = cim.cle_id
1893:
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
1910:
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
2148:
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'
2163: CURSOR srvc_strm_type_csr ( kleid NUMBER ) IS
2164: SELECT sty.capitalize_yn,
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
4213: OKC_K_LINES_B KLE_IL,
4214: OKC_LINE_STYLES_B LSE_IL,
4215: OKC_K_LINES_B KLE_IB,
4216: OKC_LINE_STYLES_B LSE_IB,
4217: OKC_K_ITEMS ITE,
4218: CSI_ITEM_INSTANCES CII,
4219: HZ_PARTY_SITES PSI,
4220: HZ_LOCATIONS LOC,
4221: -- HZ_PARTIES PAR,
4247: OKC_K_LINES_B KLE_IL,
4248: OKC_LINE_STYLES_B LSE_IL,
4249: OKC_K_LINES_B KLE_IB,
4250: OKC_LINE_STYLES_B LSE_IB,
4251: OKC_K_ITEMS ITE,
4252: CSI_ITEM_INSTANCES CII,
4253: --HZ_PARTY_SITES PSI,
4254: HZ_LOCATIONS LOC,
4255: --HZ_PARTIES PAR,
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'
9785: AND stm.say_code = 'CURR'
9786: AND ste.stm_id = stm.id
12688: CURSOR get_asset_cost_csr (p_kle_id IN NUMBER) IS
12689: SELECT nvl(fab.cost,0) current_cost
12690: FROM fa_books fab,
12691: fa_book_controls fbc,
12692: okc_k_items_v itm,
12693: okc_k_lines_b kle,
12694: okc_line_styles_v lse
12695: WHERE fbc.book_class = 'CORPORATE'
12696: AND fab.book_type_code = fbc.book_type_code
14387: SELECT SUM(cle.price_unit * cim.number_of_items) asset_cost
14388: FROM okc_subclass_top_line stl,
14389: okc_line_styles_b lse2,
14390: okc_line_styles_b lse1,
14391: okc_k_items_v cim,
14392: okc_k_lines_v cle
14393: WHERE cle.cle_id = p_line_id
14394: AND cle.dnz_chr_id = p_dnz_chr_id
14395: AND cle.id = cim.cle_id
14408: FROM okc_subclass_top_line stl,
14409: okc_line_styles_b lse3,
14410: okc_line_styles_b lse2,
14411: okc_line_styles_b lse1,
14412: okc_k_items_v cim,
14413: okc_k_lines_b cle
14414: WHERE cle.dnz_chr_id = p_dnz_chr_id
14415: AND cle.dnz_chr_id = cim.dnz_chr_id
14416: AND cle.id = cim.cle_id
14441: CURSOR c_cap_fee(p_line_id VARCHAR2,
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
14693: FROM okc_subclass_top_line stl,
14694: okc_line_styles_b lse3,
14695: okc_line_styles_b lse2,
14696: okc_line_styles_b lse1,
14697: okc_k_items_v cim,
14698: okc_k_lines_b cle
14699: WHERE cle.dnz_chr_id = p_contract_id
14700: AND cle.dnz_chr_id = cim.dnz_chr_id
14701: AND cle.id = cim.cle_id
15037:
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
15059:
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
15161:
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
15183:
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