WIS_WD_OPERATIONS_B
This table is used to define the list of sequenced operations that are necessary to manufacture the specified product.
Details
-
Schema: FUSION
-
Object owner: WIS
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
WIS_WD_OPERATIONS_B_PK |
WD_OPERATION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| WD_OPERATION_ID | NUMBER | 18 | Yes | The unique identifier of a work definition operation. 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_ID | NUMBER | 18 | Yes | Represents the work definition identifier that is the foreign key to the WIS_WORK_DEFINITIONS table. | |
| OPERATION_TYPE | VARCHAR2 | 30 | Yes | Specifies the type of the operation. Valid values are contained within the ORA_WIS_OPERATION_TYPE lookup. | |
| OPERATION_SEQ_NUMBER | NUMBER | Yes | Indicates the execution sequence of the operation. | ||
| WORK_CENTER_ID | NUMBER | 18 | Indicates the work center where this operation is executed. | ||
| EFFECTIVE_FROM_DATE | TIMESTAMP | Yes | Indicates the date from which this operation is effective. | ||
| EFFECTIVE_TO_DATE | TIMESTAMP | Indicates the date from which this operation is no longer effective. | |||
| COUNT_POINT_FLAG | VARCHAR2 | 1 | Flag used to indicate if this is a count point operation. If an operation is a count point operation, then you have to manually complete it. Any operations in between the count points are automatically completed (i.e. backflushed, etc.). | ||
| AUTO_TRANSACT_FLAG | VARCHAR2 | 1 | Indicates whether both resources and materials are automatically charged based on the supply type or the charge type setups for the operation. If the supply type is Operation Pull, the component level issue transactions will happen when the operation is completed. If the supply type is Assembly Pull, the component level issue transactions will happen at the assembly completion event. Resource transactions are automatically done when the quantity is moved outside the operation. Valid values are 'Y' and 'N'. | ||
| SERIAL_TRACKING_FLAG | VARCHAR2 | 1 | Yes | Flag used to indicate that the product is tracked by serial number while executing this operation. | |
| APPLICABILITY_RULE_ID | NUMBER | 18 | Flag used to indicate whether the operation is dependent on the choice of one or multiple optional components. This applies to an ATO Model work definition only. | ||
| OPTION_DEPENDENT_FLAG | VARCHAR2 | 1 | Indicates whether the operation is dependent on the choice of one or multiple optional components. This applies to an ATO Model work definition only. | ||
| PLANNING_PERCENT | NUMBER | Percentage used by planning for resources forecast explosion. This applies to an ATO Model work definition only. | |||
| REFERENCED_FLAG | VARCHAR2 | 1 | Yes | Flag used to indicate whether this operation references a standard operation. | |
| STANDARD_OPERATION_ID | NUMBER | 18 | Represents the standard operation identifier that is the foreign key to the WIS_STANDARD_OPERATIONS_B table. | ||
| SHIPPING_DOCUMENTS_FLAG | VARCHAR2 | 1 | Flag used to determine whether shipping documents need to be generated for a supplier operation. Valid Values: 'Y' and 'N'. | ||
| OSP_ITEM_ID | NUMBER | 18 | Item that represents the value added service in a supplier operation. This is also commonly known as a partially finished assembly. | ||
| SUPPLIER_ID | NUMBER | 18 | Represents the identifier of the suggested supplier for a supplier operation. | ||
| SUPPLIER_SITE_ID | NUMBER | 18 | Represents the identifier of the suggested supplier site for a supplier operation. | ||
| LEAD_TIME_UOM | VARCHAR2 | 3 | Represents the unit of measure for the fixed and/or variable lead time values on the supplier operation. | ||
| FIXED_LEAD_TIME | NUMBER | Represents the fixed lead time used to calculate the operation's start and end date for the supplier operation. | |||
| VARIABLE_LEAD_TIME | NUMBER | Represents the variable lead time used to calculate the operation's start and end date based on the operation quantity for the supplier operation. | |||
| LEAD_TIME_PERCENT | NUMBER | Represents the offset percent used in lead time roll up to calculate the cumulative lead times. | |||
| ACTION_STATUS_CODE | VARCHAR2 | 30 | A code used to represent the last action performed on the work definition operation which caused it to trigger the approvals workflow. Valid values are CREATE and DELETE. An empty/null value indicates this record has been reviewed and approved. | ||
| ADDL_MTL_AT_MANUAL_ISSUE | VARCHAR2 | 30 | Indicates whether or not this operation allows additional materials to be added at manual issue. Valid values exist in the lookup with lookup type = ORA_WIS_ADDL_MANUAL_ISSUE_OPTS. | ||
| OP_COMPL_WITH_UNDER_ISSUE | VARCHAR2 | 30 | Indicates whether or not to allow operation completions with under issued material. Valid values exist in the lookup with lookup type = ORA_WIS_OP_COMPLETION_VAL_OPTS. | ||
| OP_COMPL_WITH_OPEN_EXCEPTIONS | VARCHAR2 | 30 | Indicates whether or not to allow operation completions with open exceptions. Valid values exist in the lookup with lookup type = ORA_WIS_OP_COMPLETION_VAL_OPTS. | ||
| RESEQUENCE_FLAG | VARCHAR2 | 1 | Flag used to indicate if the operation can be re-sequenced while executing the operation. Valid values are Y or N. | ||
| 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_operation_outputs | wis_wd_operations_b | WD_OPERATION_ID |
| wis_wd_operation_resources | wis_wd_operations_b | WD_OPERATION_ID |
| wis_wd_operation_materials | wis_wd_operations_b | WD_OPERATION_ID |
| wis_wd_operations_tl | wis_wd_operations_b | WD_OPERATION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| WIS_WD_OPERATIONS_B_N1 | Non Unique | Default | WORK_DEFINITION_ID | Obsolete |
| WIS_WD_OPERATIONS_B_N2 | Non Unique | Default | WORK_CENTER_ID | |
| WIS_WD_OPERATIONS_B_N3 | Non Unique | Default | STANDARD_OPERATION_ID | |
| WIS_WD_OPERATIONS_B_N4 | Non Unique | Default | WORK_DEFINITION_ID, EFFECTIVE_FROM_DATE, EFFECTIVE_TO_DATE | |
| WIS_WD_OPERATIONS_B_U1 | Unique | Default | WD_OPERATION_ID |