MSS_FS_TEMPORAL_RELATIONS_V

Details

• Schema: FUSION

• Object owner: MSS

• Object type: VIEW

Columns

Name
PLAN_ID WORK_ORDER_ID FROM_WO_OPERATION_ID FROM_RESOURCE_SEQ_NUMBER FROM_OPERATION_SEQ_NUMBER FROM_LINE_OP_SEQ_NUMBER TO_WO_OPERATION_ID TO_RESOURCE_SEQ_NUMBER TO_OPERATION_SEQ_NUMBER TO_LINE_OP_SEQ_NUMBER TEMPORAL_CONSTRAINT_TYPE

Query

SQL_Statement

with fromOp as ( select PLAN_ID, WORK_ORDER_ID, WO_OPERATION_ID, RESOURCE_SEQ_NUMBER, OPERATION_SEQ_NUMBER, LINE_OP_SEQ_NUMBER, FS_OPERATION_TYPE, row_number() over (partition by PLAN_ID, WORK_ORDER_ID order by LINE_OP_SEQ_NUMBER, OPERATION_SEQ_NUMBER) SEQ_NUMBER from MSS_FS_OPERATIONS_V ), toOp as ( select PLAN_ID, WORK_ORDER_ID, WO_OPERATION_ID, RESOURCE_SEQ_NUMBER, OPERATION_SEQ_NUMBER, LINE_OP_SEQ_NUMBER, FS_OPERATION_TYPE, row_number() over (partition by PLAN_ID, WORK_ORDER_ID order by LINE_OP_SEQ_NUMBER, OPERATION_SEQ_NUMBER) SEQ_NUMBER from MSS_FS_OPERATIONS_V ) select fromOp.PLAN_ID, fromOp.WORK_ORDER_ID WORK_ORDER_ID, fromOp.WO_OPERATION_ID FROM_WO_OPERATION_ID, fromOp.RESOURCE_SEQ_NUMBER FROM_RESOURCE_SEQ_NUMBER, fromOp.OPERATION_SEQ_NUMBER FROM_OPERATION_SEQ_NUMBER, fromOp.LINE_OP_SEQ_NUMBER FROM_LINE_OP_SEQ_NUMBER, toOp.WO_OPERATION_ID TO_WO_OPERATION_ID, toOp.RESOURCE_SEQ_NUMBER TO_RESOURCE_SEQ_NUMBER, toOp.OPERATION_SEQ_NUMBER TO_OPERATION_SEQ_NUMBER, toOp.LINE_OP_SEQ_NUMBER TO_LINE_OP_SEQ_NUMBER, Decode( toOp.FS_OPERATION_TYPE, 'Takt Operation', 'EndsAtEnd', 'StartsAfterEnd') TEMPORAL_CONSTRAINT_TYPE from fromOp, toOp where fromOp.PLAN_ID = toOp.PLAN_ID and fromOp.WORK_ORDER_ID = toOp.WORK_ORDER_ID and fromOp.SEQ_NUMBER+1 = toOp.SEQ_NUMBER