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


TABLE: INV.MTL_ITEM_LOCATIONS

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


MTL_ITEM_LOCATIONS is the definition table for stock locators. The
associated attributes describe which subinventory this locator belongs
to, what the locator physical capacity is, etc.
.
The locator is a key flexfield. The Flexfield Code is MTLL.
.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MTL_ITEM_LOCATIONS_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnINVENTORY_LOCATION_ID
ColumnORGANIZATION_ID
MTL_ITEM_LOCATIONS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnSEGMENT1
ColumnORGANIZATION_ID
MTL_ITEM_LOCATIONS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnSEGMENT2
ColumnORGANIZATION_ID
MTL_ITEM_LOCATIONS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnSEGMENT3
ColumnORGANIZATION_ID
MTL_ITEM_LOCATIONS_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnORGANIZATION_ID
ColumnSUBINVENTORY_CODE
MTL_ITEM_LOCATIONS_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnLOCATION_CURRENT_UNITS
ColumnORGANIZATION_ID
ColumnSUBINVENTORY_CODE
MTL_ITEM_LOCATIONS_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnEMPTY_FLAG
MTL_ITEM_LOCATIONS_N7 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnMIXED_ITEMS_FLAG
MTL_ITEM_LOCATIONS_N8 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnPROJECT_ID
MTL_ITEM_LOCATIONS_N9 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnSTATUS_ID
Columns
Name Datatype Length Mandatory Comments
INVENTORY_LOCATION_ID NUMBER
Yes Inventory locator identifier
ORGANIZATION_ID NUMBER
Yes Organization identifier
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER

Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
DESCRIPTION VARCHAR2 (50)
Locator description
DESCRIPTIVE_TEXT VARCHAR2 (240)
Locator descriptive text
DISABLE_DATE DATE

Disable date
INVENTORY_LOCATION_TYPE NUMBER

(no longer used)
PICKING_ORDER NUMBER

Picking order
PHYSICAL_LOCATION_CODE VARCHAR2 (10)
(no longer used)
LOCATION_MAXIMUM_UNITS NUMBER

Locator maximum unit
SUBINVENTORY_CODE VARCHAR2 (10)
Subinventory name
LOCATION_WEIGHT_UOM_CODE VARCHAR2 (3)
Locator weight UOM code
MAX_WEIGHT NUMBER

Locator maximum weight
VOLUME_UOM_CODE VARCHAR2 (3)
Locator volume UOM code
MAX_CUBIC_AREA NUMBER

Locator maximum cubic area
X_COORDINATE NUMBER

(no longer used)
Y_COORDINATE NUMBER

(no longer used)
Z_COORDINATE NUMBER

(no longer used)
INVENTORY_ACCOUNT_ID NUMBER

(not currently used)
SEGMENT1 VARCHAR2 (40)
Key flexfield segment
SEGMENT2 VARCHAR2 (40)
Key flexfield segment
SEGMENT3 VARCHAR2 (40)
Key flexfield segment
SEGMENT4 VARCHAR2 (40)
Key flexfield segment
SEGMENT5 VARCHAR2 (40)
Key flexfield segment
SEGMENT6 VARCHAR2 (40)
Key flexfield segment
SEGMENT7 VARCHAR2 (40)
Key flexfield segment
SEGMENT8 VARCHAR2 (40)
Key flexfield segment
SEGMENT9 VARCHAR2 (40)
Key flexfield segment
SEGMENT10 VARCHAR2 (40)
Key flexfield segment
SEGMENT11 VARCHAR2 (40)
Key flexfield segment
SEGMENT12 VARCHAR2 (40)
Key flexfield segment
SEGMENT13 VARCHAR2 (40)
Key flexfield segment
SEGMENT14 VARCHAR2 (40)
Key flexfield segment
SEGMENT15 VARCHAR2 (40)
Key flexfield segment
SEGMENT16 VARCHAR2 (40)
Key flexfield segment
SEGMENT17 VARCHAR2 (40)
Key flexfield segment
SEGMENT18 VARCHAR2 (40)
Key flexfield segment
SEGMENT19 VARCHAR2 (40)
Key flexfield segment
SEGMENT20 VARCHAR2 (40)
Key flexfield segment
SUMMARY_FLAG VARCHAR2 (1) Yes Flag indicating whether segment combination includes a summary segment
ENABLED_FLAG VARCHAR2 (1) Yes Flag indicating whether segment combination is enabled
START_DATE_ACTIVE DATE

Date segment combination becomes active
END_DATE_ACTIVE DATE

Date segment combination becomes inactive
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
REQUEST_ID NUMBER

