SMO_EVENT_EXEC_CONTEXT_V

Details

• Schema: FUSION

• Object owner: SMO

• Object type: VIEW

Columns

Name
EVENT_TIME BO_ID EVENT_TYPE_ID BO_TYPE_ID BO_KIND_ID ATTRIBUTE_ID ORGANIZATION_ID NUMERIC_VALUE STRING_VALUE BOOLEAN_VALUE DATE_VALUE JSON_VALUE EXECUTION_ID WORK_ORDER_NUMBER OPERATION_SEQ_NUMBER WO_OPERATION_TRANSACTION_ID EQUIPMENT_INSTANCE_ID IN_RANGE_FLAG WS_WI_EXEC_ACTIVITY_ID WORK_INSTR_STEP_ID ATTR_VAL_CONTEXT_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT seav.event_time, seav.bo_id, seav.event_type_id, seav.bo_type_id, seav.bo_kind_id, seav.attribute_id, seav.organization_id, seav.numeric_value, seav.string_value, seav.boolean_value, seav.date_value, seav.json_value, seav.execution_id, wo.work_order_number, woop.operation_seq_number, seav.wo_operation_transaction_id, seav.equipment_instance_id, seav.in_range_flag, seav.ws_wi_exec_activity_id, seav.work_instr_step_id, seav.attr_val_context_id, seav.created_by, seav.creation_date, seav.last_updated_by, seav.last_update_date, seav.last_update_login FROM smo_event_attribute_values seav LEFT JOIN wie_ws_exec_activities wwea ON seav.execution_id = wwea.ws_exec_activity_id LEFT JOIN wie_work_orders_b wo ON wwea.work_order_id = wo.work_order_id LEFT JOIN wie_wo_operations_b woop ON wwea.wo_operation_id = woop.wo_operation_id WHERE seav.attr_val_context_id IS NULL AND seav.execution_id IS NOT NULL UNION ALL SELECT seav.event_time, seav.bo_id, seav.event_type_id, seav.bo_type_id, seav.bo_kind_id, seav.attribute_id, seav.organization_id, seav.numeric_value, seav.string_value, seav.boolean_value, seav.date_value, seav.json_value, seec.execution_id, wo.work_order_number, woop.operation_seq_number, seec.wo_operation_transaction_id, seec.equipment_instance_id, seec.in_range_flag, seec.ws_wi_exec_activity_id, seec.work_instr_step_id, seec.attr_val_context_id, seec.created_by, seec.creation_date, seec.last_updated_by, seec.last_update_date, seec.last_update_login FROM smo_event_attribute_values seav LEFT JOIN smo_event_exec_context seec ON seav.ATTR_VAL_CONTEXT_ID = seec.ATTR_VAL_CONTEXT_ID AND seav.EVENT_TIME = seec.EVENT_TIME LEFT JOIN wie_ws_exec_activities wwea ON seec.execution_id = wwea.ws_exec_activity_id LEFT JOIN wie_work_orders_b wo ON wwea.work_order_id = wo.work_order_id LEFT JOIN wie_wo_operations_b woop ON wwea.wo_operation_id = woop.wo_operation_id WHERE seav.ATTR_VAL_CONTEXT_ID IS NOT NULL