PSC_PER_ALL_USERS_V

Details

• Schema: FUSION

• Object owner: PSC_PER

• Object type: VIEW

Columns

Name
USER_KEY PARTY_ID PERSON_ID FULL_NAME FIRST_NAME MIDDLE_NAMES LAST_NAME USER_ID USERNAME

Query

SQL_Statement

SELECT (case when c.party_id is null then c.person_id else c.party_id end) user_key, c.party_id, a.person_id, a.full_name, a.first_name, a.middle_names, a.last_name, c.user_id, c.username FROM per_person_names_f_v a, psc_com_person_prof b, per_users c WHERE b.person_id = a.person_id (+) AND b.person_id = c.person_id (+) UNION SELECT (case when a.party_id is null then c.person_id else a.party_id end) user_key, a.party_id, c.person_id, a.party_unique_name, a.person_first_name, a.person_middle_name, a.person_last_name, c.user_id, c.username FROM hz_parties a, psc_pbl_user_ref b, per_users c WHERE b.party_id = a.party_id (+) AND b.party_id = c.party_id (+)