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

TABLE: INV.MTL_ITEM_ATTRIBUTES

Object Details
Object Name: MTL_ITEM_ATTRIBUTES
Object Type: TABLE
Owner: INV
FND Design Data: TableINV.MTL_ITEM_ATTRIBUTES
Subobject Name:
Status: VALID


MTL_ITEM_ATTRIBUTES table stores information on item attributes. Each
row in the table correponds to an attribute. The table stores the
attribute name, the corresponding user-friendly name seen by the
users, and the kind of validation enforced on the attribute.
.
CONTROL_LEVEL indicates the attribute control level: master
or organization. Master level is also referred to as item level,
and organization level is also referred to as item/org level
.
LEVEL_UPDATEABLE_FLAG indicates whether the user is allowed to update
the control level.
.
ATTRIBUTE_GROUP_ID is used to group attributes into
functional areas such as Purchasing, Costing, Invoicing, Lead
Times, etc.
.
Columns such as PREFIELD_FLAG, POST_CHANGE_FLAG, POST_FIELD_FLAG,
VALIDATION_CODE are used by the item-related forms to determine what
kind of validation is needed.
.
This table is seeded on install or upgrade.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MTL_ITEM_ATTRIBUTES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnATTRIBUTE_NAME
MTL_ITEM_ATTRIBUTES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSTATUS_CONTROL_CODE
Columns
Name Datatype Length Mandatory Comments
ATTRIBUTE_NAME VARCHAR2 (50) Yes Item attribute name
USER_ATTRIBUTE_NAME VARCHAR2 (30)
User-friendly attribute name in the character mode applications. No longer used
USER_ATTRIBUTE_NAME_GUI VARCHAR2 (30)
User-friendly attribute name
ATTRIBUTE_GROUP_ID NUMBER
Yes Attribute group identifier. Groups attributes into functional areas in character mode. No longer used
ATTRIBUTE_GROUP_ID_GUI NUMBER

Attribute group identifier. Groups attributes into functional areas
CONTROL_LEVEL NUMBER
Yes Attribute control level
DATA_TYPE VARCHAR2 (8) Yes Attribute data type
SEQUENCE NUMBER
Yes Attribute display sequence in character mode. No longer used
SEQUENCE_GUI NUMBER

Attribute display sequence
LEVEL_UPDATEABLE_FLAG VARCHAR2 (1) Yes Flag indicating whether attribute control level can be updated
STATUS_CONTROL_CODE NUMBER

Status control code for status attributes
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
VALIDATION_CODE NUMBER

Indicator for attribute validation method used
PREFIELD_FLAG VARCHAR2 (1)
Flag indicating pre-field trigger must be executed for the attribute
POST_CHANGE_FLAG VARCHAR2 (1)
Flag indicating post-change trigger must be executed for the attribute
POST_FIELD_FLAG VARCHAR2 (1)
Flag indicating post-field trigger must be executed for the attribute
MANDATORY_FLAG VARCHAR2 (1)
Flag indicating attribute is a mandatory field
UPDATE_MESSAGE_NAME VARCHAR2 (30)
Message to be displayed when the attribute is updated
REQUIRED_MESSAGE_NAME VARCHAR2 (30)
Message to be displayed when a value must be entered for the attribute
Query Text

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


SELECT ATTRIBUTE_NAME
,      USER_ATTRIBUTE_NAME
,      USER_ATTRIBUTE_NAME_GUI
,      ATTRIBUTE_GROUP_ID
,      ATTRIBUTE_GROUP_ID_GUI
,      CONTROL_LEVEL
,      DATA_TYPE
,      SEQUENCE
,      SEQUENCE_GUI
,      LEVEL_UPDATEABLE_FLAG
,      STATUS_CONTROL_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      VALIDATION_CODE
,      PREFIELD_FLAG
,      POST_CHANGE_FLAG
,      POST_FIELD_FLAG
,      MANDATORY_FLAG
,      UPDATE_MESSAGE_NAME
,      REQUIRED_MESSAGE_NAME
FROM INV.MTL_ITEM_ATTRIBUTES;

Dependencies

[top of page]

INV.MTL_ITEM_ATTRIBUTES does not reference any database object

INV.MTL_ITEM_ATTRIBUTES is referenced by following:

SchemaAPPS
SynonymMTL_ITEM_ATTRIBUTES