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_GROUP_MEMBERS_V

Object Details

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

View Type

A Business Intelligence System view

View EGO_GROUP_MEMBERS_V provides all the data related to GROUP MEMBERS such as the group for which the member belongs, member id, member name, relationship, and member personal information (through MEMBER_PERSON_ID) among others.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
GROUP_ID	NUMBER	(15)	Yes	Group Id
GROUP_NAME	VARCHAR2	(360)	Yes	Group Name
GROUP_MEMBER_REL_ID	NUMBER	(15)	Yes	Relationsship Id
GROUP_MEMBER_VERSION	NUMBER			object_version_number from HZ_RELATIONSHIPS
MEMBER_USER_ID	NUMBER	(15)	Yes	User Id from fnd_user
MEMBER_USER_NAME	VARCHAR2	(100)	Yes	User Name
MEMBER_PERSON_ID	NUMBER	(15)	Yes	Person Id from HZ_PARTIES
MEMBER_PERSON_NAME	VARCHAR2	(360)	Yes	Person Name

Query Text

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


SELECT GROUP_ID
,      GROUP_NAME
,      GROUP_MEMBER_REL_ID
,      GROUP_MEMBER_VERSION
,      MEMBER_USER_ID
,      MEMBER_USER_NAME
,      MEMBER_PERSON_ID
,      MEMBER_PERSON_NAME
FROM APPS.EGO_GROUP_MEMBERS_V;

Dependencies

[top of page]

APPS.EGO_GROUP_MEMBERS_V references the following:

APPS: FND_USER; HZ_PARTIES; HZ_RELATIONSHIPS

APPS.EGO_GROUP_MEMBERS_V is referenced by following:

APPS: EGO_GROUP_WF_PKG - show dependent code