DBA Data[Home] [Help] [Dependency Information]

TABLE: INV.MTL_INV_PICKING_RULES

Object Details
Object Name: MTL_INV_PICKING_RULES
Object Type: TABLE
Owner: INV
FND Design Data: TableINV.MTL_INV_PICKING_RULES
Subobject Name:
Status: VALID


This tables stores Inventory Picking Rule definition.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MTL_INV_PICKING_RULES_PK NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnINV_RULE_ID
MTL_INV_PICKING_RULES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnWMS_RULE_ID
Columns
Name Datatype Length Mandatory Comments
INV_RULE_ID NUMBER (15) Yes Unique identifier for the rule
SHELF_DAYS NUMBER (15)
Minimum shelf days
SINGLE_LOT VARCHAR2 (1)
Y-single lot required, N- allow multiple lots to be allocated
PARTIAL_ALLOWED_FLAG VARCHAR2 (1)
Y-partial allocation is allowed. N-partial allocation is NOT allowed
CUST_SPEC_MATCH_FLAG VARCHAR2 (1)
Y-Customer spec match required. N - customer spec match NOT required
LOT_SORT NUMBER (1)
0 - NONE, no sort; 1 - Lot number Asc; 2 - Lot number Desc; 3 - FIFO , first in first out; 4 - FEFO, first expire first out
LOT_SORT_RANK NUMBER (1)
Order by rank regarding to other sort criteria, saved as wms_sort_criteria.sequence_number
REVISION_SORT NUMBER (1)
0 - NONE; 1 - Revision Asc; 2 - Revision Desc; 3 - Effective date Asc; 4 - Effective date Desc
REVISION_SORT_RANK NUMBER (1)
Order by rank regarding to other sort criteria, saved as wms_sort_criteria.sequence_number
SUBINVENTORY_SORT NUMBER (1)
0 - NONE; 1 - Subinventory Asc; 2 - Subinventory Desc; 3 - Receipt date Asc; 4 - Receipt date Desc
SUBINVENTORY_SORT_RANK NUMBER (1)
Order by rank regarding to other sort criteria, saved as wms_sort_criteria.sequence_number
LOCATOR_SORT NUMBER (1)
0 - NONE; 1 - Locator Asc; 2 - Locator Desc; 3 - Receipt date Asc; 4 - Receipt date Desc
LOCATOR_SORT_RANK NUMBER (1)
Order by rank regarding to other sort criteria, saved as wms_sort_criteria.sequence_number
WMS_RULE_ID NUMBER (15) Yes Wms rule id, FK to wms_rules_b.rule_id table
WMS_STRATEGY_ID NUMBER (15)
WMS strategy id, FK to wms_strategy_b.strategy_id
APPLY_TO_SOURCE NUMBER

Rule will be applied to: 1-Sales order, 2-GME process execution, 3 - WIP, null - Move order
CREATION_DATE DATE
Yes Standard who column
CREATED_BY NUMBER
Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER
Yes Standard who column
LAST_UPDATE_LOGIN NUMBER

Standard who column
PROGRAM_APPLICATION_ID NUMBER (15)
Strandard column
PROGRAM_ID NUMBER (15)
Strandard column
PROGRAM_UPDATE_ID NUMBER (15)
Strandard column
REQUEST_ID NUMBER (15)
Strandard column
ATTRIBUTE1 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE16 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE17 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE18 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE19 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE20 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE21 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE22 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE23 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE24 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE25 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE26 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE27 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE28 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE29 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE30 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT INV_RULE_ID
,      SHELF_DAYS
,      SINGLE_LOT
,      PARTIAL_ALLOWED_FLAG
,      CUST_SPEC_MATCH_FLAG
,      LOT_SORT
,      LOT_SORT_RANK
,      REVISION_SORT
,      REVISION_SORT_RANK
,      SUBINVENTORY_SORT
,      SUBINVENTORY_SORT_RANK
,      LOCATOR_SORT
,      LOCATOR_SORT_RANK
,      WMS_RULE_ID
,      WMS_STRATEGY_ID
,      APPLY_TO_SOURCE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_ID
,      REQUEST_ID
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      ATTRIBUTE_CATEGORY
FROM INV.MTL_INV_PICKING_RULES;

Dependencies

[top of page]

INV.MTL_INV_PICKING_RULES does not reference any database object

INV.MTL_INV_PICKING_RULES is referenced by following:

SchemaINV
ViewMTL_INV_PICKING_RULES#