eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_XPRT_UTIL_PVT dependencies on CZ_CONFIG_ITEMS_V

Line 3217: FROM cz_config_items_v

3213: --
3214:
3215: CURSOR l_get_expert_articles_from_cz IS
3216: SELECT SUBSTR(orig_sys_ref,INSTR(orig_sys_ref,':',-1,1)+1)
3217: FROM cz_config_items_v
3218: WHERE config_hdr_id = p_config_header_id
3219: AND config_rev_nbr = p_config_rev_nbr
3220: AND orig_sys_ref LIKE 'OKC:CLAUSEMODELOPTION:%' ;
3221:

Line 3256: FROM cz_config_items_v

3252: AND NVL(kart.SUMMARY_AMEND_OPERATION_CODE, '?') <> 'DELETED'
3253: --AND (nvl(nvl(kart.ref_article_id, kart.sav_sae_id), -1) not in (
3254: AND (kart.orig_article_id NOT IN (
3255: SELECT SUBSTR(orig_sys_ref,INSTR(orig_sys_ref,':',-1,1)+1)
3256: FROM cz_config_items_v
3257: WHERE config_hdr_id = p_config_header_id
3258: AND config_rev_nbr = p_config_rev_nbr
3259: AND orig_sys_ref LIKE 'OKC:CLAUSEMODELOPTION:%'
3260: )

Line 3763: FROM cz_config_items_v

3759: --
3760:
3761: CURSOR l_get_expert_articles_from_cz IS
3762: SELECT SUBSTR(orig_sys_ref,INSTR(orig_sys_ref,':',-1,1)+1)
3763: FROM cz_config_items_v
3764: WHERE config_hdr_id = p_config_header_id
3765: AND config_rev_nbr = p_config_rev_nbr
3766: AND orig_sys_ref LIKE 'OKC:CLAUSEMODELOPTION:%' ;
3767:

Line 3831: -- cz_config_items_v, where CZ will

3827: x_return_status := FND_API.G_RET_STS_SUCCESS;
3828:
3829: --
3830: -- This SQL is based on Drop 1 changes to
3831: -- cz_config_items_v, where CZ will
3832: -- add the orig_sys_ref column.
3833: --
3834:
3835:

Line 3996: FROM cz_config_items_v

3992: --
3993:
3994: CURSOR l_get_expert_articles_from_cz IS
3995: SELECT SUBSTR(orig_sys_ref,INSTR(orig_sys_ref,':',-1,1)+1)
3996: FROM cz_config_items_v
3997: WHERE config_hdr_id = p_config_header_id
3998: AND config_rev_nbr = p_config_rev_nbr
3999: AND orig_sys_ref LIKE 'OKC:CLAUSEMODELOPTION:%' ;
4000:

Line 5164: FROM cz_config_items_v config,

5160:
5161: --Bug 4757962 cursor to fetch value for a given question id
5162: CURSOR csr_get_rule_qst_values (l_config_header_id number, l_config_rev_nbr number) is
5163: SELECT ltxt.localized_str question_value
5164: FROM cz_config_items_v config,
5165: cz_ps_nodes psn,
5166: cz_localized_texts ltxt
5167: WHERE config.config_hdr_id = l_config_header_id
5168: AND config.config_rev_nbr = l_config_rev_nbr

Line 5192: FROM cz_config_items_v config

5188:
5189: -- cursor to fetch document value for questions based on constants
5190: CURSOR csr_get_rule_qst_const_val (l_config_header_id number, l_config_rev_nbr number) is
5191: SELECT to_char(Item_num_val)
5192: FROM cz_config_items_v config
5193: WHERE config.config_hdr_id = l_config_header_id
5194: AND config.config_rev_nbr = l_config_rev_nbr
5195: AND config.orig_sys_ref LIKE 'OKC:TEMPLATEMODELFEATURE:%:' || p_object_code;
5196:

Line 5265: --In case of Numeric Questions get document value from cz_config_items_v.Item_num_val

5261: OPEN csr_get_qst_datatype;
5262: FETCH csr_get_qst_datatype INTO l_question_datatype;
5263: CLOSE csr_get_qst_datatype;
5264: if(l_question_datatype = 'N')then
5265: --In case of Numeric Questions get document value from cz_config_items_v.Item_num_val
5266: OPEN csr_get_rule_qst_const_val(l_config_header_id,l_config_rev_nbr);
5267: FETCH csr_get_rule_qst_const_val INTO l_question_value;
5268: CLOSE csr_get_rule_qst_const_val;
5269: l_final_document_value := l_question_value;

Line 6832: FROM cz_config_items_v

6828: SELECT DECODE(SUBSTR(orig_sys_ref,5,3),'CLA',NULL,'VAR',item_val) line_number,
6829: SUBSTR(orig_sys_ref,INSTR(orig_sys_ref,':',-1,1)+1) id,
6830: SUBSTR(orig_sys_ref,5,3) type,
6831: parent_config_item_id
6832: FROM cz_config_items_v
6833: WHERE config_hdr_id = p_config_header_id
6834: AND config_rev_nbr = p_config_rev_nbr
6835: AND (orig_sys_ref LIKE 'OKC:CLAUSEMODELOPTION:%' OR
6836: orig_sys_ref LIKE 'OKC:VARIABLEMODELDEVFEATURE:%');

Line 6863: FROM cz_config_items_v

6859: --
6860:
6861: CURSOR l_get_xprt_dev_line_number_csr(l_parent_config_item_id NUMBER) IS
6862: SELECT NVL(item_val,'-99') line_number
6863: FROM cz_config_items_v
6864: WHERE config_hdr_id = p_config_header_id
6865: AND config_rev_nbr = p_config_rev_nbr
6866: AND parent_config_item_id = l_parent_config_item_id
6867: AND orig_sys_ref LIKE 'OKC:VARIABLEMODELTEXTFEATURE:%LINE_NUMBER%';

Line 7368: FROM cz_config_items_v config,

7364: --
7365:
7366: CURSOR l_get_rule_qst_values_csr(p_config_header_id NUMBER, p_config_rev_nbr NUMBER, p_question_id NUMBER) IS
7367: SELECT ltxt.localized_str question_value
7368: FROM cz_config_items_v config,
7369: cz_ps_nodes psn,
7370: cz_localized_texts ltxt
7371: WHERE config.config_hdr_id = p_config_header_id
7372: AND config.config_rev_nbr = p_config_rev_nbr

Line 7381: FROM cz_config_items_v

7377: (INSTR(config.orig_sys_ref,':',-1,1) - (INSTR(config.orig_sys_ref,':',-1,2)+1))) = to_char(p_question_id);
7378:
7379:
7380: /* SELECT ps_node_name question_value
7381: FROM cz_config_items_v
7382: WHERE config_hdr_id = p_config_header_id
7383: AND config_rev_nbr = p_config_rev_nbr
7384: AND SUBSTR(orig_sys_ref, INSTR(orig_sys_ref,':',-1,2)+1,
7385: (INSTR(orig_sys_ref,':',-1,1) - (INSTR(orig_sys_ref,':',-1,2)+1))) = to_char(p_question_id);

Line 8482: -- Step 3: Get Clauses and Deviations from cz_config_items_v

8478: END LOOP;
8479: END IF;
8480:
8481:
8482: -- Step 3: Get Clauses and Deviations from cz_config_items_v
8483:
8484: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8485: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
8486: G_MODULE||l_api_name,

Line 8487: '130: Step 3: Get Clauses and Deviations from cz_config_items_v');

8483:
8484: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8485: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
8486: G_MODULE||l_api_name,
8487: '130: Step 3: Get Clauses and Deviations from cz_config_items_v');
8488: END IF;
8489:
8490: get_expert_selections(
8491: p_api_version => 1.0,

Line 8562: -- Step 6: For questions in rule get value from cz_config_items_v

8558: END IF;
8559: END IF;
8560:
8561:
8562: -- Step 6: For questions in rule get value from cz_config_items_v
8563:
8564: IF l_rule_questions_tbl.COUNT > 0 THEN
8565: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8566: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 8568: '160: Step 6: For questions in rule get value from cz_config_items_v');

8564: IF l_rule_questions_tbl.COUNT > 0 THEN
8565: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8566: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
8567: G_MODULE||l_api_name,
8568: '160: Step 6: For questions in rule get value from cz_config_items_v');
8569: END IF;
8570:
8571: get_rule_question_values(
8572: p_api_version => 1.0,