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

Source

View Text - Preformatted


select ELIG_TTL_PRTT_PRTE_ID ELIG_TTL_PRTT_PRTE_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, EXCLD_FLAG EXCLD_FLAG, NO_MN_PRTT_NUM_APLS_FLAG NO_MN_PRTT_NUM_APLS_FLAG, NO_MX_PRTT_NUM_APLS_FLAG NO_MX_PRTT_NUM_APLS_FLAG, ELIGY_PRFL_ID ELIGY_PRFL_ID, ETP_ATTRIBUTE_CATEGORY ETP_ATTRIBUTE_CATEGORY, ETP_ATTRIBUTE1 ETP_ATTRIBUTE1, ETP_ATTRIBUTE2 ETP_ATTRIBUTE2, ETP_ATTRIBUTE3 ETP_ATTRIBUTE3, ETP_ATTRIBUTE4 ETP_ATTRIBUTE4, ETP_ATTRIBUTE5 ETP_ATTRIBUTE5, ETP_ATTRIBUTE6 ETP_ATTRIBUTE6, ETP_ATTRIBUTE7 ETP_ATTRIBUTE7, ETP_ATTRIBUTE8 ETP_ATTRIBUTE8, ETP_ATTRIBUTE9 ETP_ATTRIBUTE9, ETP_ATTRIBUTE10 ETP_ATTRIBUTE10, ETP_ATTRIBUTE11 ETP_ATTRIBUTE11, ETP_ATTRIBUTE12 ETP_ATTRIBUTE12, ETP_ATTRIBUTE13 ETP_ATTRIBUTE13, ETP_ATTRIBUTE14 ETP_ATTRIBUTE14, ETP_ATTRIBUTE15 ETP_ATTRIBUTE15, ETP_ATTRIBUTE16 ETP_ATTRIBUTE16, ETP_ATTRIBUTE17 ETP_ATTRIBUTE17, ETP_ATTRIBUTE18 ETP_ATTRIBUTE18, ETP_ATTRIBUTE19 ETP_ATTRIBUTE19, ETP_ATTRIBUTE20 ETP_ATTRIBUTE20, ETP_ATTRIBUTE21 ETP_ATTRIBUTE21, ETP_ATTRIBUTE22 ETP_ATTRIBUTE22, ETP_ATTRIBUTE23 ETP_ATTRIBUTE23, ETP_ATTRIBUTE24 ETP_ATTRIBUTE24, ETP_ATTRIBUTE25 ETP_ATTRIBUTE25, ETP_ATTRIBUTE26 ETP_ATTRIBUTE26, ETP_ATTRIBUTE27 ETP_ATTRIBUTE27, ETP_ATTRIBUTE28 ETP_ATTRIBUTE28, ETP_ATTRIBUTE29 ETP_ATTRIBUTE29, ETP_ATTRIBUTE30 ETP_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, MN_PRTT_NUM MN_PRTT_NUM, MX_PRTT_NUM MX_PRTT_NUM, PRTT_DET_CD PRTT_DET_CD, PRTT_DET_RL PRTT_DET_RL from "BEN"."BEN_ELIG_TTL_PRTT_PRTE_F"

View Text - HTML Formatted

SELECT ELIG_TTL_PRTT_PRTE_ID ELIG_TTL_PRTT_PRTE_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, EXCLD_FLAG EXCLD_FLAG
, NO_MN_PRTT_NUM_APLS_FLAG NO_MN_PRTT_NUM_APLS_FLAG
, NO_MX_PRTT_NUM_APLS_FLAG NO_MX_PRTT_NUM_APLS_FLAG
, ELIGY_PRFL_ID ELIGY_PRFL_ID
, ETP_ATTRIBUTE_CATEGORY ETP_ATTRIBUTE_CATEGORY
, ETP_ATTRIBUTE1 ETP_ATTRIBUTE1
, ETP_ATTRIBUTE2 ETP_ATTRIBUTE2
, ETP_ATTRIBUTE3 ETP_ATTRIBUTE3
, ETP_ATTRIBUTE4 ETP_ATTRIBUTE4
, ETP_ATTRIBUTE5 ETP_ATTRIBUTE5
, ETP_ATTRIBUTE6 ETP_ATTRIBUTE6
, ETP_ATTRIBUTE7 ETP_ATTRIBUTE7
, ETP_ATTRIBUTE8 ETP_ATTRIBUTE8
, ETP_ATTRIBUTE9 ETP_ATTRIBUTE9
, ETP_ATTRIBUTE10 ETP_ATTRIBUTE10
, ETP_ATTRIBUTE11 ETP_ATTRIBUTE11
, ETP_ATTRIBUTE12 ETP_ATTRIBUTE12
, ETP_ATTRIBUTE13 ETP_ATTRIBUTE13
, ETP_ATTRIBUTE14 ETP_ATTRIBUTE14
, ETP_ATTRIBUTE15 ETP_ATTRIBUTE15
, ETP_ATTRIBUTE16 ETP_ATTRIBUTE16
, ETP_ATTRIBUTE17 ETP_ATTRIBUTE17
, ETP_ATTRIBUTE18 ETP_ATTRIBUTE18
, ETP_ATTRIBUTE19 ETP_ATTRIBUTE19
, ETP_ATTRIBUTE20 ETP_ATTRIBUTE20
, ETP_ATTRIBUTE21 ETP_ATTRIBUTE21
, ETP_ATTRIBUTE22 ETP_ATTRIBUTE22
, ETP_ATTRIBUTE23 ETP_ATTRIBUTE23
, ETP_ATTRIBUTE24 ETP_ATTRIBUTE24
, ETP_ATTRIBUTE25 ETP_ATTRIBUTE25
, ETP_ATTRIBUTE26 ETP_ATTRIBUTE26
, ETP_ATTRIBUTE27 ETP_ATTRIBUTE27
, ETP_ATTRIBUTE28 ETP_ATTRIBUTE28
, ETP_ATTRIBUTE29 ETP_ATTRIBUTE29
, ETP_ATTRIBUTE30 ETP_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
, MN_PRTT_NUM MN_PRTT_NUM
, MX_PRTT_NUM MX_PRTT_NUM
, PRTT_DET_CD PRTT_DET_CD
, PRTT_DET_RL PRTT_DET_RL
FROM "BEN"."BEN_ELIG_TTL_PRTT_PRTE_F"