[Home] [Help]
410:
411: CURSOR c_subsidy(c_contract_id IN NUMBER,c_parent_line_id IN NUMBER) IS
412: select nvl(sum(nvl(KLE1.subsidy_override_amount,KLE1.amount)),0) amount
413: from OKL_K_LINES KLE1,
414: OKC_K_LINES_B CLE1,
415: OKC_LINE_STYLES_B LS1,
416: OKL_ASSET_SUBSIDY_UV SUB,
417: OKL_SUBSIDIES_B SUBB,
418: OKL_SUBSIDIES_TL SUBT,
586: -- and the amounts summed up, enhancement done for user defined streams impacts, bug 3924303
587:
588: CURSOR security_deposit IS
589: SELECT ste.amount amount
590: FROM okc_k_lines_b kle,
591: okc_line_styles_b lse,
592: okc_k_items ite,
593: okl_strm_type_b sty1,
594: okl_streams stm,
794: SELECT 'x' FROM okc_k_items cim
795: WHERE cim.object1_id1 = TO_CHAR(CHR.id)
796: AND EXISTS
797: (
798: SELECT 'x' FROM okc_k_lines_b cle, okc_line_styles_b lse
799: WHERE cle.lse_id = lse.id
800: AND lse.lty_code = 'SHARED'
801: AND cle.id = cim.cle_id
802: )
916: SELECT 'x' FROM okc_k_items cim
917: WHERE cim.object1_id1 = TO_CHAR(CHR.id)
918: AND EXISTS
919: (
920: SELECT 'x' FROM okc_k_lines_b cle, okc_line_styles_b lse
921: WHERE cle.lse_id = lse.id
922: AND lse.lty_code = 'SHARED'
923: AND cle.id = cim.cle_id
924: )
1667: FUNCTION get_asset_number(p_kle_id IN NUMBER)
1668: RETURN VARCHAR2 IS
1669: CURSOR l_asset_number_csr(cp_kle_id IN NUMBER) IS
1670: SELECT fat.name
1671: FROM okc_k_lines_b fa,
1672: okc_k_lines_tl fat,
1673: okc_line_styles_b stl,
1674: okc_k_lines_b top_cle,
1675: okc_line_styles_b top_stl,
1670: SELECT fat.name
1671: FROM okc_k_lines_b fa,
1672: okc_k_lines_tl fat,
1673: okc_line_styles_b stl,
1674: okc_k_lines_b top_cle,
1675: okc_line_styles_b top_stl,
1676: okc_k_lines_b sub_cle,
1677: okc_line_styles_b sub_stl,
1678: okc_k_items cim
1672: okc_k_lines_tl fat,
1673: okc_line_styles_b stl,
1674: okc_k_lines_b top_cle,
1675: okc_line_styles_b top_stl,
1676: okc_k_lines_b sub_cle,
1677: okc_line_styles_b sub_stl,
1678: okc_k_items cim
1679: WHERE top_cle.lse_id = top_stl.id
1680: AND top_stl.lty_code in ('SOLD_SERVICE','FEE')
1770: FUNCTION get_cov_asset_id(p_kle_id IN NUMBER)
1771: RETURN NUMBER IS
1772: CURSOR l_asset_id_csr(cp_kle_id IN NUMBER) IS
1773: SELECT cim1.object1_id1
1774: FROM okc_k_lines_b cle,
1775: okc_k_lines_b cle1, /* to get all line types associated with free form 1 in that FIXED_ASSET */
1776: okc_k_items cim, /* to get the one having covered asset */
1777: okc_k_lines_b cle2, /* After getting the one having the covered asset take the id of the service line */
1778: okc_line_styles_b lse, /* to get free_form 1 */
1771: RETURN NUMBER IS
1772: CURSOR l_asset_id_csr(cp_kle_id IN NUMBER) IS
1773: SELECT cim1.object1_id1
1774: FROM okc_k_lines_b cle,
1775: okc_k_lines_b cle1, /* to get all line types associated with free form 1 in that FIXED_ASSET */
1776: okc_k_items cim, /* to get the one having covered asset */
1777: okc_k_lines_b cle2, /* After getting the one having the covered asset take the id of the service line */
1778: okc_line_styles_b lse, /* to get free_form 1 */
1779: okc_line_styles_b lse1, /* to get FIXED_ASSET lty_code */
1773: SELECT cim1.object1_id1
1774: FROM okc_k_lines_b cle,
1775: okc_k_lines_b cle1, /* to get all line types associated with free form 1 in that FIXED_ASSET */
1776: okc_k_items cim, /* to get the one having covered asset */
1777: okc_k_lines_b cle2, /* After getting the one having the covered asset take the id of the service line */
1778: okc_line_styles_b lse, /* to get free_form 1 */
1779: okc_line_styles_b lse1, /* to get FIXED_ASSET lty_code */
1780: okc_line_styles_b lse2, /* to get LINK_SERV_ASSET lty_code */
1781: okc_k_items cim1 /* to take the actual asset id */