VIEW: APPS.BEN_DSGNTR_ENRLD_CVG_V

Source

View Text - Preformatted

SELECT dec.ROWID ROW_ID, dec.DSGNTR_ENRLD_CVG_ID ,dec.EFFECTIVE_START_DATE ,dec.EFFECTIVE_END_DATE ,dec.DSGNTR_CRNTLY_ENRLD_FLAG ,dec.DPNT_CVG_ELIGY_PRFL_ID ,dec.BUSINESS_GROUP_ID ,dec.DEC_ATTRIBUTE_CATEGORY ,dec.DEC_ATTRIBUTE1 ,dec.DEC_ATTRIBUTE2 ,dec.DEC_ATTRIBUTE3 ,dec.DEC_ATTRIBUTE4 ,dec.DEC_ATTRIBUTE5 ,dec.DEC_ATTRIBUTE6 ,dec.DEC_ATTRIBUTE7 ,dec.DEC_ATTRIBUTE8 ,dec.DEC_ATTRIBUTE9 ,dec.DEC_ATTRIBUTE10 ,dec.DEC_ATTRIBUTE11 ,dec.DEC_ATTRIBUTE12 ,dec.DEC_ATTRIBUTE13 ,dec.DEC_ATTRIBUTE14 ,dec.DEC_ATTRIBUTE15 ,dec.DEC_ATTRIBUTE16 ,dec.DEC_ATTRIBUTE17 ,dec.DEC_ATTRIBUTE18 ,dec.DEC_ATTRIBUTE19 ,dec.DEC_ATTRIBUTE20 ,dec.DEC_ATTRIBUTE21 ,dec.DEC_ATTRIBUTE22 ,dec.DEC_ATTRIBUTE23 ,dec.DEC_ATTRIBUTE24 ,dec.DEC_ATTRIBUTE25 ,dec.DEC_ATTRIBUTE26 ,dec.DEC_ATTRIBUTE27 ,dec.DEC_ATTRIBUTE28 ,dec.DEC_ATTRIBUTE29 ,dec.DEC_ATTRIBUTE30 ,dec.LAST_UPDATE_DATE ,dec.LAST_UPDATED_BY ,dec.LAST_UPDATE_LOGIN ,dec.CREATED_BY ,dec.CREATION_DATE ,dec.OBJECT_VERSION_NUMBER from BEN_DSGNTR_ENRLD_CVG_F dec, fnd_sessions se WHERE se.session_id = userenv('sessionid') and se.effective_date between dec.effective_start_date and dec.effective_end_date

View Text - HTML Formatted

SELECT DEC.ROWID ROW_ID
, DEC.DSGNTR_ENRLD_CVG_ID
, DEC.EFFECTIVE_START_DATE
, DEC.EFFECTIVE_END_DATE
, DEC.DSGNTR_CRNTLY_ENRLD_FLAG
, DEC.DPNT_CVG_ELIGY_PRFL_ID
, DEC.BUSINESS_GROUP_ID
, DEC.DEC_ATTRIBUTE_CATEGORY
, DEC.DEC_ATTRIBUTE1
, DEC.DEC_ATTRIBUTE2
, DEC.DEC_ATTRIBUTE3
, DEC.DEC_ATTRIBUTE4
, DEC.DEC_ATTRIBUTE5
, DEC.DEC_ATTRIBUTE6
, DEC.DEC_ATTRIBUTE7
, DEC.DEC_ATTRIBUTE8
, DEC.DEC_ATTRIBUTE9
, DEC.DEC_ATTRIBUTE10
, DEC.DEC_ATTRIBUTE11
, DEC.DEC_ATTRIBUTE12
, DEC.DEC_ATTRIBUTE13
, DEC.DEC_ATTRIBUTE14
, DEC.DEC_ATTRIBUTE15
, DEC.DEC_ATTRIBUTE16
, DEC.DEC_ATTRIBUTE17
, DEC.DEC_ATTRIBUTE18
, DEC.DEC_ATTRIBUTE19
, DEC.DEC_ATTRIBUTE20
, DEC.DEC_ATTRIBUTE21
, DEC.DEC_ATTRIBUTE22
, DEC.DEC_ATTRIBUTE23
, DEC.DEC_ATTRIBUTE24
, DEC.DEC_ATTRIBUTE25
, DEC.DEC_ATTRIBUTE26
, DEC.DEC_ATTRIBUTE27
, DEC.DEC_ATTRIBUTE28
, DEC.DEC_ATTRIBUTE29
, DEC.DEC_ATTRIBUTE30
, DEC.LAST_UPDATE_DATE
, DEC.LAST_UPDATED_BY
, DEC.LAST_UPDATE_LOGIN
, DEC.CREATED_BY
, DEC.CREATION_DATE
, DEC.OBJECT_VERSION_NUMBER
FROM BEN_DSGNTR_ENRLD_CVG_F DEC
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN DEC.EFFECTIVE_START_DATE
AND DEC.EFFECTIVE_END_DATE