VIEW: APPS.JTM_FND_USER_V

Source

View Text - Preformatted

SELECT acc.ACCESS_ID, fu.USER_ID, fu.USER_NAME, fu.LAST_UPDATE_DATE, fu.LAST_UPDATED_BY, fu.CREATION_DATE, fu.CREATED_BY, fu.LAST_UPDATE_LOGIN, fu.ENCRYPTED_FOUNDATION_PASSWORD, fu.ENCRYPTED_USER_PASSWORD, fu.SESSION_NUMBER, fu.START_DATE, fu.END_DATE, fu.DESCRIPTION, fu.LAST_LOGON_DATE, fu.PASSWORD_DATE, fu.PASSWORD_ACCESSES_LEFT, fu.PASSWORD_LIFESPAN_ACCESSES, fu.PASSWORD_LIFESPAN_DAYS, fu.EMPLOYEE_ID, fu.EMAIL_ADDRESS, fu.FAX, fu.CUSTOMER_ID, fu.SUPPLIER_ID, fu.WEB_PASSWORD FROM FND_USER fu , JTM_FND_USER_ACC acc WHERE fu.USER_ID = acc.USER_ID AND acc.RESOURCE_ID = ASG_BASE.GET_RESOURCE_ID

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, FU.USER_ID
, FU.USER_NAME
, FU.LAST_UPDATE_DATE
, FU.LAST_UPDATED_BY
, FU.CREATION_DATE
, FU.CREATED_BY
, FU.LAST_UPDATE_LOGIN
, FU.ENCRYPTED_FOUNDATION_PASSWORD
, FU.ENCRYPTED_USER_PASSWORD
, FU.SESSION_NUMBER
, FU.START_DATE
, FU.END_DATE
, FU.DESCRIPTION
, FU.LAST_LOGON_DATE
, FU.PASSWORD_DATE
, FU.PASSWORD_ACCESSES_LEFT
, FU.PASSWORD_LIFESPAN_ACCESSES
, FU.PASSWORD_LIFESPAN_DAYS
, FU.EMPLOYEE_ID
, FU.EMAIL_ADDRESS
, FU.FAX
, FU.CUSTOMER_ID
, FU.SUPPLIER_ID
, FU.WEB_PASSWORD
FROM FND_USER FU
, JTM_FND_USER_ACC ACC
WHERE FU.USER_ID = ACC.USER_ID
AND ACC.RESOURCE_ID = ASG_BASE.GET_RESOURCE_ID