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 3219: FROM cz_config_items_v

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

Line 3274: FROM cz_config_items_v

3270: AND NVL(kart.SUMMARY_AMEND_OPERATION_CODE, '?') <> 'DELETED'
3271: --AND (nvl(nvl(kart.ref_article_id, kart.sav_sae_id), -1) not in (
3272: AND (kart.orig_article_id NOT IN (
3273: SELECT SUBSTR(orig_sys_ref,INSTR(orig_sys_ref,':',-1,1)+1)
3274: FROM cz_config_items_v
3275: WHERE config_hdr_id = p_config_header_id
3276: AND config_rev_nbr = p_config_rev_nbr
3277: AND orig_sys_ref LIKE 'OKC:CLAUSEMODELOPTION:%'
3278: )

Line 3831: FROM cz_config_items_v

3827: --
3828:
3829: CURSOR l_get_expert_articles_from_cz IS
3830: SELECT SUBSTR(orig_sys_ref,INSTR(orig_sys_ref,':',-1,1)+1)
3831: FROM cz_config_items_v
3832: WHERE config_hdr_id = p_config_header_id
3833: AND config_rev_nbr = p_config_rev_nbr
3834: AND orig_sys_ref LIKE 'OKC:CLAUSEMODELOPTION:%' ;
3835:

Line 3921: -- cz_config_items_v, where CZ will

3917: x_return_status := FND_API.G_RET_STS_SUCCESS;
3918:
3919: --
3920: -- This SQL is based on Drop 1 changes to
3921: -- cz_config_items_v, where CZ will
3922: -- add the orig_sys_ref column.
3923: --
3924:
3925:

Line 4117: FROM cz_config_items_v

4113: --
4114:
4115: CURSOR l_get_expert_articles_from_cz IS
4116: SELECT SUBSTR(orig_sys_ref,INSTR(orig_sys_ref,':',-1,1)+1)
4117: FROM cz_config_items_v
4118: WHERE config_hdr_id = p_config_header_id
4119: AND config_rev_nbr = p_config_rev_nbr
4120: AND orig_sys_ref LIKE 'OKC:CLAUSEMODELOPTION:%' ;
4121:

Line 5362: FROM cz_config_items_v config,

5358:
5359: --Bug 4757962 cursor to fetch value for a given question id
5360: CURSOR csr_get_rule_qst_values (l_config_header_id number, l_config_rev_nbr number) is
5361: SELECT ltxt.localized_str question_value
5362: FROM cz_config_items_v config,
5363: cz_ps_nodes psn,
5364: cz_localized_texts ltxt
5365: WHERE config.config_hdr_id = l_config_header_id
5366: AND config.config_rev_nbr = l_config_rev_nbr

Line 5390: FROM cz_config_items_v config

5386:
5387: -- cursor to fetch document value for questions based on constants
5388: CURSOR csr_get_rule_qst_const_val (l_config_header_id number, l_config_rev_nbr number) is
5389: SELECT to_char(Item_num_val)
5390: FROM cz_config_items_v config
5391: WHERE config.config_hdr_id = l_config_header_id
5392: AND config.config_rev_nbr = l_config_rev_nbr
5393: AND config.orig_sys_ref LIKE 'OKC:TEMPLATEMODELFEATURE:%:' || p_object_code;
5394:

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

5459: OPEN csr_get_qst_datatype;
5460: FETCH csr_get_qst_datatype INTO l_question_datatype;
5461: CLOSE csr_get_qst_datatype;
5462: if(l_question_datatype = 'N')then
5463: --In case of Numeric Questions get document value from cz_config_items_v.Item_num_val
5464: OPEN csr_get_rule_qst_const_val(l_config_header_id,l_config_rev_nbr);
5465: FETCH csr_get_rule_qst_const_val INTO l_question_value;
5466: CLOSE csr_get_rule_qst_const_val;
5467: l_final_document_value := l_question_value;

Line 7057: FROM cz_config_items_v

7053: SELECT DECODE(SUBSTR(orig_sys_ref,5,3),'CLA',NULL,'VAR',item_val) line_number,
7054: SUBSTR(orig_sys_ref,INSTR(orig_sys_ref,':',-1,1)+1) id,
7055: SUBSTR(orig_sys_ref,5,3) type,
7056: parent_config_item_id
7057: FROM cz_config_items_v
7058: WHERE config_hdr_id = p_config_header_id
7059: AND config_rev_nbr = p_config_rev_nbr
7060: AND (orig_sys_ref LIKE 'OKC:CLAUSEMODELOPTION:%' OR
7061: orig_sys_ref LIKE 'OKC:VARIABLEMODELDEVFEATURE:%');

Line 7088: FROM cz_config_items_v

7084: --
7085:
7086: CURSOR l_get_xprt_dev_line_number_csr(l_parent_config_item_id NUMBER) IS
7087: SELECT NVL(item_val,'-99') line_number
7088: FROM cz_config_items_v
7089: WHERE config_hdr_id = p_config_header_id
7090: AND config_rev_nbr = p_config_rev_nbr
7091: AND parent_config_item_id = l_parent_config_item_id
7092: AND orig_sys_ref LIKE 'OKC:VARIABLEMODELTEXTFEATURE:%LINE_NUMBER%';

Line 7651: FROM cz_config_items_v config,

7647: --
7648:
7649: CURSOR l_get_rule_qst_values_csr(p_config_header_id NUMBER, p_config_rev_nbr NUMBER, p_question_id NUMBER) IS
7650: SELECT ltxt.localized_str question_value
7651: FROM cz_config_items_v config,
7652: cz_ps_nodes psn,
7653: cz_localized_texts ltxt
7654: WHERE config.config_hdr_id = p_config_header_id
7655: AND config.config_rev_nbr = p_config_rev_nbr

Line 7664: FROM cz_config_items_v

7660: (INSTR(config.orig_sys_ref,':',-1,1) - (INSTR(config.orig_sys_ref,':',-1,2)+1))) = to_char(p_question_id);
7661:
7662:
7663: /* SELECT ps_node_name question_value
7664: FROM cz_config_items_v
7665: WHERE config_hdr_id = p_config_header_id
7666: AND config_rev_nbr = p_config_rev_nbr
7667: AND SUBSTR(orig_sys_ref, INSTR(orig_sys_ref,':',-1,2)+1,
7668: (INSTR(orig_sys_ref,':',-1,1) - (INSTR(orig_sys_ref,':',-1,2)+1))) = to_char(p_question_id);

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

8805: END LOOP;
8806: END IF;
8807:
8808:
8809: -- Step 3: Get Clauses and Deviations from cz_config_items_v
8810:
8811: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8812: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
8813: G_MODULE||l_api_name,

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

8810:
8811: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8812: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
8813: G_MODULE||l_api_name,
8814: '130: Step 3: Get Clauses and Deviations from cz_config_items_v');
8815: END IF;
8816:
8817: get_expert_selections(
8818: p_api_version => 1.0,

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

8885: END IF;
8886: END IF;
8887:
8888:
8889: -- Step 6: For questions in rule get value from cz_config_items_v
8890:
8891: IF l_rule_questions_tbl.COUNT > 0 THEN
8892: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8893: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

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

8891: IF l_rule_questions_tbl.COUNT > 0 THEN
8892: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8893: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
8894: G_MODULE||l_api_name,
8895: '160: Step 6: For questions in rule get value from cz_config_items_v');
8896: END IF;
8897:
8898: get_rule_question_values(
8899: p_api_version => 1.0,