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)