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_PTIP_ENRT_F#

Source

View Text - Preformatted


select LER_CHG_PTIP_ENRT_ID LER_CHG_PTIP_ENRT_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, CRNT_ENRT_PRCLDS_CHG_FLAG CRNT_ENRT_PRCLDS_CHG_FLAG, STL_ELIG_CANT_CHG_FLAG STL_ELIG_CANT_CHG_FLAG, DFLT_FLAG DFLT_FLAG, PTIP_ID PTIP_ID, LER_ID LER_ID, LCT_ATTRIBUTE_CATEGORY LCT_ATTRIBUTE_CATEGORY, LCT_ATTRIBUTE1 LCT_ATTRIBUTE1, LCT_ATTRIBUTE2 LCT_ATTRIBUTE2, LCT_ATTRIBUTE3 LCT_ATTRIBUTE3, LCT_ATTRIBUTE4 LCT_ATTRIBUTE4, LCT_ATTRIBUTE5 LCT_ATTRIBUTE5, LCT_ATTRIBUTE6 LCT_ATTRIBUTE6, LCT_ATTRIBUTE7 LCT_ATTRIBUTE7, LCT_ATTRIBUTE8 LCT_ATTRIBUTE8, LCT_ATTRIBUTE9 LCT_ATTRIBUTE9, LCT_ATTRIBUTE10 LCT_ATTRIBUTE10, LCT_ATTRIBUTE11 LCT_ATTRIBUTE11, LCT_ATTRIBUTE12 LCT_ATTRIBUTE12, LCT_ATTRIBUTE13 LCT_ATTRIBUTE13, LCT_ATTRIBUTE14 LCT_ATTRIBUTE14, LCT_ATTRIBUTE15 LCT_ATTRIBUTE15, LCT_ATTRIBUTE16 LCT_ATTRIBUTE16, LCT_ATTRIBUTE17 LCT_ATTRIBUTE17, LCT_ATTRIBUTE18 LCT_ATTRIBUTE18, LCT_ATTRIBUTE19 LCT_ATTRIBUTE19, LCT_ATTRIBUTE20 LCT_ATTRIBUTE20, LCT_ATTRIBUTE21 LCT_ATTRIBUTE21, LCT_ATTRIBUTE22 LCT_ATTRIBUTE22, LCT_ATTRIBUTE23 LCT_ATTRIBUTE23, LCT_ATTRIBUTE24 LCT_ATTRIBUTE24, LCT_ATTRIBUTE25 LCT_ATTRIBUTE25, LCT_ATTRIBUTE26 LCT_ATTRIBUTE26, LCT_ATTRIBUTE27 LCT_ATTRIBUTE27, LCT_ATTRIBUTE28 LCT_ATTRIBUTE28, LCT_ATTRIBUTE29 LCT_ATTRIBUTE29, LCT_ATTRIBUTE30 LCT_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, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, DFLT_ENRT_CD DFLT_ENRT_CD, DFLT_ENRT_RL DFLT_ENRT_RL, ENRT_CD ENRT_CD, ENRT_MTHD_CD ENRT_MTHD_CD, ENRT_RL ENRT_RL, TCO_CHG_ENRT_CD TCO_CHG_ENRT_CD from "BEN"."BEN_LER_CHG_PTIP_ENRT_F"

View Text - HTML Formatted

SELECT LER_CHG_PTIP_ENRT_ID LER_CHG_PTIP_ENRT_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, CRNT_ENRT_PRCLDS_CHG_FLAG CRNT_ENRT_PRCLDS_CHG_FLAG
, STL_ELIG_CANT_CHG_FLAG STL_ELIG_CANT_CHG_FLAG
, DFLT_FLAG DFLT_FLAG
, PTIP_ID PTIP_ID
, LER_ID LER_ID
, LCT_ATTRIBUTE_CATEGORY LCT_ATTRIBUTE_CATEGORY
, LCT_ATTRIBUTE1 LCT_ATTRIBUTE1
, LCT_ATTRIBUTE2 LCT_ATTRIBUTE2
, LCT_ATTRIBUTE3 LCT_ATTRIBUTE3
, LCT_ATTRIBUTE4 LCT_ATTRIBUTE4
, LCT_ATTRIBUTE5 LCT_ATTRIBUTE5
, LCT_ATTRIBUTE6 LCT_ATTRIBUTE6
, LCT_ATTRIBUTE7 LCT_ATTRIBUTE7
, LCT_ATTRIBUTE8 LCT_ATTRIBUTE8
, LCT_ATTRIBUTE9 LCT_ATTRIBUTE9
, LCT_ATTRIBUTE10 LCT_ATTRIBUTE10
, LCT_ATTRIBUTE11 LCT_ATTRIBUTE11
, LCT_ATTRIBUTE12 LCT_ATTRIBUTE12
, LCT_ATTRIBUTE13 LCT_ATTRIBUTE13
, LCT_ATTRIBUTE14 LCT_ATTRIBUTE14
, LCT_ATTRIBUTE15 LCT_ATTRIBUTE15
, LCT_ATTRIBUTE16 LCT_ATTRIBUTE16
, LCT_ATTRIBUTE17 LCT_ATTRIBUTE17
, LCT_ATTRIBUTE18 LCT_ATTRIBUTE18
, LCT_ATTRIBUTE19 LCT_ATTRIBUTE19
, LCT_ATTRIBUTE20 LCT_ATTRIBUTE20
, LCT_ATTRIBUTE21 LCT_ATTRIBUTE21
, LCT_ATTRIBUTE22 LCT_ATTRIBUTE22
, LCT_ATTRIBUTE23 LCT_ATTRIBUTE23
, LCT_ATTRIBUTE24 LCT_ATTRIBUTE24
, LCT_ATTRIBUTE25 LCT_ATTRIBUTE25
, LCT_ATTRIBUTE26 LCT_ATTRIBUTE26
, LCT_ATTRIBUTE27 LCT_ATTRIBUTE27
, LCT_ATTRIBUTE28 LCT_ATTRIBUTE28
, LCT_ATTRIBUTE29 LCT_ATTRIBUTE29
, LCT_ATTRIBUTE30 LCT_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
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, DFLT_ENRT_CD DFLT_ENRT_CD
, DFLT_ENRT_RL DFLT_ENRT_RL
, ENRT_CD ENRT_CD
, ENRT_MTHD_CD ENRT_MTHD_CD
, ENRT_RL ENRT_RL
, TCO_CHG_ENRT_CD TCO_CHG_ENRT_CD
FROM "BEN"."BEN_LER_CHG_PTIP_ENRT_F"