SMO_FAILED_ASSET_EVENTS_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 REASON_CODE ASSET_NUMBER ASSET_DESCRIPTION EQUIPMENT_INSTANCE_ID EQUIPMENT_INSTANCE_CODE EQUIPMENT_INSTANCE_NAME

Query

SQL_Statement

SELECT sfde.BO_ID as ASSET_ID, sfde.EVENT_TIME, sfde.EVENT_TYPE_ID, sfde.BO_TYPE_ID, sfde.BO_KIND_ID, sfde.ORGANIZATION_ID, sfde.REASON_CODE, cav.ASSET_NUMBER, cav.DESCRIPTION as ASSET_DESCRIPTION, wei.EQUIPMENT_INSTANCE_ID, wei.EQUIPMENT_INSTANCE_CODE, wei.EQUIPMENT_INSTANCE_NAME FROM SMO_FAILED_DISPOSITION_EVENTS sfde INNER JOIN SMO_SYSTEM_BO_TYPES_B ssbt ON sfde.BO_KIND_ID = ssbt.SYSTEM_BO_TYPE_ID AND ssbt.SYSTEM_BO_TYPE_CODE = 'CONNECTED_ASSET' LEFT OUTER JOIN CSE_ASSETS_VL cav ON sfde.BO_ID = cav.ASSET_ID LEFT OUTER JOIN WIS_EQUIPMENT_INSTANCES wei ON cav.ASSET_ID = wei.ASSET_ID