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: TableINV.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: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MTL_DESCR_ELEMENT_VALUES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnINVENTORY_ITEM_ID
ColumnELEMENT_NAME
MTL_DESCR_ELEMENT_VALUES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnELEMENT_NAME
ColumnELEMENT_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:

SchemaINV
ViewMTL_DESCR_ELEMENT_VALUES#