VIEW: APPS.BEN_OPTD_MDCR_RT_D

Source

View Text - Preformatted

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

View Text - HTML Formatted

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