eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: BEN.BEN_LER_CHG_DPNT_CVG_CTFN_F#

Source

View Text - Preformatted


select LER_CHG_DPNT_CVG_CTFN_ID LER_CHG_DPNT_CVG_CTFN_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, DPNT_CVG_CTFN_TYP_CD DPNT_CVG_CTFN_TYP_CD, LACK_CTFN_SSPND_ENRT_FLAG LACK_CTFN_SSPND_ENRT_FLAG, RQD_FLAG RQD_FLAG, LCC_ATTRIBUTE_CATEGORY LCC_ATTRIBUTE_CATEGORY, LCC_ATTRIBUTE1 LCC_ATTRIBUTE1, LCC_ATTRIBUTE2 LCC_ATTRIBUTE2, LCC_ATTRIBUTE3 LCC_ATTRIBUTE3, LCC_ATTRIBUTE4 LCC_ATTRIBUTE4, LCC_ATTRIBUTE5 LCC_ATTRIBUTE5, LCC_ATTRIBUTE6 LCC_ATTRIBUTE6, LCC_ATTRIBUTE7 LCC_ATTRIBUTE7, LCC_ATTRIBUTE8 LCC_ATTRIBUTE8, LCC_ATTRIBUTE9 LCC_ATTRIBUTE9, LCC_ATTRIBUTE10 LCC_ATTRIBUTE10, LCC_ATTRIBUTE11 LCC_ATTRIBUTE11, LCC_ATTRIBUTE12 LCC_ATTRIBUTE12, LCC_ATTRIBUTE13 LCC_ATTRIBUTE13, LCC_ATTRIBUTE14 LCC_ATTRIBUTE14, LCC_ATTRIBUTE15 LCC_ATTRIBUTE15, LCC_ATTRIBUTE16 LCC_ATTRIBUTE16, LCC_ATTRIBUTE17 LCC_ATTRIBUTE17, LCC_ATTRIBUTE18 LCC_ATTRIBUTE18, LCC_ATTRIBUTE19 LCC_ATTRIBUTE19, LCC_ATTRIBUTE20 LCC_ATTRIBUTE20, LCC_ATTRIBUTE21 LCC_ATTRIBUTE21, LCC_ATTRIBUTE22 LCC_ATTRIBUTE22, LCC_ATTRIBUTE23 LCC_ATTRIBUTE23, LCC_ATTRIBUTE24 LCC_ATTRIBUTE24, LCC_ATTRIBUTE25 LCC_ATTRIBUTE25, LCC_ATTRIBUTE26 LCC_ATTRIBUTE26, LCC_ATTRIBUTE27 LCC_ATTRIBUTE27, LCC_ATTRIBUTE28 LCC_ATTRIBUTE28, LCC_ATTRIBUTE29 LCC_ATTRIBUTE29, LCC_ATTRIBUTE30 LCC_ATTRIBUTE30, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, LER_CHG_DPNT_CVG_ID LER_CHG_DPNT_CVG_ID, RLSHP_TYP_CD RLSHP_TYP_CD, CTFN_RQD_WHEN_RL CTFN_RQD_WHEN_RL from "BEN"."BEN_LER_CHG_DPNT_CVG_CTFN_F"

View Text - HTML Formatted

SELECT LER_CHG_DPNT_CVG_CTFN_ID LER_CHG_DPNT_CVG_CTFN_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, DPNT_CVG_CTFN_TYP_CD DPNT_CVG_CTFN_TYP_CD
, LACK_CTFN_SSPND_ENRT_FLAG LACK_CTFN_SSPND_ENRT_FLAG
, RQD_FLAG RQD_FLAG
, LCC_ATTRIBUTE_CATEGORY LCC_ATTRIBUTE_CATEGORY
, LCC_ATTRIBUTE1 LCC_ATTRIBUTE1
, LCC_ATTRIBUTE2 LCC_ATTRIBUTE2
, LCC_ATTRIBUTE3 LCC_ATTRIBUTE3
, LCC_ATTRIBUTE4 LCC_ATTRIBUTE4
, LCC_ATTRIBUTE5 LCC_ATTRIBUTE5
, LCC_ATTRIBUTE6 LCC_ATTRIBUTE6
, LCC_ATTRIBUTE7 LCC_ATTRIBUTE7
, LCC_ATTRIBUTE8 LCC_ATTRIBUTE8
, LCC_ATTRIBUTE9 LCC_ATTRIBUTE9
, LCC_ATTRIBUTE10 LCC_ATTRIBUTE10
, LCC_ATTRIBUTE11 LCC_ATTRIBUTE11
, LCC_ATTRIBUTE12 LCC_ATTRIBUTE12
, LCC_ATTRIBUTE13 LCC_ATTRIBUTE13
, LCC_ATTRIBUTE14 LCC_ATTRIBUTE14
, LCC_ATTRIBUTE15 LCC_ATTRIBUTE15
, LCC_ATTRIBUTE16 LCC_ATTRIBUTE16
, LCC_ATTRIBUTE17 LCC_ATTRIBUTE17
, LCC_ATTRIBUTE18 LCC_ATTRIBUTE18
, LCC_ATTRIBUTE19 LCC_ATTRIBUTE19
, LCC_ATTRIBUTE20 LCC_ATTRIBUTE20
, LCC_ATTRIBUTE21 LCC_ATTRIBUTE21
, LCC_ATTRIBUTE22 LCC_ATTRIBUTE22
, LCC_ATTRIBUTE23 LCC_ATTRIBUTE23
, LCC_ATTRIBUTE24 LCC_ATTRIBUTE24
, LCC_ATTRIBUTE25 LCC_ATTRIBUTE25
, LCC_ATTRIBUTE26 LCC_ATTRIBUTE26
, LCC_ATTRIBUTE27 LCC_ATTRIBUTE27
, LCC_ATTRIBUTE28 LCC_ATTRIBUTE28
, LCC_ATTRIBUTE29 LCC_ATTRIBUTE29
, LCC_ATTRIBUTE30 LCC_ATTRIBUTE30
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, LER_CHG_DPNT_CVG_ID LER_CHG_DPNT_CVG_ID
, RLSHP_TYP_CD RLSHP_TYP_CD
, CTFN_RQD_WHEN_RL CTFN_RQD_WHEN_RL
FROM "BEN"."BEN_LER_CHG_DPNT_CVG_CTFN_F"