VIEW: APPS.CZ_NODETYPE_PROPERTIES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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