[Home] [Help]
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,
419: OKC_STATUSES_V STS1
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,
595: okl_strm_type_b sty2,
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: )
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,
1676: okc_k_lines_b sub_cle,
1677: okc_line_styles_b sub_stl,
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
1679: WHERE top_cle.lse_id = top_stl.id
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')
1681: AND top_cle.id = sub_cle.cle_id
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 */
1782: WHERE lse.id = cle.lse_id
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 */
1782: WHERE lse.id = cle.lse_id
1783: AND lse1.id = cle1.lse_id
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 */
1782: WHERE lse.id = cle.lse_id
1783: AND lse1.id = cle1.lse_id
1784: AND lse1.lty_code = 'FIXED_ASSET'