VIEW: BEN.BEN_PL_REGN_F#

Source

View Text - Preformatted

select PL_REGN_ID PL_REGN_ID, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, REGN_ID REGN_ID, HGHLY_COMPD_DET_RL HGHLY_COMPD_DET_RL, KEY_EE_DET_RL KEY_EE_DET_RL, CNTR_NNDSCRN_RL CNTR_NNDSCRN_RL, CVG_NNDSCRN_RL CVG_NNDSCRN_RL, FIVE_PCT_OWNR_RL FIVE_PCT_OWNR_RL, PRG_ATTRIBUTE_CATEGORY PRG_ATTRIBUTE_CATEGORY, PRG_ATTRIBUTE1 PRG_ATTRIBUTE1, PRG_ATTRIBUTE2 PRG_ATTRIBUTE2, PRG_ATTRIBUTE3 PRG_ATTRIBUTE3, PRG_ATTRIBUTE4 PRG_ATTRIBUTE4, PRG_ATTRIBUTE5 PRG_ATTRIBUTE5, PRG_ATTRIBUTE6 PRG_ATTRIBUTE6, PRG_ATTRIBUTE7 PRG_ATTRIBUTE7, PRG_ATTRIBUTE8 PRG_ATTRIBUTE8, PRG_ATTRIBUTE9 PRG_ATTRIBUTE9, PRG_ATTRIBUTE10 PRG_ATTRIBUTE10, PRG_ATTRIBUTE11 PRG_ATTRIBUTE11, PRG_ATTRIBUTE12 PRG_ATTRIBUTE12, PRG_ATTRIBUTE13 PRG_ATTRIBUTE13, PRG_ATTRIBUTE14 PRG_ATTRIBUTE14, PRG_ATTRIBUTE15 PRG_ATTRIBUTE15, PRG_ATTRIBUTE16 PRG_ATTRIBUTE16, PRG_ATTRIBUTE17 PRG_ATTRIBUTE17, PRG_ATTRIBUTE18 PRG_ATTRIBUTE18, PRG_ATTRIBUTE19 PRG_ATTRIBUTE19, PRG_ATTRIBUTE20 PRG_ATTRIBUTE20, PRG_ATTRIBUTE21 PRG_ATTRIBUTE21, PRG_ATTRIBUTE22 PRG_ATTRIBUTE22, PRG_ATTRIBUTE23 PRG_ATTRIBUTE23, PRG_ATTRIBUTE24 PRG_ATTRIBUTE24, PRG_ATTRIBUTE25 PRG_ATTRIBUTE25, PRG_ATTRIBUTE26 PRG_ATTRIBUTE26, PRG_ATTRIBUTE27 PRG_ATTRIBUTE27, PRG_ATTRIBUTE28 PRG_ATTRIBUTE28, PRG_ATTRIBUTE29 PRG_ATTRIBUTE29, PRG_ATTRIBUTE30 PRG_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, RPTG_GRP_ID RPTG_GRP_ID, PL_ID PL_ID, REGY_PL_TYP_CD REGY_PL_TYP_CD from "BEN"."BEN_PL_REGN_F"

View Text - HTML Formatted

SELECT PL_REGN_ID PL_REGN_ID
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, REGN_ID REGN_ID
, HGHLY_COMPD_DET_RL HGHLY_COMPD_DET_RL
, KEY_EE_DET_RL KEY_EE_DET_RL
, CNTR_NNDSCRN_RL CNTR_NNDSCRN_RL
, CVG_NNDSCRN_RL CVG_NNDSCRN_RL
, FIVE_PCT_OWNR_RL FIVE_PCT_OWNR_RL
, PRG_ATTRIBUTE_CATEGORY PRG_ATTRIBUTE_CATEGORY
, PRG_ATTRIBUTE1 PRG_ATTRIBUTE1
, PRG_ATTRIBUTE2 PRG_ATTRIBUTE2
, PRG_ATTRIBUTE3 PRG_ATTRIBUTE3
, PRG_ATTRIBUTE4 PRG_ATTRIBUTE4
, PRG_ATTRIBUTE5 PRG_ATTRIBUTE5
, PRG_ATTRIBUTE6 PRG_ATTRIBUTE6
, PRG_ATTRIBUTE7 PRG_ATTRIBUTE7
, PRG_ATTRIBUTE8 PRG_ATTRIBUTE8
, PRG_ATTRIBUTE9 PRG_ATTRIBUTE9
, PRG_ATTRIBUTE10 PRG_ATTRIBUTE10
, PRG_ATTRIBUTE11 PRG_ATTRIBUTE11
, PRG_ATTRIBUTE12 PRG_ATTRIBUTE12
, PRG_ATTRIBUTE13 PRG_ATTRIBUTE13
, PRG_ATTRIBUTE14 PRG_ATTRIBUTE14
, PRG_ATTRIBUTE15 PRG_ATTRIBUTE15
, PRG_ATTRIBUTE16 PRG_ATTRIBUTE16
, PRG_ATTRIBUTE17 PRG_ATTRIBUTE17
, PRG_ATTRIBUTE18 PRG_ATTRIBUTE18
, PRG_ATTRIBUTE19 PRG_ATTRIBUTE19
, PRG_ATTRIBUTE20 PRG_ATTRIBUTE20
, PRG_ATTRIBUTE21 PRG_ATTRIBUTE21
, PRG_ATTRIBUTE22 PRG_ATTRIBUTE22
, PRG_ATTRIBUTE23 PRG_ATTRIBUTE23
, PRG_ATTRIBUTE24 PRG_ATTRIBUTE24
, PRG_ATTRIBUTE25 PRG_ATTRIBUTE25
, PRG_ATTRIBUTE26 PRG_ATTRIBUTE26
, PRG_ATTRIBUTE27 PRG_ATTRIBUTE27
, PRG_ATTRIBUTE28 PRG_ATTRIBUTE28
, PRG_ATTRIBUTE29 PRG_ATTRIBUTE29
, PRG_ATTRIBUTE30 PRG_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
, RPTG_GRP_ID RPTG_GRP_ID
, PL_ID PL_ID
, REGY_PL_TYP_CD REGY_PL_TYP_CD
FROM "BEN"."BEN_PL_REGN_F"