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

Source

View Text - Preformatted


select WV_PRTN_RSN_PTIP_ID WV_PRTN_RSN_PTIP_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, DFLT_FLAG DFLT_FLAG, PTIP_ID PTIP_ID, WV_PRTN_RSN_CD WV_PRTN_RSN_CD, WPT_ATTRIBUTE_CATEGORY WPT_ATTRIBUTE_CATEGORY, WPT_ATTRIBUTE1 WPT_ATTRIBUTE1, WPT_ATTRIBUTE2 WPT_ATTRIBUTE2, WPT_ATTRIBUTE3 WPT_ATTRIBUTE3, WPT_ATTRIBUTE4 WPT_ATTRIBUTE4, WPT_ATTRIBUTE5 WPT_ATTRIBUTE5, WPT_ATTRIBUTE6 WPT_ATTRIBUTE6, WPT_ATTRIBUTE7 WPT_ATTRIBUTE7, WPT_ATTRIBUTE8 WPT_ATTRIBUTE8, WPT_ATTRIBUTE9 WPT_ATTRIBUTE9, WPT_ATTRIBUTE10 WPT_ATTRIBUTE10, WPT_ATTRIBUTE11 WPT_ATTRIBUTE11, WPT_ATTRIBUTE12 WPT_ATTRIBUTE12, WPT_ATTRIBUTE13 WPT_ATTRIBUTE13, WPT_ATTRIBUTE14 WPT_ATTRIBUTE14, WPT_ATTRIBUTE15 WPT_ATTRIBUTE15, WPT_ATTRIBUTE16 WPT_ATTRIBUTE16, WPT_ATTRIBUTE17 WPT_ATTRIBUTE17, WPT_ATTRIBUTE18 WPT_ATTRIBUTE18, WPT_ATTRIBUTE19 WPT_ATTRIBUTE19, WPT_ATTRIBUTE20 WPT_ATTRIBUTE20, WPT_ATTRIBUTE21 WPT_ATTRIBUTE21, WPT_ATTRIBUTE22 WPT_ATTRIBUTE22, WPT_ATTRIBUTE23 WPT_ATTRIBUTE23, WPT_ATTRIBUTE24 WPT_ATTRIBUTE24, WPT_ATTRIBUTE25 WPT_ATTRIBUTE25, WPT_ATTRIBUTE26 WPT_ATTRIBUTE26, WPT_ATTRIBUTE27 WPT_ATTRIBUTE27, WPT_ATTRIBUTE28 WPT_ATTRIBUTE28, WPT_ATTRIBUTE29 WPT_ATTRIBUTE29, WPT_ATTRIBUTE30 WPT_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 from "BEN"."BEN_WV_PRTN_RSN_PTIP_F"

View Text - HTML Formatted

SELECT WV_PRTN_RSN_PTIP_ID WV_PRTN_RSN_PTIP_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, DFLT_FLAG DFLT_FLAG
, PTIP_ID PTIP_ID
, WV_PRTN_RSN_CD WV_PRTN_RSN_CD
, WPT_ATTRIBUTE_CATEGORY WPT_ATTRIBUTE_CATEGORY
, WPT_ATTRIBUTE1 WPT_ATTRIBUTE1
, WPT_ATTRIBUTE2 WPT_ATTRIBUTE2
, WPT_ATTRIBUTE3 WPT_ATTRIBUTE3
, WPT_ATTRIBUTE4 WPT_ATTRIBUTE4
, WPT_ATTRIBUTE5 WPT_ATTRIBUTE5
, WPT_ATTRIBUTE6 WPT_ATTRIBUTE6
, WPT_ATTRIBUTE7 WPT_ATTRIBUTE7
, WPT_ATTRIBUTE8 WPT_ATTRIBUTE8
, WPT_ATTRIBUTE9 WPT_ATTRIBUTE9
, WPT_ATTRIBUTE10 WPT_ATTRIBUTE10
, WPT_ATTRIBUTE11 WPT_ATTRIBUTE11
, WPT_ATTRIBUTE12 WPT_ATTRIBUTE12
, WPT_ATTRIBUTE13 WPT_ATTRIBUTE13
, WPT_ATTRIBUTE14 WPT_ATTRIBUTE14
, WPT_ATTRIBUTE15 WPT_ATTRIBUTE15
, WPT_ATTRIBUTE16 WPT_ATTRIBUTE16
, WPT_ATTRIBUTE17 WPT_ATTRIBUTE17
, WPT_ATTRIBUTE18 WPT_ATTRIBUTE18
, WPT_ATTRIBUTE19 WPT_ATTRIBUTE19
, WPT_ATTRIBUTE20 WPT_ATTRIBUTE20
, WPT_ATTRIBUTE21 WPT_ATTRIBUTE21
, WPT_ATTRIBUTE22 WPT_ATTRIBUTE22
, WPT_ATTRIBUTE23 WPT_ATTRIBUTE23
, WPT_ATTRIBUTE24 WPT_ATTRIBUTE24
, WPT_ATTRIBUTE25 WPT_ATTRIBUTE25
, WPT_ATTRIBUTE26 WPT_ATTRIBUTE26
, WPT_ATTRIBUTE27 WPT_ATTRIBUTE27
, WPT_ATTRIBUTE28 WPT_ATTRIBUTE28
, WPT_ATTRIBUTE29 WPT_ATTRIBUTE29
, WPT_ATTRIBUTE30 WPT_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
FROM "BEN"."BEN_WV_PRTN_RSN_PTIP_F"