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

VIEW: APPS.AME_ATTRIBUTES_VL

Object Details
Object Name: AME_ATTRIBUTES_VL
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

MultiLingual view (a language resolved view of the data.)


This view provides the details of attributes with translated details in the current session language. This view is join between ame_attributes and ame_attributes_tl based on current session language.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ATTRIBUTE_ID NUMBER
Yes Attribute identifier
NAME VARCHAR2 (50) Yes Attribute name
ATTRIBUTE_TYPE VARCHAR2 (20) Yes Type of attribute
LINE_ITEM VARCHAR2 (1)
Not used
CREATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
START_DATE DATE
Yes Date on which row is activated
END_DATE DATE

Date on which row is inactivated
DESCRIPTION VARCHAR2 (300) Yes Attribute description
SECURITY_GROUP_ID NUMBER (15)
Not used
APPROVER_TYPE_ID NUMBER (15)
Approver type identifier if any attached to the attribute
ITEM_CLASS_ID NUMBER (15) Yes Attribute item class identifier
OBJECT_VERSION_NUMBER NUMBER (9)
System-generated version of row. Increments by one with each update
Query Text

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


SELECT ATTRIBUTE_ID
,      NAME
,      ATTRIBUTE_TYPE
,      LINE_ITEM
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      START_DATE
,      END_DATE
,      DESCRIPTION
,      SECURITY_GROUP_ID
,      APPROVER_TYPE_ID
,      ITEM_CLASS_ID
,      OBJECT_VERSION_NUMBER
FROM APPS.AME_ATTRIBUTES_VL;

Dependencies

[top of page]

APPS.AME_ATTRIBUTES_VL references the following:

SchemaAPPS
SynonymAME_ATTRIBUTES
SynonymAME_ATTRIBUTES_TL
APPS.AME_ATTRIBUTES_VL is referenced by following:

SchemaAPPS
ViewAME_ATTRIBUTES_V