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

Source

View Text - Preformatted


select ELIG_ORG_UNIT_PRTE_ID ELIG_ORG_UNIT_PRTE_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, EXCLD_FLAG EXCLD_FLAG, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, ORGANIZATION_ID ORGANIZATION_ID, ELIGY_PRFL_ID ELIGY_PRFL_ID, EOU_ATTRIBUTE_CATEGORY EOU_ATTRIBUTE_CATEGORY, EOU_ATTRIBUTE1 EOU_ATTRIBUTE1, EOU_ATTRIBUTE2 EOU_ATTRIBUTE2, EOU_ATTRIBUTE3 EOU_ATTRIBUTE3, EOU_ATTRIBUTE4 EOU_ATTRIBUTE4, EOU_ATTRIBUTE5 EOU_ATTRIBUTE5, EOU_ATTRIBUTE6 EOU_ATTRIBUTE6, EOU_ATTRIBUTE7 EOU_ATTRIBUTE7, EOU_ATTRIBUTE8 EOU_ATTRIBUTE8, EOU_ATTRIBUTE9 EOU_ATTRIBUTE9, EOU_ATTRIBUTE10 EOU_ATTRIBUTE10, EOU_ATTRIBUTE11 EOU_ATTRIBUTE11, EOU_ATTRIBUTE12 EOU_ATTRIBUTE12, EOU_ATTRIBUTE13 EOU_ATTRIBUTE13, EOU_ATTRIBUTE14 EOU_ATTRIBUTE14, EOU_ATTRIBUTE15 EOU_ATTRIBUTE15, EOU_ATTRIBUTE16 EOU_ATTRIBUTE16, EOU_ATTRIBUTE17 EOU_ATTRIBUTE17, EOU_ATTRIBUTE18 EOU_ATTRIBUTE18, EOU_ATTRIBUTE19 EOU_ATTRIBUTE19, EOU_ATTRIBUTE20 EOU_ATTRIBUTE20, EOU_ATTRIBUTE21 EOU_ATTRIBUTE21, EOU_ATTRIBUTE22 EOU_ATTRIBUTE22, EOU_ATTRIBUTE23 EOU_ATTRIBUTE23, EOU_ATTRIBUTE24 EOU_ATTRIBUTE24, EOU_ATTRIBUTE25 EOU_ATTRIBUTE25, EOU_ATTRIBUTE26 EOU_ATTRIBUTE26, EOU_ATTRIBUTE27 EOU_ATTRIBUTE27, EOU_ATTRIBUTE28 EOU_ATTRIBUTE28, EOU_ATTRIBUTE29 EOU_ATTRIBUTE29, EOU_ATTRIBUTE30 EOU_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, CRITERIA_SCORE CRITERIA_SCORE, CRITERIA_WEIGHT CRITERIA_WEIGHT from "BEN"."BEN_ELIG_ORG_UNIT_PRTE_F"

View Text - HTML Formatted

SELECT ELIG_ORG_UNIT_PRTE_ID ELIG_ORG_UNIT_PRTE_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, EXCLD_FLAG EXCLD_FLAG
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, ORGANIZATION_ID ORGANIZATION_ID
, ELIGY_PRFL_ID ELIGY_PRFL_ID
, EOU_ATTRIBUTE_CATEGORY EOU_ATTRIBUTE_CATEGORY
, EOU_ATTRIBUTE1 EOU_ATTRIBUTE1
, EOU_ATTRIBUTE2 EOU_ATTRIBUTE2
, EOU_ATTRIBUTE3 EOU_ATTRIBUTE3
, EOU_ATTRIBUTE4 EOU_ATTRIBUTE4
, EOU_ATTRIBUTE5 EOU_ATTRIBUTE5
, EOU_ATTRIBUTE6 EOU_ATTRIBUTE6
, EOU_ATTRIBUTE7 EOU_ATTRIBUTE7
, EOU_ATTRIBUTE8 EOU_ATTRIBUTE8
, EOU_ATTRIBUTE9 EOU_ATTRIBUTE9
, EOU_ATTRIBUTE10 EOU_ATTRIBUTE10
, EOU_ATTRIBUTE11 EOU_ATTRIBUTE11
, EOU_ATTRIBUTE12 EOU_ATTRIBUTE12
, EOU_ATTRIBUTE13 EOU_ATTRIBUTE13
, EOU_ATTRIBUTE14 EOU_ATTRIBUTE14
, EOU_ATTRIBUTE15 EOU_ATTRIBUTE15
, EOU_ATTRIBUTE16 EOU_ATTRIBUTE16
, EOU_ATTRIBUTE17 EOU_ATTRIBUTE17
, EOU_ATTRIBUTE18 EOU_ATTRIBUTE18
, EOU_ATTRIBUTE19 EOU_ATTRIBUTE19
, EOU_ATTRIBUTE20 EOU_ATTRIBUTE20
, EOU_ATTRIBUTE21 EOU_ATTRIBUTE21
, EOU_ATTRIBUTE22 EOU_ATTRIBUTE22
, EOU_ATTRIBUTE23 EOU_ATTRIBUTE23
, EOU_ATTRIBUTE24 EOU_ATTRIBUTE24
, EOU_ATTRIBUTE25 EOU_ATTRIBUTE25
, EOU_ATTRIBUTE26 EOU_ATTRIBUTE26
, EOU_ATTRIBUTE27 EOU_ATTRIBUTE27
, EOU_ATTRIBUTE28 EOU_ATTRIBUTE28
, EOU_ATTRIBUTE29 EOU_ATTRIBUTE29
, EOU_ATTRIBUTE30 EOU_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
, CRITERIA_SCORE CRITERIA_SCORE
, CRITERIA_WEIGHT CRITERIA_WEIGHT
FROM "BEN"."BEN_ELIG_ORG_UNIT_PRTE_F"