VIEW: APPS.EGO_USER_V

Source

View Text - Preformatted

SELECT U.user_name, U.user_id, P.party_id, P.party_name FROM fnd_user U, hz_parties P WHERE p.party_type = 'PERSON' AND P.party_id = U.person_party_id

View Text - HTML Formatted

SELECT U.USER_NAME
, U.USER_ID
, P.PARTY_ID
, P.PARTY_NAME
FROM FND_USER U
, HZ_PARTIES P
WHERE P.PARTY_TYPE = 'PERSON'
AND P.PARTY_ID = U.PERSON_PARTY_ID