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: ViewINV.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 Comments
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:

SchemaAPPS
ViewMFG_LOOKUPS
SynonymMTL_ITEM_ATTRIBUTES
APPS.MTL_ITEM_ATTRIBUTES_V is referenced by following:

SchemaAPPS
Package BodyDPP_LISTPRICE_PVT - show dependent code
Package BodyEGO_ITEM_LC_IMP_PC_PUB - show dependent code
ViewEGO_ITEM_MAIN_ATTRS_V
Package BodyEGO_ITEM_PUB - show dependent code
Package BodyEGO_UI_ITEM_PUB - show dependent code