[Home] [Help]
View: BEN_REGN_D
Product: | BEN - Advanced Benefits |
Description: | - Retrofitted |
Implementation/DBA Data: |
APPS.BEN_REGN_D
|
View Text
SELECT REG.ROWID ROW_ID
, REG.REGN_ID
, REG.EFFECTIVE_START_DATE
, REG.EFFECTIVE_END_DATE
, REG.NAME
, REG.STTRY_CITN_NAME
, REG.LAST_UPDATE_DATE
, FUSER.LAST_UPDATED_BY
FROM BEN_REGN_F REG
, FND_USER FUSER
WHERE FUSER.USER_ID (+)= REG .LAST_UPDATED_BY
Columns
Name |
ROW_ID |
REGN_ID |
EFFECTIVE_START_DATE |
EFFECTIVE_END_DATE |
NAME |
STTRY_CITN_NAME |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |