WIS_STANDARD_OPERATIONS_B
This table stores the plant specific standard operation definition. A standard operation is a reusable definition of the process step used in the manufacturing process. This includes all the resource requirements and material requirements to carry out the process step. Examples are: 'etch the company logo' and 'drill a three inch hole'.
Details
-
Schema: FUSION
-
Object owner: WIS
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
WIS_STANDARD_OPERATIONS_B_PK |
STANDARD_OPERATION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| STANDARD_OPERATION_ID | NUMBER | 18 | Yes | The unique identifier of a standard 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. | |
| STANDARD_OPERATION_CODE | VARCHAR2 | 30 | Yes | A code that represents the user key to the standard operation. | |
| OPERATION_TYPE | VARCHAR2 | 30 | Yes | Specifies the type of the operation. Valid values are contained within the ORA_WIS_OPERATION_TYPE lookup. | |
| COUNT_POINT_FLAG | VARCHAR2 | 1 | Yes | 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 | Yes | 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'. | |
| ORGANIZATION_ID | NUMBER | 18 | Yes | The organization identifier that represents the manufacturing plant to which this standard operation belongs. | |
| WORK_CENTER_ID | NUMBER | 18 | Yes | Indicates the work center where this operation is executed. | |
| INACTIVE_DATE | DATE | The date on which this standard operation has become inactive. If no date is specified, the standard operation is considered active. | |||
| USED_IN_AUTO_WD_FLAG | VARCHAR2 | 1 | Indicates that this standard operation is to be used as the default operation when creating an automated work definition. Only one standard operation is allowed to have this column set to a 'Y'. 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. | |||
| 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. | ||
| REASON_FOR_REPAIR_CODE_ID | NUMBER | 18 | Represents the primary reason for which this operation is performed. Foreign key to cse_condition_event_codes_b table. | ||
| REPAIR_TXN_CODE_ID | NUMBER | 18 | Represents the default codified transaction for which the material and resource consumed in the operation should be associated to. Foreign key to cse_condition_event_codes_b table. | ||
| WORK_ACCOMPLISHED_CODE_ID | NUMBER | 18 | Represents the default accomplishment code to record when the operation is completed. Foreign key to cse_condition_event_codes_b table. | ||
| 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_standard_operations_tl | wis_standard_operations_b | STANDARD_OPERATION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| WIS_STANDARD_OPERATIONS_B_N1 | Non Unique | Default | WORK_CENTER_ID |
| WIS_STANDARD_OPERATIONS_B_U1 | Unique | Default | STANDARD_OPERATION_ID |
| WIS_STANDARD_OPERATIONS_B_U2 | Unique | Default | ORGANIZATION_ID, STANDARD_OPERATION_CODE |