[Home] [Help]
501: FROM okc_k_headers_all_b WHERE id = p_chr_id;
502:
503: CURSOR get_status(l_sts_code VARCHAR) IS
504: SELECT ste_code
505: FROM okc_statuses_b
506: WHERE ste_code = 'ENTERED' AND code = l_sts_code;
507:
508: /*cursor get_price_list(l_price_list_id number) is
509: SELECT CURRENCY_CODE
520: **/
521: --bug 5442886
522: SELECT line_number, price_list_id
523: FROM okc_k_lines_b,
524: okc_statuses_b
525: WHERE chr_id = p_chr_id
526: AND lse_id IN (1,12,46,19)
527: AND ste_code = 'ENTERED'
528: AND code = sts_code
1060: FROM okc_k_headers_all_b chdr,
1061: OKC_K_ITEMS cim,
1062: OKC_LINE_STYLES_V lse,
1063: OKC_K_LINES_B cle,
1064: OKC_STATUSES_B sts
1065: WHERE chdr.id = cle.dnz_chr_id
1066: AND object1_id1 = p_object1_id1
1067: AND object1_id2 = p_object1_id2
1068: AND jtot_object1_code = p_jtot_object1_code
1324: okc_k_lines_v srcsl,
1325: okc_k_items srci,
1326: okc_k_lines_b srctl,
1327: okc_line_styles_v srcst,
1328: okc_statuses_b sts
1329: WHERE srcsl.dnz_chr_id = cp_chr_id
1330: AND srcsl.lse_id IN (7, 8, 9, 10, 11, 35, 13, 18, 25)
1331: AND nvl(srcsl.date_terminated, cp_date + 1) > cp_date
1332: AND srci.cle_id = srcsl.id
2259: /*** Get all service lines for given Contract header id ***/
2260: CURSOR l_csr_get_service_line_id(p_chr_id NUMBER) IS
2261: SELECT cle.id, sts.ste_code sts_code
2262: FROM okc_k_lines_v cle,
2263: okc_statuses_b sts
2264: WHERE cle.dnz_chr_id = p_chr_id
2265: AND sts.code = cle.sts_code
2266: AND cle.lse_id IN (1, 19);
2267:
4351: cle.start_date, cle.end_date, cle.date_terminated,
4352: cim.jtot_object1_code, cim.object1_id1, cim.object1_id2
4353: FROM okc_k_items cim,
4354: okc_k_lines_b cle,
4355: okc_statuses_b sts
4356: WHERE cle.dnz_chr_id = p_chr_id
4357: AND cle.cle_id IS NULL
4358: AND sts.code = cle.sts_code
4359: AND cim.cle_id = cle.id
4396: cim.jtot_object1_code, cim.object1_id1,
4397: cim.object1_id2
4398: FROM OKC_K_ITEMS cim,
4399: OKC_K_LINES_B cle,
4400: OKC_STATUSES_B sts
4401: WHERE cim.cle_id = cle.id
4402: AND cle.cle_id = p_cle_id
4403: AND sts.code = cle.sts_code
4404: AND cle.lse_id IN (35, 7, 8, 9, 10, 11, 13, 18, 25);
4458: --Changed cursor because ste_code does not have QA_HOLD
4459: CURSOR l_hdr_csr(l_chr_id NUMBER) IS
4460: SELECT sts_code --sts.ste_code sts_code
4461: FROM okc_k_headers_all_b
4462: -- ,okc_statuses_b sts
4463: WHERE id = l_chr_id;
4464: --And sts.code = chr.sts_code;
4465:
4466:
6305: /*** Get all service lines for given Contract header id ***/
6306: CURSOR l_csr_get_service_line_id(p_chr_id NUMBER) IS
6307: SELECT cle.id, sts.ste_code sts_code
6308: FROM okc_k_lines_b cle,
6309: okc_statuses_b sts
6310: WHERE cle.dnz_chr_id = p_chr_id
6311: AND sts.code = cle.sts_code
6312: AND cle.lse_id IN (1, 19)
6313: AND cle.date_cancelled IS NULL --Changes [llc]
7846: l_dummy_msg VARCHAR2(200);
7847:
7848: CURSOR cur_renewal_source_lines (p_chr_id NUMBER) IS
7849: SELECT 1
7850: FROM okc_operation_lines a, okc_operation_instances b, okc_class_operations c, okc_k_headers_all_b d, okc_statuses_b e
7851: WHERE a.subject_chr_id = p_chr_id
7852: AND c.id = b.cop_id
7853: AND c.opn_code IN('RENEWAL', 'REN_CON')
7854: AND a.oie_id = b.id
7930:
7931:
7932: CURSOR cur_is_K_renewed IS
7933: SELECT d.id target_contract_id
7934: FROM okc_operation_lines a, okc_operation_instances b, okc_class_operations c, okc_k_headers_all_b d, okc_statuses_b e
7935: WHERE a.object_chr_id = p_chr_id
7936: AND c.id = b.cop_id
7937: AND c.opn_code IN('RENEWAL', 'REN_CON')
7938: AND a.oie_id = b.id
7942: AND e.ste_code NOT IN ('ACTIVE', 'SIGNED', 'HOLD', 'EXPIRED');
7943:
7944: CURSOR cur_lines_status IS
7945: SELECT b.id, b.line_number, s.ste_code
7946: FROM okc_k_lines_b b, okc_statuses_b s
7947: WHERE dnz_chr_id = p_chr_id
7948: AND cle_id IS NULL
7949: AND s.code = b.sts_code;
7950:
7950:
7951:
7952: CURSOR cur_sublines_status(p_cle_id NUMBER) IS
7953: SELECT b.id, b.line_number, s.ste_code
7954: FROM okc_k_lines_b b, okc_statuses_b s
7955: WHERE cle_id = p_cle_id
7956: AND s.code = b.sts_code
7957: AND s.ste_code = 'CANCELLED';
7958: