View: CZ_GLOBAL_PROPERTIES_V

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

View Text

SELECT SYSPROP.RULE_ID AS PROPERTY_ID
, SYSPROP.NAME AS PROPERTY_NAME
, CONCAT(SYSPROP.NAME
, '()') AS PROPERTY_TOKEN
, 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
, PROPREL.REL_TYPE_CODE AS SYSTEM_PROPERTY_TYPE
, SYSPROP.SEQ_NBR AS SEQ_NBR
FROM CZ_SYSTEM_PROPERTY_RELS_V PROPREL
, CZ_SYSTEM_PROPERTIES_V SYSPROP
WHERE PROPREL.OBJECT_TYPE = SYSPROP.RULE_ID
AND SYSPROP.CONFIG_ENGINE_TYPE IN (SELECT SYSPROP_ENGINE_TYPE
FROM CZ_MODEL_PROP_ENGTYP_COMPAT_V
WHERE MODEL_ID = 0)

Columns