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

Source

View Text - Preformatted


select SVC_AREA_ID SVC_AREA_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, ORG_UNIT_PRDCT ORG_UNIT_PRDCT, SVA_ATTRIBUTE_CATEGORY SVA_ATTRIBUTE_CATEGORY, SVA_ATTRIBUTE1 SVA_ATTRIBUTE1, SVA_ATTRIBUTE2 SVA_ATTRIBUTE2, SVA_ATTRIBUTE3 SVA_ATTRIBUTE3, SVA_ATTRIBUTE4 SVA_ATTRIBUTE4, SVA_ATTRIBUTE5 SVA_ATTRIBUTE5, SVA_ATTRIBUTE6 SVA_ATTRIBUTE6, SVA_ATTRIBUTE7 SVA_ATTRIBUTE7, SVA_ATTRIBUTE8 SVA_ATTRIBUTE8, SVA_ATTRIBUTE9 SVA_ATTRIBUTE9, SVA_ATTRIBUTE10 SVA_ATTRIBUTE10, SVA_ATTRIBUTE11 SVA_ATTRIBUTE11, SVA_ATTRIBUTE12 SVA_ATTRIBUTE12, SVA_ATTRIBUTE13 SVA_ATTRIBUTE13, SVA_ATTRIBUTE14 SVA_ATTRIBUTE14, SVA_ATTRIBUTE15 SVA_ATTRIBUTE15, SVA_ATTRIBUTE16 SVA_ATTRIBUTE16, SVA_ATTRIBUTE17 SVA_ATTRIBUTE17, SVA_ATTRIBUTE18 SVA_ATTRIBUTE18, SVA_ATTRIBUTE19 SVA_ATTRIBUTE19, SVA_ATTRIBUTE20 SVA_ATTRIBUTE20, SVA_ATTRIBUTE21 SVA_ATTRIBUTE21, SVA_ATTRIBUTE22 SVA_ATTRIBUTE22, SVA_ATTRIBUTE23 SVA_ATTRIBUTE23, SVA_ATTRIBUTE24 SVA_ATTRIBUTE24, SVA_ATTRIBUTE25 SVA_ATTRIBUTE25, SVA_ATTRIBUTE26 SVA_ATTRIBUTE26, SVA_ATTRIBUTE27 SVA_ATTRIBUTE27, SVA_ATTRIBUTE28 SVA_ATTRIBUTE28, SVA_ATTRIBUTE29 SVA_ATTRIBUTE29, SVA_ATTRIBUTE30 SVA_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, NAME NAME from "BEN"."BEN_SVC_AREA_F"

View Text - HTML Formatted

SELECT SVC_AREA_ID SVC_AREA_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, ORG_UNIT_PRDCT ORG_UNIT_PRDCT
, SVA_ATTRIBUTE_CATEGORY SVA_ATTRIBUTE_CATEGORY
, SVA_ATTRIBUTE1 SVA_ATTRIBUTE1
, SVA_ATTRIBUTE2 SVA_ATTRIBUTE2
, SVA_ATTRIBUTE3 SVA_ATTRIBUTE3
, SVA_ATTRIBUTE4 SVA_ATTRIBUTE4
, SVA_ATTRIBUTE5 SVA_ATTRIBUTE5
, SVA_ATTRIBUTE6 SVA_ATTRIBUTE6
, SVA_ATTRIBUTE7 SVA_ATTRIBUTE7
, SVA_ATTRIBUTE8 SVA_ATTRIBUTE8
, SVA_ATTRIBUTE9 SVA_ATTRIBUTE9
, SVA_ATTRIBUTE10 SVA_ATTRIBUTE10
, SVA_ATTRIBUTE11 SVA_ATTRIBUTE11
, SVA_ATTRIBUTE12 SVA_ATTRIBUTE12
, SVA_ATTRIBUTE13 SVA_ATTRIBUTE13
, SVA_ATTRIBUTE14 SVA_ATTRIBUTE14
, SVA_ATTRIBUTE15 SVA_ATTRIBUTE15
, SVA_ATTRIBUTE16 SVA_ATTRIBUTE16
, SVA_ATTRIBUTE17 SVA_ATTRIBUTE17
, SVA_ATTRIBUTE18 SVA_ATTRIBUTE18
, SVA_ATTRIBUTE19 SVA_ATTRIBUTE19
, SVA_ATTRIBUTE20 SVA_ATTRIBUTE20
, SVA_ATTRIBUTE21 SVA_ATTRIBUTE21
, SVA_ATTRIBUTE22 SVA_ATTRIBUTE22
, SVA_ATTRIBUTE23 SVA_ATTRIBUTE23
, SVA_ATTRIBUTE24 SVA_ATTRIBUTE24
, SVA_ATTRIBUTE25 SVA_ATTRIBUTE25
, SVA_ATTRIBUTE26 SVA_ATTRIBUTE26
, SVA_ATTRIBUTE27 SVA_ATTRIBUTE27
, SVA_ATTRIBUTE28 SVA_ATTRIBUTE28
, SVA_ATTRIBUTE29 SVA_ATTRIBUTE29
, SVA_ATTRIBUTE30 SVA_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
, NAME NAME
FROM "BEN"."BEN_SVC_AREA_F"