FND Design Data [Home] [Help]

View: EGO_USER_V

Product: EGO - Advanced Product Catalog
Description: View contains the user and party information
Implementation/DBA Data: ViewAPPS.EGO_USER_V
View Text

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

Columns

Name
USER_NAME
USER_ID
PARTY_ID
PARTY_NAME