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

Source

View Text - Preformatted


select POPL_RPTG_GRP_ID POPL_RPTG_GRP_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, RPTG_GRP_ID RPTG_GRP_ID, PGM_ID PGM_ID, PL_ID PL_ID, RGR_ATTRIBUTE_CATEGORY RGR_ATTRIBUTE_CATEGORY, RGR_ATTRIBUTE1 RGR_ATTRIBUTE1, RGR_ATTRIBUTE2 RGR_ATTRIBUTE2, RGR_ATTRIBUTE3 RGR_ATTRIBUTE3, RGR_ATTRIBUTE4 RGR_ATTRIBUTE4, RGR_ATTRIBUTE5 RGR_ATTRIBUTE5, RGR_ATTRIBUTE6 RGR_ATTRIBUTE6, RGR_ATTRIBUTE7 RGR_ATTRIBUTE7, RGR_ATTRIBUTE8 RGR_ATTRIBUTE8, RGR_ATTRIBUTE9 RGR_ATTRIBUTE9, RGR_ATTRIBUTE10 RGR_ATTRIBUTE10, RGR_ATTRIBUTE11 RGR_ATTRIBUTE11, RGR_ATTRIBUTE12 RGR_ATTRIBUTE12, RGR_ATTRIBUTE13 RGR_ATTRIBUTE13, RGR_ATTRIBUTE14 RGR_ATTRIBUTE14, RGR_ATTRIBUTE15 RGR_ATTRIBUTE15, RGR_ATTRIBUTE16 RGR_ATTRIBUTE16, RGR_ATTRIBUTE17 RGR_ATTRIBUTE17, RGR_ATTRIBUTE18 RGR_ATTRIBUTE18, RGR_ATTRIBUTE19 RGR_ATTRIBUTE19, RGR_ATTRIBUTE20 RGR_ATTRIBUTE20, RGR_ATTRIBUTE21 RGR_ATTRIBUTE21, RGR_ATTRIBUTE22 RGR_ATTRIBUTE22, RGR_ATTRIBUTE23 RGR_ATTRIBUTE23, RGR_ATTRIBUTE24 RGR_ATTRIBUTE24, RGR_ATTRIBUTE25 RGR_ATTRIBUTE25, RGR_ATTRIBUTE26 RGR_ATTRIBUTE26, RGR_ATTRIBUTE27 RGR_ATTRIBUTE27, RGR_ATTRIBUTE28 RGR_ATTRIBUTE28, RGR_ATTRIBUTE29 RGR_ATTRIBUTE29, RGR_ATTRIBUTE30 RGR_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_POPL_RPTG_GRP_F"

View Text - HTML Formatted

SELECT POPL_RPTG_GRP_ID POPL_RPTG_GRP_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, RPTG_GRP_ID RPTG_GRP_ID
, PGM_ID PGM_ID
, PL_ID PL_ID
, RGR_ATTRIBUTE_CATEGORY RGR_ATTRIBUTE_CATEGORY
, RGR_ATTRIBUTE1 RGR_ATTRIBUTE1
, RGR_ATTRIBUTE2 RGR_ATTRIBUTE2
, RGR_ATTRIBUTE3 RGR_ATTRIBUTE3
, RGR_ATTRIBUTE4 RGR_ATTRIBUTE4
, RGR_ATTRIBUTE5 RGR_ATTRIBUTE5
, RGR_ATTRIBUTE6 RGR_ATTRIBUTE6
, RGR_ATTRIBUTE7 RGR_ATTRIBUTE7
, RGR_ATTRIBUTE8 RGR_ATTRIBUTE8
, RGR_ATTRIBUTE9 RGR_ATTRIBUTE9
, RGR_ATTRIBUTE10 RGR_ATTRIBUTE10
, RGR_ATTRIBUTE11 RGR_ATTRIBUTE11
, RGR_ATTRIBUTE12 RGR_ATTRIBUTE12
, RGR_ATTRIBUTE13 RGR_ATTRIBUTE13
, RGR_ATTRIBUTE14 RGR_ATTRIBUTE14
, RGR_ATTRIBUTE15 RGR_ATTRIBUTE15
, RGR_ATTRIBUTE16 RGR_ATTRIBUTE16
, RGR_ATTRIBUTE17 RGR_ATTRIBUTE17
, RGR_ATTRIBUTE18 RGR_ATTRIBUTE18
, RGR_ATTRIBUTE19 RGR_ATTRIBUTE19
, RGR_ATTRIBUTE20 RGR_ATTRIBUTE20
, RGR_ATTRIBUTE21 RGR_ATTRIBUTE21
, RGR_ATTRIBUTE22 RGR_ATTRIBUTE22
, RGR_ATTRIBUTE23 RGR_ATTRIBUTE23
, RGR_ATTRIBUTE24 RGR_ATTRIBUTE24
, RGR_ATTRIBUTE25 RGR_ATTRIBUTE25
, RGR_ATTRIBUTE26 RGR_ATTRIBUTE26
, RGR_ATTRIBUTE27 RGR_ATTRIBUTE27
, RGR_ATTRIBUTE28 RGR_ATTRIBUTE28
, RGR_ATTRIBUTE29 RGR_ATTRIBUTE29
, RGR_ATTRIBUTE30 RGR_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_POPL_RPTG_GRP_F"