INV_PICK_SLIP_NUMBERS
Parallel pick release uses this table to store pick slip numbers. Pick slip number generation is based on grouping criteria specified in the pick slip grouping rule specified at the time of pick release. Every time a line is allocated with the same criteria as a previously allocated line, the same pick slip number is to be assigned. When pick release is run as a single process, pick slip number assignment is accomplished by caching pick slip numbers and the corresponding grouping criteria in memory. When multiple concurrent pick release processes run in parallel, this approach will not work since these processes do not have visibility of each others cached data structures. Hence a database table is needed to store pick slip numbers and the grouping criteria. Data in this table is deleted at the end of the pick release run.
Details
-
Schema: FUSION
-
Object owner: INV
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
INV_PICK_SLIP_NUMBERS_PK |
PICK_SLIP_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PICK_SLIP_ID | NUMBER | 18 | Yes | This is the primary key for the pick slip. | |
| PICK_SLIP_BATCH_ID | NUMBER | 18 | This identifies the pick slip batch. | ||
| PICK_SLIP_COUNT | NUMBER | 18 | Number of lines in this pick slip. | ||
| PICK_SLIP_IDENTIFIER | VARCHAR2 | 2000 | Concatenation of grouping criteria | ||
| PICK_SLIP_NUMBER | NUMBER | 18 | This column is the pick slip number. | ||
| STATUS | VARCHAR2 | 10 | This is the status of pick slip. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| 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. | |
| PICK_SLIP_DUE_DATE | DATE | This is the due date for pick slip. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| INV_PICK_SLIP_NUMBERS_N1 | Non Unique | Default | PICK_SLIP_DUE_DATE |
| INV_PICK_SLIP_NUMBERS_U1 | Unique | FUSION_TS_TX_IDX | PICK_SLIP_IDENTIFIER, STATUS |
| INV_PICK_SLIP_NUMBERS_U2 | Unique | FUSION_TS_TX_IDX | PICK_SLIP_NUMBER |
| INV_PICK_SLIP_NUMBERS_U3 | Unique | Default | PICK_SLIP_ID |