View: CZ_UI_TEMPLATE_TYPES_V

Product:	CZ - Configurator
Description:
Implementation/DBA Data:	APPS.CZ_UI_TEMPLATE_TYPES_V

View Text

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' ORDER BY CLIENT_CODE
, TEMPLTYPE_GROUP_ID
, TEMPLATE_TYPE_ID

Columns