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_DESCR_ELEMENT_VALUES

Object Details

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

MTL_DESCR_ELEMENT_VALUES stores the descriptive element values for a
specific item. When an item is associated with a particular item
catalog group, one row per descriptive element (for that catalog
group) is inserted into this table. This table is then updated with
the descriptive element values that the user specifies for the item.
Descriptive element values are defined once (at the item master
organization) for an item. An item may only be assigned to one item
catalog group and will therefore only have descriptive elements for a
single catalog group.
.
DEFAULT_ELEMENT_FLAG is used to indicate whether the descriptive
element value is to be used in the item catalog description for this
particular item. The initial value is defaulted from
MTL_DESCRIPTIVE_ELEMENTS but may be changed when the item is
assigned to the catalog group.
.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MTL_DESCR_ELEMENT_VALUES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	INVENTORY_ITEM_ID ELEMENT_NAME
MTL_DESCR_ELEMENT_VALUES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ELEMENT_NAME ELEMENT_VALUE

Columns

Name	Datatype	Length	Mandatory	Comments
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory item identifier
ELEMENT_NAME	VARCHAR2	(30)	Yes	Descriptive element 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
ELEMENT_VALUE	VARCHAR2	(30)		Descriptive element value
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
DEFAULT_ELEMENT_FLAG	VARCHAR2	(1)	Yes	Flag indicating element to be included in default item description
ELEMENT_SEQUENCE	NUMBER		Yes	Element sequence number

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
FROM INV.MTL_DESCR_ELEMENT_VALUES;

Dependencies

[top of page]

INV.MTL_DESCR_ELEMENT_VALUES does not reference any database object

INV.MTL_DESCR_ELEMENT_VALUES is referenced by following:

INV: MTL_DESCR_ELEMENT_VALUES#