eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: BEN.BEN_CVRD_DPNT_CTFN_PRVDD_F#

Source

View Text - Preformatted


select CVRD_DPNT_CTFN_PRVDD_ID CVRD_DPNT_CTFN_PRVDD_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, DPNT_DSGN_CTFN_TYP_CD DPNT_DSGN_CTFN_TYP_CD, DPNT_DSGN_CTFN_RQD_FLAG DPNT_DSGN_CTFN_RQD_FLAG, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, ELIG_CVRD_DPNT_ID ELIG_CVRD_DPNT_ID, PRTT_ENRT_ACTN_ID PRTT_ENRT_ACTN_ID, CCP_ATTRIBUTE_CATEGORY CCP_ATTRIBUTE_CATEGORY, CCP_ATTRIBUTE1 CCP_ATTRIBUTE1, CCP_ATTRIBUTE2 CCP_ATTRIBUTE2, CCP_ATTRIBUTE3 CCP_ATTRIBUTE3, CCP_ATTRIBUTE4 CCP_ATTRIBUTE4, CCP_ATTRIBUTE5 CCP_ATTRIBUTE5, CCP_ATTRIBUTE6 CCP_ATTRIBUTE6, CCP_ATTRIBUTE7 CCP_ATTRIBUTE7, CCP_ATTRIBUTE8 CCP_ATTRIBUTE8, CCP_ATTRIBUTE9 CCP_ATTRIBUTE9, CCP_ATTRIBUTE10 CCP_ATTRIBUTE10, CCP_ATTRIBUTE11 CCP_ATTRIBUTE11, CCP_ATTRIBUTE12 CCP_ATTRIBUTE12, CCP_ATTRIBUTE13 CCP_ATTRIBUTE13, CCP_ATTRIBUTE14 CCP_ATTRIBUTE14, CCP_ATTRIBUTE15 CCP_ATTRIBUTE15, CCP_ATTRIBUTE16 CCP_ATTRIBUTE16, CCP_ATTRIBUTE17 CCP_ATTRIBUTE17, CCP_ATTRIBUTE18 CCP_ATTRIBUTE18, CCP_ATTRIBUTE19 CCP_ATTRIBUTE19, CCP_ATTRIBUTE20 CCP_ATTRIBUTE20, CCP_ATTRIBUTE21 CCP_ATTRIBUTE21, CCP_ATTRIBUTE22 CCP_ATTRIBUTE22, CCP_ATTRIBUTE23 CCP_ATTRIBUTE23, CCP_ATTRIBUTE24 CCP_ATTRIBUTE24, CCP_ATTRIBUTE25 CCP_ATTRIBUTE25, CCP_ATTRIBUTE26 CCP_ATTRIBUTE26, CCP_ATTRIBUTE27 CCP_ATTRIBUTE27, CCP_ATTRIBUTE28 CCP_ATTRIBUTE28, CCP_ATTRIBUTE29 CCP_ATTRIBUTE29, CCP_ATTRIBUTE30 CCP_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, DPNT_DSGN_CTFN_RECD_DT DPNT_DSGN_CTFN_RECD_DT from "BEN"."BEN_CVRD_DPNT_CTFN_PRVDD_F"

View Text - HTML Formatted

SELECT CVRD_DPNT_CTFN_PRVDD_ID CVRD_DPNT_CTFN_PRVDD_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, DPNT_DSGN_CTFN_TYP_CD DPNT_DSGN_CTFN_TYP_CD
, DPNT_DSGN_CTFN_RQD_FLAG DPNT_DSGN_CTFN_RQD_FLAG
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, ELIG_CVRD_DPNT_ID ELIG_CVRD_DPNT_ID
, PRTT_ENRT_ACTN_ID PRTT_ENRT_ACTN_ID
, CCP_ATTRIBUTE_CATEGORY CCP_ATTRIBUTE_CATEGORY
, CCP_ATTRIBUTE1 CCP_ATTRIBUTE1
, CCP_ATTRIBUTE2 CCP_ATTRIBUTE2
, CCP_ATTRIBUTE3 CCP_ATTRIBUTE3
, CCP_ATTRIBUTE4 CCP_ATTRIBUTE4
, CCP_ATTRIBUTE5 CCP_ATTRIBUTE5
, CCP_ATTRIBUTE6 CCP_ATTRIBUTE6
, CCP_ATTRIBUTE7 CCP_ATTRIBUTE7
, CCP_ATTRIBUTE8 CCP_ATTRIBUTE8
, CCP_ATTRIBUTE9 CCP_ATTRIBUTE9
, CCP_ATTRIBUTE10 CCP_ATTRIBUTE10
, CCP_ATTRIBUTE11 CCP_ATTRIBUTE11
, CCP_ATTRIBUTE12 CCP_ATTRIBUTE12
, CCP_ATTRIBUTE13 CCP_ATTRIBUTE13
, CCP_ATTRIBUTE14 CCP_ATTRIBUTE14
, CCP_ATTRIBUTE15 CCP_ATTRIBUTE15
, CCP_ATTRIBUTE16 CCP_ATTRIBUTE16
, CCP_ATTRIBUTE17 CCP_ATTRIBUTE17
, CCP_ATTRIBUTE18 CCP_ATTRIBUTE18
, CCP_ATTRIBUTE19 CCP_ATTRIBUTE19
, CCP_ATTRIBUTE20 CCP_ATTRIBUTE20
, CCP_ATTRIBUTE21 CCP_ATTRIBUTE21
, CCP_ATTRIBUTE22 CCP_ATTRIBUTE22
, CCP_ATTRIBUTE23 CCP_ATTRIBUTE23
, CCP_ATTRIBUTE24 CCP_ATTRIBUTE24
, CCP_ATTRIBUTE25 CCP_ATTRIBUTE25
, CCP_ATTRIBUTE26 CCP_ATTRIBUTE26
, CCP_ATTRIBUTE27 CCP_ATTRIBUTE27
, CCP_ATTRIBUTE28 CCP_ATTRIBUTE28
, CCP_ATTRIBUTE29 CCP_ATTRIBUTE29
, CCP_ATTRIBUTE30 CCP_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
, DPNT_DSGN_CTFN_RECD_DT DPNT_DSGN_CTFN_RECD_DT
FROM "BEN"."BEN_CVRD_DPNT_CTFN_PRVDD_F"