eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: INV.MTL_SECONDARY_LOCS_INTERFACE

Object Details

Object Name:	MTL_SECONDARY_LOCS_INTERFACE
Object Type:	TABLE
Owner:	INV
FND Design Data:	INV.MTL_SECONDARY_LOCS_INTERFACE
Subobject Name:
Status:	VALID

MTL_SECONDARY_LOCS_INTERFACE temporarily stores all locators within a
subinventory for a specific item before loading this information into
Oracle Inventory. Each subinventory is allowed one primary locator.
A primary locator is used as a default locator in the transaction
system.
.
This table contains user-friendly columns which allow you to easily
enter your data as well as the corresponding foreign keys. Oracle
Inventory will default column values you do not enter, after
performing the proper validation. For example, if you enter the
ITEM_NUMBER, Oracle Inventory will fill in the corresponding
INVENTORY_ITEM_ID for you.
This table is not currently used.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
INVENTORY_ITEM_ID	NUMBER			Inventory item identifier
ORGANIZATION_ID	NUMBER			Organization identifier
SECONDARY_LOCATOR	NUMBER			Locator name
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
PRIMARY_LOCATOR_FLAG	NUMBER			Primary / secondary type code
PICKING_ORDER	NUMBER			(not currently used)
SUBINVENTORY_CODE	VARCHAR2	(10)		Subinventory name
REQUEST_ID	NUMBER			Concurrent who column
PROGRAM_APPLICATION_ID	NUMBER			Concurrent who column
PROGRAM_ID	NUMBER			Concurrent who column
PROGRAM_UPDATE_DATE	DATE			Concurrent who column
TRANSACTION_ID	NUMBER			Row identifier
PROCESS_FLAG	NUMBER			Row status
ORGANIZATION_CODE	VARCHAR2	(3)		Abbreviation of organization name
ITEM_NUMBER	VARCHAR2	(81)		Concatenated item segments
LOCATION_NAME	VARCHAR2	(81)		Concatenated locator segments
STATUS_ID	NUMBER			Status Identifier - Used by WMS only

Query Text

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


SELECT INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      SECONDARY_LOCATOR
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PRIMARY_LOCATOR_FLAG
,      PICKING_ORDER
,      SUBINVENTORY_CODE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      TRANSACTION_ID
,      PROCESS_FLAG
,      ORGANIZATION_CODE
,      ITEM_NUMBER
,      LOCATION_NAME
,      STATUS_ID
FROM INV.MTL_SECONDARY_LOCS_INTERFACE;

Dependencies

[top of page]

INV.MTL_SECONDARY_LOCS_INTERFACE does not reference any database object

INV.MTL_SECONDARY_LOCS_INTERFACE is referenced by following:

APPS: MTL_SECONDARY_LOCS_INTERFACE