VIEW: BEN.BEN_LER_CHG_PL_NIP_ENRT_F#

Source

View Text - Preformatted

select LER_CHG_PL_NIP_ENRT_ID LER_CHG_PL_NIP_ENRT_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, TCO_CHG_ENRT_CD TCO_CHG_ENRT_CD, CRNT_ENRT_PRCLDS_CHG_FLAG CRNT_ENRT_PRCLDS_CHG_FLAG, PL_ID PL_ID, DFLT_FLAG DFLT_FLAG, LER_ID LER_ID, STL_ELIG_CANT_CHG_FLAG STL_ELIG_CANT_CHG_FLAG, ENRT_MTHD_CD ENRT_MTHD_CD, AUTO_ENRT_MTHD_RL AUTO_ENRT_MTHD_RL, LPE_ATTRIBUTE_CATEGORY LPE_ATTRIBUTE_CATEGORY, LPE_ATTRIBUTE1 LPE_ATTRIBUTE1, LPE_ATTRIBUTE2 LPE_ATTRIBUTE2, LPE_ATTRIBUTE3 LPE_ATTRIBUTE3, LPE_ATTRIBUTE4 LPE_ATTRIBUTE4, LPE_ATTRIBUTE5 LPE_ATTRIBUTE5, LPE_ATTRIBUTE6 LPE_ATTRIBUTE6, LPE_ATTRIBUTE7 LPE_ATTRIBUTE7, LPE_ATTRIBUTE8 LPE_ATTRIBUTE8, LPE_ATTRIBUTE9 LPE_ATTRIBUTE9, LPE_ATTRIBUTE10 LPE_ATTRIBUTE10, LPE_ATTRIBUTE11 LPE_ATTRIBUTE11, LPE_ATTRIBUTE12 LPE_ATTRIBUTE12, LPE_ATTRIBUTE13 LPE_ATTRIBUTE13, LPE_ATTRIBUTE14 LPE_ATTRIBUTE14, LPE_ATTRIBUTE15 LPE_ATTRIBUTE15, LPE_ATTRIBUTE16 LPE_ATTRIBUTE16, LPE_ATTRIBUTE17 LPE_ATTRIBUTE17, LPE_ATTRIBUTE18 LPE_ATTRIBUTE18, LPE_ATTRIBUTE19 LPE_ATTRIBUTE19, LPE_ATTRIBUTE20 LPE_ATTRIBUTE20, LPE_ATTRIBUTE21 LPE_ATTRIBUTE21, LPE_ATTRIBUTE22 LPE_ATTRIBUTE22, LPE_ATTRIBUTE23 LPE_ATTRIBUTE23, LPE_ATTRIBUTE24 LPE_ATTRIBUTE24, LPE_ATTRIBUTE25 LPE_ATTRIBUTE25, LPE_ATTRIBUTE26 LPE_ATTRIBUTE26, LPE_ATTRIBUTE27 LPE_ATTRIBUTE27, LPE_ATTRIBUTE28 LPE_ATTRIBUTE28, LPE_ATTRIBUTE29 LPE_ATTRIBUTE29, LPE_ATTRIBUTE30 LPE_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, DFLT_ENRT_CD DFLT_ENRT_CD, DFLT_ENRT_RL DFLT_ENRT_RL, ENRT_RL ENRT_RL, ENRT_CD ENRT_CD from "BEN"."BEN_LER_CHG_PL_NIP_ENRT_F"

View Text - HTML Formatted

SELECT LER_CHG_PL_NIP_ENRT_ID LER_CHG_PL_NIP_ENRT_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, TCO_CHG_ENRT_CD TCO_CHG_ENRT_CD
, CRNT_ENRT_PRCLDS_CHG_FLAG CRNT_ENRT_PRCLDS_CHG_FLAG
, PL_ID PL_ID
, DFLT_FLAG DFLT_FLAG
, LER_ID LER_ID
, STL_ELIG_CANT_CHG_FLAG STL_ELIG_CANT_CHG_FLAG
, ENRT_MTHD_CD ENRT_MTHD_CD
, AUTO_ENRT_MTHD_RL AUTO_ENRT_MTHD_RL
, LPE_ATTRIBUTE_CATEGORY LPE_ATTRIBUTE_CATEGORY
, LPE_ATTRIBUTE1 LPE_ATTRIBUTE1
, LPE_ATTRIBUTE2 LPE_ATTRIBUTE2
, LPE_ATTRIBUTE3 LPE_ATTRIBUTE3
, LPE_ATTRIBUTE4 LPE_ATTRIBUTE4
, LPE_ATTRIBUTE5 LPE_ATTRIBUTE5
, LPE_ATTRIBUTE6 LPE_ATTRIBUTE6
, LPE_ATTRIBUTE7 LPE_ATTRIBUTE7
, LPE_ATTRIBUTE8 LPE_ATTRIBUTE8
, LPE_ATTRIBUTE9 LPE_ATTRIBUTE9
, LPE_ATTRIBUTE10 LPE_ATTRIBUTE10
, LPE_ATTRIBUTE11 LPE_ATTRIBUTE11
, LPE_ATTRIBUTE12 LPE_ATTRIBUTE12
, LPE_ATTRIBUTE13 LPE_ATTRIBUTE13
, LPE_ATTRIBUTE14 LPE_ATTRIBUTE14
, LPE_ATTRIBUTE15 LPE_ATTRIBUTE15
, LPE_ATTRIBUTE16 LPE_ATTRIBUTE16
, LPE_ATTRIBUTE17 LPE_ATTRIBUTE17
, LPE_ATTRIBUTE18 LPE_ATTRIBUTE18
, LPE_ATTRIBUTE19 LPE_ATTRIBUTE19
, LPE_ATTRIBUTE20 LPE_ATTRIBUTE20
, LPE_ATTRIBUTE21 LPE_ATTRIBUTE21
, LPE_ATTRIBUTE22 LPE_ATTRIBUTE22
, LPE_ATTRIBUTE23 LPE_ATTRIBUTE23
, LPE_ATTRIBUTE24 LPE_ATTRIBUTE24
, LPE_ATTRIBUTE25 LPE_ATTRIBUTE25
, LPE_ATTRIBUTE26 LPE_ATTRIBUTE26
, LPE_ATTRIBUTE27 LPE_ATTRIBUTE27
, LPE_ATTRIBUTE28 LPE_ATTRIBUTE28
, LPE_ATTRIBUTE29 LPE_ATTRIBUTE29
, LPE_ATTRIBUTE30 LPE_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
, DFLT_ENRT_CD DFLT_ENRT_CD
, DFLT_ENRT_RL DFLT_ENRT_RL
, ENRT_RL ENRT_RL
, ENRT_CD ENRT_CD
FROM "BEN"."BEN_LER_CHG_PL_NIP_ENRT_F"