VIEW: BEN.BEN_PRTT_PREM_BY_MO_F#

Source

View Text - Preformatted

select PRTT_PREM_BY_MO_ID PRTT_PREM_BY_MO_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, MNL_ADJ_FLAG MNL_ADJ_FLAG, CR_MNL_ADJ_FLAG CR_MNL_ADJ_FLAG, ALCTD_VAL_FLAG ALCTD_VAL_FLAG, PRTT_PREM_ID PRTT_PREM_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, PRM_ATTRIBUTE_CATEGORY PRM_ATTRIBUTE_CATEGORY, PRM_ATTRIBUTE1 PRM_ATTRIBUTE1, PRM_ATTRIBUTE2 PRM_ATTRIBUTE2, PRM_ATTRIBUTE3 PRM_ATTRIBUTE3, PRM_ATTRIBUTE4 PRM_ATTRIBUTE4, PRM_ATTRIBUTE5 PRM_ATTRIBUTE5, PRM_ATTRIBUTE6 PRM_ATTRIBUTE6, PRM_ATTRIBUTE7 PRM_ATTRIBUTE7, PRM_ATTRIBUTE8 PRM_ATTRIBUTE8, PRM_ATTRIBUTE9 PRM_ATTRIBUTE9, PRM_ATTRIBUTE10 PRM_ATTRIBUTE10, PRM_ATTRIBUTE11 PRM_ATTRIBUTE11, PRM_ATTRIBUTE12 PRM_ATTRIBUTE12, PRM_ATTRIBUTE13 PRM_ATTRIBUTE13, PRM_ATTRIBUTE14 PRM_ATTRIBUTE14, PRM_ATTRIBUTE15 PRM_ATTRIBUTE15, PRM_ATTRIBUTE16 PRM_ATTRIBUTE16, PRM_ATTRIBUTE17 PRM_ATTRIBUTE17, PRM_ATTRIBUTE18 PRM_ATTRIBUTE18, PRM_ATTRIBUTE19 PRM_ATTRIBUTE19, PRM_ATTRIBUTE20 PRM_ATTRIBUTE20, PRM_ATTRIBUTE21 PRM_ATTRIBUTE21, PRM_ATTRIBUTE22 PRM_ATTRIBUTE22, PRM_ATTRIBUTE23 PRM_ATTRIBUTE23, PRM_ATTRIBUTE24 PRM_ATTRIBUTE24, PRM_ATTRIBUTE25 PRM_ATTRIBUTE25, PRM_ATTRIBUTE26 PRM_ATTRIBUTE26, PRM_ATTRIBUTE27 PRM_ATTRIBUTE27, PRM_ATTRIBUTE28 PRM_ATTRIBUTE28, PRM_ATTRIBUTE29 PRM_ATTRIBUTE29, PRM_ATTRIBUTE30 PRM_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, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, MO_NUM MO_NUM, YR_NUM YR_NUM, ANTCPD_PRTT_CNTR_UOM ANTCPD_PRTT_CNTR_UOM, ANTCPD_PRTT_CNTR_VAL ANTCPD_PRTT_CNTR_VAL, VAL VAL, CR_VAL CR_VAL, UOM UOM, COST_ALLOCATION_KEYFLEX_ID COST_ALLOCATION_KEYFLEX_ID from "BEN"."BEN_PRTT_PREM_BY_MO_F"

View Text - HTML Formatted

SELECT PRTT_PREM_BY_MO_ID PRTT_PREM_BY_MO_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, MNL_ADJ_FLAG MNL_ADJ_FLAG
, CR_MNL_ADJ_FLAG CR_MNL_ADJ_FLAG
, ALCTD_VAL_FLAG ALCTD_VAL_FLAG
, PRTT_PREM_ID PRTT_PREM_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PRM_ATTRIBUTE_CATEGORY PRM_ATTRIBUTE_CATEGORY
, PRM_ATTRIBUTE1 PRM_ATTRIBUTE1
, PRM_ATTRIBUTE2 PRM_ATTRIBUTE2
, PRM_ATTRIBUTE3 PRM_ATTRIBUTE3
, PRM_ATTRIBUTE4 PRM_ATTRIBUTE4
, PRM_ATTRIBUTE5 PRM_ATTRIBUTE5
, PRM_ATTRIBUTE6 PRM_ATTRIBUTE6
, PRM_ATTRIBUTE7 PRM_ATTRIBUTE7
, PRM_ATTRIBUTE8 PRM_ATTRIBUTE8
, PRM_ATTRIBUTE9 PRM_ATTRIBUTE9
, PRM_ATTRIBUTE10 PRM_ATTRIBUTE10
, PRM_ATTRIBUTE11 PRM_ATTRIBUTE11
, PRM_ATTRIBUTE12 PRM_ATTRIBUTE12
, PRM_ATTRIBUTE13 PRM_ATTRIBUTE13
, PRM_ATTRIBUTE14 PRM_ATTRIBUTE14
, PRM_ATTRIBUTE15 PRM_ATTRIBUTE15
, PRM_ATTRIBUTE16 PRM_ATTRIBUTE16
, PRM_ATTRIBUTE17 PRM_ATTRIBUTE17
, PRM_ATTRIBUTE18 PRM_ATTRIBUTE18
, PRM_ATTRIBUTE19 PRM_ATTRIBUTE19
, PRM_ATTRIBUTE20 PRM_ATTRIBUTE20
, PRM_ATTRIBUTE21 PRM_ATTRIBUTE21
, PRM_ATTRIBUTE22 PRM_ATTRIBUTE22
, PRM_ATTRIBUTE23 PRM_ATTRIBUTE23
, PRM_ATTRIBUTE24 PRM_ATTRIBUTE24
, PRM_ATTRIBUTE25 PRM_ATTRIBUTE25
, PRM_ATTRIBUTE26 PRM_ATTRIBUTE26
, PRM_ATTRIBUTE27 PRM_ATTRIBUTE27
, PRM_ATTRIBUTE28 PRM_ATTRIBUTE28
, PRM_ATTRIBUTE29 PRM_ATTRIBUTE29
, PRM_ATTRIBUTE30 PRM_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
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, MO_NUM MO_NUM
, YR_NUM YR_NUM
, ANTCPD_PRTT_CNTR_UOM ANTCPD_PRTT_CNTR_UOM
, ANTCPD_PRTT_CNTR_VAL ANTCPD_PRTT_CNTR_VAL
, VAL VAL
, CR_VAL CR_VAL
, UOM UOM
, COST_ALLOCATION_KEYFLEX_ID COST_ALLOCATION_KEYFLEX_ID
FROM "BEN"."BEN_PRTT_PREM_BY_MO_F"