MSS_FS_RESOURCES_V

Details

• Schema: FUSION

• Object owner: MSS

• Object type: VIEW

Columns

Name
PLAN_ID RESOURCE_ID WORK_CENTER_ID RESOURCE_CODE WORK_CENTER_CODE PRODUCTION_LINE_ID PRODUCTION_LINE_CODE AVAILABILITY_CALENDAR_ID RESOURCE_TYPE CAPACITY_TYPE MAXIMUM_CAPACITY CONSTRAINT_MODE

Query

SQL_Statement

Select PLAN_ID, (-99 - row_number() over (partition by PLAN_ID order by PRODUCTION_LINE_ID)) RESOURCE_ID, -1 WORK_CENTER_ID, PRODUCTION_LINE_CODE || ' (Line Resource)' RESOURCE_CODE, 'Flow Schedule Resources' WORK_CENTER_CODE, PRODUCTION_LINE_ID, PRODUCTION_LINE_CODE, AVAILABILITY_CALENDAR_ID, 'Machine' RESOURCE_TYPE, 'Multiple' CAPACITY_TYPE, 100 MAXIMUM_CAPACITY, 'RelaxCapacity' CONSTRAINT_MODE from mss_production_lines