WIE_WO_OPERATION_RESOURCES
This table stores the labor and equipment resource requirements for the work order.
Details
-
Schema: FUSION
-
Object owner: WIE
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
WIE_WO_OPER_RESOURCES_PK |
WO_OPERATION_RESOURCE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| WO_OPERATION_RESOURCE_ID | NUMBER | 18 | Yes | The unique identifier of work order operation resource record. 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. | |
| ORGANIZATION_ID | NUMBER | 18 | Yes | The organization identifier that represents the manufacturing plant to which this operation resource belongs. | |
| WO_OPERATION_ID | NUMBER | 18 | Yes | Represents the foreign key reference to the WIE_WO_OPERATIONS_B table. | |
| RESOURCE_SEQ_NUMBER | NUMBER | Yes | Resource sequence number value is used to define the sequence in which resources work together in finishing the operation. For parallel work the same sequence number is used. | ||
| WORK_CENTER_ID | NUMBER | 18 | Yes | Represents the internal work center identifier for which this resource belongs. | |
| RESOURCE_ID | NUMBER | 18 | Yes | Represents the internal identifier to the resource which is a foreign key to the WIS_RESOURCES_B table. | |
| PRINCIPAL_FLAG | VARCHAR2 | 1 | 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. | ||
| USAGE_RATE | NUMBER | The predefined resource rate that is required to perform operation/activity for one unit of the assembly. For example: Number of hours it take to spray paint one pedestal. | |||
| BASIS_TYPE | VARCHAR2 | 30 | Yes | Indicates whether the resource quantity 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. | |
| REQUIRED_USAGE | NUMBER | Yes | Represents the total required usage for the resource based on the basis type, usage rate, and work order quantity. It is the usage per assembly unit (variable basis) or the usage per work order (fixed basis). For example, assuming usage rate = 1 hour and work order quantity = 10: If Basis = Variable, then required usage = 1 * 10 = 10 hours If Basis = Fixed, then required usage = 1 hour | ||
| INVERSE_REQUIRED_USAGE | NUMBER | The inverse of the required usage. | |||
| UOM_CODE | VARCHAR2 | 3 | Yes | Represents the unit of measure code of the specified resource usage. | |
| CHARGE_TYPE | VARCHAR2 | 30 | Yes | Indicates whether resource transactions are automatically generated and at what stage. Valid values exist in the lookup with lookup type = ORA_WIS_CHARGE_TYPE. | |
| ASSIGNED_UNITS | NUMBER | Yes | Number of resource units assigned to perform the operation. | ||
| PLANNED_START_DATE | TIMESTAMP | Date when the resource is planned to start within the operation to which it is assigned. | |||
| PLANNED_COMPLETION_DATE | TIMESTAMP | Date when the resource is planned to complete within the operation to which it is assigned. | |||
| 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. | ||
| SCHEDULED_FLAG | VARCHAR2 | 30 | Yes | Flag used to indicate if this resource is scheduled or not. Valid values exist in the lookup with lookup type = ORA_WIS_RESOURCE_SCHEDULE. | |
| PHANTOM_FLAG | VARCHAR2 | 1 | Yes | This flag denotes that the resource that is associated to this operation was pulled in as part of a phantom explosion that pulled in the resources from the work definition of a phantom material tied to the operation. | |
| ACTUAL_RESOURCE_USAGE | NUMBER | Represents the actual resource usage recorded for the assigned resource. This is a calculated column. | |||
| WD_OPERATION_RESOURCE_ID | NUMBER | 18 | Represents the work order operation resource identifier from the work definition. | ||
| PROFILE_ID | NUMBER | 18 | Foreign key reference to HCM model profiles. | ||
| EQP_QUAL_PROFILE_ID | NUMBER | 18 | Foreign key reference to equipment qualification profiles. | ||
| REASON_FOR_REPAIR_CODE_ID | NUMBER | 18 | Represents the reason for which this repair operation is to be performed. Foreign key to cse_condition_event_codes_b table. | ||
| REPAIR_TXN_CODE_ID | NUMBER | 18 | Represents the code to which this repair transaction is applicable. Foreign key to cse_condition_event_codes_b table. | ||
| WORK_ACCOMPLISHED_CODE_ID | NUMBER | 18 | Represents the accomplishment code to record when the operation is completed. Foreign key to cse_condition_event_codes_b table. | ||
| MNT_COMPLETE_FLAG | VARCHAR2 | 1 | Flag indicating whether the operation resource requirements are fulfilled by the maintenance technician. | ||
| 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. | |||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| WIE_WO_OPERATION_RESOURCES | wie_wo_operations_b | WO_OPERATION_ID |
| wie_wo_op_resource_instances | wie_wo_operation_resources | WO_OPERATION_RESOURCE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| WIE_WO_OPER_RESOURCES_N01 | Non Unique | Default | ORGANIZATION_ID |
| WIE_WO_OPER_RESOURCES_N02 | Non Unique | Default | WO_OPERATION_ID, BASIS_TYPE |
| WIE_WO_OPER_RESOURCES_N03 | Non Unique | Default | PROFILE_ID |
| WIE_WO_OPER_RESOURCES_N04 | Non Unique | Default | EQP_QUAL_PROFILE_ID |
| WIE_WO_OPER_RESOURCES_N05 | Non Unique | Default | RESOURCE_ID |
| WIE_WO_OPER_RESOURCES_U01 | Unique | Default | WO_OPERATION_RESOURCE_ID |
| WIE_WO_OPER_RESOURCES_U02 | Unique | Default | WO_OPERATION_ID, RESOURCE_SEQ_NUMBER, RESOURCE_ID |