[Home] [Help] [Dependency Information]

TABLE: INV.MTL_PICK_SLIP_NUMBERS

Object Details

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.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MTL_PICK_SLIP_NUMBERS_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	PICK_SLIP_IDENTIFIER STATUS

Columns

Query Text

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;

Dependencies

[top of page]

INV.MTL_PICK_SLIP_NUMBERS does not reference any database object

INV.MTL_PICK_SLIP_NUMBERS is referenced by following:

APPS

MTL_PICK_SLIP_NUMBERS