VIEW: BEN.BEN_PRTT_PREM_F#

Source

View Text - Preformatted

select PRTT_PREM_ID PRTT_PREM_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, ACTL_PREM_ID ACTL_PREM_ID, PRTT_ENRT_RSLT_ID PRTT_ENRT_RSLT_ID, PER_IN_LER_ID PER_IN_LER_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, PPE_ATTRIBUTE_CATEGORY PPE_ATTRIBUTE_CATEGORY, PPE_ATTRIBUTE1 PPE_ATTRIBUTE1, PPE_ATTRIBUTE2 PPE_ATTRIBUTE2, PPE_ATTRIBUTE3 PPE_ATTRIBUTE3, PPE_ATTRIBUTE4 PPE_ATTRIBUTE4, PPE_ATTRIBUTE5 PPE_ATTRIBUTE5, PPE_ATTRIBUTE6 PPE_ATTRIBUTE6, PPE_ATTRIBUTE7 PPE_ATTRIBUTE7, PPE_ATTRIBUTE8 PPE_ATTRIBUTE8, PPE_ATTRIBUTE9 PPE_ATTRIBUTE9, PPE_ATTRIBUTE10 PPE_ATTRIBUTE10, PPE_ATTRIBUTE11 PPE_ATTRIBUTE11, PPE_ATTRIBUTE12 PPE_ATTRIBUTE12, PPE_ATTRIBUTE13 PPE_ATTRIBUTE13, PPE_ATTRIBUTE14 PPE_ATTRIBUTE14, PPE_ATTRIBUTE15 PPE_ATTRIBUTE15, PPE_ATTRIBUTE16 PPE_ATTRIBUTE16, PPE_ATTRIBUTE17 PPE_ATTRIBUTE17, PPE_ATTRIBUTE18 PPE_ATTRIBUTE18, PPE_ATTRIBUTE19 PPE_ATTRIBUTE19, PPE_ATTRIBUTE20 PPE_ATTRIBUTE20, PPE_ATTRIBUTE21 PPE_ATTRIBUTE21, PPE_ATTRIBUTE22 PPE_ATTRIBUTE22, PPE_ATTRIBUTE23 PPE_ATTRIBUTE23, PPE_ATTRIBUTE24 PPE_ATTRIBUTE24, PPE_ATTRIBUTE25 PPE_ATTRIBUTE25, PPE_ATTRIBUTE26 PPE_ATTRIBUTE26, PPE_ATTRIBUTE27 PPE_ATTRIBUTE27, PPE_ATTRIBUTE28 PPE_ATTRIBUTE28, PPE_ATTRIBUTE29 PPE_ATTRIBUTE29, PPE_ATTRIBUTE30 PPE_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, STD_PREM_UOM STD_PREM_UOM, STD_PREM_VAL STD_PREM_VAL from "BEN"."BEN_PRTT_PREM_F"

View Text - HTML Formatted

SELECT PRTT_PREM_ID PRTT_PREM_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, ACTL_PREM_ID ACTL_PREM_ID
, PRTT_ENRT_RSLT_ID PRTT_ENRT_RSLT_ID
, PER_IN_LER_ID PER_IN_LER_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PPE_ATTRIBUTE_CATEGORY PPE_ATTRIBUTE_CATEGORY
, PPE_ATTRIBUTE1 PPE_ATTRIBUTE1
, PPE_ATTRIBUTE2 PPE_ATTRIBUTE2
, PPE_ATTRIBUTE3 PPE_ATTRIBUTE3
, PPE_ATTRIBUTE4 PPE_ATTRIBUTE4
, PPE_ATTRIBUTE5 PPE_ATTRIBUTE5
, PPE_ATTRIBUTE6 PPE_ATTRIBUTE6
, PPE_ATTRIBUTE7 PPE_ATTRIBUTE7
, PPE_ATTRIBUTE8 PPE_ATTRIBUTE8
, PPE_ATTRIBUTE9 PPE_ATTRIBUTE9
, PPE_ATTRIBUTE10 PPE_ATTRIBUTE10
, PPE_ATTRIBUTE11 PPE_ATTRIBUTE11
, PPE_ATTRIBUTE12 PPE_ATTRIBUTE12
, PPE_ATTRIBUTE13 PPE_ATTRIBUTE13
, PPE_ATTRIBUTE14 PPE_ATTRIBUTE14
, PPE_ATTRIBUTE15 PPE_ATTRIBUTE15
, PPE_ATTRIBUTE16 PPE_ATTRIBUTE16
, PPE_ATTRIBUTE17 PPE_ATTRIBUTE17
, PPE_ATTRIBUTE18 PPE_ATTRIBUTE18
, PPE_ATTRIBUTE19 PPE_ATTRIBUTE19
, PPE_ATTRIBUTE20 PPE_ATTRIBUTE20
, PPE_ATTRIBUTE21 PPE_ATTRIBUTE21
, PPE_ATTRIBUTE22 PPE_ATTRIBUTE22
, PPE_ATTRIBUTE23 PPE_ATTRIBUTE23
, PPE_ATTRIBUTE24 PPE_ATTRIBUTE24
, PPE_ATTRIBUTE25 PPE_ATTRIBUTE25
, PPE_ATTRIBUTE26 PPE_ATTRIBUTE26
, PPE_ATTRIBUTE27 PPE_ATTRIBUTE27
, PPE_ATTRIBUTE28 PPE_ATTRIBUTE28
, PPE_ATTRIBUTE29 PPE_ATTRIBUTE29
, PPE_ATTRIBUTE30 PPE_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
, STD_PREM_UOM STD_PREM_UOM
, STD_PREM_VAL STD_PREM_VAL
FROM "BEN"."BEN_PRTT_PREM_F"