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_DESCRIPTIVE_ELEMENTS

Object Details

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

MTL_DESCRIPTIVE_ELEMENTS stores the descriptive element definitions
for an item catalog group. Descriptive elements are defining
properties used to describe in the catalog group.
.
DEFAULT_ELEMENT_FLAG indicates whether the descriptive element is
typically used in the item catalog description (using the concatenated
descriptive element values) for the item. The value of the flag
entered here provides the default behavior for the descriptive
element. Whether a particular element is used for a particular item
can be determined in the Master Items window.
.
REQUIRED_ELEMENT_FLAG indicates whether a value must be defined for
the descriptive element before the item catalog definition of an item
can be considered complete.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MTL_DESCRIPTIVE_ELEMENTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ITEM_CATALOG_GROUP_ID ELEMENT_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
ITEM_CATALOG_GROUP_ID	NUMBER		Yes	Item Catalog Group 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
REQUIRED_ELEMENT_FLAG	VARCHAR2	(1)	Yes	Flag indicating element is required
DEFAULT_ELEMENT_FLAG	VARCHAR2	(1)	Yes	Flag indicating that the element needs to be included in default item description
ELEMENT_SEQUENCE	NUMBER		Yes	Descriptive element sequence number
DESCRIPTION	VARCHAR2	(50)		Descriptive element description
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

Query Text

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


SELECT ITEM_CATALOG_GROUP_ID
,      ELEMENT_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUIRED_ELEMENT_FLAG
,      DEFAULT_ELEMENT_FLAG
,      ELEMENT_SEQUENCE
,      DESCRIPTION
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM INV.MTL_DESCRIPTIVE_ELEMENTS;

Dependencies

[top of page]

INV.MTL_DESCRIPTIVE_ELEMENTS does not reference any database object

INV.MTL_DESCRIPTIVE_ELEMENTS is referenced by following:

INV: MTL_DESCRIPTIVE_ELEMENTS#