SMO_ASSET_EVENT_ATTR_VALUES_V

Details

• Schema: FUSION

• Object owner: SMO

• Object type: VIEW

Columns

Name
ASSET_ID EVENT_TIME EVENT_TYPE_ID BO_TYPE_ID BO_KIND_ID ORGANIZATION_ID ATTRIBUTE_ID NUMERIC_VALUE STRING_VALUE DATE_VALUE JSON_VALUE ASSET_NUMBER ASSET_DESCRIPTION EQUIPMENT_INSTANCE_ID EQUIPMENT_INSTANCE_CODE EQUIPMENT_INSTANCE_NAME

Query

SQL_Statement

SELECT seav.BO_ID as ASSET_ID, seav.EVENT_TIME, seav.EVENT_TYPE_ID, seav.BO_TYPE_ID, seav.BO_KIND_ID, seav.ORGANIZATION_ID, seav.ATTRIBUTE_ID, seav.NUMERIC_VALUE, seav.STRING_VALUE, seav.DATE_VALUE, seav.JSON_VALUE, cav.ASSET_NUMBER, cav.DESCRIPTION as ASSET_DESCRIPTION, wei.EQUIPMENT_INSTANCE_ID, wei.EQUIPMENT_INSTANCE_CODE, wei.EQUIPMENT_INSTANCE_NAME FROM SMO_EVENT_ATTRIBUTE_VALUES seav INNER JOIN SMO_SYSTEM_BO_TYPES_B ssbt ON seav.BO_KIND_ID = ssbt.SYSTEM_BO_TYPE_ID AND ssbt.SYSTEM_BO_TYPE_CODE = 'CONNECTED_ASSET' LEFT OUTER JOIN CSE_ASSETS_VL cav ON seav.BO_ID = cav.ASSET_ID LEFT OUTER JOIN WIS_EQUIPMENT_INSTANCES wei ON cav.ASSET_ID = wei.ASSET_ID