VIEW: BEN.BEN_ACTL_PREM_F#

Source

View Text - Preformatted

select ACTL_PREM_ID ACTL_PREM_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, NAME NAME, ACTY_REF_PERD_CD ACTY_REF_PERD_CD, UOM UOM, CR_LKBK_CRNT_PY_ONLY_FLAG CR_LKBK_CRNT_PY_ONLY_FLAG, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, APR_ATTRIBUTE_CATEGORY APR_ATTRIBUTE_CATEGORY, APR_ATTRIBUTE1 APR_ATTRIBUTE1, APR_ATTRIBUTE2 APR_ATTRIBUTE2, APR_ATTRIBUTE3 APR_ATTRIBUTE3, APR_ATTRIBUTE4 APR_ATTRIBUTE4, APR_ATTRIBUTE5 APR_ATTRIBUTE5, APR_ATTRIBUTE6 APR_ATTRIBUTE6, APR_ATTRIBUTE7 APR_ATTRIBUTE7, APR_ATTRIBUTE8 APR_ATTRIBUTE8, APR_ATTRIBUTE9 APR_ATTRIBUTE9, APR_ATTRIBUTE10 APR_ATTRIBUTE10, APR_ATTRIBUTE11 APR_ATTRIBUTE11, APR_ATTRIBUTE12 APR_ATTRIBUTE12, APR_ATTRIBUTE13 APR_ATTRIBUTE13, APR_ATTRIBUTE14 APR_ATTRIBUTE14, APR_ATTRIBUTE15 APR_ATTRIBUTE15, APR_ATTRIBUTE16 APR_ATTRIBUTE16, APR_ATTRIBUTE17 APR_ATTRIBUTE17, APR_ATTRIBUTE18 APR_ATTRIBUTE18, APR_ATTRIBUTE19 APR_ATTRIBUTE19, APR_ATTRIBUTE20 APR_ATTRIBUTE20, APR_ATTRIBUTE21 APR_ATTRIBUTE21, APR_ATTRIBUTE22 APR_ATTRIBUTE22, APR_ATTRIBUTE23 APR_ATTRIBUTE23, APR_ATTRIBUTE24 APR_ATTRIBUTE24, APR_ATTRIBUTE25 APR_ATTRIBUTE25, APR_ATTRIBUTE26 APR_ATTRIBUTE26, APR_ATTRIBUTE27 APR_ATTRIBUTE27, APR_ATTRIBUTE28 APR_ATTRIBUTE28, APR_ATTRIBUTE29 APR_ATTRIBUTE29, APR_ATTRIBUTE30 APR_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, PRTL_MO_DET_MTHD_CD PRTL_MO_DET_MTHD_CD, PRTL_MO_DET_MTHD_RL PRTL_MO_DET_MTHD_RL, WSH_RL_DY_MO_NUM WSH_RL_DY_MO_NUM, RT_TYP_CD RT_TYP_CD, BNFT_RT_TYP_CD BNFT_RT_TYP_CD, VAL VAL, MLT_CD MLT_CD, PRDCT_CD PRDCT_CD, RNDG_CD RNDG_CD, RNDG_RL RNDG_RL, VAL_CALC_RL VAL_CALC_RL, PREM_ASNMT_CD PREM_ASNMT_CD, PREM_ASNMT_LVL_CD PREM_ASNMT_LVL_CD, ACTL_PREM_TYP_CD ACTL_PREM_TYP_CD, PREM_PYR_CD PREM_PYR_CD, CR_LKBK_VAL CR_LKBK_VAL, CR_LKBK_UOM CR_LKBK_UOM, PRSPTV_R_RTSPTV_CD PRSPTV_R_RTSPTV_CD, UPR_LMT_VAL UPR_LMT_VAL, UPR_LMT_CALC_RL UPR_LMT_CALC_RL, LWR_LMT_VAL LWR_LMT_VAL, LWR_LMT_CALC_RL LWR_LMT_CALC_RL, VRBL_RT_ADD_ON_CALC_RL VRBL_RT_ADD_ON_CALC_RL, COST_ALLOCATION_KEYFLEX_ID COST_ALLOCATION_KEYFLEX_ID, ORGANIZATION_ID ORGANIZATION_ID, OIPL_ID OIPL_ID, PL_ID PL_ID, COMP_LVL_FCTR_ID COMP_LVL_FCTR_ID from "BEN"."BEN_ACTL_PREM_F"

View Text - HTML Formatted

