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

Source

View Text - Preformatted


select EXT_RCD_ID EXT_RCD_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, XRC_ATTRIBUTE_CATEGORY XRC_ATTRIBUTE_CATEGORY, XRC_ATTRIBUTE1 XRC_ATTRIBUTE1, XRC_ATTRIBUTE2 XRC_ATTRIBUTE2, XRC_ATTRIBUTE3 XRC_ATTRIBUTE3, XRC_ATTRIBUTE4 XRC_ATTRIBUTE4, XRC_ATTRIBUTE5 XRC_ATTRIBUTE5, XRC_ATTRIBUTE6 XRC_ATTRIBUTE6, XRC_ATTRIBUTE7 XRC_ATTRIBUTE7, XRC_ATTRIBUTE8 XRC_ATTRIBUTE8, XRC_ATTRIBUTE9 XRC_ATTRIBUTE9, XRC_ATTRIBUTE10 XRC_ATTRIBUTE10, XRC_ATTRIBUTE11 XRC_ATTRIBUTE11, XRC_ATTRIBUTE12 XRC_ATTRIBUTE12, XRC_ATTRIBUTE13 XRC_ATTRIBUTE13, XRC_ATTRIBUTE14 XRC_ATTRIBUTE14, XRC_ATTRIBUTE15 XRC_ATTRIBUTE15, XRC_ATTRIBUTE16 XRC_ATTRIBUTE16, XRC_ATTRIBUTE17 XRC_ATTRIBUTE17, XRC_ATTRIBUTE18 XRC_ATTRIBUTE18, XRC_ATTRIBUTE19 XRC_ATTRIBUTE19, XRC_ATTRIBUTE20 XRC_ATTRIBUTE20, XRC_ATTRIBUTE21 XRC_ATTRIBUTE21, XRC_ATTRIBUTE22 XRC_ATTRIBUTE22, XRC_ATTRIBUTE23 XRC_ATTRIBUTE23, XRC_ATTRIBUTE24 XRC_ATTRIBUTE24, XRC_ATTRIBUTE25 XRC_ATTRIBUTE25, XRC_ATTRIBUTE26 XRC_ATTRIBUTE26, XRC_ATTRIBUTE27 XRC_ATTRIBUTE27, XRC_ATTRIBUTE28 XRC_ATTRIBUTE28, XRC_ATTRIBUTE29 XRC_ATTRIBUTE29, XRC_ATTRIBUTE30 XRC_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, RCD_TYPE_CD RCD_TYPE_CD, LOW_LVL_CD LOW_LVL_CD, LEGISLATION_CODE LEGISLATION_CODE, XML_TAG_NAME XML_TAG_NAME, ZD_EDITION_NAME ZD_EDITION_NAME from "BEN"."BEN_EXT_RCD"

View Text - HTML Formatted

SELECT EXT_RCD_ID EXT_RCD_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, XRC_ATTRIBUTE_CATEGORY XRC_ATTRIBUTE_CATEGORY
, XRC_ATTRIBUTE1 XRC_ATTRIBUTE1
, XRC_ATTRIBUTE2 XRC_ATTRIBUTE2
, XRC_ATTRIBUTE3 XRC_ATTRIBUTE3
, XRC_ATTRIBUTE4 XRC_ATTRIBUTE4
, XRC_ATTRIBUTE5 XRC_ATTRIBUTE5
, XRC_ATTRIBUTE6 XRC_ATTRIBUTE6
, XRC_ATTRIBUTE7 XRC_ATTRIBUTE7
, XRC_ATTRIBUTE8 XRC_ATTRIBUTE8
, XRC_ATTRIBUTE9 XRC_ATTRIBUTE9
, XRC_ATTRIBUTE10 XRC_ATTRIBUTE10
, XRC_ATTRIBUTE11 XRC_ATTRIBUTE11
, XRC_ATTRIBUTE12 XRC_ATTRIBUTE12
, XRC_ATTRIBUTE13 XRC_ATTRIBUTE13
, XRC_ATTRIBUTE14 XRC_ATTRIBUTE14
, XRC_ATTRIBUTE15 XRC_ATTRIBUTE15
, XRC_ATTRIBUTE16 XRC_ATTRIBUTE16
, XRC_ATTRIBUTE17 XRC_ATTRIBUTE17
, XRC_ATTRIBUTE18 XRC_ATTRIBUTE18
, XRC_ATTRIBUTE19 XRC_ATTRIBUTE19
, XRC_ATTRIBUTE20 XRC_ATTRIBUTE20
, XRC_ATTRIBUTE21 XRC_ATTRIBUTE21
, XRC_ATTRIBUTE22 XRC_ATTRIBUTE22
, XRC_ATTRIBUTE23 XRC_ATTRIBUTE23
, XRC_ATTRIBUTE24 XRC_ATTRIBUTE24
, XRC_ATTRIBUTE25 XRC_ATTRIBUTE25
, XRC_ATTRIBUTE26 XRC_ATTRIBUTE26
, XRC_ATTRIBUTE27 XRC_ATTRIBUTE27
, XRC_ATTRIBUTE28 XRC_ATTRIBUTE28
, XRC_ATTRIBUTE29 XRC_ATTRIBUTE29
, XRC_ATTRIBUTE30 XRC_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
, RCD_TYPE_CD RCD_TYPE_CD
, LOW_LVL_CD LOW_LVL_CD
, LEGISLATION_CODE LEGISLATION_CODE
, XML_TAG_NAME XML_TAG_NAME
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "BEN"."BEN_EXT_RCD"