[Home] [Help]
90: FROM dual
91: where exists (SELECT 1
92: FROM OKC_LINE_STYLES_B lse,
93: OKC_K_LINES_B cle,
94: okc_statuses_b sts
95: WHERE lse.id = cle.lse_id
96: AND lse.lty_code = 'USAGE'
97: AND cle.dnz_chr_id = p_chr_id
98: AND sts.code =cle.sts_code
235: AND NOT EXISTS (
236: SELECT 1
237: FROM okc_k_lines_b line,
238: okc_line_styles_b lse,
239: okc_statuses_b sts
240: WHERE line.dnz_chr_id = p_chr_id
241: AND line.cle_id = cle.id
242: AND line.lse_id = lse.id
243: AND lse.lty_code ='LINK_USAGE_ASSET'
262: p_usage_line_id NUMBER) IS
263: SELECT line.id
264: FROM okc_k_lines_b line,
265: okc_line_styles_b lse,
266: okc_statuses_b okcsts
267: WHERE line.dnz_chr_id = p_chr_id
268: AND line.cle_id = p_usage_line_id
269: AND line.lse_id = lse.id
270: AND lse.lty_code ='LINK_USAGE_ASSET'
888: -- Cursor to get top line id
889: Cursor top_cle_csr (p_chr_id IN NUMBER) is
890: SELECT cle.id
891: From okc_k_lines_b cle,
892: okc_statuses_b sts
893: where cle.dnz_chr_id = cle.chr_id
894: and cle.chr_id = p_chr_id
895: and sts.code = cle.sts_code;
896:
913: From okc_k_lines_b cle
914: connect by prior cle.id = cle.cle_id
915: start with cle.id = p_cle_id
916: and exists (select 1
917: from okc_statuses_b sts
918: where sts.code = cle.sts_code);
919: -- bug 5769216 - End
920: */
921:
2571: cursor l_ubb_contract_csr(p_orig_chr_id number) IS
2572: SELECT oks.date_terminated,sts.ste_code
2573: FROM okc_k_rel_objs_v krelobj ,
2574: okc_k_headers_b oks,
2575: okc_statuses_b sts
2576: WHERE krelobj.JTOT_OBJECT1_CODE = 'OKL_SERVICE'
2577: AND krelobj.RTY_CODE = 'OKLUBB'
2578: and krelobj.OBJECT1_ID1 = oks.id
2579: and krelobj.OBJECT1_ID2='#'
4156: cle.orig_system_id1
4157: FROM okc_k_lines_b cle,
4158: okl_k_lines kle,
4159: okc_line_styles_b lse,
4160: okc_statuses_b sts
4161: WHERE cle.dnz_chr_id = p_chr_id
4162: AND cle.chr_id = p_chr_id
4163: AND kle.id = cle.id
4164: AND cle.lse_id = lse.id
4168: CURSOR orig_cle_sts_csr(p_cle_id IN NUMBER)
4169: IS
4170: SELECT sts.ste_code
4171: FROM okc_k_lines_b cle,
4172: okc_statuses_b sts
4173: WHERE cle.id = p_cle_id
4174: AND cle.sts_code = sts.code;
4175:
4176: orig_cle_sts_rec orig_cle_sts_csr%ROWTYPE;
5676: sts.ste_code
5677: FROM okc_k_lines_b cle,
5678: okl_k_lines kle,
5679: okc_line_styles_b lse,
5680: okc_statuses_b sts
5681: WHERE cle.dnz_chr_id = p_chr_id
5682: AND cle.chr_id = p_chr_id
5683: AND kle.id = cle.id
5684: AND cle.lse_id = lse.id
5688: CURSOR orig_cle_sts_csr(p_cle_id IN NUMBER)
5689: IS
5690: SELECT sts.ste_code
5691: FROM okc_k_lines_b cle,
5692: okc_statuses_b sts
5693: WHERE cle.id = p_cle_id
5694: AND cle.sts_code = sts.code;
5695:
5696: orig_cle_sts_rec orig_cle_sts_csr%ROWTYPE;
6887: sts.ste_code,
6888: cle.orig_system_id1
6889: FROM okc_k_lines_b cle,
6890: okc_line_styles_b lse,
6891: okc_statuses_b sts
6892: WHERE cle.dnz_chr_id = p_chr_id
6893: AND cle.chr_id = p_chr_id
6894: AND cle.lse_id = lse.id
6895: AND lse.lty_code = 'FREE_FORM1'
6900: SELECT sts.ste_code,
6901: --Bug# 4670760
6902: cle.dnz_chr_id
6903: FROM okc_k_lines_b cle,
6904: okc_statuses_b sts
6905: WHERE cle.id = p_cle_id
6906: AND cle.sts_code = sts.code;
6907:
6908: orig_cle_sts_rec orig_cle_sts_csr%ROWTYPE;
8204: chr.end_date,
8205: st.ste_code sts_code,
8206: chr.authoring_org_id
8207: FROM OKC_K_HEADERS_B chr,
8208: okc_statuses_b st
8209: WHERE chr.id = p_chr_id
8210: and st.code = chr.sts_code;
8211:
8212: l_new_contract_number okc_k_headers_b.contract_number%TYPE;
8778: OKC_K_ITEMS cim_orig,
8779: OKC_K_ITEMS cim,
8780: OKC_K_LINES_B cle,
8781: OKC_LINE_STYLES_B lse,
8782: OKC_STATUSES_B sts,
8783: OKL_TXL_ASSETS_B txl
8784: WHERE asr.kle_id = cle_orig.cle_id
8785: AND asr.ars_code = 'RELEASE_IN_PROCESS'
8786: AND cim.object1_id1 = cim_orig.object1_id1