DBA Data[Home] [Help]

VIEW: APPS.BEN_ELIG_PSTL_CD_R_RNG_CVG_D

Source

View Text - Preformatted

SELECT EPL.ELIG_PSTL_CD_R_RNG_CVG_ID , EPL.EFFECTIVE_START_DATE , EPL.EFFECTIVE_END_DATE , EPL.ORDR_NUM , EPL.EXCLD_FLAG , EPL.DPNT_CVG_ELIGY_PRFL_ID , EPL.PSTL_ZIP_RNG_ID , EPL.LAST_UPDATE_DATE , fuser.user_name FROM BEN_ELIG_PSTL_CD_R_RNG_CVG_F EPL, fnd_user fuser WHERE fuser.user_id(+) = epl.last_updated_by
View Text - HTML Formatted

SELECT EPL.ELIG_PSTL_CD_R_RNG_CVG_ID
, EPL.EFFECTIVE_START_DATE
, EPL.EFFECTIVE_END_DATE
, EPL.ORDR_NUM
, EPL.EXCLD_FLAG
, EPL.DPNT_CVG_ELIGY_PRFL_ID
, EPL.PSTL_ZIP_RNG_ID
, EPL.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_ELIG_PSTL_CD_R_RNG_CVG_F EPL
, FND_USER FUSER
WHERE FUSER.USER_ID(+) = EPL.LAST_UPDATED_BY