VIEW: APPS.BEN_ELIG_LVG_RSN_PRTE_V

Source

View Text - Preformatted

SELECT elv.ROWID ROW_ID, elv.ELIG_LVG_RSN_PRTE_ID ,elv.EFFECTIVE_START_DATE ,elv.EFFECTIVE_END_DATE ,elv.EXCLD_FLAG ,elv.ORDR_NUM ,elv.LVG_RSN_CD ,elv.ELIGY_PRFL_ID ,elv.BUSINESS_GROUP_ID , elv.CRITERIA_SCORE , elv.CRITERIA_WEIGHT ,elv.ELV_ATTRIBUTE_CATEGORY ,elv.ELV_ATTRIBUTE1 ,elv.ELV_ATTRIBUTE2 ,elv.ELV_ATTRIBUTE3 ,elv.ELV_ATTRIBUTE4 ,elv.ELV_ATTRIBUTE5 ,elv.ELV_ATTRIBUTE6 ,elv.ELV_ATTRIBUTE7 ,elv.ELV_ATTRIBUTE8 ,elv.ELV_ATTRIBUTE9 ,elv.ELV_ATTRIBUTE10 ,elv.ELV_ATTRIBUTE11 ,elv.ELV_ATTRIBUTE12 ,elv.ELV_ATTRIBUTE13 ,elv.ELV_ATTRIBUTE14 ,elv.ELV_ATTRIBUTE15 ,elv.ELV_ATTRIBUTE16 ,elv.ELV_ATTRIBUTE17 ,elv.ELV_ATTRIBUTE18 ,elv.ELV_ATTRIBUTE19 ,elv.ELV_ATTRIBUTE20 ,elv.ELV_ATTRIBUTE21 ,elv.ELV_ATTRIBUTE22 ,elv.ELV_ATTRIBUTE23 ,elv.ELV_ATTRIBUTE24 ,elv.ELV_ATTRIBUTE25 ,elv.ELV_ATTRIBUTE26 ,elv.ELV_ATTRIBUTE27 ,elv.ELV_ATTRIBUTE28 ,elv.ELV_ATTRIBUTE29 ,elv.ELV_ATTRIBUTE30 ,elv.LAST_UPDATE_DATE ,elv.LAST_UPDATED_BY ,elv.LAST_UPDATE_LOGIN ,elv.CREATED_BY ,elv.CREATION_DATE ,elv.OBJECT_VERSION_NUMBER from BEN_ELIG_LVG_RSN_PRTE_F elv, fnd_sessions se WHERE se.session_id = userenv('sessionid') and se.effective_date between elv.effective_start_date and elv.effective_end_date

View Text - HTML Formatted

SELECT ELV.ROWID ROW_ID
, ELV.ELIG_LVG_RSN_PRTE_ID
, ELV.EFFECTIVE_START_DATE
, ELV.EFFECTIVE_END_DATE
, ELV.EXCLD_FLAG
, ELV.ORDR_NUM
, ELV.LVG_RSN_CD
, ELV.ELIGY_PRFL_ID
, ELV.BUSINESS_GROUP_ID
, ELV.CRITERIA_SCORE
, ELV.CRITERIA_WEIGHT
, ELV.ELV_ATTRIBUTE_CATEGORY
, ELV.ELV_ATTRIBUTE1
, ELV.ELV_ATTRIBUTE2
, ELV.ELV_ATTRIBUTE3
, ELV.ELV_ATTRIBUTE4
, ELV.ELV_ATTRIBUTE5
, ELV.ELV_ATTRIBUTE6
, ELV.ELV_ATTRIBUTE7
, ELV.ELV_ATTRIBUTE8
, ELV.ELV_ATTRIBUTE9
, ELV.ELV_ATTRIBUTE10
, ELV.ELV_ATTRIBUTE11
, ELV.ELV_ATTRIBUTE12
, ELV.ELV_ATTRIBUTE13
, ELV.ELV_ATTRIBUTE14
, ELV.ELV_ATTRIBUTE15
, ELV.ELV_ATTRIBUTE16
, ELV.ELV_ATTRIBUTE17
, ELV.ELV_ATTRIBUTE18
, ELV.ELV_ATTRIBUTE19
, ELV.ELV_ATTRIBUTE20
, ELV.ELV_ATTRIBUTE21
, ELV.ELV_ATTRIBUTE22
, ELV.ELV_ATTRIBUTE23
, ELV.ELV_ATTRIBUTE24
, ELV.ELV_ATTRIBUTE25
, ELV.ELV_ATTRIBUTE26
, ELV.ELV_ATTRIBUTE27
, ELV.ELV_ATTRIBUTE28
, ELV.ELV_ATTRIBUTE29
, ELV.ELV_ATTRIBUTE30
, ELV.LAST_UPDATE_DATE
, ELV.LAST_UPDATED_BY
, ELV.LAST_UPDATE_LOGIN
, ELV.CREATED_BY
, ELV.CREATION_DATE
, ELV.OBJECT_VERSION_NUMBER
FROM BEN_ELIG_LVG_RSN_PRTE_F ELV
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN ELV.EFFECTIVE_START_DATE
AND ELV.EFFECTIVE_END_DATE