[Home] [Help]
372:
373: CURSOR c_subsidy(c_contract_id IN NUMBER,c_parent_line_id IN NUMBER) IS
374: select nvl(sum(nvl(KLE1.subsidy_override_amount,KLE1.amount)),0) amount
375: from OKL_K_LINES KLE1,
376: OKC_K_LINES_B CLE1,
377: OKC_LINE_STYLES_B LS1,
378: OKL_ASSET_SUBSIDY_UV SUB,
379: OKL_SUBSIDIES_B SUBB,
380: OKL_SUBSIDIES_TL SUBT,
548: -- and the amounts summed up, enhancement done for user defined streams impacts, bug 3924303
549:
550: CURSOR security_deposit IS
551: SELECT ste.amount amount
552: FROM okc_k_lines_b kle,
553: okc_line_styles_b lse,
554: okc_k_items ite,
555: okl_strm_type_b sty1,
556: okl_streams stm,
756: SELECT 'x' FROM okc_k_items cim
757: WHERE cim.object1_id1 = TO_CHAR(CHR.id)
758: AND EXISTS
759: (
760: SELECT 'x' FROM okc_k_lines_b cle, okc_line_styles_b lse
761: WHERE cle.lse_id = lse.id
762: AND lse.lty_code = 'SHARED'
763: AND cle.id = cim.cle_id
764: )
878: SELECT 'x' FROM okc_k_items cim
879: WHERE cim.object1_id1 = TO_CHAR(CHR.id)
880: AND EXISTS
881: (
882: SELECT 'x' FROM okc_k_lines_b cle, okc_line_styles_b lse
883: WHERE cle.lse_id = lse.id
884: AND lse.lty_code = 'SHARED'
885: AND cle.id = cim.cle_id
886: )
1629: FUNCTION get_asset_number(p_kle_id IN NUMBER)
1630: RETURN VARCHAR2 IS
1631: CURSOR l_asset_number_csr(cp_kle_id IN NUMBER) IS
1632: SELECT fat.name
1633: FROM okc_k_lines_b fa,
1634: okc_k_lines_tl fat,
1635: okc_line_styles_b stl,
1636: okc_k_lines_b top_cle,
1637: okc_line_styles_b top_stl,
1632: SELECT fat.name
1633: FROM okc_k_lines_b fa,
1634: okc_k_lines_tl fat,
1635: okc_line_styles_b stl,
1636: okc_k_lines_b top_cle,
1637: okc_line_styles_b top_stl,
1638: okc_k_lines_b sub_cle,
1639: okc_line_styles_b sub_stl,
1640: okc_k_items cim
1634: okc_k_lines_tl fat,
1635: okc_line_styles_b stl,
1636: okc_k_lines_b top_cle,
1637: okc_line_styles_b top_stl,
1638: okc_k_lines_b sub_cle,
1639: okc_line_styles_b sub_stl,
1640: okc_k_items cim
1641: WHERE top_cle.lse_id = top_stl.id
1642: AND top_stl.lty_code in ('SOLD_SERVICE','FEE')
1732: FUNCTION get_cov_asset_id(p_kle_id IN NUMBER)
1733: RETURN NUMBER IS
1734: CURSOR l_asset_id_csr(cp_kle_id IN NUMBER) IS
1735: SELECT cim1.object1_id1
1736: FROM okc_k_lines_b cle,
1737: okc_k_lines_b cle1, /* to get all line types associated with free form 1 in that FIXED_ASSET */
1738: okc_k_items cim, /* to get the one having covered asset */
1739: okc_k_lines_b cle2, /* After getting the one having the covered asset take the id of the service line */
1740: okc_line_styles_b lse, /* to get free_form 1 */
1733: RETURN NUMBER IS
1734: CURSOR l_asset_id_csr(cp_kle_id IN NUMBER) IS
1735: SELECT cim1.object1_id1
1736: FROM okc_k_lines_b cle,
1737: okc_k_lines_b cle1, /* to get all line types associated with free form 1 in that FIXED_ASSET */
1738: okc_k_items cim, /* to get the one having covered asset */
1739: okc_k_lines_b cle2, /* After getting the one having the covered asset take the id of the service line */
1740: okc_line_styles_b lse, /* to get free_form 1 */
1741: okc_line_styles_b lse1, /* to get FIXED_ASSET lty_code */
1735: SELECT cim1.object1_id1
1736: FROM okc_k_lines_b cle,
1737: okc_k_lines_b cle1, /* to get all line types associated with free form 1 in that FIXED_ASSET */
1738: okc_k_items cim, /* to get the one having covered asset */
1739: okc_k_lines_b cle2, /* After getting the one having the covered asset take the id of the service line */
1740: okc_line_styles_b lse, /* to get free_form 1 */
1741: okc_line_styles_b lse1, /* to get FIXED_ASSET lty_code */
1742: okc_line_styles_b lse2, /* to get LINK_SERV_ASSET lty_code */
1743: okc_k_items cim1 /* to take the actual asset id */