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

Source

View Text - Preformatted


select ORG_UNIT_RT_ID ORG_UNIT_RT_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, EXCLD_FLAG EXCLD_FLAG, VRBL_RT_PRFL_ID VRBL_RT_PRFL_ID, OUR_ATTRIBUTE_CATEGORY OUR_ATTRIBUTE_CATEGORY, OUR_ATTRIBUTE1 OUR_ATTRIBUTE1, OUR_ATTRIBUTE2 OUR_ATTRIBUTE2, OUR_ATTRIBUTE3 OUR_ATTRIBUTE3, OUR_ATTRIBUTE4 OUR_ATTRIBUTE4, OUR_ATTRIBUTE5 OUR_ATTRIBUTE5, OUR_ATTRIBUTE6 OUR_ATTRIBUTE6, OUR_ATTRIBUTE7 OUR_ATTRIBUTE7, OUR_ATTRIBUTE8 OUR_ATTRIBUTE8, OUR_ATTRIBUTE9 OUR_ATTRIBUTE9, OUR_ATTRIBUTE10 OUR_ATTRIBUTE10, OUR_ATTRIBUTE11 OUR_ATTRIBUTE11, OUR_ATTRIBUTE12 OUR_ATTRIBUTE12, OUR_ATTRIBUTE13 OUR_ATTRIBUTE13, OUR_ATTRIBUTE14 OUR_ATTRIBUTE14, OUR_ATTRIBUTE15 OUR_ATTRIBUTE15, OUR_ATTRIBUTE16 OUR_ATTRIBUTE16, OUR_ATTRIBUTE17 OUR_ATTRIBUTE17, OUR_ATTRIBUTE18 OUR_ATTRIBUTE18, OUR_ATTRIBUTE19 OUR_ATTRIBUTE19, OUR_ATTRIBUTE20 OUR_ATTRIBUTE20, OUR_ATTRIBUTE21 OUR_ATTRIBUTE21, OUR_ATTRIBUTE22 OUR_ATTRIBUTE22, OUR_ATTRIBUTE23 OUR_ATTRIBUTE23, OUR_ATTRIBUTE24 OUR_ATTRIBUTE24, OUR_ATTRIBUTE25 OUR_ATTRIBUTE25, OUR_ATTRIBUTE26 OUR_ATTRIBUTE26, OUR_ATTRIBUTE27 OUR_ATTRIBUTE27, OUR_ATTRIBUTE28 OUR_ATTRIBUTE28, OUR_ATTRIBUTE29 OUR_ATTRIBUTE29, OUR_ATTRIBUTE30 OUR_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, ORDR_NUM ORDR_NUM from "BEN"."BEN_ORG_UNIT_RT_F"

View Text - HTML Formatted

SELECT ORG_UNIT_RT_ID ORG_UNIT_RT_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, EXCLD_FLAG EXCLD_FLAG
, VRBL_RT_PRFL_ID VRBL_RT_PRFL_ID
, OUR_ATTRIBUTE_CATEGORY OUR_ATTRIBUTE_CATEGORY
, OUR_ATTRIBUTE1 OUR_ATTRIBUTE1
, OUR_ATTRIBUTE2 OUR_ATTRIBUTE2
, OUR_ATTRIBUTE3 OUR_ATTRIBUTE3
, OUR_ATTRIBUTE4 OUR_ATTRIBUTE4
, OUR_ATTRIBUTE5 OUR_ATTRIBUTE5
, OUR_ATTRIBUTE6 OUR_ATTRIBUTE6
, OUR_ATTRIBUTE7 OUR_ATTRIBUTE7
, OUR_ATTRIBUTE8 OUR_ATTRIBUTE8
, OUR_ATTRIBUTE9 OUR_ATTRIBUTE9
, OUR_ATTRIBUTE10 OUR_ATTRIBUTE10
, OUR_ATTRIBUTE11 OUR_ATTRIBUTE11
, OUR_ATTRIBUTE12 OUR_ATTRIBUTE12
, OUR_ATTRIBUTE13 OUR_ATTRIBUTE13
, OUR_ATTRIBUTE14 OUR_ATTRIBUTE14
, OUR_ATTRIBUTE15 OUR_ATTRIBUTE15
, OUR_ATTRIBUTE16 OUR_ATTRIBUTE16
, OUR_ATTRIBUTE17 OUR_ATTRIBUTE17
, OUR_ATTRIBUTE18 OUR_ATTRIBUTE18
, OUR_ATTRIBUTE19 OUR_ATTRIBUTE19
, OUR_ATTRIBUTE20 OUR_ATTRIBUTE20
, OUR_ATTRIBUTE21 OUR_ATTRIBUTE21
, OUR_ATTRIBUTE22 OUR_ATTRIBUTE22
, OUR_ATTRIBUTE23 OUR_ATTRIBUTE23
, OUR_ATTRIBUTE24 OUR_ATTRIBUTE24
, OUR_ATTRIBUTE25 OUR_ATTRIBUTE25
, OUR_ATTRIBUTE26 OUR_ATTRIBUTE26
, OUR_ATTRIBUTE27 OUR_ATTRIBUTE27
, OUR_ATTRIBUTE28 OUR_ATTRIBUTE28
, OUR_ATTRIBUTE29 OUR_ATTRIBUTE29
, OUR_ATTRIBUTE30 OUR_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
, ORDR_NUM ORDR_NUM
FROM "BEN"."BEN_ORG_UNIT_RT_F"