[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 |