MSS_MFG_WO_OPERATIONS_V

Details

• Schema: FUSION

• Object owner: MSS

• Object type: VIEW

Columns

Name
PLAN_ID WORK_ORDER_ID WO_OPERATION_ID OPERATION_SEQ_NUMBER OPERATION_NAME PLANNED_START_DATE PLANNED_END_DATE

Query

SQL_Statement
select PLAN_ID, WORK_ORDER_ID, WO_OPERATION_ID, OPERATION_SEQ_NUMBER, OPERATION_NAME, Min(SCHEDULED_START_DATE) PLANNED_START_DATE, Max(SCHEDULED_END_DATE) PLANNED_END_DATE from MSS_WO_OPERATIONS group by PLAN_ID, WORK_ORDER_ID, WO_OPERATION_ID, OPERATION_SEQ_NUMBER, OPERATION_NAME