VIEW: APPS.BEN_ELIG_DSBLTY_RSN_PRTE_V

Source

View Text - Preformatted

SELECT edr.rowid row_id ,elig_dsblty_rsn_prte_id ,EFFECTIVE_START_DATE ,EFFECTIVE_END_DATE ,BUSINESS_GROUP_ID ,eligy_prfl_id ,excld_flag ,reason ,ordr_num ,EDR.CRITERIA_SCORE ,EDR.CRITERIA_WEIGHT ,edr_ATTRIBUTE_CATEGORY ,edr_ATTRIBUTE1 ,edr_ATTRIBUTE2 ,edr_ATTRIBUTE3 ,edr_ATTRIBUTE4 ,edr_ATTRIBUTE5 ,edr_ATTRIBUTE6 ,edr_ATTRIBUTE7 ,edr_ATTRIBUTE8 ,edr_ATTRIBUTE9 ,edr_ATTRIBUTE10 ,edr_ATTRIBUTE11 ,edr_ATTRIBUTE12 ,edr_ATTRIBUTE13 ,edr_ATTRIBUTE14 ,edr_ATTRIBUTE15 ,edr_ATTRIBUTE16 ,edr_ATTRIBUTE17 ,edr_ATTRIBUTE18 ,edr_ATTRIBUTE19 ,edr_ATTRIBUTE20 ,edr_ATTRIBUTE21 ,edr_ATTRIBUTE22 ,edr_ATTRIBUTE23 ,edr_ATTRIBUTE24 ,edr_ATTRIBUTE25 ,edr_ATTRIBUTE26 ,edr_ATTRIBUTE27 ,edr_ATTRIBUTE28 ,edr_ATTRIBUTE29 ,edr_ATTRIBUTE30 ,LAST_UPDATE_DATE ,LAST_UPDATED_BY ,LAST_UPDATE_LOGIN ,CREATED_BY ,CREATION_DATE ,OBJECT_VERSION_NUMBER from ben_elig_dsblty_rsn_prte_f edr, 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 EDR.ROWID ROW_ID
, ELIG_DSBLTY_RSN_PRTE_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID
, ELIGY_PRFL_ID
, EXCLD_FLAG
, REASON
, ORDR_NUM
, EDR.CRITERIA_SCORE
, EDR.CRITERIA_WEIGHT
, EDR_ATTRIBUTE_CATEGORY
, EDR_ATTRIBUTE1
, EDR_ATTRIBUTE2
, EDR_ATTRIBUTE3
, EDR_ATTRIBUTE4
, EDR_ATTRIBUTE5
, EDR_ATTRIBUTE6
, EDR_ATTRIBUTE7
, EDR_ATTRIBUTE8
, EDR_ATTRIBUTE9
, EDR_ATTRIBUTE10
, EDR_ATTRIBUTE11
, EDR_ATTRIBUTE12
, EDR_ATTRIBUTE13
, EDR_ATTRIBUTE14
, EDR_ATTRIBUTE15
, EDR_ATTRIBUTE16
, EDR_ATTRIBUTE17
, EDR_ATTRIBUTE18
, EDR_ATTRIBUTE19
, EDR_ATTRIBUTE20
, EDR_ATTRIBUTE21
, EDR_ATTRIBUTE22
, EDR_ATTRIBUTE23
, EDR_ATTRIBUTE24
, EDR_ATTRIBUTE25
, EDR_ATTRIBUTE26
, EDR_ATTRIBUTE27
, EDR_ATTRIBUTE28
, EDR_ATTRIBUTE29
, EDR_ATTRIBUTE30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
FROM BEN_ELIG_DSBLTY_RSN_PRTE_F EDR
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND EFFECTIVE_DATE BETWEEN EFFECTIVE_START_DATE
AND EFFECTIVE_END_DATE