EGO_PARTICIPANTS_V

Details

• Schema: FUSION

• Object owner: EGO

• Object type: VIEW

Columns

Name
PARTICIPANT_NAME PARTICIPANT_GUID PARTICIPANT_TYPE PARTICIPANT_ID PARTICIPANT_USERNAME PARTICIPANT_DISPLAY_NAME

Query

SQL_Statement

SELECT PARTICIPANT_NAME, PARTICIPANT_GUID, PARTICIPANT_TYPE, PARTICIPANT_ID, PARTICIPANT_USERNAME, PARTICIPANT_DISPLAY_NAME FROM ( SELECT NVL(emailaddresspeo.email_address,userpeo.username) AS participant_name, userpeo.user_guid AS participant_guid, 'USER' AS participant_type, userpeo.user_id AS participant_id, userpeo.username AS participant_username, personnameseo.DISPLAY_NAME AS participant_display_name FROM per_users userpeo, per_email_addresses emailaddresspeo, per_all_people_f per, per_person_names_f_v personnameseo WHERE userpeo.person_id = per.person_id AND trunc(sys_extract_utc(systimestamp) + 0.5) BETWEEN per.effective_start_date (+) AND per.effective_end_date (+) AND per.primary_email_id = emailaddresspeo.email_address_id (+) AND trunc(sys_extract_utc(systimestamp) + 0.5) BETWEEN personnameseo.effective_start_date (+) AND personnameseo.effective_end_date(+) AND userpeo.person_id = personnameseo.person_id (+) UNION SELECT nvl(hzp.email_address,userpeo.username) AS participant_name, userpeo.user_guid AS participant_guid, 'USER' AS participant_type, userpeo.user_id AS participant_id, userpeo.username AS participant_username, hzp.party_name AS participant_display_name 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, userpeo.username AS participant_username, userpeo.username AS participant_display_name 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, per_roles_dn_vl.ROLE_COMMON_NAME AS participant_username, per_roles_dn_vl.role_name AS participant_display_name FROM per_roles_dn_vl )