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_DESC_ELEM_VAL_INTERFACE

Object Details

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

MTL_DESC_ELEM_VAL_INTERFACE temporarily stores descriptive element
values for an item that is associated with an item catalog group
before loading this information into Oracle Inventory. 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 an ITEM_NUMBER,
Oracle Inventory will fill in the corresponding INVENTORY_ITEM_ID for
you.
This table is not used currently.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MTL_DESC_ELEM_VAL_INTERFACE_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	SET_PROCESS_ID

Columns

Name	Datatype	Length	Mandatory	Comments
INVENTORY_ITEM_ID	NUMBER			Inventory item identifier
ELEMENT_NAME	VARCHAR2	(30)		Descriptive element name
LAST_UPDATE_DATE	DATE			Standard Who column
LAST_UPDATED_BY	NUMBER			Standard Who column
CREATION_DATE	DATE			Standard Who column
CREATED_BY	NUMBER			Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
ELEMENT_VALUE	VARCHAR2	(30)		Descriptive element value
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
DEFAULT_ELEMENT_FLAG	VARCHAR2	(1)		Flag indicating whether element is included in default item description
ELEMENT_SEQUENCE	NUMBER			Element sequence number
TRANSACTION_ID	NUMBER			Row identifier
PROCESS_FLAG	NUMBER			Row status
ITEM_NUMBER	VARCHAR2	(81)		Concatenated item segments
SET_PROCESS_ID	NUMBER		Yes	Any numeric value, used to group records to be imported

Query Text

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


SELECT INVENTORY_ITEM_ID
,      ELEMENT_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ELEMENT_VALUE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      DEFAULT_ELEMENT_FLAG
,      ELEMENT_SEQUENCE
,      TRANSACTION_ID
,      PROCESS_FLAG
,      ITEM_NUMBER
,      SET_PROCESS_ID
FROM INV.MTL_DESC_ELEM_VAL_INTERFACE;

Dependencies

[top of page]

INV.MTL_DESC_ELEM_VAL_INTERFACE does not reference any database object

INV.MTL_DESC_ELEM_VAL_INTERFACE is referenced by following:

APPS: MTL_DESC_ELEM_VAL_INTERFACE