View: BEN_OPTD_MDCR_RT_D

Product:	BEN - Advanced Benefits
Description:
Implementation/DBA Data:	APPS.BEN_OPTD_MDCR_RT_D

View Text

SELECT OMR.ROWID
, OMR.OPTD_MDCR_RT_ID
, OMR.EFFECTIVE_START_DATE
, OMR.EFFECTIVE_END_DATE
, DECODE(OMR.OPTD_MDCR_FLAG
, 'Y'
, 'YES'
, 'N'
, 'NO'
, OMR.OPTD_MDCR_FLAG) OPTD_MDCR_FLAG
, DECODE(OMR.EXLCD_FLAG
, 'Y'
, 'YES'
, 'N'
, 'NO'
, OMR.EXLCD_FLAG) EXLCD_FLAG
, VPR.NAME
, OMR.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_OPTD_MDCR_RT_F OMR
, FND_USER_VIEW FUSER
, BEN_VRBL_RT_PRFL_F VPR
WHERE FUSER.USER_ID(+) = OMR.LAST_UPDATED_BY
AND OMR.VRBL_RT_PRFL_ID = VPR.VRBL_RT_PRFL_ID

Columns