VIEW: APPS.EGO_GROUP_MEMBERS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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