[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: |
APPS.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 |