EGO_PARTICIPANTS_V

Details

• Schema: FUSION

• Object owner: EGO

• Object type: VIEW

Columns

Name
PARTICIPANT_NAME PARTICIPANT_GUID PARTICIPANT_TYPE PARTICIPANT_ID

Query

SQL_Statement

SELECT PARTICIPANT_NAME, PARTICIPANT_GUID, PARTICIPANT_TYPE, PARTICIPANT_ID FROM ( SELECT emailaddresspeo.email_address AS participant_name, userpeo.user_guid AS participant_guid, 'USER' AS participant_type, userpeo.user_id AS participant_id FROM per_users userpeo, per_email_addresses emailaddresspeo, per_all_people_f per WHERE userpeo.person_id = per.person_id AND per.primary_email_id = emailaddresspeo.email_address_id (+) UNION SELECT hzp.email_address AS participant_name, userpeo.user_guid AS participant_guid, 'USER' AS participant_type, userpeo.user_id AS participant_id FROM per_users userpeo, hz_parties hzp WHERE userpeo.party_id = hzp.party_id AND userpeo.person_id IS NULL UNION SELECT userpeo.username AS participant_name, userpeo.user_guid AS participant_guid, 'USER' AS participant_type, userpeo.user_id AS participant_id FROM per_users userpeo WHERE userpeo.person_id IS NULL AND userpeo.party_id IS NULL UNION SELECT per_roles_dn_vl.role_name AS participant_name, per_roles_dn_vl.role_guid AS participant_guid, 'ROLE' AS participant_type, per_roles_dn_vl.role_id AS participant_id FROM per_roles_dn_vl )