VIEW: BEN.BEN_PL_R_OIPL_PREM_BY_MO_F#

Source

View Text - Preformatted

select PL_R_OIPL_PREM_BY_MO_ID PL_R_OIPL_PREM_BY_MO_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, MNL_ADJ_FLAG MNL_ADJ_FLAG, ACTL_PREM_ID ACTL_PREM_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, PBM_ATTRIBUTE_CATEGORY PBM_ATTRIBUTE_CATEGORY, PBM_ATTRIBUTE1 PBM_ATTRIBUTE1, PBM_ATTRIBUTE2 PBM_ATTRIBUTE2, PBM_ATTRIBUTE3 PBM_ATTRIBUTE3, PBM_ATTRIBUTE4 PBM_ATTRIBUTE4, PBM_ATTRIBUTE5 PBM_ATTRIBUTE5, PBM_ATTRIBUTE6 PBM_ATTRIBUTE6, PBM_ATTRIBUTE7 PBM_ATTRIBUTE7, PBM_ATTRIBUTE8 PBM_ATTRIBUTE8, PBM_ATTRIBUTE9 PBM_ATTRIBUTE9, PBM_ATTRIBUTE10 PBM_ATTRIBUTE10, PBM_ATTRIBUTE11 PBM_ATTRIBUTE11, PBM_ATTRIBUTE12 PBM_ATTRIBUTE12, PBM_ATTRIBUTE13 PBM_ATTRIBUTE13, PBM_ATTRIBUTE14 PBM_ATTRIBUTE14, PBM_ATTRIBUTE15 PBM_ATTRIBUTE15, PBM_ATTRIBUTE16 PBM_ATTRIBUTE16, PBM_ATTRIBUTE17 PBM_ATTRIBUTE17, PBM_ATTRIBUTE18 PBM_ATTRIBUTE18, PBM_ATTRIBUTE19 PBM_ATTRIBUTE19, PBM_ATTRIBUTE20 PBM_ATTRIBUTE20, PBM_ATTRIBUTE21 PBM_ATTRIBUTE21, PBM_ATTRIBUTE22 PBM_ATTRIBUTE22, PBM_ATTRIBUTE23 PBM_ATTRIBUTE23, PBM_ATTRIBUTE24 PBM_ATTRIBUTE24, PBM_ATTRIBUTE25 PBM_ATTRIBUTE25, PBM_ATTRIBUTE26 PBM_ATTRIBUTE26, PBM_ATTRIBUTE27 PBM_ATTRIBUTE27, PBM_ATTRIBUTE28 PBM_ATTRIBUTE28, PBM_ATTRIBUTE29 PBM_ATTRIBUTE29, PBM_ATTRIBUTE30 PBM_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, COST_ALLOCATION_KEYFLEX_ID COST_ALLOCATION_KEYFLEX_ID, REQUEST_ID REQUEST_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, MO_NUM MO_NUM, YR_NUM YR_NUM, VAL VAL, UOM UOM, PRTTS_NUM PRTTS_NUM from "BEN"."BEN_PL_R_OIPL_PREM_BY_MO_F"

View Text - HTML Formatted

SELECT PL_R_OIPL_PREM_BY_MO_ID PL_R_OIPL_PREM_BY_MO_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, MNL_ADJ_FLAG MNL_ADJ_FLAG
, ACTL_PREM_ID ACTL_PREM_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PBM_ATTRIBUTE_CATEGORY PBM_ATTRIBUTE_CATEGORY
, PBM_ATTRIBUTE1 PBM_ATTRIBUTE1
, PBM_ATTRIBUTE2 PBM_ATTRIBUTE2
, PBM_ATTRIBUTE3 PBM_ATTRIBUTE3
, PBM_ATTRIBUTE4 PBM_ATTRIBUTE4
, PBM_ATTRIBUTE5 PBM_ATTRIBUTE5
, PBM_ATTRIBUTE6 PBM_ATTRIBUTE6
, PBM_ATTRIBUTE7 PBM_ATTRIBUTE7
, PBM_ATTRIBUTE8 PBM_ATTRIBUTE8
, PBM_ATTRIBUTE9 PBM_ATTRIBUTE9
, PBM_ATTRIBUTE10 PBM_ATTRIBUTE10
, PBM_ATTRIBUTE11 PBM_ATTRIBUTE11
, PBM_ATTRIBUTE12 PBM_ATTRIBUTE12
, PBM_ATTRIBUTE13 PBM_ATTRIBUTE13
, PBM_ATTRIBUTE14 PBM_ATTRIBUTE14
, PBM_ATTRIBUTE15 PBM_ATTRIBUTE15
, PBM_ATTRIBUTE16 PBM_ATTRIBUTE16
, PBM_ATTRIBUTE17 PBM_ATTRIBUTE17
, PBM_ATTRIBUTE18 PBM_ATTRIBUTE18
, PBM_ATTRIBUTE19 PBM_ATTRIBUTE19
, PBM_ATTRIBUTE20 PBM_ATTRIBUTE20
, PBM_ATTRIBUTE21 PBM_ATTRIBUTE21
, PBM_ATTRIBUTE22 PBM_ATTRIBUTE22
, PBM_ATTRIBUTE23 PBM_ATTRIBUTE23
, PBM_ATTRIBUTE24 PBM_ATTRIBUTE24
, PBM_ATTRIBUTE25 PBM_ATTRIBUTE25
, PBM_ATTRIBUTE26 PBM_ATTRIBUTE26
, PBM_ATTRIBUTE27 PBM_ATTRIBUTE27
, PBM_ATTRIBUTE28 PBM_ATTRIBUTE28
, PBM_ATTRIBUTE29 PBM_ATTRIBUTE29
, PBM_ATTRIBUTE30 PBM_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
, COST_ALLOCATION_KEYFLEX_ID COST_ALLOCATION_KEYFLEX_ID
, REQUEST_ID REQUEST_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, MO_NUM MO_NUM
, YR_NUM YR_NUM
, VAL VAL
, UOM UOM
, PRTTS_NUM PRTTS_NUM
FROM "BEN"."BEN_PL_R_OIPL_PREM_BY_MO_F"