[Home] [Help]
147:
148: CURSOR l_line_name_csr IS
149: SELECT RTRIM(RTRIM(line_number) || ', ' || RTRIM(lsev.name) || ' ' ||
150: RTRIM(clev.name)) "LINE_NAME"
151: FROM OKC_LINE_STYLES_V lsev,
152: OKC_K_LINES_V clev
153: WHERE lsev.id = clev.lse_id
154: AND clev.id = p_cle_id;
155:
1058: , cle.id
1059: , chdr.contract_number_modifier
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
1319: FROM okc_k_headers_all_b trgh,
1320: okc_k_lines_v trgsl,
1321: okc_k_items trgi,
1322: okc_k_lines_b trgtl,
1323: okc_line_styles_v trgst,
1324: okc_k_lines_v srcsl,
1325: okc_k_items srci,
1326: okc_k_lines_b srctl,
1327: okc_line_styles_v srcst,
1323: okc_line_styles_v trgst,
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
1717: in authoring form is no longer mandatory - Bug #2364436 - Anupama */
1718:
1719: CURSOR l_cvd_lvl_csr (p_cle_id NUMBER) IS
1720: SELECT cle.id id
1721: FROM okc_k_lines_v cle, okc_line_styles_v lse
1722: WHERE lse.id = cle.lse_id
1723: AND lse.LTY_CODE IN
1724: ('COVER_CUST', 'COVER_ITEM', 'COVER_PROD',
1725: 'COVER_PTY', 'COVER_SITE', 'COVER_SYS', 'INST_CTR')