VIEW: APPS.BEN_SVC_AREA_D

Source

View Text - Preformatted

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

View Text - HTML Formatted

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