WIS_STD_OPERATION_RESOURCES
This table stores the resource requirements for a given standard operation definition.
Details
-
Schema: FUSION
-
Object owner: WIS
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
WIS_STD_OPERATION_RESOURCES_PK |
STD_OPERATION_RESOURCE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| STD_OPERATION_RESOURCE_ID | NUMBER | 18 | Yes | The unique identifier of a standard operation resource. Its value is an application generated unique id. | |
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| RESOURCE_SEQ_NUMBER | NUMBER | Yes | Defines the actual sequence of the resource used in the operation. Multiple resources can be scheduled to be working concurrently within the same operation. Simultaneity is implemented by having more than one resource with the same sequence number. | ||
| ASSIGNED_UNITS | NUMBER | Yes | Indicates the number of resource instances assigned to this operation. | ||
| USAGE_RATE | NUMBER | Yes | The resource usage rate to yield one unit of product. | ||
| UOM_CODE | VARCHAR2 | 3 | Yes | Represents the unit of measure code of the resource usage rate. | |
| BASIS_TYPE | VARCHAR2 | 30 | Yes | Indicates whether the resource usage is fixed (i.e. usage per lot produced) or variable (i.e. usage per item produced). Valid values exist in the lookup with lookup type = EGP_BOM_BASIS_TYPE. | |
| SCHEDULE_TYPE | VARCHAR2 | 30 | Yes | Indicates if this resource is scheduled or not. Valid values exist in the lookup with lookup type = ORA_WIS_RESOURCE_SCHEDULE. | |
| PRINCIPAL_FLAG | VARCHAR2 | 1 | Yes | 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/primary resource. Planning will identify bottlenecks if the principal resource is not available when checking for capacity. | |
| CHARGE_TYPE | VARCHAR2 | 30 | Indicates how the resource is charged during work execution. Valid values exist in the lookup with lookup type = ORA_WIS_CHARGE_TYPE. | ||
| RESOURCE_ACTIVITY_CODE | VARCHAR2 | 30 | Indicates the activity this production resource is going to perform at this operation. Valid values exist in the lookup with lookup type = ORA_WIS_RESOURCE_ACTIVITY. | ||
| INVERSE_USAGE_RATE | NUMBER | Indicates the inverse resource usage rate. | |||
| STANDARD_OPERATION_ID | NUMBER | 18 | Yes | Reference to the standard operation to which this resource is assigned. | |
| WORK_CENTER_ID | NUMBER | 18 | Yes | Indicates the work center where this resource resides. | |
| RESOURCE_ID | NUMBER | 18 | Yes | Indicates the resource assigned to the standard operation. | |
| PROFILE_ID | NUMBER | 18 | Foreign key reference to HCM model profiles. | ||
| EQP_QUAL_PROFILE_ID | NUMBER | 18 | Foreign key reference to equipment qualification profiles. | ||
| 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. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 80 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR1 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR2 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR3 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR4 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR5 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR6 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR7 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR8 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR9 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR10 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR11 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR12 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR13 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR14 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR15 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR16 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR17 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR18 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR19 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR20 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| WIS_STD_OPERATION_RESOURCES | wis_standard_operations_b | STANDARD_OPERATION_ID |
| wis_std_op_alt_resources | wis_std_operation_resources | STD_OPERATION_RESOURCE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| WIS_STD_OPERATION_RESOURCES_N1 | Non Unique | Default | WORK_CENTER_ID, RESOURCE_ID |
| WIS_STD_OPERATION_RESOURCES_N2 | Non Unique | WIS_STD_OPERATION_RESOURCES_N2 | PROFILE_ID |
| WIS_STD_OPERATION_RESOURCES_N3 | Non Unique | WIS_STD_OPERATION_RESOURCES_N3 | EQP_QUAL_PROFILE_ID |
| WIS_STD_OPERATION_RESOURCES_U1 | Unique | Default | STD_OPERATION_RESOURCE_ID |
| WIS_STD_OPERATION_RESOURCES_U2 | Unique | Default | STANDARD_OPERATION_ID, RESOURCE_SEQ_NUMBER, RESOURCE_ID |