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

Object Details

Object Name:	AME_ATTRIBUTES_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[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
ATTRIBUTE_DESCRIPTION	VARCHAR2	(300)	Yes	Attribute description
APPROVER_TYPE_ID	NUMBER	(15)		Approver type identifier if any, attached to the attribute
ITEM_CLASS_ID	NUMBER	(15)	Yes	Attribute item class identifier
AME_APPLICATION_ID	NUMBER		Yes	AME internal application identifier which identifies atransaction type
FND_APPLICATION_ID	NUMBER		Yes	FND application identifier for which the transaction type belongs
TRANSACTION_TYPE_ID	VARCHAR2	(50)		Transaction type key
VALUE	VARCHAR2	(4000)		Value of the attribute or Sql statement to fetch the value of the dynamic attribute usages
IS_STATIC	VARCHAR2	(1)		Indicates whether an attribute usage is static or not
CREATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
VALUE_SET_ID	NUMBER	(10)		Value set identifier if attached
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
,      ATTRIBUTE_DESCRIPTION
,      APPROVER_TYPE_ID
,      ITEM_CLASS_ID
,      AME_APPLICATION_ID
,      FND_APPLICATION_ID
,      TRANSACTION_TYPE_ID
,      VALUE
,      IS_STATIC
,      CREATED_BY
,      CREATION_DATE
,      VALUE_SET_ID
,      OBJECT_VERSION_NUMBER
FROM APPS.AME_ATTRIBUTES_V;

Dependencies

[top of page]

APPS.AME_ATTRIBUTES_V references the following:

APPS: AME_ATTRIBUTES_VL; AME_ATTRIBUTE_USAGES; AME_CALLING_APPS

APPS.AME_ATTRIBUTES_V is not referenced by any database object