VIEW: APPS.CZ_NODE_CAPTION_PROPERTIES_V

Source

View Text - Preformatted

SELECT sys.prop_id AS prop_id, sys.name as name, sys.sys_prop_name as sys_prop_name, psn.ps_node_id AS ps_node_id, sys.data_type AS data_type, sys.mutable_flag AS mutable_flag, sys.collection_flag AS collection_flag, sys.seq_nbr AS seq_nbr, DECODE(sys.node_type, 10, 0, 1) AS property_type FROM CZ_RUL_TYPEDPSN_V psn, CZ_NODETYPE_PROPERTIES_V sys WHERE sys.system_property_type = 'CAP' AND (psn.DETAILED_TYPE_ID = sys.node_type OR sys.node_type = 10) AND sys.config_engine_type in (select sysprop_engine_type from cz_model_prop_engtyp_compat_v where model_id = psn.devl_project_id)

View Text - HTML Formatted

SELECT SYS.PROP_ID AS PROP_ID
, SYS.NAME AS NAME
, SYS.SYS_PROP_NAME AS SYS_PROP_NAME
, PSN.PS_NODE_ID AS PS_NODE_ID
, SYS.DATA_TYPE AS DATA_TYPE
, SYS.MUTABLE_FLAG AS MUTABLE_FLAG
, SYS.COLLECTION_FLAG AS COLLECTION_FLAG
, SYS.SEQ_NBR AS SEQ_NBR
, DECODE(SYS.NODE_TYPE
, 10
, 0
, 1) AS PROPERTY_TYPE
FROM CZ_RUL_TYPEDPSN_V PSN
, CZ_NODETYPE_PROPERTIES_V SYS
WHERE SYS.SYSTEM_PROPERTY_TYPE = 'CAP'
AND (PSN.DETAILED_TYPE_ID = SYS.NODE_TYPE OR SYS.NODE_TYPE = 10)
AND SYS.CONFIG_ENGINE_TYPE IN (SELECT SYSPROP_ENGINE_TYPE
FROM CZ_MODEL_PROP_ENGTYP_COMPAT_V
WHERE MODEL_ID = PSN.DEVL_PROJECT_ID)