VIEW: APPS.BEN_ELIG_LOS_PRTE_V

Source

View Text - Preformatted

SELECT ELS.ROWID ROW_ID , ELS.ELIG_LOS_PRTE_ID , ELS.EFFECTIVE_START_DATE , ELS.EFFECTIVE_END_DATE , ELS.BUSINESS_GROUP_ID , ELS.LOS_FCTR_ID , ELS.ELIGY_PRFL_ID , ELS.ORDR_NUM , ELS.EXCLD_FLAG , ELS.CRITERIA_SCORE , ELS.CRITERIA_WEIGHT , ELS.ELS_ATTRIBUTE_CATEGORY , ELS.ELS_ATTRIBUTE1 , ELS.ELS_ATTRIBUTE2 , ELS.ELS_ATTRIBUTE3 , ELS.ELS_ATTRIBUTE4 , ELS.ELS_ATTRIBUTE5 , ELS.ELS_ATTRIBUTE6 , ELS.ELS_ATTRIBUTE7 , ELS.ELS_ATTRIBUTE8 , ELS.ELS_ATTRIBUTE9 , ELS.ELS_ATTRIBUTE10 , ELS.ELS_ATTRIBUTE11 , ELS.ELS_ATTRIBUTE12 , ELS.ELS_ATTRIBUTE13 , ELS.ELS_ATTRIBUTE14 , ELS.ELS_ATTRIBUTE15 , ELS.ELS_ATTRIBUTE16 , ELS.ELS_ATTRIBUTE17 , ELS.ELS_ATTRIBUTE18 , ELS.ELS_ATTRIBUTE19 , ELS.ELS_ATTRIBUTE20 , ELS.ELS_ATTRIBUTE21 , ELS.ELS_ATTRIBUTE22 , ELS.ELS_ATTRIBUTE23 , ELS.ELS_ATTRIBUTE24 , ELS.ELS_ATTRIBUTE25 , ELS.ELS_ATTRIBUTE26 , ELS.ELS_ATTRIBUTE27 , ELS.ELS_ATTRIBUTE28 , ELS.ELS_ATTRIBUTE29 , ELS.ELS_ATTRIBUTE30 , ELS.LAST_UPDATE_DATE , ELS.LAST_UPDATED_BY , ELS.LAST_UPDATE_LOGIN , ELS.CREATED_BY , ELS.CREATION_DATE , ELS.OBJECT_VERSION_NUMBER FROM BEN_ELIG_LOS_PRTE_F ELS, FND_SESSIONS SE WHERE SE.SESSION_ID = USERENV('sessionid') AND SE.EFFECTIVE_DATE BETWEEN ELS.EFFECTIVE_START_DATE AND ELS.EFFECTIVE_END_DATE

View Text - HTML Formatted

SELECT ELS.ROWID ROW_ID
, ELS.ELIG_LOS_PRTE_ID
, ELS.EFFECTIVE_START_DATE
, ELS.EFFECTIVE_END_DATE
, ELS.BUSINESS_GROUP_ID
, ELS.LOS_FCTR_ID
, ELS.ELIGY_PRFL_ID
, ELS.ORDR_NUM
, ELS.EXCLD_FLAG
, ELS.CRITERIA_SCORE
, ELS.CRITERIA_WEIGHT
, ELS.ELS_ATTRIBUTE_CATEGORY
, ELS.ELS_ATTRIBUTE1
, ELS.ELS_ATTRIBUTE2
, ELS.ELS_ATTRIBUTE3
, ELS.ELS_ATTRIBUTE4
, ELS.ELS_ATTRIBUTE5
, ELS.ELS_ATTRIBUTE6
, ELS.ELS_ATTRIBUTE7
, ELS.ELS_ATTRIBUTE8
, ELS.ELS_ATTRIBUTE9
, ELS.ELS_ATTRIBUTE10
, ELS.ELS_ATTRIBUTE11
, ELS.ELS_ATTRIBUTE12
, ELS.ELS_ATTRIBUTE13
, ELS.ELS_ATTRIBUTE14
, ELS.ELS_ATTRIBUTE15
, ELS.ELS_ATTRIBUTE16
, ELS.ELS_ATTRIBUTE17
, ELS.ELS_ATTRIBUTE18
, ELS.ELS_ATTRIBUTE19
, ELS.ELS_ATTRIBUTE20
, ELS.ELS_ATTRIBUTE21
, ELS.ELS_ATTRIBUTE22
, ELS.ELS_ATTRIBUTE23
, ELS.ELS_ATTRIBUTE24
, ELS.ELS_ATTRIBUTE25
, ELS.ELS_ATTRIBUTE26
, ELS.ELS_ATTRIBUTE27
, ELS.ELS_ATTRIBUTE28
, ELS.ELS_ATTRIBUTE29
, ELS.ELS_ATTRIBUTE30
, ELS.LAST_UPDATE_DATE
, ELS.LAST_UPDATED_BY
, ELS.LAST_UPDATE_LOGIN
, ELS.CREATED_BY
, ELS.CREATION_DATE
, ELS.OBJECT_VERSION_NUMBER
FROM BEN_ELIG_LOS_PRTE_F ELS
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN ELS.EFFECTIVE_START_DATE
AND ELS.EFFECTIVE_END_DATE