VIEW: BEN.BEN_CVG_AMT_CALC_MTHD_F#

Source

View Text - Preformatted

select CVG_AMT_CALC_MTHD_ID CVG_AMT_CALC_MTHD_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, NAME NAME, NO_MX_VAL_DFND_FLAG NO_MX_VAL_DFND_FLAG, NO_MN_VAL_DFND_FLAG NO_MN_VAL_DFND_FLAG, VAL_OVRID_ALWD_FLAG VAL_OVRID_ALWD_FLAG, ENTR_VAL_AT_ENRT_FLAG ENTR_VAL_AT_ENRT_FLAG, DFLT_FLAG DFLT_FLAG, LWR_LMT_VAL LWR_LMT_VAL, LWR_LMT_CALC_RL LWR_LMT_CALC_RL, UPR_LMT_VAL UPR_LMT_VAL, UPR_LMT_CALC_RL UPR_LMT_CALC_RL, COMP_LVL_FCTR_ID COMP_LVL_FCTR_ID, CCM_ATTRIBUTE_CATEGORY CCM_ATTRIBUTE_CATEGORY, CCM_ATTRIBUTE1 CCM_ATTRIBUTE1, CCM_ATTRIBUTE2 CCM_ATTRIBUTE2, CCM_ATTRIBUTE3 CCM_ATTRIBUTE3, CCM_ATTRIBUTE4 CCM_ATTRIBUTE4, CCM_ATTRIBUTE5 CCM_ATTRIBUTE5, CCM_ATTRIBUTE6 CCM_ATTRIBUTE6, CCM_ATTRIBUTE7 CCM_ATTRIBUTE7, CCM_ATTRIBUTE8 CCM_ATTRIBUTE8, CCM_ATTRIBUTE9 CCM_ATTRIBUTE9, CCM_ATTRIBUTE10 CCM_ATTRIBUTE10, CCM_ATTRIBUTE11 CCM_ATTRIBUTE11, CCM_ATTRIBUTE12 CCM_ATTRIBUTE12, CCM_ATTRIBUTE13 CCM_ATTRIBUTE13, CCM_ATTRIBUTE14 CCM_ATTRIBUTE14, CCM_ATTRIBUTE15 CCM_ATTRIBUTE15, CCM_ATTRIBUTE16 CCM_ATTRIBUTE16, CCM_ATTRIBUTE17 CCM_ATTRIBUTE17, CCM_ATTRIBUTE18 CCM_ATTRIBUTE18, CCM_ATTRIBUTE19 CCM_ATTRIBUTE19, CCM_ATTRIBUTE20 CCM_ATTRIBUTE20, CCM_ATTRIBUTE21 CCM_ATTRIBUTE21, CCM_ATTRIBUTE22 CCM_ATTRIBUTE22, CCM_ATTRIBUTE23 CCM_ATTRIBUTE23, CCM_ATTRIBUTE24 CCM_ATTRIBUTE24, CCM_ATTRIBUTE25 CCM_ATTRIBUTE25, CCM_ATTRIBUTE26 CCM_ATTRIBUTE26, CCM_ATTRIBUTE27 CCM_ATTRIBUTE27, CCM_ATTRIBUTE28 CCM_ATTRIBUTE28, CCM_ATTRIBUTE29 CCM_ATTRIBUTE29, CCM_ATTRIBUTE30 CCM_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, OIPL_ID OIPL_ID, PL_ID PL_ID, PLIP_ID PLIP_ID, INCRMT_VAL INCRMT_VAL, MX_VAL MX_VAL, RNDG_RL RNDG_RL, MN_VAL MN_VAL, VAL_CALC_RL VAL_CALC_RL, RNDG_CD RNDG_CD, VAL VAL, UOM UOM, NNMNTRY_UOM NNMNTRY_UOM, BNDRY_PERD_CD BNDRY_PERD_CD, BNFT_TYP_CD BNFT_TYP_CD, CVG_MLT_CD CVG_MLT_CD, RT_TYP_CD RT_TYP_CD, DFLT_VAL DFLT_VAL from "BEN"."BEN_CVG_AMT_CALC_MTHD_F"

View Text - HTML Formatted

