VIEW: BEN.BEN_ENRT_PERD_FOR_PL_F#

Source

View Text - Preformatted

select ENRT_PERD_FOR_PL_ID ENRT_PERD_FOR_PL_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, PL_ID PL_ID, ERP_ATTRIBUTE_CATEGORY ERP_ATTRIBUTE_CATEGORY, ERP_ATTRIBUTE1 ERP_ATTRIBUTE1, ERP_ATTRIBUTE2 ERP_ATTRIBUTE2, ERP_ATTRIBUTE3 ERP_ATTRIBUTE3, ERP_ATTRIBUTE4 ERP_ATTRIBUTE4, ERP_ATTRIBUTE5 ERP_ATTRIBUTE5, ERP_ATTRIBUTE6 ERP_ATTRIBUTE6, ERP_ATTRIBUTE7 ERP_ATTRIBUTE7, ERP_ATTRIBUTE8 ERP_ATTRIBUTE8, ERP_ATTRIBUTE9 ERP_ATTRIBUTE9, ERP_ATTRIBUTE10 ERP_ATTRIBUTE10, ERP_ATTRIBUTE11 ERP_ATTRIBUTE11, ERP_ATTRIBUTE12 ERP_ATTRIBUTE12, ERP_ATTRIBUTE13 ERP_ATTRIBUTE13, ERP_ATTRIBUTE14 ERP_ATTRIBUTE14, ERP_ATTRIBUTE15 ERP_ATTRIBUTE15, ERP_ATTRIBUTE16 ERP_ATTRIBUTE16, ERP_ATTRIBUTE17 ERP_ATTRIBUTE17, ERP_ATTRIBUTE18 ERP_ATTRIBUTE18, ERP_ATTRIBUTE19 ERP_ATTRIBUTE19, ERP_ATTRIBUTE20 ERP_ATTRIBUTE20, ERP_ATTRIBUTE21 ERP_ATTRIBUTE21, ERP_ATTRIBUTE22 ERP_ATTRIBUTE22, ERP_ATTRIBUTE23 ERP_ATTRIBUTE23, ERP_ATTRIBUTE24 ERP_ATTRIBUTE24, ERP_ATTRIBUTE25 ERP_ATTRIBUTE25, ERP_ATTRIBUTE26 ERP_ATTRIBUTE26, ERP_ATTRIBUTE27 ERP_ATTRIBUTE27, ERP_ATTRIBUTE28 ERP_ATTRIBUTE28, ERP_ATTRIBUTE29 ERP_ATTRIBUTE29, ERP_ATTRIBUTE30 ERP_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, ENRT_CVG_STRT_DT_CD ENRT_CVG_STRT_DT_CD, ENRT_CVG_STRT_DT_RL ENRT_CVG_STRT_DT_RL, ENRT_CVG_END_DT_CD ENRT_CVG_END_DT_CD, ENRT_CVG_END_DT_RL ENRT_CVG_END_DT_RL, RT_STRT_DT_CD RT_STRT_DT_CD, RT_STRT_DT_RL RT_STRT_DT_RL, RT_END_DT_CD RT_END_DT_CD, RT_END_DT_RL RT_END_DT_RL, ENRT_PERD_ID ENRT_PERD_ID, LEE_RSN_ID LEE_RSN_ID from "BEN"."BEN_ENRT_PERD_FOR_PL_F"

View Text - HTML Formatted

SELECT ENRT_PERD_FOR_PL_ID ENRT_PERD_FOR_PL_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PL_ID PL_ID
, ERP_ATTRIBUTE_CATEGORY ERP_ATTRIBUTE_CATEGORY
, ERP_ATTRIBUTE1 ERP_ATTRIBUTE1
, ERP_ATTRIBUTE2 ERP_ATTRIBUTE2
, ERP_ATTRIBUTE3 ERP_ATTRIBUTE3
, ERP_ATTRIBUTE4 ERP_ATTRIBUTE4
, ERP_ATTRIBUTE5 ERP_ATTRIBUTE5
, ERP_ATTRIBUTE6 ERP_ATTRIBUTE6
, ERP_ATTRIBUTE7 ERP_ATTRIBUTE7
, ERP_ATTRIBUTE8 ERP_ATTRIBUTE8
, ERP_ATTRIBUTE9 ERP_ATTRIBUTE9
, ERP_ATTRIBUTE10 ERP_ATTRIBUTE10
, ERP_ATTRIBUTE11 ERP_ATTRIBUTE11
, ERP_ATTRIBUTE12 ERP_ATTRIBUTE12
, ERP_ATTRIBUTE13 ERP_ATTRIBUTE13
, ERP_ATTRIBUTE14 ERP_ATTRIBUTE14
, ERP_ATTRIBUTE15 ERP_ATTRIBUTE15
, ERP_ATTRIBUTE16 ERP_ATTRIBUTE16
, ERP_ATTRIBUTE17 ERP_ATTRIBUTE17
, ERP_ATTRIBUTE18 ERP_ATTRIBUTE18
, ERP_ATTRIBUTE19 ERP_ATTRIBUTE19
, ERP_ATTRIBUTE20 ERP_ATTRIBUTE20
, ERP_ATTRIBUTE21 ERP_ATTRIBUTE21
, ERP_ATTRIBUTE22 ERP_ATTRIBUTE22
, ERP_ATTRIBUTE23 ERP_ATTRIBUTE23
, ERP_ATTRIBUTE24 ERP_ATTRIBUTE24
, ERP_ATTRIBUTE25 ERP_ATTRIBUTE25
, ERP_ATTRIBUTE26 ERP_ATTRIBUTE26
, ERP_ATTRIBUTE27 ERP_ATTRIBUTE27
, ERP_ATTRIBUTE28 ERP_ATTRIBUTE28
, ERP_ATTRIBUTE29 ERP_ATTRIBUTE29
, ERP_ATTRIBUTE30 ERP_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
, ENRT_CVG_STRT_DT_CD ENRT_CVG_STRT_DT_CD
, ENRT_CVG_STRT_DT_RL ENRT_CVG_STRT_DT_RL
, ENRT_CVG_END_DT_CD ENRT_CVG_END_DT_CD
, ENRT_CVG_END_DT_RL ENRT_CVG_END_DT_RL
, RT_STRT_DT_CD RT_STRT_DT_CD
, RT_STRT_DT_RL RT_STRT_DT_RL
, RT_END_DT_CD RT_END_DT_CD
, RT_END_DT_RL RT_END_DT_RL
, ENRT_PERD_ID ENRT_PERD_ID
, LEE_RSN_ID LEE_RSN_ID
FROM "BEN"."BEN_ENRT_PERD_FOR_PL_F"