VIEW: APPS.BEN_ENRLD_ANTHR_PLIP_RT_V

Source

View Text - Preformatted

SELECT EAR.ROWID ROW_ID, EAR.ENRLD_ANTHR_PLIP_RT_ID ,EAR.EFFECTIVE_START_DATE , EAR.EFFECTIVE_END_DATE ,EAR.EXCLD_FLAG ,EAR.ENRL_DET_DT_CD ,EAR.ORDR_NUM ,EAR.PLIP_ID , EAR.VRBL_RT_PRFL_ID ,EAR.BUSINESS_GROUP_ID ,EAR.EAR_ATTRIBUTE_CATEGORY ,EAR.EAR_ATTRIBUTE1 , EAR.EAR_ATTRIBUTE2 ,EAR.EAR_ATTRIBUTE3 ,EAR.EAR_ATTRIBUTE4 ,EAR.EAR_ATTRIBUTE5 , EAR.EAR_ATTRIBUTE6 ,EAR.EAR_ATTRIBUTE7 ,EAR.EAR_ATTRIBUTE8 ,EAR.EAR_ATTRIBUTE9 , EAR.EAR_ATTRIBUTE10 ,EAR.EAR_ATTRIBUTE11 ,EAR.EAR_ATTRIBUTE12 ,EAR.EAR_ATTRIBUTE13 , EAR.EAR_ATTRIBUTE14 ,EAR.EAR_ATTRIBUTE15 ,EAR.EAR_ATTRIBUTE16 ,EAR.EAR_ATTRIBUTE17 , EAR.EAR_ATTRIBUTE18 ,EAR.EAR_ATTRIBUTE19 ,EAR.EAR_ATTRIBUTE20 ,EAR.EAR_ATTRIBUTE21 , EAR.EAR_ATTRIBUTE22 ,EAR.EAR_ATTRIBUTE23 ,EAR.EAR_ATTRIBUTE24 ,EAR.EAR_ATTRIBUTE25 , EAR.EAR_ATTRIBUTE26 ,EAR.EAR_ATTRIBUTE27 ,EAR.EAR_ATTRIBUTE28 ,EAR.EAR_ATTRIBUTE29 , EAR.EAR_ATTRIBUTE30 ,EAR.LAST_UPDATE_DATE ,EAR.LAST_UPDATED_BY ,EAR.LAST_UPDATE_LOGIN , EAR.CREATED_BY ,EAR.CREATION_DATE ,EAR.OBJECT_VERSION_NUMBER FROM BEN_ENRLD_ANTHR_PLIP_RT_F ear, fnd_sessions se WHERE se.session_id = USERENV('sessionid') AND se.effective_date BETWEEN EAR.effective_start_date AND EAR.effective_end_date

View Text - HTML Formatted

SELECT EAR.ROWID ROW_ID
, EAR.ENRLD_ANTHR_PLIP_RT_ID
, EAR.EFFECTIVE_START_DATE
, EAR.EFFECTIVE_END_DATE
, EAR.EXCLD_FLAG
, EAR.ENRL_DET_DT_CD
, EAR.ORDR_NUM
, EAR.PLIP_ID
, EAR.VRBL_RT_PRFL_ID
, EAR.BUSINESS_GROUP_ID
, EAR.EAR_ATTRIBUTE_CATEGORY
, EAR.EAR_ATTRIBUTE1
, EAR.EAR_ATTRIBUTE2
, EAR.EAR_ATTRIBUTE3
, EAR.EAR_ATTRIBUTE4
, EAR.EAR_ATTRIBUTE5
, EAR.EAR_ATTRIBUTE6
, EAR.EAR_ATTRIBUTE7
, EAR.EAR_ATTRIBUTE8
, EAR.EAR_ATTRIBUTE9
, EAR.EAR_ATTRIBUTE10
, EAR.EAR_ATTRIBUTE11
, EAR.EAR_ATTRIBUTE12
, EAR.EAR_ATTRIBUTE13
, EAR.EAR_ATTRIBUTE14
, EAR.EAR_ATTRIBUTE15
, EAR.EAR_ATTRIBUTE16
, EAR.EAR_ATTRIBUTE17
, EAR.EAR_ATTRIBUTE18
, EAR.EAR_ATTRIBUTE19
, EAR.EAR_ATTRIBUTE20
, EAR.EAR_ATTRIBUTE21
, EAR.EAR_ATTRIBUTE22
, EAR.EAR_ATTRIBUTE23
, EAR.EAR_ATTRIBUTE24
, EAR.EAR_ATTRIBUTE25
, EAR.EAR_ATTRIBUTE26
, EAR.EAR_ATTRIBUTE27
, EAR.EAR_ATTRIBUTE28
, EAR.EAR_ATTRIBUTE29
, EAR.EAR_ATTRIBUTE30
, EAR.LAST_UPDATE_DATE
, EAR.LAST_UPDATED_BY
, EAR.LAST_UPDATE_LOGIN
, EAR.CREATED_BY
, EAR.CREATION_DATE
, EAR.OBJECT_VERSION_NUMBER
FROM BEN_ENRLD_ANTHR_PLIP_RT_F EAR
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN EAR.EFFECTIVE_START_DATE
AND EAR.EFFECTIVE_END_DATE