VIEW: APPS.CZ_GLOBAL_PROPERTIES_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)