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

Source

View Text - Preformatted


select ACTL_PREM_VRBL_RT_ID ACTL_PREM_VRBL_RT_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, ACTL_PREM_ID ACTL_PREM_ID, VRBL_RT_PRFL_ID VRBL_RT_PRFL_ID, APV_ATTRIBUTE_CATEGORY APV_ATTRIBUTE_CATEGORY, APV_ATTRIBUTE1 APV_ATTRIBUTE1, APV_ATTRIBUTE2 APV_ATTRIBUTE2, APV_ATTRIBUTE3 APV_ATTRIBUTE3, APV_ATTRIBUTE4 APV_ATTRIBUTE4, APV_ATTRIBUTE5 APV_ATTRIBUTE5, APV_ATTRIBUTE6 APV_ATTRIBUTE6, APV_ATTRIBUTE7 APV_ATTRIBUTE7, APV_ATTRIBUTE8 APV_ATTRIBUTE8, APV_ATTRIBUTE9 APV_ATTRIBUTE9, APV_ATTRIBUTE10 APV_ATTRIBUTE10, APV_ATTRIBUTE11 APV_ATTRIBUTE11, APV_ATTRIBUTE12 APV_ATTRIBUTE12, APV_ATTRIBUTE13 APV_ATTRIBUTE13, APV_ATTRIBUTE14 APV_ATTRIBUTE14, APV_ATTRIBUTE15 APV_ATTRIBUTE15, APV_ATTRIBUTE16 APV_ATTRIBUTE16, APV_ATTRIBUTE17 APV_ATTRIBUTE17, APV_ATTRIBUTE18 APV_ATTRIBUTE18, APV_ATTRIBUTE19 APV_ATTRIBUTE19, APV_ATTRIBUTE20 APV_ATTRIBUTE20, APV_ATTRIBUTE21 APV_ATTRIBUTE21, APV_ATTRIBUTE22 APV_ATTRIBUTE22, APV_ATTRIBUTE23 APV_ATTRIBUTE23, APV_ATTRIBUTE24 APV_ATTRIBUTE24, APV_ATTRIBUTE25 APV_ATTRIBUTE25, APV_ATTRIBUTE26 APV_ATTRIBUTE26, APV_ATTRIBUTE27 APV_ATTRIBUTE27, APV_ATTRIBUTE28 APV_ATTRIBUTE28, APV_ATTRIBUTE29 APV_ATTRIBUTE29, APV_ATTRIBUTE30 APV_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_ACTL_PREM_VRBL_RT_F"

View Text - HTML Formatted

SELECT ACTL_PREM_VRBL_RT_ID ACTL_PREM_VRBL_RT_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, ACTL_PREM_ID ACTL_PREM_ID
, VRBL_RT_PRFL_ID VRBL_RT_PRFL_ID
, APV_ATTRIBUTE_CATEGORY APV_ATTRIBUTE_CATEGORY
, APV_ATTRIBUTE1 APV_ATTRIBUTE1
, APV_ATTRIBUTE2 APV_ATTRIBUTE2
, APV_ATTRIBUTE3 APV_ATTRIBUTE3
, APV_ATTRIBUTE4 APV_ATTRIBUTE4
, APV_ATTRIBUTE5 APV_ATTRIBUTE5
, APV_ATTRIBUTE6 APV_ATTRIBUTE6
, APV_ATTRIBUTE7 APV_ATTRIBUTE7
, APV_ATTRIBUTE8 APV_ATTRIBUTE8
, APV_ATTRIBUTE9 APV_ATTRIBUTE9
, APV_ATTRIBUTE10 APV_ATTRIBUTE10
, APV_ATTRIBUTE11 APV_ATTRIBUTE11
, APV_ATTRIBUTE12 APV_ATTRIBUTE12
, APV_ATTRIBUTE13 APV_ATTRIBUTE13
, APV_ATTRIBUTE14 APV_ATTRIBUTE14
, APV_ATTRIBUTE15 APV_ATTRIBUTE15
, APV_ATTRIBUTE16 APV_ATTRIBUTE16
, APV_ATTRIBUTE17 APV_ATTRIBUTE17
, APV_ATTRIBUTE18 APV_ATTRIBUTE18
, APV_ATTRIBUTE19 APV_ATTRIBUTE19
, APV_ATTRIBUTE20 APV_ATTRIBUTE20
, APV_ATTRIBUTE21 APV_ATTRIBUTE21
, APV_ATTRIBUTE22 APV_ATTRIBUTE22
, APV_ATTRIBUTE23 APV_ATTRIBUTE23
, APV_ATTRIBUTE24 APV_ATTRIBUTE24
, APV_ATTRIBUTE25 APV_ATTRIBUTE25
, APV_ATTRIBUTE26 APV_ATTRIBUTE26
, APV_ATTRIBUTE27 APV_ATTRIBUTE27
, APV_ATTRIBUTE28 APV_ATTRIBUTE28
, APV_ATTRIBUTE29 APV_ATTRIBUTE29
, APV_ATTRIBUTE30 APV_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_ACTL_PREM_VRBL_RT_F"