VIEW: BEN.BEN_ELIGY_CRIT_VALUES_F#

Source

View Text - Preformatted

select ELIGY_CRIT_VALUES_ID ELIGY_CRIT_VALUES_ID, ELIGY_PRFL_ID ELIGY_PRFL_ID, ELIGY_CRITERIA_ID ELIGY_CRITERIA_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, ORDR_NUM ORDR_NUM, NUMBER_VALUE1 NUMBER_VALUE1, NUMBER_VALUE2 NUMBER_VALUE2, NUMBER_VALUE3 NUMBER_VALUE3, NUMBER_VALUE4 NUMBER_VALUE4, CHAR_VALUE1 CHAR_VALUE1, CHAR_VALUE2 CHAR_VALUE2, CHAR_VALUE3 CHAR_VALUE3, CHAR_VALUE4 CHAR_VALUE4, DATE_VALUE1 DATE_VALUE1, DATE_VALUE2 DATE_VALUE2, DATE_VALUE3 DATE_VALUE3, DATE_VALUE4 DATE_VALUE4, EXCLD_FLAG EXCLD_FLAG, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, LEGISLATION_CODE LEGISLATION_CODE, CRITERIA_SCORE CRITERIA_SCORE, CRITERIA_WEIGHT CRITERIA_WEIGHT, ECV_ATTRIBUTE_CATEGORY ECV_ATTRIBUTE_CATEGORY, ECV_ATTRIBUTE1 ECV_ATTRIBUTE1, ECV_ATTRIBUTE2 ECV_ATTRIBUTE2, ECV_ATTRIBUTE3 ECV_ATTRIBUTE3, ECV_ATTRIBUTE4 ECV_ATTRIBUTE4, ECV_ATTRIBUTE5 ECV_ATTRIBUTE5, ECV_ATTRIBUTE6 ECV_ATTRIBUTE6, ECV_ATTRIBUTE7 ECV_ATTRIBUTE7, ECV_ATTRIBUTE8 ECV_ATTRIBUTE8, ECV_ATTRIBUTE9 ECV_ATTRIBUTE9, ECV_ATTRIBUTE10 ECV_ATTRIBUTE10, ECV_ATTRIBUTE11 ECV_ATTRIBUTE11, ECV_ATTRIBUTE12 ECV_ATTRIBUTE12, ECV_ATTRIBUTE13 ECV_ATTRIBUTE13, ECV_ATTRIBUTE14 ECV_ATTRIBUTE14, ECV_ATTRIBUTE15 ECV_ATTRIBUTE15, ECV_ATTRIBUTE16 ECV_ATTRIBUTE16, ECV_ATTRIBUTE17 ECV_ATTRIBUTE17, ECV_ATTRIBUTE18 ECV_ATTRIBUTE18, ECV_ATTRIBUTE19 ECV_ATTRIBUTE19, ECV_ATTRIBUTE20 ECV_ATTRIBUTE20, ECV_ATTRIBUTE21 ECV_ATTRIBUTE21, ECV_ATTRIBUTE22 ECV_ATTRIBUTE22, ECV_ATTRIBUTE23 ECV_ATTRIBUTE23, ECV_ATTRIBUTE24 ECV_ATTRIBUTE24, ECV_ATTRIBUTE25 ECV_ATTRIBUTE25, ECV_ATTRIBUTE26 ECV_ATTRIBUTE26, ECV_ATTRIBUTE27 ECV_ATTRIBUTE27, ECV_ATTRIBUTE28 ECV_ATTRIBUTE28, ECV_ATTRIBUTE29 ECV_ATTRIBUTE29, ECV_ATTRIBUTE30 ECV_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_ELIGY_CRIT_VALUES_F"

View Text - HTML Formatted

SELECT ELIGY_CRIT_VALUES_ID ELIGY_CRIT_VALUES_ID
, ELIGY_PRFL_ID ELIGY_PRFL_ID
, ELIGY_CRITERIA_ID ELIGY_CRITERIA_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, ORDR_NUM ORDR_NUM
, NUMBER_VALUE1 NUMBER_VALUE1
, NUMBER_VALUE2 NUMBER_VALUE2
, NUMBER_VALUE3 NUMBER_VALUE3
, NUMBER_VALUE4 NUMBER_VALUE4
, CHAR_VALUE1 CHAR_VALUE1
, CHAR_VALUE2 CHAR_VALUE2
, CHAR_VALUE3 CHAR_VALUE3
, CHAR_VALUE4 CHAR_VALUE4
, DATE_VALUE1 DATE_VALUE1
, DATE_VALUE2 DATE_VALUE2
, DATE_VALUE3 DATE_VALUE3
, DATE_VALUE4 DATE_VALUE4
, EXCLD_FLAG EXCLD_FLAG
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, LEGISLATION_CODE LEGISLATION_CODE
, CRITERIA_SCORE CRITERIA_SCORE
, CRITERIA_WEIGHT CRITERIA_WEIGHT
, ECV_ATTRIBUTE_CATEGORY ECV_ATTRIBUTE_CATEGORY
, ECV_ATTRIBUTE1 ECV_ATTRIBUTE1
, ECV_ATTRIBUTE2 ECV_ATTRIBUTE2
, ECV_ATTRIBUTE3 ECV_ATTRIBUTE3
, ECV_ATTRIBUTE4 ECV_ATTRIBUTE4
, ECV_ATTRIBUTE5 ECV_ATTRIBUTE5
, ECV_ATTRIBUTE6 ECV_ATTRIBUTE6
, ECV_ATTRIBUTE7 ECV_ATTRIBUTE7
, ECV_ATTRIBUTE8 ECV_ATTRIBUTE8
, ECV_ATTRIBUTE9 ECV_ATTRIBUTE9
, ECV_ATTRIBUTE10 ECV_ATTRIBUTE10
, ECV_ATTRIBUTE11 ECV_ATTRIBUTE11
, ECV_ATTRIBUTE12 ECV_ATTRIBUTE12
, ECV_ATTRIBUTE13 ECV_ATTRIBUTE13
, ECV_ATTRIBUTE14 ECV_ATTRIBUTE14
, ECV_ATTRIBUTE15 ECV_ATTRIBUTE15
, ECV_ATTRIBUTE16 ECV_ATTRIBUTE16
, ECV_ATTRIBUTE17 ECV_ATTRIBUTE17
, ECV_ATTRIBUTE18 ECV_ATTRIBUTE18
, ECV_ATTRIBUTE19 ECV_ATTRIBUTE19
, ECV_ATTRIBUTE20 ECV_ATTRIBUTE20
, ECV_ATTRIBUTE21 ECV_ATTRIBUTE21
, ECV_ATTRIBUTE22 ECV_ATTRIBUTE22
, ECV_ATTRIBUTE23 ECV_ATTRIBUTE23
, ECV_ATTRIBUTE24 ECV_ATTRIBUTE24
, ECV_ATTRIBUTE25 ECV_ATTRIBUTE25
, ECV_ATTRIBUTE26 ECV_ATTRIBUTE26
, ECV_ATTRIBUTE27 ECV_ATTRIBUTE27
, ECV_ATTRIBUTE28 ECV_ATTRIBUTE28
, ECV_ATTRIBUTE29 ECV_ATTRIBUTE29
, ECV_ATTRIBUTE30 ECV_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_ELIGY_CRIT_VALUES_F"