View: EGO_GROUPS_V

Product:	EGO - Advanced Product Catalog
Description:	View contains all the Groups.
Implementation/DBA Data:	APPS.EGO_GROUPS_V

View Text

SELECT GRP.PARTY_ID GROUP_ID
, GRP.PARTY_NAME GROUP_NAME
, GRP.MISSION_STATEMENT GROUP_DESCRIPTION
, GRP.EMAIL_ADDRESS GROUP_EMAIL_ADDRESS
, GRP.OBJECT_VERSION_NUMBER GROUP_OBJECT_VERSION_NUMBER
FROM HZ_PARTIES GRP
WHERE GRP.PARTY_TYPE = 'GROUP'
AND GRP.STATUS = 'A' OR GRP.PARTY_ID = -1000

Columns