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

Source

View Text - Preformatted


select REGN_ID REGN_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, NAME NAME, STTRY_CITN_NAME STTRY_CITN_NAME, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, REG_ATTRIBUTE_CATEGORY REG_ATTRIBUTE_CATEGORY, REG_ATTRIBUTE1 REG_ATTRIBUTE1, REG_ATTRIBUTE2 REG_ATTRIBUTE2, REG_ATTRIBUTE3 REG_ATTRIBUTE3, REG_ATTRIBUTE4 REG_ATTRIBUTE4, REG_ATTRIBUTE5 REG_ATTRIBUTE5, REG_ATTRIBUTE6 REG_ATTRIBUTE6, REG_ATTRIBUTE7 REG_ATTRIBUTE7, REG_ATTRIBUTE8 REG_ATTRIBUTE8, REG_ATTRIBUTE9 REG_ATTRIBUTE9, REG_ATTRIBUTE10 REG_ATTRIBUTE10, REG_ATTRIBUTE11 REG_ATTRIBUTE11, REG_ATTRIBUTE12 REG_ATTRIBUTE12, REG_ATTRIBUTE13 REG_ATTRIBUTE13, REG_ATTRIBUTE14 REG_ATTRIBUTE14, REG_ATTRIBUTE15 REG_ATTRIBUTE15, REG_ATTRIBUTE16 REG_ATTRIBUTE16, REG_ATTRIBUTE17 REG_ATTRIBUTE17, REG_ATTRIBUTE18 REG_ATTRIBUTE18, REG_ATTRIBUTE19 REG_ATTRIBUTE19, REG_ATTRIBUTE20 REG_ATTRIBUTE20, REG_ATTRIBUTE21 REG_ATTRIBUTE21, REG_ATTRIBUTE22 REG_ATTRIBUTE22, REG_ATTRIBUTE23 REG_ATTRIBUTE23, REG_ATTRIBUTE24 REG_ATTRIBUTE24, REG_ATTRIBUTE25 REG_ATTRIBUTE25, REG_ATTRIBUTE26 REG_ATTRIBUTE26, REG_ATTRIBUTE27 REG_ATTRIBUTE27, REG_ATTRIBUTE28 REG_ATTRIBUTE28, REG_ATTRIBUTE29 REG_ATTRIBUTE29, REG_ATTRIBUTE30 REG_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, ORGANIZATION_ID ORGANIZATION_ID from "BEN"."BEN_REGN_F"

View Text - HTML Formatted

SELECT REGN_ID REGN_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, NAME NAME
, STTRY_CITN_NAME STTRY_CITN_NAME
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, REG_ATTRIBUTE_CATEGORY REG_ATTRIBUTE_CATEGORY
, REG_ATTRIBUTE1 REG_ATTRIBUTE1
, REG_ATTRIBUTE2 REG_ATTRIBUTE2
, REG_ATTRIBUTE3 REG_ATTRIBUTE3
, REG_ATTRIBUTE4 REG_ATTRIBUTE4
, REG_ATTRIBUTE5 REG_ATTRIBUTE5
, REG_ATTRIBUTE6 REG_ATTRIBUTE6
, REG_ATTRIBUTE7 REG_ATTRIBUTE7
, REG_ATTRIBUTE8 REG_ATTRIBUTE8
, REG_ATTRIBUTE9 REG_ATTRIBUTE9
, REG_ATTRIBUTE10 REG_ATTRIBUTE10
, REG_ATTRIBUTE11 REG_ATTRIBUTE11
, REG_ATTRIBUTE12 REG_ATTRIBUTE12
, REG_ATTRIBUTE13 REG_ATTRIBUTE13
, REG_ATTRIBUTE14 REG_ATTRIBUTE14
, REG_ATTRIBUTE15 REG_ATTRIBUTE15
, REG_ATTRIBUTE16 REG_ATTRIBUTE16
, REG_ATTRIBUTE17 REG_ATTRIBUTE17
, REG_ATTRIBUTE18 REG_ATTRIBUTE18
, REG_ATTRIBUTE19 REG_ATTRIBUTE19
, REG_ATTRIBUTE20 REG_ATTRIBUTE20
, REG_ATTRIBUTE21 REG_ATTRIBUTE21
, REG_ATTRIBUTE22 REG_ATTRIBUTE22
, REG_ATTRIBUTE23 REG_ATTRIBUTE23
, REG_ATTRIBUTE24 REG_ATTRIBUTE24
, REG_ATTRIBUTE25 REG_ATTRIBUTE25
, REG_ATTRIBUTE26 REG_ATTRIBUTE26
, REG_ATTRIBUTE27 REG_ATTRIBUTE27
, REG_ATTRIBUTE28 REG_ATTRIBUTE28
, REG_ATTRIBUTE29 REG_ATTRIBUTE29
, REG_ATTRIBUTE30 REG_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
, ORGANIZATION_ID ORGANIZATION_ID
FROM "BEN"."BEN_REGN_F"