EGP_USER_DETAILS_V

Details

• Schema: FUSION

• Object owner: EGP

• Object type: VIEW

Columns

Name
USERNAME DISPLAY_PERSON_NAME DISPLAY_EMAIL_ADDRESS USER_GUID LOGIN_USERNAME

Query

SQL_Statement

SELECT USERNAME, DISPLAY_PERSON_NAME, DISPLAY_EMAIL_ADDRESS, USER_GUID, LOGIN_USERNAME FROM ( SELECT UserPEO.USERNAME AS USERNAME, PersonNameDPEO.display_name AS DISPLAY_PERSON_NAME, EmailAddressPEO.email_address AS DISPLAY_EMAIL_ADDRESS, UserPEO.USER_GUID AS USER_GUID, UserPEO.MULTITENANCY_USERNAME AS LOGIN_USERNAME FROM PER_USERS UserPEO, PER_PERSON_NAMES_F_V PersonNameDPEO, PER_EMAIL_ADDRESSES EmailAddressPEO, per_all_people_f per 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 UserPEO.person_id = PersonNameDPEO.person_id(+) and trunc(sys_extract_utc(systimestamp)+0.5) between PersonNameDPEO.effective_start_date(+) and PersonNameDPEO.effective_end_date(+) union all select UserPEO.USERNAME AS USERNAME, hzp.party_name AS DISPLAY_PERSON_NAME, hzp.email_address AS DISPLAY_EMAIL_ADDRES, UserPEO.USER_GUID AS USER_GUID, UserPEO.MULTITENANCY_USERNAME AS LOGIN_USERNAME FROM PER_USERS UserPEO, HZ_PARTIES hzp WHERE UserPEO.party_id=hzp.party_id and UserPEO.person_id is null union all select UserPEO.USERNAME as USERNAME, UserPEO.USERNAME AS DISPLAY_PERSON_NAME, UserPEO.USERNAME AS DISPLAY_EMAIL_ADDRESS, UserPEO.USER_GUID AS USER_GUID, UserPEO.MULTITENANCY_USERNAME AS LOGIN_USERNAME FROM PER_USERS UserPEO WHERE UserPEO.person_id is null and UserPEO.party_id is null )