[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'
886: -- Cursor to get top line id
887: Cursor top_cle_csr (p_chr_id IN NUMBER) is
888: SELECT cle.id
889: From okc_k_lines_b cle,
890: okc_statuses_b sts
891: where cle.dnz_chr_id = cle.chr_id
892: and cle.chr_id = p_chr_id
893: and sts.code = cle.sts_code;
894:
911: From okc_k_lines_b cle
912: connect by prior cle.id = cle.cle_id
913: start with cle.id = p_cle_id
914: and exists (select 1
915: from okc_statuses_b sts
916: where sts.code = cle.sts_code);
917: -- bug 5769216 - End
918:
919: BEGIN
2547: cursor l_ubb_contract_csr(p_orig_chr_id number) IS
2548: SELECT oks.date_terminated,sts.ste_code
2549: FROM okc_k_rel_objs_v krelobj ,
2550: okc_k_headers_b oks,
2551: okc_statuses_b sts
2552: WHERE krelobj.JTOT_OBJECT1_CODE = 'OKL_SERVICE'
2553: AND krelobj.RTY_CODE = 'OKLUBB'
2554: and krelobj.OBJECT1_ID1 = oks.id
2555: and krelobj.OBJECT1_ID2='#'
4096: cle.orig_system_id1
4097: FROM okc_k_lines_b cle,
4098: okl_k_lines kle,
4099: okc_line_styles_b lse,
4100: okc_statuses_b sts
4101: WHERE cle.dnz_chr_id = p_chr_id
4102: AND cle.chr_id = p_chr_id
4103: AND kle.id = cle.id
4104: AND cle.lse_id = lse.id
4108: CURSOR orig_cle_sts_csr(p_cle_id IN NUMBER)
4109: IS
4110: SELECT sts.ste_code
4111: FROM okc_k_lines_b cle,
4112: okc_statuses_b sts
4113: WHERE cle.id = p_cle_id
4114: AND cle.sts_code = sts.code;
4115:
4116: orig_cle_sts_rec orig_cle_sts_csr%ROWTYPE;
5367: sts.ste_code
5368: FROM okc_k_lines_b cle,
5369: okl_k_lines kle,
5370: okc_line_styles_b lse,
5371: okc_statuses_b sts
5372: WHERE cle.dnz_chr_id = p_chr_id
5373: AND cle.chr_id = p_chr_id
5374: AND kle.id = cle.id
5375: AND cle.lse_id = lse.id
5379: CURSOR orig_cle_sts_csr(p_cle_id IN NUMBER)
5380: IS
5381: SELECT sts.ste_code
5382: FROM okc_k_lines_b cle,
5383: okc_statuses_b sts
5384: WHERE cle.id = p_cle_id
5385: AND cle.sts_code = sts.code;
5386:
5387: orig_cle_sts_rec orig_cle_sts_csr%ROWTYPE;
6578: sts.ste_code,
6579: cle.orig_system_id1
6580: FROM okc_k_lines_b cle,
6581: okc_line_styles_b lse,
6582: okc_statuses_b sts
6583: WHERE cle.dnz_chr_id = p_chr_id
6584: AND cle.chr_id = p_chr_id
6585: AND cle.lse_id = lse.id
6586: AND lse.lty_code = 'FREE_FORM1'
6591: SELECT sts.ste_code,
6592: --Bug# 4670760
6593: cle.dnz_chr_id
6594: FROM okc_k_lines_b cle,
6595: okc_statuses_b sts
6596: WHERE cle.id = p_cle_id
6597: AND cle.sts_code = sts.code;
6598:
6599: orig_cle_sts_rec orig_cle_sts_csr%ROWTYPE;
7880: chr.end_date,
7881: st.ste_code sts_code,
7882: chr.authoring_org_id
7883: FROM OKC_K_HEADERS_B chr,
7884: okc_statuses_b st
7885: WHERE chr.id = p_chr_id
7886: and st.code = chr.sts_code;
7887:
7888: l_new_contract_number okc_k_headers_b.contract_number%TYPE;
8449: OKC_K_ITEMS cim_orig,
8450: OKC_K_ITEMS cim,
8451: OKC_K_LINES_B cle,
8452: OKC_LINE_STYLES_B lse,
8453: OKC_STATUSES_B sts,
8454: OKL_TXL_ASSETS_B txl
8455: WHERE asr.kle_id = cle_orig.cle_id
8456: AND asr.ars_code = 'RELEASE_IN_PROCESS'
8457: AND cim.object1_id1 = cim_orig.object1_id1