WIE_WO_PICK_REQUESTS
This table is used to store the work orders that need to be picked as part of the component picking process. This will be used to record the list of work orders both from the ESS job, as well as, the work order and material availability pages.
Details
-
Schema: FUSION
-
Object owner: WIE
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
WIE_WO_PICK_REQUESTS_PK |
WO_PICK_REQUEST_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| WO_PICK_REQUEST_ID | NUMBER | 18 | Yes | The unique identifier of the work order pick request 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. | |
| GROUP_ID | NUMBER | 18 | Yes | This field is used as a logical identifier to group multiple records that are part of the same request. This is used to segregate requests coming from multiple users. | |
| STATUS_CODE | VARCHAR2 | 30 | Yes | Represents the progress of the pick release process 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. | |
| WORK_ORDER_ID | NUMBER | 18 | Yes | Represents the internal identifier of the work order. Pick release is always performed in the context of a work order. | |
| PICK_SET_FLAG | VARCHAR2 | 1 | Yes | Flag used to indicate if all of the components selected for picking on this work order must be available in inventory to perform the pick release processing. Valid values are 'Y' and 'N'. | |
| WORK_ORDER_QUANTITY | NUMBER | This column is an internal field used to store the work order quantity that is used as part of pick processing. | |||
| PICK_PRIORITY | NUMBER | The priority in which the work orders should be processed for pick release. | |||
| PARTITION_NUMBER | NUMBER | The partition number for multi-threading. | |||
| 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. | ||
| 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 |
|---|---|---|---|
| WIE_WO_PICK_REQUESTS_N01 | Non Unique | Default | GROUP_ID, STATUS_CODE |
| WIE_WO_PICK_REQUESTS_N02 | Non Unique | Default | PARTITION_NUMBER, STATUS_CODE |
| WIE_WO_PICK_REQUESTS_N03 | Non Unique | Default | REQUEST_ID, WORK_ORDER_ID |
| WIE_WO_PICK_REQUESTS_U01 | Unique | Default | WO_PICK_REQUEST_ID |
| WIE_WO_PICK_REQUESTS_U02 | Unique | Default | GROUP_ID, WORK_ORDER_ID |