View: CZ_UI_ELEMENT_ATTRIBUTES_V

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

View Text

SELECT ELETPL.TEMPLATE_TYPE AS ELEMENT_SIGNATURE_ID
, ELESIG.NAME AS ELEMENT_SIGNATURE_NAME
, ELETPL.TEMPLATE_NAME AS ELEMENT_NAME
, ELETPL.ROOT_REGION_TYPE AS ELEMENT_TAG
, ELETPL.JRAD_DOC AS ATTRIBUTE_SET_JRAD_DOC
FROM CZ_UI_TEMPLATES ELETPL
, CZ_SIGNATURES ELESIG
WHERE ELETPL.DELETED_FLAG = '0'
AND ELESIG.DELETED_FLAG = '0'
AND ELETPL.TEMPLATE_TYPE = ELESIG.SIGNATURE_ID
AND ELESIG.SIGNATURE_TYPE = 'PGE'
AND ELETPL.TEMPLATE_USAGE = '1'
AND ELETPL.UI_DEF_ID = 0

Columns