WIS_WORK_DEFINITIONS
This table stores a definition of how to produce a final product with a predefined ordered set of operations, and what material and labor are required at every operation step. Examples are recipe to manufacture a pill and how to build a computer. It identifies the primary product and can optionally refer to the item structure used to define material requirements. This table also holds immutable attributes, or attributes that do not require being version controlled. Version controlled work definition attributes are stored in the work definition versions table.
Details
-
Schema: FUSION
-
Object owner: WIS
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
WIS_WORK_DEFINITIONS_PK |
WORK_DEFINITION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| WORK_DEFINITION_ID | NUMBER | 18 | Yes | The unique identifier of a work definition. 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. | |
| WORK_DEFINITION_TYPE | VARCHAR2 | 30 | Yes | Indicates the type of this work definition. Valid values exist in the lookup with lookup type = ORA_WIS_WORK_DEFINITION_TYPE. | |
| WORK_METHOD_ID | NUMBER | 18 | Yes | Represents the work method for which this work definition is applicable. It is a foreign key to the WIS_WORK_METHODS_B table. | |
| ORGANIZATION_ID | NUMBER | 18 | Yes | The organization identifier that represents the manufacturing plant to which this work definition belongs. | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Represents the top level, final assembly, subassembly, or model item which belongs to the given organization. | ||
| TRANSFORM_FROM_ITEM_ID | NUMBER | 18 | Refers to the assembly item that is being transformed to a new assembly item on a Transform work definition. | ||
| WORK_DEFINITION_NAME_ID | NUMBER | 18 | Yes | Represents the work definition name assigned to this work definition which is a foreign key to the WIS_WORK_DEFINITION_NAMES_B table. | |
| WD_MNT_NAME_ID | NUMBER | 18 | Represents the foreign key to the maintenance work definition names table. | ||
| STATUS_CODE | VARCHAR2 | 30 | Yes | Indicates the status of this work definition. Valid values exist in the lookup with lookup type = ORA_WIS_WD_STATUS. | |
| INACTIVE_DATE | DATE | The date on which this work definition has become inactive. | |||
| WORK_DEFINITION_HEADER_NAME | VARCHAR2 | 120 | Indicates the unique name for the work definition. In the case of process manufacturing, this represents the process name. | ||
| PRODUCTION_PRIORITY | NUMBER | Indicates the relative rank of the work definition compared to other work definitions for the item. The work definition with a priority of '1' for an item is considered the primary work definition. A stacked rank of production priorities indicates alternate capacity to Fusion Planning. | |||
| COSTING_PRIORITY | NUMBER | Costing uses the highest priority work definition to calculate the standard cost using the cost rollup. Upon exploding the BOM the child work definitions are threaded using the priority number chosen at the very top. | |||
| SERIAL_TRACKING_FLAG | VARCHAR2 | 1 | Yes | Flag used to indicate that the end item (i.e. assembly in discrete manufacturing) is tracked by serial numbers during work execution. | |
| BILL_SEQUENCE_ID | NUMBER | 18 | Represents the item structure used to define material requirements. | ||
| QUANTITY | NUMBER | Represents the quantity produced for the work definition. In process manufacturing, this is the batch quantity. | |||
| UOM_CODE | VARCHAR2 | 3 | Represents the unit of measure code of the work definition quantity. | ||
| SYSTEM_GENERATED_FLAG | VARCHAR2 | 1 | Flag used to identify if the work definition was automatically created by the system. Valid values: 'Y' and 'N'. | ||
| WORK_ORDER_TYPE | VARCHAR2 | 30 | The default work order type to be used during work order creation. Valid manufacturing work order types are contained within the ORA_WIE_WO_TYPE lookup. Valid maintenance work order types are contained within the ORA_MNT_WO_TYPE lookup. | ||
| WORK_ORDER_SUB_TYPE | VARCHAR2 | 30 | The default work order subtype to be used during work order creation. Valid manufacturing work order subtypes are contained within the ORA_WIE_WO_SUB_TYPE lookup. Valid maintenance work order subtypes are contained within the ORA_MNT_WO_SUB_TYPE lookup. | ||
| PREASSIGN_LOT_FLAG | VARCHAR2 | 1 | Flag used to indicate that the lots for primary product and outputs can be pre-assigned in the work order. | ||
| RESEQUENCE_FLAG | VARCHAR2 | 1 | Flag used to indicate if the work definition has re-sequence operations. Valid values are Y or N. | ||
| MINIMUM_TRANSFER_QUANTITY | NUMBER | The minimum quantity that must be completed from the prior operation or work order before the next operation or work order is allowed to start. | |||
| 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 |
|---|---|---|
| wis_wd_versions | wis_work_definitions | WORK_DEFINITION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| WIS_WORK_DEFINITIONS_N1 | Non Unique | Default | BILL_SEQUENCE_ID | |
| WIS_WORK_DEFINITIONS_N2 | Non Unique | Default | ORGANIZATION_ID, WORK_METHOD_ID, STATUS_CODE | Obsolete |
| WIS_WORK_DEFINITIONS_N3 | Non Unique | Default | ORGANIZATION_ID, WORK_METHOD_ID, STATUS_CODE, PRODUCTION_PRIORITY | |
| WIS_WORK_DEFINITIONS_N4 | Non Unique | Default | ORGANIZATION_ID, INVENTORY_ITEM_ID, WORK_METHOD_ID, STATUS_CODE, PRODUCTION_PRIORITY | |
| WIS_WORK_DEFINITIONS_N5 | Non Unique | Default | ORGANIZATION_ID, INVENTORY_ITEM_ID, WORK_DEFINITION_NAME_ID, WORK_METHOD_ID, STATUS_CODE, PRODUCTION_PRIORITY | |
| WIS_WORK_DEFINITIONS_N6 | Non Unique | Default | ORGANIZATION_ID, SYSTEM_GENERATED_FLAG | |
| WIS_WORK_DEFINITIONS_U1 | Unique | Default | WORK_DEFINITION_ID | |
| WIS_WORK_DEFINITIONS_U2 | Unique | Default | ORGANIZATION_ID, INVENTORY_ITEM_ID, WORK_DEFINITION_NAME_ID, WD_MNT_NAME_ID |