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.

VIEW: BEN.BEN_WV_PRTN_RSN_PL_F#

Source

View Text - Preformatted


select WV_PRTN_RSN_PL_ID WV_PRTN_RSN_PL_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, DFLT_FLAG DFLT_FLAG, PL_ID PL_ID, WPN_ATTRIBUTE_CATEGORY WPN_ATTRIBUTE_CATEGORY, WPN_ATTRIBUTE1 WPN_ATTRIBUTE1, WPN_ATTRIBUTE2 WPN_ATTRIBUTE2, WPN_ATTRIBUTE3 WPN_ATTRIBUTE3, WPN_ATTRIBUTE4 WPN_ATTRIBUTE4, WPN_ATTRIBUTE5 WPN_ATTRIBUTE5, WPN_ATTRIBUTE6 WPN_ATTRIBUTE6, WPN_ATTRIBUTE7 WPN_ATTRIBUTE7, WPN_ATTRIBUTE8 WPN_ATTRIBUTE8, WPN_ATTRIBUTE9 WPN_ATTRIBUTE9, WPN_ATTRIBUTE10 WPN_ATTRIBUTE10, WPN_ATTRIBUTE11 WPN_ATTRIBUTE11, WPN_ATTRIBUTE12 WPN_ATTRIBUTE12, WPN_ATTRIBUTE13 WPN_ATTRIBUTE13, WPN_ATTRIBUTE14 WPN_ATTRIBUTE14, WPN_ATTRIBUTE15 WPN_ATTRIBUTE15, WPN_ATTRIBUTE16 WPN_ATTRIBUTE16, WPN_ATTRIBUTE17 WPN_ATTRIBUTE17, WPN_ATTRIBUTE18 WPN_ATTRIBUTE18, WPN_ATTRIBUTE19 WPN_ATTRIBUTE19, WPN_ATTRIBUTE20 WPN_ATTRIBUTE20, WPN_ATTRIBUTE21 WPN_ATTRIBUTE21, WPN_ATTRIBUTE22 WPN_ATTRIBUTE22, WPN_ATTRIBUTE23 WPN_ATTRIBUTE23, WPN_ATTRIBUTE24 WPN_ATTRIBUTE24, WPN_ATTRIBUTE25 WPN_ATTRIBUTE25, WPN_ATTRIBUTE26 WPN_ATTRIBUTE26, WPN_ATTRIBUTE27 WPN_ATTRIBUTE27, WPN_ATTRIBUTE28 WPN_ATTRIBUTE28, WPN_ATTRIBUTE29 WPN_ATTRIBUTE29, WPN_ATTRIBUTE30 WPN_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, WV_PRTN_RSN_CD WV_PRTN_RSN_CD from "BEN"."BEN_WV_PRTN_RSN_PL_F"

View Text - HTML Formatted

SELECT WV_PRTN_RSN_PL_ID WV_PRTN_RSN_PL_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, DFLT_FLAG DFLT_FLAG
, PL_ID PL_ID
, WPN_ATTRIBUTE_CATEGORY WPN_ATTRIBUTE_CATEGORY
, WPN_ATTRIBUTE1 WPN_ATTRIBUTE1
, WPN_ATTRIBUTE2 WPN_ATTRIBUTE2
, WPN_ATTRIBUTE3 WPN_ATTRIBUTE3
, WPN_ATTRIBUTE4 WPN_ATTRIBUTE4
, WPN_ATTRIBUTE5 WPN_ATTRIBUTE5
, WPN_ATTRIBUTE6 WPN_ATTRIBUTE6
, WPN_ATTRIBUTE7 WPN_ATTRIBUTE7
, WPN_ATTRIBUTE8 WPN_ATTRIBUTE8
, WPN_ATTRIBUTE9 WPN_ATTRIBUTE9
, WPN_ATTRIBUTE10 WPN_ATTRIBUTE10
, WPN_ATTRIBUTE11 WPN_ATTRIBUTE11
, WPN_ATTRIBUTE12 WPN_ATTRIBUTE12
, WPN_ATTRIBUTE13 WPN_ATTRIBUTE13
, WPN_ATTRIBUTE14 WPN_ATTRIBUTE14
, WPN_ATTRIBUTE15 WPN_ATTRIBUTE15
, WPN_ATTRIBUTE16 WPN_ATTRIBUTE16
, WPN_ATTRIBUTE17 WPN_ATTRIBUTE17
, WPN_ATTRIBUTE18 WPN_ATTRIBUTE18
, WPN_ATTRIBUTE19 WPN_ATTRIBUTE19
, WPN_ATTRIBUTE20 WPN_ATTRIBUTE20
, WPN_ATTRIBUTE21 WPN_ATTRIBUTE21
, WPN_ATTRIBUTE22 WPN_ATTRIBUTE22
, WPN_ATTRIBUTE23 WPN_ATTRIBUTE23
, WPN_ATTRIBUTE24 WPN_ATTRIBUTE24
, WPN_ATTRIBUTE25 WPN_ATTRIBUTE25
, WPN_ATTRIBUTE26 WPN_ATTRIBUTE26
, WPN_ATTRIBUTE27 WPN_ATTRIBUTE27
, WPN_ATTRIBUTE28 WPN_ATTRIBUTE28
, WPN_ATTRIBUTE29 WPN_ATTRIBUTE29
, WPN_ATTRIBUTE30 WPN_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
, WV_PRTN_RSN_CD WV_PRTN_RSN_CD
FROM "BEN"."BEN_WV_PRTN_RSN_PL_F"