VIEW: BEN.BEN_COMP_LVL_RT_F#

Source

View Text - Preformatted

select COMP_LVL_RT_ID COMP_LVL_RT_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, COMP_LVL_FCTR_ID COMP_LVL_FCTR_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, ORDR_NUM ORDR_NUM, EXCLD_FLAG EXCLD_FLAG, VRBL_RT_PRFL_ID VRBL_RT_PRFL_ID, CLR_ATTRIBUTE_CATEGORY CLR_ATTRIBUTE_CATEGORY, CLR_ATTRIBUTE1 CLR_ATTRIBUTE1, CLR_ATTRIBUTE2 CLR_ATTRIBUTE2, CLR_ATTRIBUTE3 CLR_ATTRIBUTE3, CLR_ATTRIBUTE4 CLR_ATTRIBUTE4, CLR_ATTRIBUTE5 CLR_ATTRIBUTE5, CLR_ATTRIBUTE6 CLR_ATTRIBUTE6, CLR_ATTRIBUTE7 CLR_ATTRIBUTE7, CLR_ATTRIBUTE8 CLR_ATTRIBUTE8, CLR_ATTRIBUTE9 CLR_ATTRIBUTE9, CLR_ATTRIBUTE10 CLR_ATTRIBUTE10, CLR_ATTRIBUTE11 CLR_ATTRIBUTE11, CLR_ATTRIBUTE12 CLR_ATTRIBUTE12, CLR_ATTRIBUTE13 CLR_ATTRIBUTE13, CLR_ATTRIBUTE14 CLR_ATTRIBUTE14, CLR_ATTRIBUTE15 CLR_ATTRIBUTE15, CLR_ATTRIBUTE16 CLR_ATTRIBUTE16, CLR_ATTRIBUTE17 CLR_ATTRIBUTE17, CLR_ATTRIBUTE18 CLR_ATTRIBUTE18, CLR_ATTRIBUTE19 CLR_ATTRIBUTE19, CLR_ATTRIBUTE20 CLR_ATTRIBUTE20, CLR_ATTRIBUTE21 CLR_ATTRIBUTE21, CLR_ATTRIBUTE22 CLR_ATTRIBUTE22, CLR_ATTRIBUTE23 CLR_ATTRIBUTE23, CLR_ATTRIBUTE24 CLR_ATTRIBUTE24, CLR_ATTRIBUTE25 CLR_ATTRIBUTE25, CLR_ATTRIBUTE26 CLR_ATTRIBUTE26, CLR_ATTRIBUTE27 CLR_ATTRIBUTE27, CLR_ATTRIBUTE28 CLR_ATTRIBUTE28, CLR_ATTRIBUTE29 CLR_ATTRIBUTE29, CLR_ATTRIBUTE30 CLR_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 from "BEN"."BEN_COMP_LVL_RT_F"

View Text - HTML Formatted

SELECT COMP_LVL_RT_ID COMP_LVL_RT_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, COMP_LVL_FCTR_ID COMP_LVL_FCTR_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, ORDR_NUM ORDR_NUM
, EXCLD_FLAG EXCLD_FLAG
, VRBL_RT_PRFL_ID VRBL_RT_PRFL_ID
, CLR_ATTRIBUTE_CATEGORY CLR_ATTRIBUTE_CATEGORY
, CLR_ATTRIBUTE1 CLR_ATTRIBUTE1
, CLR_ATTRIBUTE2 CLR_ATTRIBUTE2
, CLR_ATTRIBUTE3 CLR_ATTRIBUTE3
, CLR_ATTRIBUTE4 CLR_ATTRIBUTE4
, CLR_ATTRIBUTE5 CLR_ATTRIBUTE5
, CLR_ATTRIBUTE6 CLR_ATTRIBUTE6
, CLR_ATTRIBUTE7 CLR_ATTRIBUTE7
, CLR_ATTRIBUTE8 CLR_ATTRIBUTE8
, CLR_ATTRIBUTE9 CLR_ATTRIBUTE9
, CLR_ATTRIBUTE10 CLR_ATTRIBUTE10
, CLR_ATTRIBUTE11 CLR_ATTRIBUTE11
, CLR_ATTRIBUTE12 CLR_ATTRIBUTE12
, CLR_ATTRIBUTE13 CLR_ATTRIBUTE13
, CLR_ATTRIBUTE14 CLR_ATTRIBUTE14
, CLR_ATTRIBUTE15 CLR_ATTRIBUTE15
, CLR_ATTRIBUTE16 CLR_ATTRIBUTE16
, CLR_ATTRIBUTE17 CLR_ATTRIBUTE17
, CLR_ATTRIBUTE18 CLR_ATTRIBUTE18
, CLR_ATTRIBUTE19 CLR_ATTRIBUTE19
, CLR_ATTRIBUTE20 CLR_ATTRIBUTE20
, CLR_ATTRIBUTE21 CLR_ATTRIBUTE21
, CLR_ATTRIBUTE22 CLR_ATTRIBUTE22
, CLR_ATTRIBUTE23 CLR_ATTRIBUTE23
, CLR_ATTRIBUTE24 CLR_ATTRIBUTE24
, CLR_ATTRIBUTE25 CLR_ATTRIBUTE25
, CLR_ATTRIBUTE26 CLR_ATTRIBUTE26
, CLR_ATTRIBUTE27 CLR_ATTRIBUTE27
, CLR_ATTRIBUTE28 CLR_ATTRIBUTE28
, CLR_ATTRIBUTE29 CLR_ATTRIBUTE29
, CLR_ATTRIBUTE30 CLR_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
FROM "BEN"."BEN_COMP_LVL_RT_F"