[Home] [Help] [Dependency Information]
Object Name: | MTL_PICK_SLIP_NUMBERS |
---|---|
Object Type: | TABLE |
Owner: | INV |
FND Design Data: | INV.MTL_PICK_SLIP_NUMBERS |
Subobject Name: | |
Status: | VALID |
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.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MTL_PICK_SLIP_NUMBERS_U1 | NORMAL | UNIQUE | APPS_TS_INTERFACE |
PICK_SLIP_IDENTIFIER
STATUS |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | Unique identifier | |
PICK_SLIP_BATCH_ID | NUMBER | Pick slip batch identifier | ||
PICK_SLIP_COUNT | NUMBER | Number of lines in pick slip | ||
PICK_SLIP_IDENTIFIER | VARCHAR2 | (2000) | Concatenation of grouping criteria | |
PICK_SLIP_NUMBER | NUMBER | Pick Slip Number | ||
STATUS | VARCHAR2 | (10) | Status of pick slip |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, PICK_SLIP_BATCH_ID
, PICK_SLIP_COUNT
, PICK_SLIP_IDENTIFIER
, PICK_SLIP_NUMBER
, STATUS
FROM INV.MTL_PICK_SLIP_NUMBERS;
INV.MTL_PICK_SLIP_NUMBERS does not reference any database object
INV.MTL_PICK_SLIP_NUMBERS is referenced by following:
|
|
|