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

Source

View Text - Preformatted


select AGE_RT_ID AGE_RT_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, EXCLD_FLAG EXCLD_FLAG, AGE_FCTR_ID AGE_FCTR_ID, VRBL_RT_PRFL_ID VRBL_RT_PRFL_ID, ART_ATTRIBUTE_CATEGORY ART_ATTRIBUTE_CATEGORY, ART_ATTRIBUTE1 ART_ATTRIBUTE1, ART_ATTRIBUTE2 ART_ATTRIBUTE2, ART_ATTRIBUTE3 ART_ATTRIBUTE3, ART_ATTRIBUTE4 ART_ATTRIBUTE4, ART_ATTRIBUTE5 ART_ATTRIBUTE5, ART_ATTRIBUTE6 ART_ATTRIBUTE6, ART_ATTRIBUTE7 ART_ATTRIBUTE7, ART_ATTRIBUTE8 ART_ATTRIBUTE8, ART_ATTRIBUTE9 ART_ATTRIBUTE9, ART_ATTRIBUTE10 ART_ATTRIBUTE10, ART_ATTRIBUTE11 ART_ATTRIBUTE11, ART_ATTRIBUTE12 ART_ATTRIBUTE12, ART_ATTRIBUTE13 ART_ATTRIBUTE13, ART_ATTRIBUTE14 ART_ATTRIBUTE14, ART_ATTRIBUTE15 ART_ATTRIBUTE15, ART_ATTRIBUTE16 ART_ATTRIBUTE16, ART_ATTRIBUTE17 ART_ATTRIBUTE17, ART_ATTRIBUTE18 ART_ATTRIBUTE18, ART_ATTRIBUTE19 ART_ATTRIBUTE19, ART_ATTRIBUTE20 ART_ATTRIBUTE20, ART_ATTRIBUTE21 ART_ATTRIBUTE21, ART_ATTRIBUTE22 ART_ATTRIBUTE22, ART_ATTRIBUTE23 ART_ATTRIBUTE23, ART_ATTRIBUTE24 ART_ATTRIBUTE24, ART_ATTRIBUTE25 ART_ATTRIBUTE25, ART_ATTRIBUTE26 ART_ATTRIBUTE26, ART_ATTRIBUTE27 ART_ATTRIBUTE27, ART_ATTRIBUTE28 ART_ATTRIBUTE28, ART_ATTRIBUTE29 ART_ATTRIBUTE29, ART_ATTRIBUTE30 ART_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_AGE_RT_F"

View Text - HTML Formatted

SELECT AGE_RT_ID AGE_RT_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, EXCLD_FLAG EXCLD_FLAG
, AGE_FCTR_ID AGE_FCTR_ID
, VRBL_RT_PRFL_ID VRBL_RT_PRFL_ID
, ART_ATTRIBUTE_CATEGORY ART_ATTRIBUTE_CATEGORY
, ART_ATTRIBUTE1 ART_ATTRIBUTE1
, ART_ATTRIBUTE2 ART_ATTRIBUTE2
, ART_ATTRIBUTE3 ART_ATTRIBUTE3
, ART_ATTRIBUTE4 ART_ATTRIBUTE4
, ART_ATTRIBUTE5 ART_ATTRIBUTE5
, ART_ATTRIBUTE6 ART_ATTRIBUTE6
, ART_ATTRIBUTE7 ART_ATTRIBUTE7
, ART_ATTRIBUTE8 ART_ATTRIBUTE8
, ART_ATTRIBUTE9 ART_ATTRIBUTE9
, ART_ATTRIBUTE10 ART_ATTRIBUTE10
, ART_ATTRIBUTE11 ART_ATTRIBUTE11
, ART_ATTRIBUTE12 ART_ATTRIBUTE12
, ART_ATTRIBUTE13 ART_ATTRIBUTE13
, ART_ATTRIBUTE14 ART_ATTRIBUTE14
, ART_ATTRIBUTE15 ART_ATTRIBUTE15
, ART_ATTRIBUTE16 ART_ATTRIBUTE16
, ART_ATTRIBUTE17 ART_ATTRIBUTE17
, ART_ATTRIBUTE18 ART_ATTRIBUTE18
, ART_ATTRIBUTE19 ART_ATTRIBUTE19
, ART_ATTRIBUTE20 ART_ATTRIBUTE20
, ART_ATTRIBUTE21 ART_ATTRIBUTE21
, ART_ATTRIBUTE22 ART_ATTRIBUTE22
, ART_ATTRIBUTE23 ART_ATTRIBUTE23
, ART_ATTRIBUTE24 ART_ATTRIBUTE24
, ART_ATTRIBUTE25 ART_ATTRIBUTE25
, ART_ATTRIBUTE26 ART_ATTRIBUTE26
, ART_ATTRIBUTE27 ART_ATTRIBUTE27
, ART_ATTRIBUTE28 ART_ATTRIBUTE28
, ART_ATTRIBUTE29 ART_ATTRIBUTE29
, ART_ATTRIBUTE30 ART_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_AGE_RT_F"