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]

VIEW: APPS.MTL_ITEM_ATTRIBUTES_V

Object Details

Object Name:	MTL_ITEM_ATTRIBUTES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	INV.MTL_ITEM_ATTRIBUTES_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory
ROW_ID	ROWID	(10)
ATTRIBUTE_NAME	VARCHAR2	(50)	Yes
USER_ATTRIBUTE_NAME	VARCHAR2	(30)
USER_ATTRIBUTE_NAME_GUI	VARCHAR2	(30)
ATTRIBUTE_GROUP_ID	NUMBER		Yes
ATTRIBUTE_GROUP_ID_GUI	NUMBER
CONTROL_LEVEL	NUMBER		Yes
DATA_TYPE	VARCHAR2	(8)	Yes
SEQUENCE	NUMBER		Yes
SEQUENCE_GUI	NUMBER
LEVEL_UPDATEABLE_FLAG	VARCHAR2	(1)	Yes
STATUS_CONTROL_CODE	NUMBER
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER		Yes
LAST_UPDATE_LOGIN	NUMBER
VALIDATION_CODE	NUMBER
PREFIELD_FLAG	VARCHAR2	(1)
POST_CHANGE_FLAG	VARCHAR2	(1)
POST_FIELD_FLAG	VARCHAR2	(1)
MANDATORY_FLAG	VARCHAR2	(1)
UPDATE_MESSAGE_NAME	VARCHAR2	(30)
REQUIRED_MESSAGE_NAME	VARCHAR2	(30)
LOOKUP_TYPE1	VARCHAR2	(30)	Yes
LOOKUP_CODE1	NUMBER
MEANING1	VARCHAR2	(80)	Yes
ENABLED_FLAG1	VARCHAR2	(1)	Yes
LOOKUP_TYPE2	VARCHAR2	(30)	Yes
LOOKUP_CODE2	NUMBER
MEANING2	VARCHAR2	(80)	Yes
ENABLED_FLAG2	VARCHAR2	(1)	Yes
LOOKUP_TYPE3	VARCHAR2	(30)
LOOKUP_CODE3	NUMBER
MEANING3	VARCHAR2	(80)
ENABLED_FLAG3	VARCHAR2	(1)
LOOKUP_TYPE4	VARCHAR2	(30)
LOOKUP_CODE4	NUMBER
MEANING4	VARCHAR2	(80)
ENABLED_FLAG4	VARCHAR2	(1)

Query Text

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


SELECT ROW_ID
,      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
,      LOOKUP_TYPE1
,      LOOKUP_CODE1
,      MEANING1
,      ENABLED_FLAG1
,      LOOKUP_TYPE2
,      LOOKUP_CODE2
,      MEANING2
,      ENABLED_FLAG2
,      LOOKUP_TYPE3
,      LOOKUP_CODE3
,      MEANING3
,      ENABLED_FLAG3
,      LOOKUP_TYPE4
,      LOOKUP_CODE4
,      MEANING4
,      ENABLED_FLAG4
FROM APPS.MTL_ITEM_ATTRIBUTES_V;

Dependencies

[top of page]

APPS.MTL_ITEM_ATTRIBUTES_V references the following:

APPS: MFG_LOOKUPS; MTL_ITEM_ATTRIBUTES

APPS.MTL_ITEM_ATTRIBUTES_V is referenced by following:

APPS: DPP_LISTPRICE_PVT - show dependent code; EGO_ITEM_LC_IMP_PC_PUB - show dependent code; EGO_ITEM_MAIN_ATTRS_V; EGO_ITEM_PUB - show dependent code; EGO_UI_ITEM_PUB - show dependent code