WIE_MATERIAL_DISPENSE_TASKS
This table stores snapshot of instruction tasks completed as part of dispensing. This data will be used to show task details against completed dispense transactions in UI and reports.
Details
-
Schema: FUSION
-
Object owner: WIE
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
WIE_MATERIAL_DISPENSE_TASKS_PK |
MATERIAL_DISPENSE_TASK_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| MATERIAL_DISPENSE_TASK_ID | NUMBER | 18 | Yes | The unique identifier of a material dispensing instruction task. Its value is an application generated unique id. | |
| MATERIAL_DISPENSE_ID | NUMBER | 18 | Yes | Identifier of the material dispensing transaction for which the instruction task is performed. | |
| TASK_ID | NUMBER | 18 | Identifies the instruction task detail for the dispense instruction. This is a foreign key to PER_TASKS_IN_CHECKLIST_B. | ||
| TASK_NAME | VARCHAR2 | 240 | Name of the specific task performed as part of dispense instructions. | ||
| TASK_TYPE | VARCHAR2 | 30 | Task type defined in the dispense instruction template for the task. Valid values exist in lookup with lookup type = ORA_PER_CHK_TASK_ACTION_TYPE. | ||
| MANDATORY_FLAG | VARCHAR2 | 30 | Yes | Indicates if the task is optional or mandatory. | |
| TASK_SEQUENCE | NUMBER | 9 | Sequence in which the tasks are expected to be completed as part of dispense instructions. | ||
| STATUS | VARCHAR2 | 60 | Indicates the status of the task. Valid values exist in lookup with lookup type = PER_CHECKLIST_TASK_STATUS. | ||
| TASK_COMMENTS | VARCHAR2 | 4000 | Comments entered by the user while completing the specific task. | ||
| TASK_START_TIME | TIMESTAMP | Time at which the task was started. | |||
| TASK_END_TIME | TIMESTAMP | Time at which the task was completed. | |||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| WIE_MTRL_DISPENSE_TASKS_U01 | Unique | Default | MATERIAL_DISPENSE_TASK_ID |