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

Source

View Text - Preformatted


select ELIG_ANTHR_PL_PRTE_ID ELIG_ANTHR_PL_PRTE_ID, PL_ID PL_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, EXCLD_FLAG EXCLD_FLAG, ELIGY_PRFL_ID ELIGY_PRFL_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, EOP_ATTRIBUTE_CATEGORY EOP_ATTRIBUTE_CATEGORY, EOP_ATTRIBUTE1 EOP_ATTRIBUTE1, EOP_ATTRIBUTE2 EOP_ATTRIBUTE2, EOP_ATTRIBUTE3 EOP_ATTRIBUTE3, EOP_ATTRIBUTE4 EOP_ATTRIBUTE4, EOP_ATTRIBUTE5 EOP_ATTRIBUTE5, EOP_ATTRIBUTE6 EOP_ATTRIBUTE6, EOP_ATTRIBUTE7 EOP_ATTRIBUTE7, EOP_ATTRIBUTE8 EOP_ATTRIBUTE8, EOP_ATTRIBUTE9 EOP_ATTRIBUTE9, EOP_ATTRIBUTE10 EOP_ATTRIBUTE10, EOP_ATTRIBUTE11 EOP_ATTRIBUTE11, EOP_ATTRIBUTE12 EOP_ATTRIBUTE12, EOP_ATTRIBUTE13 EOP_ATTRIBUTE13, EOP_ATTRIBUTE14 EOP_ATTRIBUTE14, EOP_ATTRIBUTE15 EOP_ATTRIBUTE15, EOP_ATTRIBUTE16 EOP_ATTRIBUTE16, EOP_ATTRIBUTE17 EOP_ATTRIBUTE17, EOP_ATTRIBUTE18 EOP_ATTRIBUTE18, EOP_ATTRIBUTE19 EOP_ATTRIBUTE19, EOP_ATTRIBUTE20 EOP_ATTRIBUTE20, EOP_ATTRIBUTE21 EOP_ATTRIBUTE21, EOP_ATTRIBUTE22 EOP_ATTRIBUTE22, EOP_ATTRIBUTE23 EOP_ATTRIBUTE23, EOP_ATTRIBUTE24 EOP_ATTRIBUTE24, EOP_ATTRIBUTE25 EOP_ATTRIBUTE25, EOP_ATTRIBUTE26 EOP_ATTRIBUTE26, EOP_ATTRIBUTE27 EOP_ATTRIBUTE27, EOP_ATTRIBUTE28 EOP_ATTRIBUTE28, EOP_ATTRIBUTE29 EOP_ATTRIBUTE29, EOP_ATTRIBUTE30 EOP_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 from "BEN"."BEN_ELIG_ANTHR_PL_PRTE_F"

View Text - HTML Formatted

SELECT ELIG_ANTHR_PL_PRTE_ID ELIG_ANTHR_PL_PRTE_ID
, PL_ID PL_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, EXCLD_FLAG EXCLD_FLAG
, ELIGY_PRFL_ID ELIGY_PRFL_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, EOP_ATTRIBUTE_CATEGORY EOP_ATTRIBUTE_CATEGORY
, EOP_ATTRIBUTE1 EOP_ATTRIBUTE1
, EOP_ATTRIBUTE2 EOP_ATTRIBUTE2
, EOP_ATTRIBUTE3 EOP_ATTRIBUTE3
, EOP_ATTRIBUTE4 EOP_ATTRIBUTE4
, EOP_ATTRIBUTE5 EOP_ATTRIBUTE5
, EOP_ATTRIBUTE6 EOP_ATTRIBUTE6
, EOP_ATTRIBUTE7 EOP_ATTRIBUTE7
, EOP_ATTRIBUTE8 EOP_ATTRIBUTE8
, EOP_ATTRIBUTE9 EOP_ATTRIBUTE9
, EOP_ATTRIBUTE10 EOP_ATTRIBUTE10
, EOP_ATTRIBUTE11 EOP_ATTRIBUTE11
, EOP_ATTRIBUTE12 EOP_ATTRIBUTE12
, EOP_ATTRIBUTE13 EOP_ATTRIBUTE13
, EOP_ATTRIBUTE14 EOP_ATTRIBUTE14
, EOP_ATTRIBUTE15 EOP_ATTRIBUTE15
, EOP_ATTRIBUTE16 EOP_ATTRIBUTE16
, EOP_ATTRIBUTE17 EOP_ATTRIBUTE17
, EOP_ATTRIBUTE18 EOP_ATTRIBUTE18
, EOP_ATTRIBUTE19 EOP_ATTRIBUTE19
, EOP_ATTRIBUTE20 EOP_ATTRIBUTE20
, EOP_ATTRIBUTE21 EOP_ATTRIBUTE21
, EOP_ATTRIBUTE22 EOP_ATTRIBUTE22
, EOP_ATTRIBUTE23 EOP_ATTRIBUTE23
, EOP_ATTRIBUTE24 EOP_ATTRIBUTE24
, EOP_ATTRIBUTE25 EOP_ATTRIBUTE25
, EOP_ATTRIBUTE26 EOP_ATTRIBUTE26
, EOP_ATTRIBUTE27 EOP_ATTRIBUTE27
, EOP_ATTRIBUTE28 EOP_ATTRIBUTE28
, EOP_ATTRIBUTE29 EOP_ATTRIBUTE29
, EOP_ATTRIBUTE30 EOP_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
FROM "BEN"."BEN_ELIG_ANTHR_PL_PRTE_F"