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.AMV_D_ENT_ATTRIBUTES_VL

Object Details

Object Name:	AMV_D_ENT_ATTRIBUTES_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AMV.AMV_D_ENT_ATTRIBUTES_VL
Subobject Name:
Status:	VALID

View Type

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

AMV_D_ENT_ATTRIBUTES_VL is a view on the base and translation tables that contains the translated label based on the current language.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Unique identifier generated by the database
ATTRIBUTE_ID	NUMBER		Yes	Unique Identifier.
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	This column is used for locking purposes
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO column.
CREATION_DATE	DATE		Yes	Standard WHO column.
CREATED_BY	NUMBER	(15)	Yes	Standard WHO column.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO column.
ENTITY_ID	NUMBER		Yes	Entity Identifier
DATA_TYPE	VARCHAR2	(30)	Yes	Type of data stored for the attribute
STATUS	VARCHAR2	(30)	Yes	Entity Attribute Status
COLUMN_NAME	VARCHAR2	(255)	Yes	Table column or object to which attribute is associated
VALIDATION_TYPE	VARCHAR2	(1)		Indicates the validation used for the attribute in distribution engine
RANGE_LOW_VALUE	VARCHAR2	(255)		Low range value for the attribute
RANGE_HIGH_VALUE	VARCHAR2	(255)		High range value for the attribute
FUNCTION_CALL	VARCHAR2	(61)		Name of the function to call for getting the attribute values
USAGE_INDICATOR	VARCHAR2	(30)	Yes	Process using this entity attribute
ATTRIBUTE_NAME	VARCHAR2	(80)	Yes	Attribute Name
DESCRIPTION	VARCHAR2	(2000)		Description

Query Text

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


SELECT ROW_ID
,      ATTRIBUTE_ID
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ENTITY_ID
,      DATA_TYPE
,      STATUS
,      COLUMN_NAME
,      VALIDATION_TYPE
,      RANGE_LOW_VALUE
,      RANGE_HIGH_VALUE
,      FUNCTION_CALL
,      USAGE_INDICATOR
,      ATTRIBUTE_NAME
,      DESCRIPTION
FROM APPS.AMV_D_ENT_ATTRIBUTES_VL;

Dependencies

[top of page]

APPS.AMV_D_ENT_ATTRIBUTES_VL references the following:

APPS: AMV_D_ENT_ATTRIBUTES_B; AMV_D_ENT_ATTRIBUTES_TL

APPS.AMV_D_ENT_ATTRIBUTES_VL is not referenced by any database object