FND Design Data [Home] [Help]

View: IGI_ITR_CHARGE_AUTH_V

Product: IGI - Public Sector Financials International
Description: Based on IGI_ITR_CHARGE_AUTH and FND_USER
Implementation/DBA Data: ViewAPPS.IGI_ITR_CHARGE_AUTH_V
View Text

SELECT AUTH.ROWID ROW_ID
, AUTH.USER_ID USER_ID
, AUTH.CHARGE_CENTER_ID CHARGE_CENTER_ID
, AUTH.CREATION_DATE CREATION_DATE
, AUTH.CREATED_BY CREATED_BY
, AUTH.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, AUTH.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AUTH.LAST_UPDATED_BY LAST_UPDATED_BY
, FU.USER_NAME AUTH_NAME_DSP
FROM FND_USER FU
, IGI_ITR_CHARGE_AUTH AUTH
WHERE FU.USER_ID = AUTH.USER_ID

Columns

Name
ROW_ID
USER_ID
CHARGE_CENTER_ID
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
LAST_UPDATE_DATE
LAST_UPDATED_BY
AUTH_NAME_DSP