MSS_WO_OPERATION_RESOURCES
This table stores the resource requirements for the work order. The labor and equipment requirements are recorded in this table.
Details
-
Schema: FUSION
-
Object owner: MSS
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
MSS_WO_OPERATION_RESOURCES_PK |
PLAN_ID, WO_OPERATION_RESOURCE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PLAN_ID | NUMBER | 18 | Yes | Identifier of the Production Scheduling plan. | |
| WO_OPERATION_RESOURCE_ID | NUMBER | 18 | Yes | Indirect foreign key to WIS_WO_OPERATION_RESOURCES. | |
| WO_OPERATION_ID | NUMBER | 18 | Yes | Foreign Key reference to its parent table MSS_WO_OPERATIONS. | |
| RESOURCE_SEQ_NUMBER | NUMBER | Yes | Resource sequence number of the work order operation. | ||
| WORK_CENTER_ID | NUMBER | 18 | Yes | Indicates the work center where the resource resides. | |
| RESOURCE_ID | NUMBER | 18 | Yes | Foreign Key reference to MSS_RESOURCES. | |
| ORIGINAL_RESOURCE_ID | NUMBER | 18 | Original planned resource ID. Foreign key to MSS_RESOURCES. | ||
| PRIMARY_RESOURCE_ID | NUMBER | 18 | Identifies the primary resource of the resource set in work definition. Foreign key to MSS_RESOURCES. | ||
| WD_OPERATION_RESOURCE_ID | NUMBER | 18 | Work Definition Operation Resource reference. | ||
| SP_RESOURCE_REQUIREMENT_ID | NUMBER | 18 | Resource requirement transaction ID, indirect foreign key field to MSC_RESOURCE_REQUIREMENTS table. | ||
| RESOURCE_ACTIVITY_NAME | VARCHAR2 | 80 | Indicates the activity name this operation resource is going to perform. Valid values are looked-up from lookup type = ORA_WIS_RESOURCE_ACTIVITY. | ||
| PRINCIPAL_FLAG | VARCHAR2 | 1 | Is this the principal operation resource (Y/N)? When two or more resources are running in parallel (i.e. simultaneous resources which have the same sequence number), one and only one of them must be marked as the principal resource. | ||
| DURATION_RESOURCE_FLAG | VARCHAR2 | 1 | Is this the duration operation resource (Y/N)? Computed based on the operation resource being either the PRINCIPAL or the only operation resource. | ||
| SCHEDULED_FLAG | VARCHAR2 | 1 | Is this operation resource scheduled (Y/N)? | ||
| ALLOW_OFFLOADING | VARCHAR2 | 1 | Allow resource offloading (Y/N)? | ||
| RESOURCE_ASSIGNMENT_FIXED | VARCHAR2 | 1 | Indicate whether ALLOW_OFFLOADING can be changed by Production Scheduling (Y/N). For example operation resources with transactions or with resource instances assigned may never be offloaded. | ||
| DURATION | NUMBER | Yes | Time duration run on the operation resource. | ||
| EXPENDED_DURATION | NUMBER | Expended resource duration on the operation. | |||
| REMAINING_DURATION | NUMBER | Remaining resource duration on the operation. | |||
| DURATION_UNIT | VARCHAR2 | 30 | Resource duration unit: seconds|minutes|hours|days|weeks. Applies to all duration types. | ||
| LOT_MULTIPLE | NUMBER | Resource lot multiple on the operation. | |||
| CAPACITY_REQUIRED | NUMBER | Capacity required for the chosen resource. | |||
| ORIGINAL_CAPACITY_REQUIRED | NUMBER | Capacity required for the original planned resource. | |||
| DISPLAY_SLOT_NUMBER | NUMBER | 5 | This is the display row generated by the engine for displaying non-overlapping operations on multi-capacity resources in the Gantt component. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| MSS_WO_OPERATION_RESOURCES | mss_wo_operations | PLAN_ID, WO_OPERATION_ID, RESOURCE_SEQ_NUMBER |
| MSS_WO_OPERATION_RESOURCES | mss_resources | PLAN_ID, WORK_CENTER_ID, RESOURCE_ID |
| MSS_WO_OPERATION_RESOURCES | mss_resources | PLAN_ID, WORK_CENTER_ID, ORIGINAL_RESOURCE_ID |
| MSS_WO_OPERATION_RESOURCES | mss_resources | PLAN_ID, WORK_CENTER_ID, PRIMARY_RESOURCE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MSS_WO_OPERATION_RESOURCES_N1 | Non Unique | Default | PLAN_ID, WORK_CENTER_ID, RESOURCE_ID |
| MSS_WO_OPERATION_RESOURCES_N2 | Non Unique | Default | PLAN_ID, WORK_CENTER_ID, ORIGINAL_RESOURCE_ID |
| MSS_WO_OPERATION_RESOURCES_N3 | Non Unique | Default | PLAN_ID, WORK_CENTER_ID, PRIMARY_RESOURCE_ID |
| MSS_WO_OPERATION_RESOURCES_U1 | Unique | Default | PLAN_ID, WO_OPERATION_RESOURCE_ID |
| MSS_WO_OPERATION_RESOURCES_U2 | Unique | Default | PLAN_ID, WO_OPERATION_ID, RESOURCE_SEQ_NUMBER, WORK_CENTER_ID, RESOURCE_ID |