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_OBJ_IDS_V

Object Details

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

View Type

A Business Intelligence System view

View EGO_ATTR_GROUP_OBJ_IDS_V provides all the User-Defined Attribute Groups associated to an Object. Each row of this view contains the attribute group metadata information (e.g. name, description, type, flags, etc) for a given object type specified by column OBJECT_ID.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
APPLICATION_ID	NUMBER	(15)	Yes	Application identifier
OBJECT_ID	NUMBER	(15)	Yes	Identifier for the Object for whose Attribute Groups the Extension Table stores data (foreign key to FND_OBJECTS)
DESCRIPTIVE_FLEXFIELD_NAME	VARCHAR2	(40)	Yes	Name of Descriptive Flex field from (FND_DESCRIPTIVE_FLEXS_TL)
ATTR_GROUP_TYPE	VARCHAR2	(40)	Yes	Attribute Group type
ATTR_GROUP_NAME	VARCHAR2	(30)	Yes	Attribute group type
SECURITY_CODE	VARCHAR2	(30)	Yes	Security Code (Obsolete column)
OWNING_PARTY_ID	NUMBER	(15)	Yes	Identifier of the party who owns this attribute group (Obsolete column)
ATTR_GROUP_DISP_NAME	VARCHAR2	(80)	Yes	Attribute group display name
ENABLED_CODE	VARCHAR2	(1)	Yes	Enabled Or Not
MULTI_ROW_CODE	VARCHAR2	(1)	Yes	Is this a multi row attribute group
MULTI_ROW_MEANING	VARCHAR2	(80)	Yes	Meaning of multi row code Yes or No
SECURITY_MEANING	VARCHAR2	(80)	Yes	Meaning of security like public etc (Obsolete column)
ENABLED_MEANING	VARCHAR2	(80)	Yes	Enabled or not (Yes or No)
DESCRIPTION	VARCHAR2	(240)		Description of Attribute group

Query Text

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


SELECT APPLICATION_ID
,      OBJECT_ID
,      DESCRIPTIVE_FLEXFIELD_NAME
,      ATTR_GROUP_TYPE
,      ATTR_GROUP_NAME
,      SECURITY_CODE
,      OWNING_PARTY_ID
,      ATTR_GROUP_DISP_NAME
,      ENABLED_CODE
,      MULTI_ROW_CODE
,      MULTI_ROW_MEANING
,      SECURITY_MEANING
,      ENABLED_MEANING
,      DESCRIPTION
FROM APPS.EGO_ATTR_GROUP_OBJ_IDS_V;

Dependencies

[top of page]

APPS.EGO_ATTR_GROUP_OBJ_IDS_V references the following:

APPS: EGO_ATTR_GROUPS_V; EGO_OBJECT_EXT_TABLES_B; FND_DESCRIPTIVE_FLEXS; FND_DESCRIPTIVE_FLEXS_TL; FND_TABLES

APPS.EGO_ATTR_GROUP_OBJ_IDS_V is not referenced by any database object