VIEW: APPS.BEN_LER_ENRT_CTFN_V

Source

View Text - Preformatted

SELECT lnc.ROWID ROW_ID, lnc.LER_ENRT_CTFN_ID ,lnc.EFFECTIVE_START_DATE ,lnc.EFFECTIVE_END_DATE ,lnc.RQD_FLAG ,lnc.ENRT_CTFN_TYP_CD ,lnc.CTFN_RQD_WHEN_RL ,lnc.LER_RQRS_ENRT_CTFN_ID ,lnc.BUSINESS_GROUP_ID ,lnc.LNC_ATTRIBUTE_CATEGORY ,lnc.LNC_ATTRIBUTE1 ,lnc.LNC_ATTRIBUTE2 ,lnc.LNC_ATTRIBUTE3 ,lnc.LNC_ATTRIBUTE4 ,lnc.LNC_ATTRIBUTE5 ,lnc.LNC_ATTRIBUTE6 ,lnc.LNC_ATTRIBUTE7 ,lnc.LNC_ATTRIBUTE8 ,lnc.LNC_ATTRIBUTE9 ,lnc.LNC_ATTRIBUTE10 ,lnc.LNC_ATTRIBUTE11 ,lnc.LNC_ATTRIBUTE12 ,lnc.LNC_ATTRIBUTE13 ,lnc.LNC_ATTRIBUTE14 ,lnc.LNC_ATTRIBUTE15 ,lnc.LNC_ATTRIBUTE16 ,lnc.LNC_ATTRIBUTE17 ,lnc.LNC_ATTRIBUTE18 ,lnc.LNC_ATTRIBUTE19 ,lnc.LNC_ATTRIBUTE20 ,lnc.LNC_ATTRIBUTE21 ,lnc.LNC_ATTRIBUTE22 ,lnc.LNC_ATTRIBUTE23 ,lnc.LNC_ATTRIBUTE24 ,lnc.LNC_ATTRIBUTE25 ,lnc.LNC_ATTRIBUTE26 ,lnc.LNC_ATTRIBUTE27 ,lnc.LNC_ATTRIBUTE28 ,lnc.LNC_ATTRIBUTE29 ,lnc.LNC_ATTRIBUTE30 ,lnc.LAST_UPDATE_DATE ,lnc.LAST_UPDATED_BY ,lnc.LAST_UPDATE_LOGIN ,lnc.CREATED_BY ,lnc.CREATION_DATE ,lnc.OBJECT_VERSION_NUMBER from BEN_LER_ENRT_CTFN_F lnc, fnd_sessions se WHERE se.session_id = userenv('sessionid') and se.effective_date between lnc.effective_start_date and lnc.effective_end_date

View Text - HTML Formatted

SELECT LNC.ROWID ROW_ID
, LNC.LER_ENRT_CTFN_ID
, LNC.EFFECTIVE_START_DATE
, LNC.EFFECTIVE_END_DATE
, LNC.RQD_FLAG
, LNC.ENRT_CTFN_TYP_CD
, LNC.CTFN_RQD_WHEN_RL
, LNC.LER_RQRS_ENRT_CTFN_ID
, LNC.BUSINESS_GROUP_ID
, LNC.LNC_ATTRIBUTE_CATEGORY
, LNC.LNC_ATTRIBUTE1
, LNC.LNC_ATTRIBUTE2
, LNC.LNC_ATTRIBUTE3
, LNC.LNC_ATTRIBUTE4
, LNC.LNC_ATTRIBUTE5
, LNC.LNC_ATTRIBUTE6
, LNC.LNC_ATTRIBUTE7
, LNC.LNC_ATTRIBUTE8
, LNC.LNC_ATTRIBUTE9
, LNC.LNC_ATTRIBUTE10
, LNC.LNC_ATTRIBUTE11
, LNC.LNC_ATTRIBUTE12
, LNC.LNC_ATTRIBUTE13
, LNC.LNC_ATTRIBUTE14
, LNC.LNC_ATTRIBUTE15
, LNC.LNC_ATTRIBUTE16
, LNC.LNC_ATTRIBUTE17
, LNC.LNC_ATTRIBUTE18
, LNC.LNC_ATTRIBUTE19
, LNC.LNC_ATTRIBUTE20
, LNC.LNC_ATTRIBUTE21
, LNC.LNC_ATTRIBUTE22
, LNC.LNC_ATTRIBUTE23
, LNC.LNC_ATTRIBUTE24
, LNC.LNC_ATTRIBUTE25
, LNC.LNC_ATTRIBUTE26
, LNC.LNC_ATTRIBUTE27
, LNC.LNC_ATTRIBUTE28
, LNC.LNC_ATTRIBUTE29
, LNC.LNC_ATTRIBUTE30
, LNC.LAST_UPDATE_DATE
, LNC.LAST_UPDATED_BY
, LNC.LAST_UPDATE_LOGIN
, LNC.CREATED_BY
, LNC.CREATION_DATE
, LNC.OBJECT_VERSION_NUMBER
FROM BEN_LER_ENRT_CTFN_F LNC
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN LNC.EFFECTIVE_START_DATE
AND LNC.EFFECTIVE_END_DATE