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_ENRLD_ANTHR_PGM_RT_F#

Source

View Text - Preformatted


select ENRLD_ANTHR_PGM_RT_ID ENRLD_ANTHR_PGM_RT_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, EXCLD_FLAG EXCLD_FLAG, PGM_ID PGM_ID, VRBL_RT_PRFL_ID VRBL_RT_PRFL_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, EPM_ATTRIBUTE_CATEGORY EPM_ATTRIBUTE_CATEGORY, EPM_ATTRIBUTE1 EPM_ATTRIBUTE1, EPM_ATTRIBUTE2 EPM_ATTRIBUTE2, EPM_ATTRIBUTE3 EPM_ATTRIBUTE3, EPM_ATTRIBUTE4 EPM_ATTRIBUTE4, EPM_ATTRIBUTE5 EPM_ATTRIBUTE5, EPM_ATTRIBUTE6 EPM_ATTRIBUTE6, EPM_ATTRIBUTE7 EPM_ATTRIBUTE7, EPM_ATTRIBUTE8 EPM_ATTRIBUTE8, EPM_ATTRIBUTE9 EPM_ATTRIBUTE9, EPM_ATTRIBUTE10 EPM_ATTRIBUTE10, EPM_ATTRIBUTE11 EPM_ATTRIBUTE11, EPM_ATTRIBUTE12 EPM_ATTRIBUTE12, EPM_ATTRIBUTE13 EPM_ATTRIBUTE13, EPM_ATTRIBUTE14 EPM_ATTRIBUTE14, EPM_ATTRIBUTE15 EPM_ATTRIBUTE15, EPM_ATTRIBUTE16 EPM_ATTRIBUTE16, EPM_ATTRIBUTE17 EPM_ATTRIBUTE17, EPM_ATTRIBUTE18 EPM_ATTRIBUTE18, EPM_ATTRIBUTE19 EPM_ATTRIBUTE19, EPM_ATTRIBUTE20 EPM_ATTRIBUTE20, EPM_ATTRIBUTE21 EPM_ATTRIBUTE21, EPM_ATTRIBUTE22 EPM_ATTRIBUTE22, EPM_ATTRIBUTE23 EPM_ATTRIBUTE23, EPM_ATTRIBUTE24 EPM_ATTRIBUTE24, EPM_ATTRIBUTE25 EPM_ATTRIBUTE25, EPM_ATTRIBUTE26 EPM_ATTRIBUTE26, EPM_ATTRIBUTE27 EPM_ATTRIBUTE27, EPM_ATTRIBUTE28 EPM_ATTRIBUTE28, EPM_ATTRIBUTE29 EPM_ATTRIBUTE29, EPM_ATTRIBUTE30 EPM_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, ORDR_NUM ORDR_NUM, ENRL_DET_DT_CD ENRL_DET_DT_CD from "BEN"."BEN_ENRLD_ANTHR_PGM_RT_F"

View Text - HTML Formatted

SELECT ENRLD_ANTHR_PGM_RT_ID ENRLD_ANTHR_PGM_RT_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, EXCLD_FLAG EXCLD_FLAG
, PGM_ID PGM_ID
, VRBL_RT_PRFL_ID VRBL_RT_PRFL_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, EPM_ATTRIBUTE_CATEGORY EPM_ATTRIBUTE_CATEGORY
, EPM_ATTRIBUTE1 EPM_ATTRIBUTE1
, EPM_ATTRIBUTE2 EPM_ATTRIBUTE2
, EPM_ATTRIBUTE3 EPM_ATTRIBUTE3
, EPM_ATTRIBUTE4 EPM_ATTRIBUTE4
, EPM_ATTRIBUTE5 EPM_ATTRIBUTE5
, EPM_ATTRIBUTE6 EPM_ATTRIBUTE6
, EPM_ATTRIBUTE7 EPM_ATTRIBUTE7
, EPM_ATTRIBUTE8 EPM_ATTRIBUTE8
, EPM_ATTRIBUTE9 EPM_ATTRIBUTE9
, EPM_ATTRIBUTE10 EPM_ATTRIBUTE10
, EPM_ATTRIBUTE11 EPM_ATTRIBUTE11
, EPM_ATTRIBUTE12 EPM_ATTRIBUTE12
, EPM_ATTRIBUTE13 EPM_ATTRIBUTE13
, EPM_ATTRIBUTE14 EPM_ATTRIBUTE14
, EPM_ATTRIBUTE15 EPM_ATTRIBUTE15
, EPM_ATTRIBUTE16 EPM_ATTRIBUTE16
, EPM_ATTRIBUTE17 EPM_ATTRIBUTE17
, EPM_ATTRIBUTE18 EPM_ATTRIBUTE18
, EPM_ATTRIBUTE19 EPM_ATTRIBUTE19
, EPM_ATTRIBUTE20 EPM_ATTRIBUTE20
, EPM_ATTRIBUTE21 EPM_ATTRIBUTE21
, EPM_ATTRIBUTE22 EPM_ATTRIBUTE22
, EPM_ATTRIBUTE23 EPM_ATTRIBUTE23
, EPM_ATTRIBUTE24 EPM_ATTRIBUTE24
, EPM_ATTRIBUTE25 EPM_ATTRIBUTE25
, EPM_ATTRIBUTE26 EPM_ATTRIBUTE26
, EPM_ATTRIBUTE27 EPM_ATTRIBUTE27
, EPM_ATTRIBUTE28 EPM_ATTRIBUTE28
, EPM_ATTRIBUTE29 EPM_ATTRIBUTE29
, EPM_ATTRIBUTE30 EPM_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
, ORDR_NUM ORDR_NUM
, ENRL_DET_DT_CD ENRL_DET_DT_CD
FROM "BEN"."BEN_ENRLD_ANTHR_PGM_RT_F"