View: CZ_NODETYPE_PROPERTIES_V

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

View Text

SELECT DISTINCT SYSPROP.RULE_ID AS PROP_ID
, CONCAT(SYSPROP.NAME
, '()') AS NAME
, SYSPROP.NAME AS SYS_PROP_NAME
, NODEREL.OBJECT_TYPE AS NODE_TYPE
, PROPREL.SUBJECT_TYPE AS ATTACHED_TO_NODE_TYPE
, SYSPROP.DATA_TYPE AS DATA_TYPE
, SYSPROP.MUTABLE_FLAG AS MUTABLE_FLAG
, SYSPROP.COLLECTION_FLAG AS COLLECTION_FLAG
, SYSPROP.SEQ_NBR AS SEQ_NBR
, PROPREL.REL_TYPE_CODE AS SYSTEM_PROPERTY_TYPE
, SYSPROP.CONFIG_ENGINE_TYPE
FROM CZ_CONVERSION_RELS_V NODEREL
, CZ_SYSTEM_PROPERTY_RELS_V PROPREL
, CZ_SYSTEM_PROPERTIES_V SYSPROP
WHERE NODEREL.SUBJECT_TYPE = PROPREL.SUBJECT_TYPE
AND PROPREL.OBJECT_TYPE = SYSPROP.RULE_ID

Columns