FND Design Data [Home] [Help]

View: BEN_SVC_AREA_D

Product: BEN - Advanced Benefits
Description: - Retrofitted
Implementation/DBA Data: ViewAPPS.BEN_SVC_AREA_D
View Text

SELECT SVA.ROWID ROW_ID
, SVA.SVC_AREA_ID
, SVA.EFFECTIVE_START_DATE
, SVA.EFFECTIVE_END_DATE
, SVA.NAME
, SVA.ORG_UNIT_PRDCT
, SVA.LAST_UPDATE_DATE
, FUSER.LAST_UPDATED_BY
FROM BEN_SVC_AREA_F SVA
, FND_USER FUSER
WHERE FUSER.USER_ID (+)= SVA .LAST_UPDATED_BY

Columns

Name
ROW_ID
SVC_AREA_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
NAME
ORG_UNIT_PRDCT
LAST_UPDATE_DATE
LAST_UPDATED_BY