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

Source

View Text - Preformatted


select ENRLD_ANTHR_OIPL_RT_ID ENRLD_ANTHR_OIPL_RT_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, EXCLD_FLAG EXCLD_FLAG, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, OIPL_ID OIPL_ID, VRBL_RT_PRFL_ID VRBL_RT_PRFL_ID, EAO_ATTRIBUTE_CATEGORY EAO_ATTRIBUTE_CATEGORY, EAO_ATTRIBUTE1 EAO_ATTRIBUTE1, EAO_ATTRIBUTE2 EAO_ATTRIBUTE2, EAO_ATTRIBUTE3 EAO_ATTRIBUTE3, EAO_ATTRIBUTE4 EAO_ATTRIBUTE4, EAO_ATTRIBUTE5 EAO_ATTRIBUTE5, EAO_ATTRIBUTE6 EAO_ATTRIBUTE6, EAO_ATTRIBUTE7 EAO_ATTRIBUTE7, EAO_ATTRIBUTE8 EAO_ATTRIBUTE8, EAO_ATTRIBUTE9 EAO_ATTRIBUTE9, EAO_ATTRIBUTE10 EAO_ATTRIBUTE10, EAO_ATTRIBUTE11 EAO_ATTRIBUTE11, EAO_ATTRIBUTE12 EAO_ATTRIBUTE12, EAO_ATTRIBUTE13 EAO_ATTRIBUTE13, EAO_ATTRIBUTE14 EAO_ATTRIBUTE14, EAO_ATTRIBUTE15 EAO_ATTRIBUTE15, EAO_ATTRIBUTE16 EAO_ATTRIBUTE16, EAO_ATTRIBUTE17 EAO_ATTRIBUTE17, EAO_ATTRIBUTE18 EAO_ATTRIBUTE18, EAO_ATTRIBUTE19 EAO_ATTRIBUTE19, EAO_ATTRIBUTE20 EAO_ATTRIBUTE20, EAO_ATTRIBUTE21 EAO_ATTRIBUTE21, EAO_ATTRIBUTE22 EAO_ATTRIBUTE22, EAO_ATTRIBUTE23 EAO_ATTRIBUTE23, EAO_ATTRIBUTE24 EAO_ATTRIBUTE24, EAO_ATTRIBUTE25 EAO_ATTRIBUTE25, EAO_ATTRIBUTE26 EAO_ATTRIBUTE26, EAO_ATTRIBUTE27 EAO_ATTRIBUTE27, EAO_ATTRIBUTE28 EAO_ATTRIBUTE28, EAO_ATTRIBUTE29 EAO_ATTRIBUTE29, EAO_ATTRIBUTE30 EAO_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_OIPL_RT_F"

View Text - HTML Formatted

SELECT ENRLD_ANTHR_OIPL_RT_ID ENRLD_ANTHR_OIPL_RT_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, EXCLD_FLAG EXCLD_FLAG
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, OIPL_ID OIPL_ID
, VRBL_RT_PRFL_ID VRBL_RT_PRFL_ID
, EAO_ATTRIBUTE_CATEGORY EAO_ATTRIBUTE_CATEGORY
, EAO_ATTRIBUTE1 EAO_ATTRIBUTE1
, EAO_ATTRIBUTE2 EAO_ATTRIBUTE2
, EAO_ATTRIBUTE3 EAO_ATTRIBUTE3
, EAO_ATTRIBUTE4 EAO_ATTRIBUTE4
, EAO_ATTRIBUTE5 EAO_ATTRIBUTE5
, EAO_ATTRIBUTE6 EAO_ATTRIBUTE6
, EAO_ATTRIBUTE7 EAO_ATTRIBUTE7
, EAO_ATTRIBUTE8 EAO_ATTRIBUTE8
, EAO_ATTRIBUTE9 EAO_ATTRIBUTE9
, EAO_ATTRIBUTE10 EAO_ATTRIBUTE10
, EAO_ATTRIBUTE11 EAO_ATTRIBUTE11
, EAO_ATTRIBUTE12 EAO_ATTRIBUTE12
, EAO_ATTRIBUTE13 EAO_ATTRIBUTE13
, EAO_ATTRIBUTE14 EAO_ATTRIBUTE14
, EAO_ATTRIBUTE15 EAO_ATTRIBUTE15
, EAO_ATTRIBUTE16 EAO_ATTRIBUTE16
, EAO_ATTRIBUTE17 EAO_ATTRIBUTE17
, EAO_ATTRIBUTE18 EAO_ATTRIBUTE18
, EAO_ATTRIBUTE19 EAO_ATTRIBUTE19
, EAO_ATTRIBUTE20 EAO_ATTRIBUTE20
, EAO_ATTRIBUTE21 EAO_ATTRIBUTE21
, EAO_ATTRIBUTE22 EAO_ATTRIBUTE22
, EAO_ATTRIBUTE23 EAO_ATTRIBUTE23
, EAO_ATTRIBUTE24 EAO_ATTRIBUTE24
, EAO_ATTRIBUTE25 EAO_ATTRIBUTE25
, EAO_ATTRIBUTE26 EAO_ATTRIBUTE26
, EAO_ATTRIBUTE27 EAO_ATTRIBUTE27
, EAO_ATTRIBUTE28 EAO_ATTRIBUTE28
, EAO_ATTRIBUTE29 EAO_ATTRIBUTE29
, EAO_ATTRIBUTE30 EAO_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_OIPL_RT_F"