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

Object Details

Object Name:	EGO_ATTR_GROUP_TYPES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	EGO.EGO_ATTR_GROUP_TYPES_V
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

View EGO_ATTR_GROUP_TYPES_V provides the metadata for attribute groups types. Each row contains information about a particular attribute group type such as its name, description, the names of the tables utilized to store is values, translatable information, the names of the views for a given attribute group type among others.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
APPLICATION_ID	NUMBER	(10)	Yes	Application identifier
ATTR_GROUP_TYPE	VARCHAR2	(40)	Yes	Attribute Group Type
EXT_TABLE_NAME	VARCHAR2	(30)	Yes	Table name
EXT_TL_TABLE_NAME	VARCHAR2	(30)		The name of the TL table that stores the runtime translated data
EXT_VL_NAME	VARCHAR2	(30)		VL View name where the attribute values are stored
ATTR_GROUP_TYPE_TITLE	VARCHAR2	(60)	Yes	Translated attribute group title
DESCRIPTION	VARCHAR2	(240)		Translated description
BUSINESS_EVENT_NAME	VARCHAR2	(240)		Post Business Event name associated with this group type
HIERARCHY_NODE_QUERY	VARCHAR2	(4000)		Query to determine the node at which the object is associated. This is used for propogation purposes.
HIERARCHY_PROPAGATION_API	VARCHAR2	(240)		The API that is called to propogate the value across the hierarchy
PRE_BUSINESS_EVENT_NAME	VARCHAR2	(240)		Pre Business Event name associated with this group type

Query Text

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


SELECT APPLICATION_ID
,      ATTR_GROUP_TYPE
,      EXT_TABLE_NAME
,      EXT_TL_TABLE_NAME
,      EXT_VL_NAME
,      ATTR_GROUP_TYPE_TITLE
,      DESCRIPTION
,      BUSINESS_EVENT_NAME
,      HIERARCHY_NODE_QUERY
,      HIERARCHY_PROPAGATION_API
,      PRE_BUSINESS_EVENT_NAME
FROM APPS.EGO_ATTR_GROUP_TYPES_V;

Dependencies

[top of page]

APPS.EGO_ATTR_GROUP_TYPES_V references the following:

APPS: EGO_FND_DESC_FLEXS_EXT; FND_DESCRIPTIVE_FLEXS; FND_DESCRIPTIVE_FLEXS_TL

APPS.EGO_ATTR_GROUP_TYPES_V is referenced by following:

APPS: BOM_ATTRS_V; EGO_AG_BULKLOAD_PVT - show dependent code; EGO_EXT_FWK_PUB - show dependent code; EGO_USER_ATTRS_DATA_PVT - show dependent code; ENG_IMPL_ITEM_CHANGES_PKG - show dependent code; PO_UDA_AUTOCREATE_PKG - show dependent code