VIEW: BEN.BEN_MTCHG_RT_F#

Source

View Text - Preformatted

select MTCHG_RT_ID MTCHG_RT_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, ORDR_NUM ORDR_NUM, NO_MX_MTCH_AMT_FLAG NO_MX_MTCH_AMT_FLAG, NO_MX_PCT_OF_PY_NUM_FLAG NO_MX_PCT_OF_PY_NUM_FLAG, CNTNU_MTCH_AFTR_MX_RL_FLAG CNTNU_MTCH_AFTR_MX_RL_FLAG, NO_MX_AMT_OF_PY_NUM_FLAG NO_MX_AMT_OF_PY_NUM_FLAG, COMP_LVL_FCTR_ID COMP_LVL_FCTR_ID, MTR_ATTRIBUTE_CATEGORY MTR_ATTRIBUTE_CATEGORY, MTR_ATTRIBUTE1 MTR_ATTRIBUTE1, MTR_ATTRIBUTE2 MTR_ATTRIBUTE2, MTR_ATTRIBUTE3 MTR_ATTRIBUTE3, MTR_ATTRIBUTE4 MTR_ATTRIBUTE4, MTR_ATTRIBUTE5 MTR_ATTRIBUTE5, MTR_ATTRIBUTE6 MTR_ATTRIBUTE6, MTR_ATTRIBUTE7 MTR_ATTRIBUTE7, MTR_ATTRIBUTE8 MTR_ATTRIBUTE8, MTR_ATTRIBUTE9 MTR_ATTRIBUTE9, MTR_ATTRIBUTE10 MTR_ATTRIBUTE10, MTR_ATTRIBUTE11 MTR_ATTRIBUTE11, MTR_ATTRIBUTE12 MTR_ATTRIBUTE12, MTR_ATTRIBUTE13 MTR_ATTRIBUTE13, MTR_ATTRIBUTE14 MTR_ATTRIBUTE14, MTR_ATTRIBUTE15 MTR_ATTRIBUTE15, MTR_ATTRIBUTE16 MTR_ATTRIBUTE16, MTR_ATTRIBUTE17 MTR_ATTRIBUTE17, MTR_ATTRIBUTE18 MTR_ATTRIBUTE18, MTR_ATTRIBUTE19 MTR_ATTRIBUTE19, MTR_ATTRIBUTE20 MTR_ATTRIBUTE20, MTR_ATTRIBUTE21 MTR_ATTRIBUTE21, MTR_ATTRIBUTE22 MTR_ATTRIBUTE22, MTR_ATTRIBUTE23 MTR_ATTRIBUTE23, MTR_ATTRIBUTE24 MTR_ATTRIBUTE24, MTR_ATTRIBUTE25 MTR_ATTRIBUTE25, MTR_ATTRIBUTE26 MTR_ATTRIBUTE26, MTR_ATTRIBUTE27 MTR_ATTRIBUTE27, MTR_ATTRIBUTE28 MTR_ATTRIBUTE28, MTR_ATTRIBUTE29 MTR_ATTRIBUTE29, MTR_ATTRIBUTE30 MTR_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_PCT_VAL FROM_PCT_VAL, TO_PCT_VAL TO_PCT_VAL, PCT_VAL PCT_VAL, MX_AMT_OF_PY_NUM MX_AMT_OF_PY_NUM, MX_PCT_OF_PY_NUM MX_PCT_OF_PY_NUM, MX_MTCH_AMT MX_MTCH_AMT, MN_MTCH_AMT MN_MTCH_AMT, ACTY_BASE_RT_ID ACTY_BASE_RT_ID, MTCHG_RT_CALC_RL MTCHG_RT_CALC_RL from "BEN"."BEN_MTCHG_RT_F"

View Text - HTML Formatted

SELECT MTCHG_RT_ID MTCHG_RT_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, ORDR_NUM ORDR_NUM
, NO_MX_MTCH_AMT_FLAG NO_MX_MTCH_AMT_FLAG
, NO_MX_PCT_OF_PY_NUM_FLAG NO_MX_PCT_OF_PY_NUM_FLAG
, CNTNU_MTCH_AFTR_MX_RL_FLAG CNTNU_MTCH_AFTR_MX_RL_FLAG
, NO_MX_AMT_OF_PY_NUM_FLAG NO_MX_AMT_OF_PY_NUM_FLAG
, COMP_LVL_FCTR_ID COMP_LVL_FCTR_ID
, MTR_ATTRIBUTE_CATEGORY MTR_ATTRIBUTE_CATEGORY
, MTR_ATTRIBUTE1 MTR_ATTRIBUTE1
, MTR_ATTRIBUTE2 MTR_ATTRIBUTE2
, MTR_ATTRIBUTE3 MTR_ATTRIBUTE3
, MTR_ATTRIBUTE4 MTR_ATTRIBUTE4
, MTR_ATTRIBUTE5 MTR_ATTRIBUTE5
, MTR_ATTRIBUTE6 MTR_ATTRIBUTE6
, MTR_ATTRIBUTE7 MTR_ATTRIBUTE7
, MTR_ATTRIBUTE8 MTR_ATTRIBUTE8
, MTR_ATTRIBUTE9 MTR_ATTRIBUTE9
, MTR_ATTRIBUTE10 MTR_ATTRIBUTE10
, MTR_ATTRIBUTE11 MTR_ATTRIBUTE11
, MTR_ATTRIBUTE12 MTR_ATTRIBUTE12
, MTR_ATTRIBUTE13 MTR_ATTRIBUTE13
, MTR_ATTRIBUTE14 MTR_ATTRIBUTE14
, MTR_ATTRIBUTE15 MTR_ATTRIBUTE15
, MTR_ATTRIBUTE16 MTR_ATTRIBUTE16
, MTR_ATTRIBUTE17 MTR_ATTRIBUTE17
, MTR_ATTRIBUTE18 MTR_ATTRIBUTE18
, MTR_ATTRIBUTE19 MTR_ATTRIBUTE19
, MTR_ATTRIBUTE20 MTR_ATTRIBUTE20
, MTR_ATTRIBUTE21 MTR_ATTRIBUTE21
, MTR_ATTRIBUTE22 MTR_ATTRIBUTE22
, MTR_ATTRIBUTE23 MTR_ATTRIBUTE23
, MTR_ATTRIBUTE24 MTR_ATTRIBUTE24
, MTR_ATTRIBUTE25 MTR_ATTRIBUTE25
, MTR_ATTRIBUTE26 MTR_ATTRIBUTE26
, MTR_ATTRIBUTE27 MTR_ATTRIBUTE27
, MTR_ATTRIBUTE28 MTR_ATTRIBUTE28
, MTR_ATTRIBUTE29 MTR_ATTRIBUTE29
, MTR_ATTRIBUTE30 MTR_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_PCT_VAL FROM_PCT_VAL
, TO_PCT_VAL TO_PCT_VAL
, PCT_VAL PCT_VAL
, MX_AMT_OF_PY_NUM MX_AMT_OF_PY_NUM
, MX_PCT_OF_PY_NUM MX_PCT_OF_PY_NUM
, MX_MTCH_AMT MX_MTCH_AMT
, MN_MTCH_AMT MN_MTCH_AMT
, ACTY_BASE_RT_ID ACTY_BASE_RT_ID
, MTCHG_RT_CALC_RL MTCHG_RT_CALC_RL
FROM "BEN"."BEN_MTCHG_RT_F"