FND Design Data [Home] [Help]

View: JTF_FM_FND_USER_V

Product: JTF - CRM Foundation
Description: View referring to the FND_USER table
Implementation/DBA Data: ViewAPPS.JTF_FM_FND_USER_V
View Text

SELECT USER_ID
, USER_NAME
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, ENCRYPTED_FOUNDATION_PASSWORD
, ENCRYPTED_USER_PASSWORD
, SESSION_NUMBER
, START_DATE
, END_DATE
, DESCRIPTION
, LAST_LOGON_DATE
, PASSWORD_DATE
, PASSWORD_ACCESSES_LEFT
, PASSWORD_LIFESPAN_ACCESSES
, PASSWORD_LIFESPAN_DAYS
, EMPLOYEE_ID
, EMAIL_ADDRESS
, FAX
, CUSTOMER_ID
, SUPPLIER_ID
, WEB_PASSWORD
, NULL
, 1
FROM FND_USER

Columns

Name
USER_ID
USER_NAME
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
ENCRYPTED_FOUNDATION_PASSWORD
ENCRYPTED_USER_PASSWORD
SESSION_NUMBER
START_DATE
END_DATE
DESCRIPTION
LAST_LOGON_DATE
PASSWORD_DATE
PASSWORD_ACCESSES_LEFT
PASSWORD_LIFESPAN_ACCESSES
PASSWORD_LIFESPAN_DAYS
EMPLOYEE_ID
EMAIL_ADDRESS
FAX
CUSTOMER_ID
SUPPLIER_ID
WEB_PASSWORD
F_DELETEDFLAG
OBJECT_VERSION_NUMBER