VIEW: APPS.BEN_ELIG_DSBLTY_DGR_PRTE_V

Source

View Text - Preformatted

SELECT edd.rowid row_id ,elig_dsblty_dgr_prte_id ,EFFECTIVE_START_DATE ,EFFECTIVE_END_DATE ,BUSINESS_GROUP_ID ,eligy_prfl_id ,excld_flag ,degree ,ordr_num ,EDD.CRITERIA_SCORE ,EDD.CRITERIA_WEIGHT ,edd_ATTRIBUTE_CATEGORY ,edd_ATTRIBUTE1 ,edd_ATTRIBUTE2 ,edd_ATTRIBUTE3 ,edd_ATTRIBUTE4 ,edd_ATTRIBUTE5 ,edd_ATTRIBUTE6 ,edd_ATTRIBUTE7 ,edd_ATTRIBUTE8 ,edd_ATTRIBUTE9 ,edd_ATTRIBUTE10 ,edd_ATTRIBUTE11 ,edd_ATTRIBUTE12 ,edd_ATTRIBUTE13 ,edd_ATTRIBUTE14 ,edd_ATTRIBUTE15 ,edd_ATTRIBUTE16 ,edd_ATTRIBUTE17 ,edd_ATTRIBUTE18 ,edd_ATTRIBUTE19 ,edd_ATTRIBUTE20 ,edd_ATTRIBUTE21 ,edd_ATTRIBUTE22 ,edd_ATTRIBUTE23 ,edd_ATTRIBUTE24 ,edd_ATTRIBUTE25 ,edd_ATTRIBUTE26 ,edd_ATTRIBUTE27 ,edd_ATTRIBUTE28 ,edd_ATTRIBUTE29 ,edd_ATTRIBUTE30 ,LAST_UPDATE_DATE ,LAST_UPDATED_BY ,LAST_UPDATE_LOGIN ,CREATED_BY ,CREATION_DATE ,OBJECT_VERSION_NUMBER from ben_elig_dsblty_dgr_prte_f edd, fnd_sessions se WHERE se.session_id = userenv('sessionid') and effective_date between effective_start_date and effective_end_date

View Text - HTML Formatted

SELECT EDD.ROWID ROW_ID
, ELIG_DSBLTY_DGR_PRTE_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID
, ELIGY_PRFL_ID
, EXCLD_FLAG
, DEGREE
, ORDR_NUM
, EDD.CRITERIA_SCORE
, EDD.CRITERIA_WEIGHT
, EDD_ATTRIBUTE_CATEGORY
, EDD_ATTRIBUTE1
, EDD_ATTRIBUTE2
, EDD_ATTRIBUTE3
, EDD_ATTRIBUTE4
, EDD_ATTRIBUTE5
, EDD_ATTRIBUTE6
, EDD_ATTRIBUTE7
, EDD_ATTRIBUTE8
, EDD_ATTRIBUTE9
, EDD_ATTRIBUTE10
, EDD_ATTRIBUTE11
, EDD_ATTRIBUTE12
, EDD_ATTRIBUTE13
, EDD_ATTRIBUTE14
, EDD_ATTRIBUTE15
, EDD_ATTRIBUTE16
, EDD_ATTRIBUTE17
, EDD_ATTRIBUTE18
, EDD_ATTRIBUTE19
, EDD_ATTRIBUTE20
, EDD_ATTRIBUTE21
, EDD_ATTRIBUTE22
, EDD_ATTRIBUTE23
, EDD_ATTRIBUTE24
, EDD_ATTRIBUTE25
, EDD_ATTRIBUTE26
, EDD_ATTRIBUTE27
, EDD_ATTRIBUTE28
, EDD_ATTRIBUTE29
, EDD_ATTRIBUTE30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
FROM BEN_ELIG_DSBLTY_DGR_PRTE_F EDD
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND EFFECTIVE_DATE BETWEEN EFFECTIVE_START_DATE
AND EFFECTIVE_END_DATE