VIEW: APPS.CZ_UI_TEMPLATE_TYPES_V

Source

View Text - Preformatted

SELECT SUBSTR (NVL (clnt.client_code, 'RUNTIME'), 1, 8) as client_code, substr (decode (rels.rel_type_code, 'UTM', '1', 'UTO', '0', 'X'), 1, 1) as required_flag, ttgrp.signature_id as templtype_group_id, ttgrp.name as templtype_group_name, ttgrp.description as templtype_group_description, ttgrp.signature_type as templtype_group_sigtype, ttspec.signature_id as template_type_id, ttspec.name as template_type_name, ttspec.description as template_type_description, ttspec.signature_type as template_type_sigtype from cz_type_relationships rels, cz_signatures ttgrp, cz_signatures ttspec, ( select substr ('NEWTEMPL', 1, 8) as client_code from dual union all select substr ('UIGEN', 1, 8) as client_code from dual union all select substr ('RUNTIME', 1, 8) as client_code from dual ) clnt WHERE ( ( clnt.client_code = 'NEWTEMPL' and subject_type != 2065 ) or ( clnt.client_code = 'UIGEN' and subject_type = 2065 ) or ( clnt.client_code = 'RUNTIME' and subject_type not in (160, 2065) ) ) and rel_type_code in ('UTM', 'UTO') and rels.deleted_flag = '0' and ttgrp.signature_id = rels.subject_type and ttgrp.deleted_flag = '0' and ttspec.signature_id = rels.object_type and ttspec.deleted_flag = '0' and ('B' = ttspec.config_engine_type or 'B' = fnd_profile.value_wnps('CZ_DEV_ENABLE_CONFIG_ENGINE') or ttspec.config_engine_type = fnd_profile.value_wnps('CZ_DEV_ENABLE_CONFIG_ENGINE') ) order by client_code, templtype_group_id, template_type_id

View Text - HTML Formatted

SELECT SUBSTR (NVL (CLNT.CLIENT_CODE
, 'RUNTIME')
, 1
, 8) AS CLIENT_CODE
, SUBSTR (DECODE (RELS.REL_TYPE_CODE
, 'UTM'
, '1'
, 'UTO'
, '0'
, 'X')
, 1
, 1) AS REQUIRED_FLAG
, TTGRP.SIGNATURE_ID AS TEMPLTYPE_GROUP_ID
, TTGRP.NAME AS TEMPLTYPE_GROUP_NAME
, TTGRP.DESCRIPTION AS TEMPLTYPE_GROUP_DESCRIPTION
, TTGRP.SIGNATURE_TYPE AS TEMPLTYPE_GROUP_SIGTYPE
, TTSPEC.SIGNATURE_ID AS TEMPLATE_TYPE_ID
, TTSPEC.NAME AS TEMPLATE_TYPE_NAME
, TTSPEC.DESCRIPTION AS TEMPLATE_TYPE_DESCRIPTION
, TTSPEC.SIGNATURE_TYPE AS TEMPLATE_TYPE_SIGTYPE
FROM CZ_TYPE_RELATIONSHIPS RELS
, CZ_SIGNATURES TTGRP
, CZ_SIGNATURES TTSPEC
, ( SELECT SUBSTR ('NEWTEMPL'
, 1
, 8) AS CLIENT_CODE
FROM DUAL UNION ALL SELECT SUBSTR ('UIGEN'
, 1
, 8) AS CLIENT_CODE
FROM DUAL UNION ALL SELECT SUBSTR ('RUNTIME'
, 1
, 8) AS CLIENT_CODE
FROM DUAL ) CLNT
WHERE ( ( CLNT.CLIENT_CODE = 'NEWTEMPL'
AND SUBJECT_TYPE != 2065 ) OR ( CLNT.CLIENT_CODE = 'UIGEN'
AND SUBJECT_TYPE = 2065 ) OR ( CLNT.CLIENT_CODE = 'RUNTIME'
AND SUBJECT_TYPE NOT IN (160
, 2065) ) )
AND REL_TYPE_CODE IN ('UTM'
, 'UTO')
AND RELS.DELETED_FLAG = '0'
AND TTGRP.SIGNATURE_ID = RELS.SUBJECT_TYPE
AND TTGRP.DELETED_FLAG = '0'
AND TTSPEC.SIGNATURE_ID = RELS.OBJECT_TYPE
AND TTSPEC.DELETED_FLAG = '0'
AND ('B' = TTSPEC.CONFIG_ENGINE_TYPE OR 'B' = FND_PROFILE.VALUE_WNPS('CZ_DEV_ENABLE_CONFIG_ENGINE') OR TTSPEC.CONFIG_ENGINE_TYPE = FND_PROFILE.VALUE_WNPS('CZ_DEV_ENABLE_CONFIG_ENGINE') ) ORDER BY CLIENT_CODE
, TEMPLTYPE_GROUP_ID
, TEMPLATE_TYPE_ID