View: CZ_NODE_CAPTION_PROPERTIES_V

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

View Text

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)

Columns