[Home] [Help] [Dependency Information]
Object Name: | MTL_ITEM_ATTRIBUTES |
---|---|
Object Type: | TABLE |
Owner: | INV |
FND Design Data: | INV.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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MTL_ITEM_ATTRIBUTES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ATTRIBUTE_NAME |
MTL_ITEM_ATTRIBUTES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | STATUS_CONTROL_CODE |
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 |
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;
INV.MTL_ITEM_ATTRIBUTES does not reference any database object
INV.MTL_ITEM_ATTRIBUTES is referenced by following:
|
|
|