WIS_WORK_DEFINITIONS_INT
This is the interface table for the work definition header.
Details
-
Schema: FUSION
-
Object owner: WIS
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
WIS_WORK_DEFINITIONS_INT_PK |
INTERFACE_ROW_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| INTERFACE_ROW_ID | NUMBER | 18 | Yes | The unique identifier of a work definition interface 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. | |
| INTERFACE_BATCH_CODE | VARCHAR2 | 30 | Yes | Represents the user identified code for the interface batch. | |
| INTERFACE_BATCH_ID | NUMBER | 18 | Represents the internal interface batch identifier. This is used to group a batch of interface records for processing. When interface records are brought in via services or the UI, the system will internally generate this value. | ||
| INTERFACE_STATUS_CODE | VARCHAR2 | 30 | Yes | Represents the progress of the interface processing with statuses such as ready for processing or currently in process as well as the various flavors of completion statuses. Valid values exist in the lookup with lookup type = ORA_WIE_INTERFACE_STATUS. | |
| HEADER_NUMBER | VARCHAR2 | 18 | Yes | This attribute allows the user to connect the header records with the details in the various work definition interface details tables. | |
| ACTION_CODE | VARCHAR2 | 30 | Yes | A code used to indicate if the system should create or update this entity. Valid values exist in the lookup with lookup type = ORA_WIS_WD_IMP_HEADER_ACTION. | |
| ORGANIZATION_CODE | VARCHAR2 | 30 | The organization identifier code that represents the manufacturing plant to which this work definition belongs. | ||
| ORGANIZATION_ID | NUMBER | 18 | The organization identifier that represents the manufacturing plant to which this work definition belongs. | ||
| WORK_DEFINITION_ID | NUMBER | 18 | The unique identifier of a work definition. Its value is an application generated unique id. | ||
| WORK_DEFINITION_TYPE | VARCHAR2 | 30 | Indicates the type of this work definition. Valid values exist in the lookup with lookup type = ORA_WIS_WORK_DEFINITION_TYPE. | ||
| WORK_DEFINITION_CODE | VARCHAR2 | 30 | Indicates the user defined work definition code. | ||
| WORK_DEFINITION_NAME_ID | NUMBER | 18 | The unique identifier of a work definition name. Its value is an application generated unique id. | ||
| STATUS_CODE | VARCHAR2 | 30 | 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 | Flag used to indicate that the end item (i.e. assembly in discrete manufacturing) is tracked by serial numbers during work execution. | ||
| WORK_METHOD_CODE | VARCHAR2 | 30 | A code that represents the user key to the work method. | ||
| WORK_METHOD_ID | NUMBER | 18 | Represents the work method for which this work definition is applicable. It is a foreign key to the WIS_WORK_METHODS_B table. | ||
| INVENTORY_ITEM_NUMBER | VARCHAR2 | 300 | Represents the user key to the top level, final assembly, subassembly, or model item which belongs to the given organization. | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Represents the top level, final assembly, subassembly, or model item which belongs to the given organization. | ||
| IS_ATO_FLAG | VARCHAR2 | 1 | Flag used to indicate if the item represents an ATO model. | ||
| STRUCTURE_NAME | VARCHAR2 | 80 | Unique name given to a specific variation of an item structure type. | ||
| 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. | ||
| TRANSFORM_FROM_ITEM_NUMBER | VARCHAR2 | 300 | Refers to the assembly item number that is being transformed to a new assembly item on a Transform work definition. | ||
| 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. | ||
| MAINTENANCE_WD_CODE | VARCHAR2 | 30 | Indicates the user defined maintenance work definition code. | ||
| MAINTENANCE_WD_NAME | VARCHAR2 | 120 | Indicates the name of the maintenance work definition. | ||
| MAINTENANCE_WD_DESC | VARCHAR2 | 240 | Indicates the description of the maintenance work definition name. | ||
| WD_MNT_NAME_ID | NUMBER | 18 | Represents the foreign key to the maintenance work definition names table. | ||
| WORK_DEFINITION_VERSION_ID | NUMBER | 18 | The unique identifier of a work definition version. Its value is an application generated unique id. | ||
| VERSION_NUMBER | VARCHAR2 | 10 | Indicates the version of the work definition. | ||
| EFFECTIVE_FROM_DATE | TIMESTAMP | Date from which this work definition version is effective. | |||
| EFFECTIVE_TO_DATE | TIMESTAMP | Date from which this work definition version is no longer effective. | |||
| COSTING_BATCH_OUTPUT_SIZE | NUMBER | The costing item attribute for costing output batch size (i.e. 10 units) is maintained on the item master. It is then defaulted as shown in the work definition header where it can be edited. Maintaining the costing output batch size in the work definition allows for changes from year to year, whereas, the value in the item master is static. This costing attribute is used for cost planning and simulation purposes. | |||
| COMPLETION_SUBINVENTORY_NAME | VARCHAR2 | 10 | Indicates the default subinventory where the primary product is yielded. | ||
| COMPLETION_LOCATOR_ID | NUMBER | 18 | Indicates the default locator where the primary product is yielded. | ||
| COMPL_LOCATOR_SEGMENT1 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
| COMPL_LOCATOR_SEGMENT2 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
| COMPL_LOCATOR_SEGMENT3 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
| COMPL_LOCATOR_SEGMENT4 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
| COMPL_LOCATOR_SEGMENT5 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
| COMPL_LOCATOR_SEGMENT6 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
| COMPL_LOCATOR_SEGMENT7 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
| COMPL_LOCATOR_SEGMENT8 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
| COMPL_LOCATOR_SEGMENT9 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
| COMPL_LOCATOR_SEGMENT10 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
| COMPL_LOCATOR_SEGMENT11 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
| COMPL_LOCATOR_SEGMENT12 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
| COMPL_LOCATOR_SEGMENT13 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
| COMPL_LOCATOR_SEGMENT14 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
| COMPL_LOCATOR_SEGMENT15 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
| COMPL_LOCATOR_SEGMENT16 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
| COMPL_LOCATOR_SEGMENT17 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
| COMPL_LOCATOR_SEGMENT18 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
| COMPL_LOCATOR_SEGMENT19 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
| COMPL_LOCATOR_SEGMENT20 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
| 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. | ||
| 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. | |||
| WORKER_ID | NUMBER | The partition number for multi-threading. | |||
| CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Who column: indicates the user who last updated the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | 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. | |||
| LOAD_REQUEST_ID | NUMBER | 18 | This column is used when loading data from the csv file to the interface table using the central ESS program. This is the request id for the job that did the move from UCM to the interface table. | ||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| WIS_WORK_DEFINITIONS_INT_N01 | Non Unique | Default | INTERFACE_BATCH_ID, INTERFACE_STATUS_CODE, ACTION_CODE |
| WIS_WORK_DEFINITIONS_INT_N02 | Non Unique | Default | WORKER_ID, INTERFACE_STATUS_CODE, ACTION_CODE |
| WIS_WORK_DEFINITIONS_INT_N03 | Non Unique | Default | REQUEST_ID, INTERFACE_STATUS_CODE |
| WIS_WORK_DEFINITIONS_INT_N04 | Non Unique | Default | LAST_UPDATE_DATE, INTERFACE_STATUS_CODE |
| WIS_WORK_DEFINITIONS_INT_U01 | Unique | Default | INTERFACE_ROW_ID |
| WIS_WORK_DEFINITIONS_INT_U02 | Unique | Default | INTERFACE_BATCH_CODE, HEADER_NUMBER |