SELECT CVG_AMT_CALC_MTHD_ID CVG_AMT_CALC_MTHD_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, NAME NAME
, NO_MX_VAL_DFND_FLAG NO_MX_VAL_DFND_FLAG
, NO_MN_VAL_DFND_FLAG NO_MN_VAL_DFND_FLAG
, VAL_OVRID_ALWD_FLAG VAL_OVRID_ALWD_FLAG
, ENTR_VAL_AT_ENRT_FLAG ENTR_VAL_AT_ENRT_FLAG
, DFLT_FLAG DFLT_FLAG
, LWR_LMT_VAL LWR_LMT_VAL
, LWR_LMT_CALC_RL LWR_LMT_CALC_RL
, UPR_LMT_VAL UPR_LMT_VAL
, UPR_LMT_CALC_RL UPR_LMT_CALC_RL
, COMP_LVL_FCTR_ID COMP_LVL_FCTR_ID
, CCM_ATTRIBUTE_CATEGORY CCM_ATTRIBUTE_CATEGORY
, CCM_ATTRIBUTE1 CCM_ATTRIBUTE1
, CCM_ATTRIBUTE2 CCM_ATTRIBUTE2
, CCM_ATTRIBUTE3 CCM_ATTRIBUTE3
, CCM_ATTRIBUTE4 CCM_ATTRIBUTE4
, CCM_ATTRIBUTE5 CCM_ATTRIBUTE5
, CCM_ATTRIBUTE6 CCM_ATTRIBUTE6
, CCM_ATTRIBUTE7 CCM_ATTRIBUTE7
, CCM_ATTRIBUTE8 CCM_ATTRIBUTE8
, CCM_ATTRIBUTE9 CCM_ATTRIBUTE9
, CCM_ATTRIBUTE10 CCM_ATTRIBUTE10
, CCM_ATTRIBUTE11 CCM_ATTRIBUTE11
, CCM_ATTRIBUTE12 CCM_ATTRIBUTE12
, CCM_ATTRIBUTE13 CCM_ATTRIBUTE13
, CCM_ATTRIBUTE14 CCM_ATTRIBUTE14
, CCM_ATTRIBUTE15 CCM_ATTRIBUTE15
, CCM_ATTRIBUTE16 CCM_ATTRIBUTE16
, CCM_ATTRIBUTE17 CCM_ATTRIBUTE17
, CCM_ATTRIBUTE18 CCM_ATTRIBUTE18
, CCM_ATTRIBUTE19 CCM_ATTRIBUTE19
, CCM_ATTRIBUTE20 CCM_ATTRIBUTE20
, CCM_ATTRIBUTE21 CCM_ATTRIBUTE21
, CCM_ATTRIBUTE22 CCM_ATTRIBUTE22
, CCM_ATTRIBUTE23 CCM_ATTRIBUTE23
, CCM_ATTRIBUTE24 CCM_ATTRIBUTE24
, CCM_ATTRIBUTE25 CCM_ATTRIBUTE25
, CCM_ATTRIBUTE26 CCM_ATTRIBUTE26
, CCM_ATTRIBUTE27 CCM_ATTRIBUTE27
, CCM_ATTRIBUTE28 CCM_ATTRIBUTE28
, CCM_ATTRIBUTE29 CCM_ATTRIBUTE29
, CCM_ATTRIBUTE30 CCM_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
, OIPL_ID OIPL_ID
, PL_ID PL_ID
, PLIP_ID PLIP_ID
, INCRMT_VAL INCRMT_VAL
, MX_VAL MX_VAL
, RNDG_RL RNDG_RL
, MN_VAL MN_VAL
, VAL_CALC_RL VAL_CALC_RL
, RNDG_CD RNDG_CD
, VAL VAL
, UOM UOM
, NNMNTRY_UOM NNMNTRY_UOM
, BNDRY_PERD_CD BNDRY_PERD_CD
, BNFT_TYP_CD BNFT_TYP_CD
, CVG_MLT_CD CVG_MLT_CD
, RT_TYP_CD RT_TYP_CD
, DFLT_VAL DFLT_VAL
FROM "BEN"."BEN_CVG_AMT_CALC_MTHD_F"