FND Design Data [Home] [Help]

View: BEN_REGN_D

Product: BEN - Advanced Benefits
Description: - Retrofitted
Implementation/DBA Data: ViewAPPS.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