[Home] [Help]
56: tl.item_description DESCRIPTION
57: from OKC_K_LINES_B CLE,
58: OKC_K_LINES_TL TL,
59: OKC_LINE_STYLES_B LSE,
60: OKC_K_HEADERS_B CHR
61: where
62: cle.lse_id = lse.id
63: and lse.lty_code = 'USAGE'
64: and cle.chr_id = chr.id
2899: WHERE lines.id = p_id
2900: AND lse.id = lines.lse_id
2901: AND items.cle_id = lines.id;
2902:
2903: CURSOR get_serv_chr_from_serv(p_chr_id okc_k_headers_b.id%TYPE,
2904: p_line_id okc_k_lines_b.id%TYPE) IS
2905: SELECT rlobj.object1_id1
2906: FROM okc_k_rel_objs_v rlobj
2907: WHERE rlobj.chr_id = p_chr_id
2915: SELECT dnz_chr_id
2916: FROM okc_k_lines_b
2917: WHERE id = p_serv_top_line_id;
2918:
2919: l_serv_contract_id okc_k_headers_b.id%TYPE;
2920:
2921: l_lty_code okc_line_styles_b.lty_code%TYPE;
2922: l_asset_id okc_k_lines_b.id%TYPE;
2923: l_raise_business_event VARCHAR2(1) := OKL_API.G_FALSE;
2971: --cursor to check if contract is a rebook copy contract
2972: Cursor l_rbk_asst_csr(p_cle_id IN NUMBER) is
2973: Select 'Y' rbk_asst_flag
2974: from okc_k_lines_b cleb,
2975: okc_k_headers_b chrb
2976: where chrb.id = cleb.dnz_chr_id
2977: and chrb.scs_code = 'LEASE'
2978: and chrb.orig_system_source_code = 'OKL_REBOOK'
2979: and cleb.id = p_cle_id
2978: and chrb.orig_system_source_code = 'OKL_REBOOK'
2979: and cleb.id = p_cle_id
2980: and cleb.orig_system_id1 is not NULL
2981: and exists (select '1'
2982: from okc_k_headers_b orig_chrb,
2983: okc_k_lines_b orig_cleb
2984: where orig_chrb.id = chrb.orig_system_id1
2985: and orig_cleb.id = cleb.orig_system_id1
2986: and orig_cleb.sts_code <> 'ABANDONED'