MSS_FS_OPERATION_RESOURCES_V

Details

• Schema: FUSION

• Object owner: MSS

• Object type: VIEW

Columns

Name
PLAN_ID WO_OPERATION_RESOURCE_ID WO_OPERATION_ID RESOURCE_SEQ_NUMBER WORK_CENTER_ID RESOURCE_ID DURATION REMAINING_DURATION DURATION_UNIT LOT_MULTIPLE CAPACITY_REQUIRED

Query

SQL_Statement

select fsOp.PLAN_ID, (-999 - row_number() over (partition by fsOp.PLAN_ID order by fsOp.WO_OPERATION_ID desc)) WO_OPERATION_RESOURCE_ID, fsOp.WO_OPERATION_ID, fsOp.RESOURCE_SEQ_NUMBER, fsOp.WORK_CENTER_ID, fsOp.DURATION_RES_ID RESOURCE_ID, Decode(fsOp.LINE_RATE, null, 0.0, 0.0, 0.0, Decode(wo.PRIMARY_PRODUCT_QUANTITY, null, Nvl(wo.NETTABLE_REMAINING_QUANTITY, wo.REMAINING_QUANTITY), wo.PRIMARY_PRODUCT_REMAINING_QTY) / fsOp.LINE_RATE) DURATION, Decode(fsOp.LINE_RATE, null, 0.0, 0.0, 0.0, Decode(wo.PRIMARY_PRODUCT_QUANTITY, null, Nvl(wo.NETTABLE_REMAINING_QUANTITY, wo.REMAINING_QUANTITY), wo.PRIMARY_PRODUCT_REMAINING_QTY) / fsOp.LINE_RATE) REMAINING_DURATION, 'hours' DURATION_UNIT, 1 LOT_MULTIPLE, 1 CAPACITY_REQUIRED from MSS_FS_OPERATIONS_V fsOp join MSS_WORK_ORDERS wo on fsOp.PLAN_ID = wo.PLAN_ID and fsOp.WORK_ORDER_ID = wo.WORK_ORDER_ID