DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.EGO_GROUPS_V

Object Details
Object Name: EGO_GROUPS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewEGO.EGO_GROUPS_V
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


View EGO_GROUPS_V provides all the data related to GROUPS such as name, description, and email address. The unique identifier for each row is GROUP_ID. In other words, each row provides the data for a given group.


[View Source]

Columns
Name Datatype Length Mandatory Comments
GROUP_ID NUMBER (15) Yes hz_party_id
GROUP_NAME VARCHAR2 (360) Yes Name
GROUP_DESCRIPTION VARCHAR2 (2000)
Description
GROUP_EMAIL_ADDRESS VARCHAR2 (2000)
Email address
GROUP_OBJECT_VERSION_NUMBER NUMBER

hz_party.object_version_number
Query Text

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


SELECT GROUP_ID
,      GROUP_NAME
,      GROUP_DESCRIPTION
,      GROUP_EMAIL_ADDRESS
,      GROUP_OBJECT_VERSION_NUMBER
FROM APPS.EGO_GROUPS_V;

Dependencies

[top of page]

APPS.EGO_GROUPS_V references the following:

SchemaAPPS
SynonymHZ_PARTIES
APPS.EGO_GROUPS_V is referenced by following:

SchemaAPPS
Package BodyDOM_WS_INTERFACE_PUB - show dependent code
Package BodyEGO_CHANGE_PEOPLE_IMPORT_PKG - show dependent code
Package BodyEGO_ITEM_PEOPLE_IMPORT_PKG - show dependent code
Package BodyENG_ECO_PVT - show dependent code
Package BodyENG_WORKFLOW_UTIL - show dependent code
Package BodyWF_PUB_ICC - show dependent code