APPS.OKC_CFG_PUB dependencies on OKC_K_LINES_V

Line 23: -- in the okc_k_lines_v Returns Y or N.

19:
20: -- ---------------------------------------------------------------------------
21: -- FUNCTION : cle_config_check
22: -- PURPOSE : To check whether the contract configuration exists
23: -- in the okc_k_lines_v Returns Y or N.
24: -- Default return value = N
25: -- ---------------------------------------------------------------------------
26: FUNCTION cle_config_check ( p_line_id IN NUMBER,
27: p_config_hdr_id IN NUMBER,

Line 36: FROM okc_k_lines_v clev

32: l_config_hdr_id NUMBER,
33: l_config_rev_nbr NUMBER )
34: IS
35: SELECT 'Y'
36: FROM okc_k_lines_v clev
37: WHERE clev.id = l_line_id
38: AND clev.config_item_type = 'TOP_MODEL_LINE'
39: AND clev.config_header_id = l_config_hdr_id
40: AND clev.config_revision_number = l_config_rev_nbr;

Line 96: FROM okc_k_lines_v clev,

92: WHERE czdv.config_hdr_id = l_config_hdr_id
93: AND czdv.config_rev_nbr = l_config_rev_nbr
94: AND NOT EXISTS (
95: SELECT 'x'
96: FROM okc_k_lines_v clev,
97: okc_k_items_v cimv
98: WHERE clev.id = cimv.cle_id
99: AND clev.dnz_chr_id = l_dnz_chr_id
100: AND clev.config_header_id = czdv.config_hdr_id

Line 310: -- Check whether the configuration already exists in okc_k_lines_v

306: END IF;
307:
308: -- -------------------------------------------------------------------
309: -- STEP.1: DEBUG: 100 series
310: -- Check whether the configuration already exists in okc_k_lines_v
311: -- for a given config_header_id and config_revision_number
312: -- -------------------------------------------------------------------
313: l_config_exists := cle_config_check(p_au_line_rec.id,
314: p_config_rec.config_hdr_id,

Line 2050: FROM okc_k_lines_v clev

2046: IS
2047: SELECT clev.id,
2048: clev.config_header_id,
2049: clev.config_revision_number
2050: FROM okc_k_lines_v clev
2051: WHERE clev.dnz_chr_id = p_dnz_chr_id
2052: AND clev.config_item_type = 'TOP_MODEL_LINE';
2053:
2054: l_top_model_line_id NUMBER;