VIEW: APPS.BEN_ELIG_QUAL_TITL_PRTE_V

Source

View Text - Preformatted

SELECT eqt.rowid ,elig_qual_titl_prte_id ,EFFECTIVE_START_DATE ,EFFECTIVE_END_DATE ,BUSINESS_GROUP_ID ,eligy_prfl_id ,excld_flag ,title ,ordr_num ,qualification_type_id , CRITERIA_SCORE , CRITERIA_WEIGHT ,eqt_ATTRIBUTE_CATEGORY ,eqt_ATTRIBUTE1 ,eqt_ATTRIBUTE2 ,eqt_ATTRIBUTE3 ,eqt_ATTRIBUTE4 ,eqt_ATTRIBUTE5 ,eqt_ATTRIBUTE6 ,eqt_ATTRIBUTE7 ,eqt_ATTRIBUTE8 ,eqt_ATTRIBUTE9 ,eqt_ATTRIBUTE10 ,eqt_ATTRIBUTE11 ,eqt_ATTRIBUTE12 ,eqt_ATTRIBUTE13 ,eqt_ATTRIBUTE14 ,eqt_ATTRIBUTE15 ,eqt_ATTRIBUTE16 ,eqt_ATTRIBUTE17 ,eqt_ATTRIBUTE18 ,eqt_ATTRIBUTE19 ,eqt_ATTRIBUTE20 ,eqt_ATTRIBUTE21 ,eqt_ATTRIBUTE22 ,eqt_ATTRIBUTE23 ,eqt_ATTRIBUTE24 ,eqt_ATTRIBUTE25 ,eqt_ATTRIBUTE26 ,eqt_ATTRIBUTE27 ,eqt_ATTRIBUTE28 ,eqt_ATTRIBUTE29 ,eqt_ATTRIBUTE30 ,LAST_UPDATE_DATE ,LAST_UPDATED_BY ,LAST_UPDATE_LOGIN ,CREATED_BY ,CREATION_DATE ,OBJECT_VERSION_NUMBER from ben_elig_qual_titl_prte_f eqt, fnd_sessions se WHERE se.session_id = userenv('sessionid') and se.effective_date between eqt.effective_start_date and eqt.effective_end_date

View Text - HTML Formatted

SELECT EQT.ROWID
, ELIG_QUAL_TITL_PRTE_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID
, ELIGY_PRFL_ID
, EXCLD_FLAG
, TITLE
, ORDR_NUM
, QUALIFICATION_TYPE_ID
, CRITERIA_SCORE
, CRITERIA_WEIGHT
, EQT_ATTRIBUTE_CATEGORY
, EQT_ATTRIBUTE1
, EQT_ATTRIBUTE2
, EQT_ATTRIBUTE3
, EQT_ATTRIBUTE4
, EQT_ATTRIBUTE5
, EQT_ATTRIBUTE6
, EQT_ATTRIBUTE7
, EQT_ATTRIBUTE8
, EQT_ATTRIBUTE9
, EQT_ATTRIBUTE10
, EQT_ATTRIBUTE11
, EQT_ATTRIBUTE12
, EQT_ATTRIBUTE13
, EQT_ATTRIBUTE14
, EQT_ATTRIBUTE15
, EQT_ATTRIBUTE16
, EQT_ATTRIBUTE17
, EQT_ATTRIBUTE18
, EQT_ATTRIBUTE19
, EQT_ATTRIBUTE20
, EQT_ATTRIBUTE21
, EQT_ATTRIBUTE22
, EQT_ATTRIBUTE23
, EQT_ATTRIBUTE24
, EQT_ATTRIBUTE25
, EQT_ATTRIBUTE26
, EQT_ATTRIBUTE27
, EQT_ATTRIBUTE28
, EQT_ATTRIBUTE29
, EQT_ATTRIBUTE30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
FROM BEN_ELIG_QUAL_TITL_PRTE_F EQT
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN EQT.EFFECTIVE_START_DATE
AND EQT.EFFECTIVE_END_DATE