Standard Who column
PROGRAM_APPLICATION_ID NUMBER

Standard Who column
PROGRAM_ID NUMBER

Standard Who column
PROGRAM_UPDATE_DATE DATE

Standard Who column
PROJECT_ID NUMBER (15)
Project identifier
TASK_ID NUMBER (15)
Task identifier
PHYSICAL_LOCATION_ID NUMBER (15)
Physical location identifier
PICK_UOM_CODE VARCHAR2 (3)
Unit of measure in which items are stored in locator
DIMENSION_UOM_CODE VARCHAR2 (3)
Unit of measure of physical dimensions - length, width and height
LENGTH NUMBER

Length
WIDTH NUMBER

Width
HEIGHT NUMBER

Height
LOCATOR_STATUS NUMBER

Locator Status
STATUS_ID NUMBER

Status Identifier - Used by WMS only
CURRENT_CUBIC_AREA NUMBER

Current volume of item(s) in locator
AVAILABLE_CUBIC_AREA NUMBER

Remaining volume capacity in locator
CURRENT_WEIGHT NUMBER

Current weight of item(s) in locator
AVAILABLE_WEIGHT NUMBER

Remaining weight capacity in locator
LOCATION_CURRENT_UNITS NUMBER

Current number of units (items) in locator
LOCATION_AVAILABLE_UNITS NUMBER

Remaining unit capacity in locator
INVENTORY_ITEM_ID NUMBER

If not null, the only item that can be in locator
SUGGESTED_CUBIC_AREA NUMBER

Suggested volume to be put into locator
SUGGESTED_WEIGHT NUMBER

Suggested weight to be put into locator
LOCATION_SUGGESTED_UNITS NUMBER

Suggested units to be put into locator
EMPTY_FLAG VARCHAR2 (1)
Set to Y if the locator has no material; N if material resides in locator
MIXED_ITEMS_FLAG VARCHAR2 (1)
Y if multiple items reside in the locator; N if locator is empty or contains a single item
DROPPING_ORDER NUMBER

Dropping order used to sequence a drop operation
AVAILABILITY_TYPE NUMBER

Subinventory availability code
INVENTORY_ATP_CODE NUMBER

Inventory available to promise code
RESERVABLE_TYPE NUMBER

Hard reservation eligibility
ALIAS VARCHAR2 (30)
Short Alias for the Locator name
Query Text

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


SELECT INVENTORY_LOCATION_ID
,      ORGANIZATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      DESCRIPTION
,      DESCRIPTIVE_TEXT
,      DISABLE_DATE
,      INVENTORY_LOCATION_TYPE
,      PICKING_ORDER
,      PHYSICAL_LOCATION_CODE
,      LOCATION_MAXIMUM_UNITS
,      SUBINVENTORY_CODE
,      LOCATION_WEIGHT_UOM_CODE
,      MAX_WEIGHT
,      VOLUME_UOM_CODE
,      MAX_CUBIC_AREA
,      X_COORDINATE
,      Y_COORDINATE
,      Z_COORDINATE
,      INVENTORY_ACCOUNT_ID
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SEGMENT16
,      SEGMENT17
,      SEGMENT18
,      SEGMENT19
,      SEGMENT20
,      SUMMARY_FLAG
,      ENABLED_FLAG
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PROJECT_ID
,      TASK_ID
,      PHYSICAL_LOCATION_ID
,      PICK_UOM_CODE
,      DIMENSION_UOM_CODE
,      LENGTH
,      WIDTH
,      HEIGHT
,      LOCATOR_STATUS
,      STATUS_ID
,      CURRENT_CUBIC_AREA
,      AVAILABLE_CUBIC_AREA
,      CURRENT_WEIGHT
,      AVAILABLE_WEIGHT
,      LOCATION_CURRENT_UNITS
,      LOCATION_AVAILABLE_UNITS
,      INVENTORY_ITEM_ID
,      SUGGESTED_CUBIC_AREA
,      SUGGESTED_WEIGHT
,      LOCATION_SUGGESTED_UNITS
,      EMPTY_FLAG
,      MIXED_ITEMS_FLAG
,      DROPPING_ORDER
,      AVAILABILITY_TYPE
,      INVENTORY_ATP_CODE
,      RESERVABLE_TYPE
,      ALIAS
FROM INV.MTL_ITEM_LOCATIONS;

Dependencies

[top of page]

INV.MTL_ITEM_LOCATIONS does not reference any database object

INV.MTL_ITEM_LOCATIONS is referenced by following:

SchemaINV
ViewMTL_ITEM_LOCATIONS#