SELECT ACTL_PREM_ID ACTL_PREM_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, NAME NAME
, ACTY_REF_PERD_CD ACTY_REF_PERD_CD
, UOM UOM
, CR_LKBK_CRNT_PY_ONLY_FLAG CR_LKBK_CRNT_PY_ONLY_FLAG
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, APR_ATTRIBUTE_CATEGORY APR_ATTRIBUTE_CATEGORY
, APR_ATTRIBUTE1 APR_ATTRIBUTE1
, APR_ATTRIBUTE2 APR_ATTRIBUTE2
, APR_ATTRIBUTE3 APR_ATTRIBUTE3
, APR_ATTRIBUTE4 APR_ATTRIBUTE4
, APR_ATTRIBUTE5 APR_ATTRIBUTE5
, APR_ATTRIBUTE6 APR_ATTRIBUTE6
, APR_ATTRIBUTE7 APR_ATTRIBUTE7
, APR_ATTRIBUTE8 APR_ATTRIBUTE8
, APR_ATTRIBUTE9 APR_ATTRIBUTE9
, APR_ATTRIBUTE10 APR_ATTRIBUTE10
, APR_ATTRIBUTE11 APR_ATTRIBUTE11
, APR_ATTRIBUTE12 APR_ATTRIBUTE12
, APR_ATTRIBUTE13 APR_ATTRIBUTE13
, APR_ATTRIBUTE14 APR_ATTRIBUTE14
, APR_ATTRIBUTE15 APR_ATTRIBUTE15
, APR_ATTRIBUTE16 APR_ATTRIBUTE16
, APR_ATTRIBUTE17 APR_ATTRIBUTE17
, APR_ATTRIBUTE18 APR_ATTRIBUTE18
, APR_ATTRIBUTE19 APR_ATTRIBUTE19
, APR_ATTRIBUTE20 APR_ATTRIBUTE20
, APR_ATTRIBUTE21 APR_ATTRIBUTE21
, APR_ATTRIBUTE22 APR_ATTRIBUTE22
, APR_ATTRIBUTE23 APR_ATTRIBUTE23
, APR_ATTRIBUTE24 APR_ATTRIBUTE24
, APR_ATTRIBUTE25 APR_ATTRIBUTE25
, APR_ATTRIBUTE26 APR_ATTRIBUTE26
, APR_ATTRIBUTE27 APR_ATTRIBUTE27
, APR_ATTRIBUTE28 APR_ATTRIBUTE28
, APR_ATTRIBUTE29 APR_ATTRIBUTE29
, APR_ATTRIBUTE30 APR_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
, PRTL_MO_DET_MTHD_CD PRTL_MO_DET_MTHD_CD
, PRTL_MO_DET_MTHD_RL PRTL_MO_DET_MTHD_RL
, WSH_RL_DY_MO_NUM WSH_RL_DY_MO_NUM
, RT_TYP_CD RT_TYP_CD
, BNFT_RT_TYP_CD BNFT_RT_TYP_CD
, VAL VAL
, MLT_CD MLT_CD
, PRDCT_CD PRDCT_CD
, RNDG_CD RNDG_CD
, RNDG_RL RNDG_RL
, VAL_CALC_RL VAL_CALC_RL
, PREM_ASNMT_CD PREM_ASNMT_CD
, PREM_ASNMT_LVL_CD PREM_ASNMT_LVL_CD
, ACTL_PREM_TYP_CD ACTL_PREM_TYP_CD
, PREM_PYR_CD PREM_PYR_CD
, CR_LKBK_VAL CR_LKBK_VAL
, CR_LKBK_UOM CR_LKBK_UOM
, PRSPTV_R_RTSPTV_CD PRSPTV_R_RTSPTV_CD
, UPR_LMT_VAL UPR_LMT_VAL
, UPR_LMT_CALC_RL UPR_LMT_CALC_RL
, LWR_LMT_VAL LWR_LMT_VAL
, LWR_LMT_CALC_RL LWR_LMT_CALC_RL
, VRBL_RT_ADD_ON_CALC_RL VRBL_RT_ADD_ON_CALC_RL
, COST_ALLOCATION_KEYFLEX_ID COST_ALLOCATION_KEYFLEX_ID
, ORGANIZATION_ID ORGANIZATION_ID
, OIPL_ID OIPL_ID
, PL_ID PL_ID
, COMP_LVL_FCTR_ID COMP_LVL_FCTR_ID
FROM "BEN"."BEN_ACTL_PREM_F"