VIEW: APPLSYS.FND_USER#

Source

View Text - Preformatted

select USER_ID USER_ID, USER_NAME USER_NAME, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ENCRYPTED_FOUNDATION_PASSWORD ENCRYPTED_FOUNDATION_PASSWORD, ENCRYPTED_USER_PASSWORD ENCRYPTED_USER_PASSWORD, SESSION_NUMBER SESSION_NUMBER, START_DATE START_DATE, END_DATE END_DATE, DESCRIPTION DESCRIPTION, LAST_LOGON_DATE LAST_LOGON_DATE, PASSWORD_DATE PASSWORD_DATE, PASSWORD_ACCESSES_LEFT PASSWORD_ACCESSES_LEFT, PASSWORD_LIFESPAN_ACCESSES PASSWORD_LIFESPAN_ACCESSES, PASSWORD_LIFESPAN_DAYS PASSWORD_LIFESPAN_DAYS, EMPLOYEE_ID EMPLOYEE_ID, EMAIL_ADDRESS EMAIL_ADDRESS, FAX FAX, CUSTOMER_ID CUSTOMER_ID, SUPPLIER_ID SUPPLIER_ID, WEB_PASSWORD WEB_PASSWORD, USER_GUID USER_GUID, GCN_CODE_COMBINATION_ID GCN_CODE_COMBINATION_ID, PERSON_PARTY_ID PERSON_PARTY_ID from "APPLSYS"."FND_USER"

View Text - HTML Formatted

SELECT USER_ID USER_ID
, USER_NAME USER_NAME
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ENCRYPTED_FOUNDATION_PASSWORD ENCRYPTED_FOUNDATION_PASSWORD
, ENCRYPTED_USER_PASSWORD ENCRYPTED_USER_PASSWORD
, SESSION_NUMBER SESSION_NUMBER
, START_DATE START_DATE
, END_DATE END_DATE
, DESCRIPTION DESCRIPTION
, LAST_LOGON_DATE LAST_LOGON_DATE
, PASSWORD_DATE PASSWORD_DATE
, PASSWORD_ACCESSES_LEFT PASSWORD_ACCESSES_LEFT
, PASSWORD_LIFESPAN_ACCESSES PASSWORD_LIFESPAN_ACCESSES
, PASSWORD_LIFESPAN_DAYS PASSWORD_LIFESPAN_DAYS
, EMPLOYEE_ID EMPLOYEE_ID
, EMAIL_ADDRESS EMAIL_ADDRESS
, FAX FAX
, CUSTOMER_ID CUSTOMER_ID
, SUPPLIER_ID SUPPLIER_ID
, WEB_PASSWORD WEB_PASSWORD
, USER_GUID USER_GUID
, GCN_CODE_COMBINATION_ID GCN_CODE_COMBINATION_ID
, PERSON_PARTY_ID PERSON_PARTY_ID
FROM "APPLSYS"."FND_USER"