View: EGO_GROUP_MEMBERS_V

Product:	EGO - Advanced Product Catalog
Description:	This view contains the group member information
Implementation/DBA Data:	APPS.EGO_GROUP_MEMBERS_V

View Text

SELECT GRP.PARTY_ID GROUP_ID
, GRP.PARTY_NAME GROUP_NAME
, MEMBER_GROUP.RELATIONSHIP_ID GROUP_MEMBER_REL_ID
, MEMBER_GROUP.OBJECT_VERSION_NUMBER GROUP_MEMBER_VERSION
, FND_USER.USER_ID MEMBER_USER_ID
, FND_USER.USER_NAME MEMBER_USER_NAME
, MEMBER.PARTY_ID MEMBER_PERSON_ID
, MEMBER.PARTY_NAME MEMBER_PERSON_NAME
FROM HZ_PARTIES GRP
, HZ_RELATIONSHIPS MEMBER_GROUP
, HZ_PARTIES MEMBER
, FND_USER
WHERE GRP.PARTY_TYPE = 'GROUP'
AND GRP.PARTY_ID = MEMBER_GROUP.OBJECT_ID
AND MEMBER_GROUP.OBJECT_TYPE = 'GROUP'
AND MEMBER_GROUP.RELATIONSHIP_TYPE = 'MEMBERSHIP'
AND MEMBER_GROUP.STATUS = 'A'
AND MEMBER_GROUP.START_DATE <= SYSDATE
AND NVL(MEMBER_GROUP.END_DATE
, SYSDATE) >= SYSDATE
AND MEMBER_GROUP.SUBJECT_TYPE = 'PERSON'
AND MEMBER_GROUP.SUBJECT_ID = MEMBER.PARTY_ID
AND MEMBER.PARTY_TYPE = 'PERSON'
AND MEMBER.PARTY_ID = FND_USER.PERSON_PARTY_ID

Columns