VIEW: BEN.BEN_ELIGY_CRITERIA_DPNT#

Source

View Text - Preformatted

select ELIGY_CRITERIA_DPNT_ID ELIGY_CRITERIA_DPNT_ID, NAME NAME, SHORT_CODE SHORT_CODE, DESCRIPTION DESCRIPTION, CRITERIA_TYPE CRITERIA_TYPE, CRIT_COL1_VAL_TYPE_CD CRIT_COL1_VAL_TYPE_CD, CRIT_COL1_DATATYPE CRIT_COL1_DATATYPE, COL1_LOOKUP_TYPE COL1_LOOKUP_TYPE, COL1_VALUE_SET_ID COL1_VALUE_SET_ID, ACCESS_TABLE_NAME1 ACCESS_TABLE_NAME1, ACCESS_COLUMN_NAME1 ACCESS_COLUMN_NAME1, TIME_ENTRY_ACCESS_TABLE_NAME1 TIME_ENTRY_ACCESS_TABLE_NAME1, TIME_ENTRY_ACCESS_COL_NAME1 TIME_ENTRY_ACCESS_COL_NAME1, CRIT_COL2_VAL_TYPE_CD CRIT_COL2_VAL_TYPE_CD, CRIT_COL2_DATATYPE CRIT_COL2_DATATYPE, COL2_LOOKUP_TYPE COL2_LOOKUP_TYPE, COL2_VALUE_SET_ID COL2_VALUE_SET_ID, ACCESS_TABLE_NAME2 ACCESS_TABLE_NAME2, ACCESS_COLUMN_NAME2 ACCESS_COLUMN_NAME2, TIME_ENTRY_ACCESS_TABLE_NAME2 TIME_ENTRY_ACCESS_TABLE_NAME2, TIME_ENTRY_ACCESS_COL_NAME2 TIME_ENTRY_ACCESS_COL_NAME2, TIME_ACCESS_CALC_RULE1 TIME_ACCESS_CALC_RULE1, TIME_ACCESS_CALC_RULE2 TIME_ACCESS_CALC_RULE2, ALLOW_RANGE_VALIDATION_FLAG ALLOW_RANGE_VALIDATION_FLAG, ALLOW_RANGE_VALIDATION_FLAG2 ALLOW_RANGE_VALIDATION_FLAG2, USER_DEFINED_FLAG USER_DEFINED_FLAG, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, EGD_ATTRIBUTE_CATEGORY EGD_ATTRIBUTE_CATEGORY, EGD_ATTRIBUTE1 EGD_ATTRIBUTE1, EGD_ATTRIBUTE2 EGD_ATTRIBUTE2, EGD_ATTRIBUTE3 EGD_ATTRIBUTE3, EGD_ATTRIBUTE4 EGD_ATTRIBUTE4, EGD_ATTRIBUTE5 EGD_ATTRIBUTE5, EGD_ATTRIBUTE6 EGD_ATTRIBUTE6, EGD_ATTRIBUTE7 EGD_ATTRIBUTE7, EGD_ATTRIBUTE8 EGD_ATTRIBUTE8, EGD_ATTRIBUTE9 EGD_ATTRIBUTE9, EGD_ATTRIBUTE10 EGD_ATTRIBUTE10, EGD_ATTRIBUTE11 EGD_ATTRIBUTE11, EGD_ATTRIBUTE12 EGD_ATTRIBUTE12, EGD_ATTRIBUTE13 EGD_ATTRIBUTE13, EGD_ATTRIBUTE14 EGD_ATTRIBUTE14, EGD_ATTRIBUTE15 EGD_ATTRIBUTE15, EGD_ATTRIBUTE16 EGD_ATTRIBUTE16, EGD_ATTRIBUTE17 EGD_ATTRIBUTE17, EGD_ATTRIBUTE18 EGD_ATTRIBUTE18, EGD_ATTRIBUTE19 EGD_ATTRIBUTE19, EGD_ATTRIBUTE20 EGD_ATTRIBUTE20, EGD_ATTRIBUTE21 EGD_ATTRIBUTE21, EGD_ATTRIBUTE22 EGD_ATTRIBUTE22, EGD_ATTRIBUTE23 EGD_ATTRIBUTE23, EGD_ATTRIBUTE24 EGD_ATTRIBUTE24, EGD_ATTRIBUTE25 EGD_ATTRIBUTE25, EGD_ATTRIBUTE26 EGD_ATTRIBUTE26, EGD_ATTRIBUTE27 EGD_ATTRIBUTE27, EGD_ATTRIBUTE28 EGD_ATTRIBUTE28, EGD_ATTRIBUTE29 EGD_ATTRIBUTE29, EGD_ATTRIBUTE30 EGD_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_CRITERIA_DPNT"

View Text - HTML Formatted

