VIEW: BEN.BEN_PER_CM_F#

Source

View Text - Preformatted

select PER_CM_ID PER_CM_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, PERSON_ID PERSON_ID, CM_TYP_ID CM_TYP_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, RQSTBL_UNTL_DT RQSTBL_UNTL_DT, PCM_ATTRIBUTE_CATEGORY PCM_ATTRIBUTE_CATEGORY, PCM_ATTRIBUTE1 PCM_ATTRIBUTE1, PCM_ATTRIBUTE2 PCM_ATTRIBUTE2, PCM_ATTRIBUTE3 PCM_ATTRIBUTE3, PCM_ATTRIBUTE4 PCM_ATTRIBUTE4, PCM_ATTRIBUTE5 PCM_ATTRIBUTE5, PCM_ATTRIBUTE6 PCM_ATTRIBUTE6, PCM_ATTRIBUTE7 PCM_ATTRIBUTE7, PCM_ATTRIBUTE8 PCM_ATTRIBUTE8, PCM_ATTRIBUTE9 PCM_ATTRIBUTE9, PCM_ATTRIBUTE10 PCM_ATTRIBUTE10, PCM_ATTRIBUTE11 PCM_ATTRIBUTE11, PCM_ATTRIBUTE12 PCM_ATTRIBUTE12, PCM_ATTRIBUTE13 PCM_ATTRIBUTE13, PCM_ATTRIBUTE14 PCM_ATTRIBUTE14, PCM_ATTRIBUTE15 PCM_ATTRIBUTE15, PCM_ATTRIBUTE16 PCM_ATTRIBUTE16, PCM_ATTRIBUTE17 PCM_ATTRIBUTE17, PCM_ATTRIBUTE18 PCM_ATTRIBUTE18, PCM_ATTRIBUTE19 PCM_ATTRIBUTE19, PCM_ATTRIBUTE20 PCM_ATTRIBUTE20, PCM_ATTRIBUTE21 PCM_ATTRIBUTE21, PCM_ATTRIBUTE22 PCM_ATTRIBUTE22, PCM_ATTRIBUTE23 PCM_ATTRIBUTE23, PCM_ATTRIBUTE24 PCM_ATTRIBUTE24, PCM_ATTRIBUTE25 PCM_ATTRIBUTE25, PCM_ATTRIBUTE26 PCM_ATTRIBUTE26, PCM_ATTRIBUTE27 PCM_ATTRIBUTE27, PCM_ATTRIBUTE28 PCM_ATTRIBUTE28, PCM_ATTRIBUTE29 PCM_ATTRIBUTE29, PCM_ATTRIBUTE30 PCM_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, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, LF_EVT_OCRD_DT LF_EVT_OCRD_DT, LER_ID LER_ID, BNF_PERSON_ID BNF_PERSON_ID, DPNT_PERSON_ID DPNT_PERSON_ID, PRTT_ENRT_ACTN_ID PRTT_ENRT_ACTN_ID, PER_IN_LER_ID PER_IN_LER_ID from "BEN"."BEN_PER_CM_F"

View Text - HTML Formatted

SELECT PER_CM_ID PER_CM_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, PERSON_ID PERSON_ID
, CM_TYP_ID CM_TYP_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, RQSTBL_UNTL_DT RQSTBL_UNTL_DT
, PCM_ATTRIBUTE_CATEGORY PCM_ATTRIBUTE_CATEGORY
, PCM_ATTRIBUTE1 PCM_ATTRIBUTE1
, PCM_ATTRIBUTE2 PCM_ATTRIBUTE2
, PCM_ATTRIBUTE3 PCM_ATTRIBUTE3
, PCM_ATTRIBUTE4 PCM_ATTRIBUTE4
, PCM_ATTRIBUTE5 PCM_ATTRIBUTE5
, PCM_ATTRIBUTE6 PCM_ATTRIBUTE6
, PCM_ATTRIBUTE7 PCM_ATTRIBUTE7
, PCM_ATTRIBUTE8 PCM_ATTRIBUTE8
, PCM_ATTRIBUTE9 PCM_ATTRIBUTE9
, PCM_ATTRIBUTE10 PCM_ATTRIBUTE10
, PCM_ATTRIBUTE11 PCM_ATTRIBUTE11
, PCM_ATTRIBUTE12 PCM_ATTRIBUTE12
, PCM_ATTRIBUTE13 PCM_ATTRIBUTE13
, PCM_ATTRIBUTE14 PCM_ATTRIBUTE14
, PCM_ATTRIBUTE15 PCM_ATTRIBUTE15
, PCM_ATTRIBUTE16 PCM_ATTRIBUTE16
, PCM_ATTRIBUTE17 PCM_ATTRIBUTE17
, PCM_ATTRIBUTE18 PCM_ATTRIBUTE18
, PCM_ATTRIBUTE19 PCM_ATTRIBUTE19
, PCM_ATTRIBUTE20 PCM_ATTRIBUTE20
, PCM_ATTRIBUTE21 PCM_ATTRIBUTE21
, PCM_ATTRIBUTE22 PCM_ATTRIBUTE22
, PCM_ATTRIBUTE23 PCM_ATTRIBUTE23
, PCM_ATTRIBUTE24 PCM_ATTRIBUTE24
, PCM_ATTRIBUTE25 PCM_ATTRIBUTE25
, PCM_ATTRIBUTE26 PCM_ATTRIBUTE26
, PCM_ATTRIBUTE27 PCM_ATTRIBUTE27
, PCM_ATTRIBUTE28 PCM_ATTRIBUTE28
, PCM_ATTRIBUTE29 PCM_ATTRIBUTE29
, PCM_ATTRIBUTE30 PCM_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
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, LF_EVT_OCRD_DT LF_EVT_OCRD_DT
, LER_ID LER_ID
, BNF_PERSON_ID BNF_PERSON_ID
, DPNT_PERSON_ID DPNT_PERSON_ID
, PRTT_ENRT_ACTN_ID PRTT_ENRT_ACTN_ID
, PER_IN_LER_ID PER_IN_LER_ID
FROM "BEN"."BEN_PER_CM_F"