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

Source

View Text - Preformatted


select PL_REGY_PRPS_ID PL_REGY_PRPS_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, PL_REGY_PRPS_CD PL_REGY_PRPS_CD, PL_REGY_BOD_ID PL_REGY_BOD_ID, PRP_ATTRIBUTE_CATEGORY PRP_ATTRIBUTE_CATEGORY, PRP_ATTRIBUTE1 PRP_ATTRIBUTE1, PRP_ATTRIBUTE2 PRP_ATTRIBUTE2, PRP_ATTRIBUTE3 PRP_ATTRIBUTE3, PRP_ATTRIBUTE4 PRP_ATTRIBUTE4, PRP_ATTRIBUTE5 PRP_ATTRIBUTE5, PRP_ATTRIBUTE6 PRP_ATTRIBUTE6, PRP_ATTRIBUTE7 PRP_ATTRIBUTE7, PRP_ATTRIBUTE8 PRP_ATTRIBUTE8, PRP_ATTRIBUTE9 PRP_ATTRIBUTE9, PRP_ATTRIBUTE10 PRP_ATTRIBUTE10, PRP_ATTRIBUTE11 PRP_ATTRIBUTE11, PRP_ATTRIBUTE12 PRP_ATTRIBUTE12, PRP_ATTRIBUTE13 PRP_ATTRIBUTE13, PRP_ATTRIBUTE14 PRP_ATTRIBUTE14, PRP_ATTRIBUTE15 PRP_ATTRIBUTE15, PRP_ATTRIBUTE16 PRP_ATTRIBUTE16, PRP_ATTRIBUTE17 PRP_ATTRIBUTE17, PRP_ATTRIBUTE18 PRP_ATTRIBUTE18, PRP_ATTRIBUTE19 PRP_ATTRIBUTE19, PRP_ATTRIBUTE20 PRP_ATTRIBUTE20, PRP_ATTRIBUTE21 PRP_ATTRIBUTE21, PRP_ATTRIBUTE22 PRP_ATTRIBUTE22, PRP_ATTRIBUTE23 PRP_ATTRIBUTE23, PRP_ATTRIBUTE24 PRP_ATTRIBUTE24, PRP_ATTRIBUTE25 PRP_ATTRIBUTE25, PRP_ATTRIBUTE26 PRP_ATTRIBUTE26, PRP_ATTRIBUTE27 PRP_ATTRIBUTE27, PRP_ATTRIBUTE28 PRP_ATTRIBUTE28, PRP_ATTRIBUTE29 PRP_ATTRIBUTE29, PRP_ATTRIBUTE30 PRP_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 from "BEN"."BEN_PL_REGY_PRP_F"

View Text - HTML Formatted

SELECT PL_REGY_PRPS_ID PL_REGY_PRPS_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, PL_REGY_PRPS_CD PL_REGY_PRPS_CD
, PL_REGY_BOD_ID PL_REGY_BOD_ID
, PRP_ATTRIBUTE_CATEGORY PRP_ATTRIBUTE_CATEGORY
, PRP_ATTRIBUTE1 PRP_ATTRIBUTE1
, PRP_ATTRIBUTE2 PRP_ATTRIBUTE2
, PRP_ATTRIBUTE3 PRP_ATTRIBUTE3
, PRP_ATTRIBUTE4 PRP_ATTRIBUTE4
, PRP_ATTRIBUTE5 PRP_ATTRIBUTE5
, PRP_ATTRIBUTE6 PRP_ATTRIBUTE6
, PRP_ATTRIBUTE7 PRP_ATTRIBUTE7
, PRP_ATTRIBUTE8 PRP_ATTRIBUTE8
, PRP_ATTRIBUTE9 PRP_ATTRIBUTE9
, PRP_ATTRIBUTE10 PRP_ATTRIBUTE10
, PRP_ATTRIBUTE11 PRP_ATTRIBUTE11
, PRP_ATTRIBUTE12 PRP_ATTRIBUTE12
, PRP_ATTRIBUTE13 PRP_ATTRIBUTE13
, PRP_ATTRIBUTE14 PRP_ATTRIBUTE14
, PRP_ATTRIBUTE15 PRP_ATTRIBUTE15
, PRP_ATTRIBUTE16 PRP_ATTRIBUTE16
, PRP_ATTRIBUTE17 PRP_ATTRIBUTE17
, PRP_ATTRIBUTE18 PRP_ATTRIBUTE18
, PRP_ATTRIBUTE19 PRP_ATTRIBUTE19
, PRP_ATTRIBUTE20 PRP_ATTRIBUTE20
, PRP_ATTRIBUTE21 PRP_ATTRIBUTE21
, PRP_ATTRIBUTE22 PRP_ATTRIBUTE22
, PRP_ATTRIBUTE23 PRP_ATTRIBUTE23
, PRP_ATTRIBUTE24 PRP_ATTRIBUTE24
, PRP_ATTRIBUTE25 PRP_ATTRIBUTE25
, PRP_ATTRIBUTE26 PRP_ATTRIBUTE26
, PRP_ATTRIBUTE27 PRP_ATTRIBUTE27
, PRP_ATTRIBUTE28 PRP_ATTRIBUTE28
, PRP_ATTRIBUTE29 PRP_ATTRIBUTE29
, PRP_ATTRIBUTE30 PRP_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
FROM "BEN"."BEN_PL_REGY_PRP_F"