[Home] [Help]
1114: SELECT SUM(cle.price_unit * cim.number_of_items) oec
1115: FROM okc_subclass_top_line stl,
1116: okc_line_styles_b lse2,
1117: okc_line_styles_b lse1,
1118: okc_k_items_v cim,
1119: okc_k_lines_v cle
1120: WHERE cle.cle_id = p_top_cle_id
1121: AND cle.dnz_chr_id = p_dnz_chr_id
1122: AND cle.id = cim.cle_id
1134: FROM okc_subclass_top_line stl,
1135: okc_line_styles_b lse3,
1136: okc_line_styles_b lse2,
1137: okc_line_styles_b lse1,
1138: okc_k_items_v cim,
1139: okc_k_lines_b cle
1140: WHERE cle.dnz_chr_id = p_dnz_chr_id
1141: AND cle.dnz_chr_id = cim.dnz_chr_id
1142: AND cle.id = cim.cle_id
1234: SELECT SUM(cle.price_unit * cim.number_of_items) oec
1235: FROM okc_subclass_top_line stl,
1236: okc_line_styles_b lse2,
1237: okc_line_styles_b lse1,
1238: okc_k_items_v cim,
1239: okc_k_lines_v cle
1240: WHERE cle.cle_id = p_top_cle_id
1241: AND cle.dnz_chr_id = p_dnz_chr_id
1242: AND cle.id = cim.cle_id
2284:
2285: CURSOR l_fee_csr( kleId NUMBER) IS
2286: SELECT NVL(SUM(kle_cov.capital_amount),0) CapAmountLines
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
2301:
2302: CURSOR l_fee_csr_incl_terminated( kleId NUMBER) IS
2303: SELECT NVL(SUM(kle_cov.capital_amount),0) CapAmountLines
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
2612:
2613: CURSOR l_srvcline_csr ( kleId NUMBER ) IS
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'
2627: CURSOR srvc_strm_type_csr ( kleid NUMBER ) IS
2628: SELECT sty.capitalize_yn,
2629: sty.name
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
4797: OKC_K_LINES_B KLE_IL,
4798: OKC_LINE_STYLES_B LSE_IL,
4799: OKC_K_LINES_B KLE_IB,
4800: OKC_LINE_STYLES_B LSE_IB,
4801: OKC_K_ITEMS ITE,
4802: CSI_ITEM_INSTANCES CII,
4803: HZ_PARTY_SITES PSI,
4804: HZ_LOCATIONS LOC,
4805: -- HZ_PARTIES PAR,
4831: OKC_K_LINES_B KLE_IL,
4832: OKC_LINE_STYLES_B LSE_IL,
4833: OKC_K_LINES_B KLE_IB,
4834: OKC_LINE_STYLES_B LSE_IB,
4835: OKC_K_ITEMS ITE,
4836: CSI_ITEM_INSTANCES CII,
4837: --HZ_PARTY_SITES PSI,
4838: HZ_LOCATIONS LOC,
4839: --HZ_PARTIES PAR,
10635: ,okc_line_styles_b lse
10636: ,okl_strm_elements ste
10637: ,okl_k_lines cle
10638: ,okc_k_lines_b cles
10639: ,okc_k_items cim
10640: WHERE stm.khr_id = cp_chr_id
10641: AND stm.active_yn = 'Y'
10642: AND stm.say_code = 'CURR'
10643: AND ste.stm_id = stm.id
13920: CURSOR get_asset_cost_csr (p_kle_id IN NUMBER) IS
13921: SELECT nvl(fab.cost,0) current_cost
13922: FROM fa_books fab,
13923: fa_book_controls fbc,
13924: okc_k_items_v itm,
13925: okc_k_lines_b kle,
13926: okc_line_styles_v lse
13927: WHERE fbc.book_class = 'CORPORATE'
13928: AND fab.book_type_code = fbc.book_type_code
15619: SELECT SUM(cle.price_unit * cim.number_of_items) asset_cost
15620: FROM okc_subclass_top_line stl,
15621: okc_line_styles_b lse2,
15622: okc_line_styles_b lse1,
15623: okc_k_items_v cim,
15624: okc_k_lines_v cle
15625: WHERE cle.cle_id = p_line_id
15626: AND cle.dnz_chr_id = p_dnz_chr_id
15627: AND cle.id = cim.cle_id
15640: FROM okc_subclass_top_line stl,
15641: okc_line_styles_b lse3,
15642: okc_line_styles_b lse2,
15643: okc_line_styles_b lse1,
15644: okc_k_items_v cim,
15645: okc_k_lines_b cle
15646: WHERE cle.dnz_chr_id = p_dnz_chr_id
15647: AND cle.dnz_chr_id = cim.dnz_chr_id
15648: AND cle.id = cim.cle_id
15673: CURSOR c_cap_fee(p_line_id VARCHAR2,
15674: p_dnz_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
15675: SELECT SUM(kle_cov.capital_amount) Cap_fee
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
15925: FROM okc_subclass_top_line stl,
15926: okc_line_styles_b lse3,
15927: okc_line_styles_b lse2,
15928: okc_line_styles_b lse1,
15929: okc_k_items_v cim,
15930: okc_k_lines_b cle
15931: WHERE cle.dnz_chr_id = p_contract_id
15932: AND cle.dnz_chr_id = cim.dnz_chr_id
15933: AND cle.id = cim.cle_id
16269:
16270: CURSOR l_fee_csr( c_chr_id IN NUMBER, c_fin_asset_line_id IN NUMBER) IS
16271: SELECT sum(kle_cov.amount) asset_fin_fee_amt
16272: FROM OKC_LINE_STYLES_B LSEB,
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
16291:
16292: CURSOR l_fee_csr_incl_terminated( c_chr_id IN NUMBER, c_fin_asset_line_id IN NUMBER) IS
16293: SELECT sum(kle_cov.amount) asset_fin_fee_amt
16294: FROM OKC_LINE_STYLES_B LSEB,
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
16393:
16394: CURSOR l_fee_csr( c_chr_id IN NUMBER, c_fin_asset_line_id IN NUMBER) IS
16395: SELECT sum(kle_cov.amount) asset_roll_fee_amt
16396: FROM OKC_LINE_STYLES_B LSEB,
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
16415:
16416: CURSOR l_fee_csr_incl_terminated( c_chr_id IN NUMBER, c_fin_asset_line_id IN NUMBER) IS
16417: SELECT sum(kle_cov.amount) asset_roll_fee_amt
16418: FROM OKC_LINE_STYLES_B LSEB,
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