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]

TABLE: EGO.EGO_TEMPL_ATTRIBUTES

Object Details

Object Name:	EGO_TEMPL_ATTRIBUTES
Object Type:	TABLE
Owner:	EGO
FND Design Data:	EGO.EGO_TEMPL_ATTRIBUTES
Subobject Name:
Status:	VALID

Table contains the value entered for attributes in templates

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
EGO_TEMPL_ATTRIBUTES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TEMPLATE_ID ATTRIBUTE_GROUP_ID ATTRIBUTE_ID CLASSIFICATION_CODE ROW_NUMBER
EGO_TEMPL_ATTRIBUTES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TEMPLATE_ID ATTRIBUTE_GROUP_ID CLASSIFICATION_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
TEMPLATE_ID	NUMBER	(22)	Yes	Template Id
ATTRIBUTE_GROUP_ID	NUMBER	(10)	Yes	Attribute group identifier
ATTRIBUTE_ID	NUMBER	(15)	Yes	attribute identifier
ENABLED_FLAG	VARCHAR2	(1)	Yes	Enabled or not
CREATED_BY	NUMBER	(15)	Yes	Standard WHO column
CREATION_DATE	DATE		Yes	Standard WHO column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO column
ROW_NUMBER	NUMBER	(15)		Row Number
ATTRIBUTE_STRING_VALUE	VARCHAR2	(150)		Value of the attribute for String type
ATTRIBUTE_NUMBER_VALUE	NUMBER			Value of the attribute for Number type
ATTRIBUTE_DATE_VALUE	DATE			Value of the attribute for Date type
ATTRIBUTE_TRANSLATED_VALUE	VARCHAR2	(1000)		Value of the attribute for translatable type
ATTRIBUTE_UOM_CODE	VARCHAR2	(3)		Unit of Measure for attribute
CLASSIFICATION_CODE	VARCHAR2	(150)		Classification Code for the objects. Example - Item Catalog Group ID
REQUEST_ID	NUMBER	(15)		Request Id
PROGRAM_APPLICATION_ID	NUMBER	(15)		Application Id
PROGRAM_ID	NUMBER	(15)		Program id
PROGRAM_UPDATE_DATE	DATE			Program Update Date
DATA_LEVEL_ID	NUMBER			The ID of the data level at which the specified template value applies to the attribute

Query Text

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


SELECT TEMPLATE_ID
,      ATTRIBUTE_GROUP_ID
,      ATTRIBUTE_ID
,      ENABLED_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ROW_NUMBER
,      ATTRIBUTE_STRING_VALUE
,      ATTRIBUTE_NUMBER_VALUE
,      ATTRIBUTE_DATE_VALUE
,      ATTRIBUTE_TRANSLATED_VALUE
,      ATTRIBUTE_UOM_CODE
,      CLASSIFICATION_CODE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      DATA_LEVEL_ID
FROM EGO.EGO_TEMPL_ATTRIBUTES;

Dependencies

[top of page]

EGO.EGO_TEMPL_ATTRIBUTES does not reference any database object

EGO.EGO_TEMPL_ATTRIBUTES is referenced by following:

APPS: EGO_TEMPL_ATTRIBUTES