WIE_WO_EXECUTION_RUNS_
This table stores execution runs created for manufacturing work orders that are split for execution due to capacity constraints. The split can be performed based on either the number of runs, multiples of product quantity or manually. This reference is then carried across all related transactions to ensure traceability.
Details
-
Schema: FUSION
-
Object owner: WIE
-
Object type: TABLE
-
Tablespace: DEFAULT
Primary Key
| Name | Columns |
|---|---|
|
WIE_WO_EXECUTION_RUNS_PK_ |
LAST_UPDATE_DATE, LAST_UPDATED_BY, WO_EXECUTION_RUN_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| WO_EXECUTION_RUN_ID | NUMBER | 18 | Yes | The unique identifier of execution run record. Its value is an application generated unique id. | |
| OBJECT_VERSION_NUMBER | NUMBER | 9 | 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. | ||
| EXECUTION_RUN_NUMBER | NUMBER | A number that uniquely identifies an execution run within a work order. When a work order is split into execution runs, each run is assigned this unique number, which is used to track the materials, resources, and products transacted for that specific run. | |||
| WORK_ORDER_ID | NUMBER | 18 | Represents the internal identifier of the work order. Foreign key to WIE_WORK_ORDERS_B. | ||
| LAST_COMPL_OP_SEQUENCE | NUMBER | This is the operation sequence of the last operation in chronological order where a completion transaction is reported. | |||
| LAST_COMPL_WO_OPERATION_ID | NUMBER | 18 | This is the internal identifier of the last operation in chronological order where a completion transaction is reported. Foreign key to WIE_WO_OPERATIONS_B. | ||
| STATUS_CODE | VARCHAR2 | 30 | A value that indicates the current status of an execution run. The values for this attribute come from lookup ORA_WIE_EXEC_RUN_STATUSES. | ||
| PLANNED_RUN_QUANTITY | NUMBER | The quantity of primary product that is planned to be produced in this execution run. | |||
| PLANNED_BATCH_QUANTITY | NUMBER | The batch quantity that is planned to be executed as part of this execution run. | |||
| UNDER_COMPLETED_FLAG | VARCHAR2 | 1 | Flag to indicate that the execution run is marked as under-completed. | ||
| 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 | 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. | ||
| 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. | ||
| AUDIT_ACTION_TYPE_ | VARCHAR2 | 10 | Action Type - have values like INSERT, UPDATE and DELETE. | ||
| AUDIT_CHANGE_BIT_MAP_ | VARCHAR2 | 1000 | Used to store a bit map of 1s and 0s for each column in the table. | ||
| AUDIT_IMPERSONATOR_ | VARCHAR2 | 64 | Original Impersonator User. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| WIE_WO_EXECUTION_RUNS_N01_ | Non Unique | DEFAULT | WO_EXECUTION_RUN_ID |
| WIE_WO_EXECUTION_RUNS_U01_ | Unique | DEFAULT | LAST_UPDATE_DATE, LAST_UPDATED_BY, WO_EXECUTION_RUN_ID |
| WIE_WO_EXECUTION_RUNS_U02_ | Unique | DEFAULT | LAST_UPDATE_DATE, LAST_UPDATED_BY, WORK_ORDER_ID, EXECUTION_RUN_NUMBER |