VIEW: APPS.BEN_ELIG_TTL_CVG_VOL_PRTE_D

Source

View Text - Preformatted

SELECT ETC.ELIG_TTL_CVG_VOL_PRTE_ID , ETC.EFFECTIVE_START_DATE , ETC.EFFECTIVE_END_DATE , ETC.BUSINESS_GROUP_ID , ETC.EXCLD_FLAG , ETC.NO_MN_CVG_VOL_AMT_APLS_FLAG, ETC.NO_MX_CVG_VOL_AMT_APLS_FLAG, ETC.ELIGY_PRFL_ID , ETC.LAST_UPDATE_DATE , ETC.LAST_UPDATED_BY , ETC.LAST_UPDATE_LOGIN , ETC.CREATED_BY , ETC.CREATION_DATE , ETC.OBJECT_VERSION_NUMBER , ETC.ORDR_NUM , ETC.MN_CVG_VOL_AMT , ETC.MX_CVG_VOL_AMT , ETC.CVG_VOL_DET_CD , ETC.CVG_VOL_DET_RL FROM     BEN_ELIG_TTL_CVG_VOL_PRTE_F ETC, FND_USER_VIEW FUSER WHERE FUSER.USER_ID(+) = ETC.LAST_UPDATED_BY

View Text - HTML Formatted

SELECT ETC.ELIG_TTL_CVG_VOL_PRTE_ID
, ETC.EFFECTIVE_START_DATE
, ETC.EFFECTIVE_END_DATE
, ETC.BUSINESS_GROUP_ID
, ETC.EXCLD_FLAG
, ETC.NO_MN_CVG_VOL_AMT_APLS_FLAG
, ETC.NO_MX_CVG_VOL_AMT_APLS_FLAG
, ETC.ELIGY_PRFL_ID
, ETC.LAST_UPDATE_DATE
, ETC.LAST_UPDATED_BY
, ETC.LAST_UPDATE_LOGIN
, ETC.CREATED_BY
, ETC.CREATION_DATE
, ETC.OBJECT_VERSION_NUMBER
, ETC.ORDR_NUM
, ETC.MN_CVG_VOL_AMT
, ETC.MX_CVG_VOL_AMT
, ETC.CVG_VOL_DET_CD
, ETC.CVG_VOL_DET_RL
FROM BEN_ELIG_TTL_CVG_VOL_PRTE_F ETC
, FND_USER_VIEW FUSER
WHERE FUSER.USER_ID(+) = ETC.LAST_UPDATED_BY