SELECT ELIGY_CRITERIA_DPNT_ID ELIGY_CRITERIA_DPNT_ID
, NAME NAME
, SHORT_CODE SHORT_CODE
, DESCRIPTION DESCRIPTION
, CRITERIA_TYPE CRITERIA_TYPE
, CRIT_COL1_VAL_TYPE_CD CRIT_COL1_VAL_TYPE_CD
, CRIT_COL1_DATATYPE CRIT_COL1_DATATYPE
, COL1_LOOKUP_TYPE COL1_LOOKUP_TYPE
, COL1_VALUE_SET_ID COL1_VALUE_SET_ID
, ACCESS_TABLE_NAME1 ACCESS_TABLE_NAME1
, ACCESS_COLUMN_NAME1 ACCESS_COLUMN_NAME1
, TIME_ENTRY_ACCESS_TABLE_NAME1 TIME_ENTRY_ACCESS_TABLE_NAME1
, TIME_ENTRY_ACCESS_COL_NAME1 TIME_ENTRY_ACCESS_COL_NAME1
, CRIT_COL2_VAL_TYPE_CD CRIT_COL2_VAL_TYPE_CD
, CRIT_COL2_DATATYPE CRIT_COL2_DATATYPE
, COL2_LOOKUP_TYPE COL2_LOOKUP_TYPE
, COL2_VALUE_SET_ID COL2_VALUE_SET_ID
, ACCESS_TABLE_NAME2 ACCESS_TABLE_NAME2
, ACCESS_COLUMN_NAME2 ACCESS_COLUMN_NAME2
, TIME_ENTRY_ACCESS_TABLE_NAME2 TIME_ENTRY_ACCESS_TABLE_NAME2
, TIME_ENTRY_ACCESS_COL_NAME2 TIME_ENTRY_ACCESS_COL_NAME2
, TIME_ACCESS_CALC_RULE1 TIME_ACCESS_CALC_RULE1
, TIME_ACCESS_CALC_RULE2 TIME_ACCESS_CALC_RULE2
, ALLOW_RANGE_VALIDATION_FLAG ALLOW_RANGE_VALIDATION_FLAG
, ALLOW_RANGE_VALIDATION_FLAG2 ALLOW_RANGE_VALIDATION_FLAG2
, USER_DEFINED_FLAG USER_DEFINED_FLAG
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, EGD_ATTRIBUTE_CATEGORY EGD_ATTRIBUTE_CATEGORY
, EGD_ATTRIBUTE1 EGD_ATTRIBUTE1
, EGD_ATTRIBUTE2 EGD_ATTRIBUTE2
, EGD_ATTRIBUTE3 EGD_ATTRIBUTE3
, EGD_ATTRIBUTE4 EGD_ATTRIBUTE4
, EGD_ATTRIBUTE5 EGD_ATTRIBUTE5
, EGD_ATTRIBUTE6 EGD_ATTRIBUTE6
, EGD_ATTRIBUTE7 EGD_ATTRIBUTE7
, EGD_ATTRIBUTE8 EGD_ATTRIBUTE8
, EGD_ATTRIBUTE9 EGD_ATTRIBUTE9
, EGD_ATTRIBUTE10 EGD_ATTRIBUTE10
, EGD_ATTRIBUTE11 EGD_ATTRIBUTE11
, EGD_ATTRIBUTE12 EGD_ATTRIBUTE12
, EGD_ATTRIBUTE13 EGD_ATTRIBUTE13
, EGD_ATTRIBUTE14 EGD_ATTRIBUTE14
, EGD_ATTRIBUTE15 EGD_ATTRIBUTE15
, EGD_ATTRIBUTE16 EGD_ATTRIBUTE16
, EGD_ATTRIBUTE17 EGD_ATTRIBUTE17
, EGD_ATTRIBUTE18 EGD_ATTRIBUTE18
, EGD_ATTRIBUTE19 EGD_ATTRIBUTE19
, EGD_ATTRIBUTE20 EGD_ATTRIBUTE20
, EGD_ATTRIBUTE21 EGD_ATTRIBUTE21
, EGD_ATTRIBUTE22 EGD_ATTRIBUTE22
, EGD_ATTRIBUTE23 EGD_ATTRIBUTE23
, EGD_ATTRIBUTE24 EGD_ATTRIBUTE24
, EGD_ATTRIBUTE25 EGD_ATTRIBUTE25
, EGD_ATTRIBUTE26 EGD_ATTRIBUTE26
, EGD_ATTRIBUTE27 EGD_ATTRIBUTE27
, EGD_ATTRIBUTE28 EGD_ATTRIBUTE28
, EGD_ATTRIBUTE29 EGD_ATTRIBUTE29
, EGD_ATTRIBUTE30 EGD_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_CRITERIA_DPNT"