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

Source

View Text - Preformatted


select PSTL_ZIP_RNG_ID PSTL_ZIP_RNG_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, FROM_VALUE FROM_VALUE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, RZR_ATTRIBUTE_CATEGORY RZR_ATTRIBUTE_CATEGORY, RZR_ATTRIBUTE1 RZR_ATTRIBUTE1, RZR_ATTRIBUTE10 RZR_ATTRIBUTE10, RZR_ATTRIBUTE11 RZR_ATTRIBUTE11, RZR_ATTRIBUTE12 RZR_ATTRIBUTE12, RZR_ATTRIBUTE13 RZR_ATTRIBUTE13, RZR_ATTRIBUTE14 RZR_ATTRIBUTE14, RZR_ATTRIBUTE15 RZR_ATTRIBUTE15, RZR_ATTRIBUTE16 RZR_ATTRIBUTE16, RZR_ATTRIBUTE17 RZR_ATTRIBUTE17, RZR_ATTRIBUTE18 RZR_ATTRIBUTE18, RZR_ATTRIBUTE19 RZR_ATTRIBUTE19, RZR_ATTRIBUTE2 RZR_ATTRIBUTE2, RZR_ATTRIBUTE20 RZR_ATTRIBUTE20, RZR_ATTRIBUTE21 RZR_ATTRIBUTE21, RZR_ATTRIBUTE22 RZR_ATTRIBUTE22, RZR_ATTRIBUTE23 RZR_ATTRIBUTE23, RZR_ATTRIBUTE24 RZR_ATTRIBUTE24, RZR_ATTRIBUTE25 RZR_ATTRIBUTE25, RZR_ATTRIBUTE26 RZR_ATTRIBUTE26, RZR_ATTRIBUTE27 RZR_ATTRIBUTE27, RZR_ATTRIBUTE28 RZR_ATTRIBUTE28, RZR_ATTRIBUTE29 RZR_ATTRIBUTE29, RZR_ATTRIBUTE3 RZR_ATTRIBUTE3, RZR_ATTRIBUTE30 RZR_ATTRIBUTE30, RZR_ATTRIBUTE4 RZR_ATTRIBUTE4, RZR_ATTRIBUTE5 RZR_ATTRIBUTE5, RZR_ATTRIBUTE6 RZR_ATTRIBUTE6, RZR_ATTRIBUTE7 RZR_ATTRIBUTE7, RZR_ATTRIBUTE8 RZR_ATTRIBUTE8, RZR_ATTRIBUTE9 RZR_ATTRIBUTE9, 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, TO_VALUE TO_VALUE from "BEN"."BEN_PSTL_ZIP_RNG_F"

View Text - HTML Formatted

SELECT PSTL_ZIP_RNG_ID PSTL_ZIP_RNG_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, FROM_VALUE FROM_VALUE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, RZR_ATTRIBUTE_CATEGORY RZR_ATTRIBUTE_CATEGORY
, RZR_ATTRIBUTE1 RZR_ATTRIBUTE1
, RZR_ATTRIBUTE10 RZR_ATTRIBUTE10
, RZR_ATTRIBUTE11 RZR_ATTRIBUTE11
, RZR_ATTRIBUTE12 RZR_ATTRIBUTE12
, RZR_ATTRIBUTE13 RZR_ATTRIBUTE13
, RZR_ATTRIBUTE14 RZR_ATTRIBUTE14
, RZR_ATTRIBUTE15 RZR_ATTRIBUTE15
, RZR_ATTRIBUTE16 RZR_ATTRIBUTE16
, RZR_ATTRIBUTE17 RZR_ATTRIBUTE17
, RZR_ATTRIBUTE18 RZR_ATTRIBUTE18
, RZR_ATTRIBUTE19 RZR_ATTRIBUTE19
, RZR_ATTRIBUTE2 RZR_ATTRIBUTE2
, RZR_ATTRIBUTE20 RZR_ATTRIBUTE20
, RZR_ATTRIBUTE21 RZR_ATTRIBUTE21
, RZR_ATTRIBUTE22 RZR_ATTRIBUTE22
, RZR_ATTRIBUTE23 RZR_ATTRIBUTE23
, RZR_ATTRIBUTE24 RZR_ATTRIBUTE24
, RZR_ATTRIBUTE25 RZR_ATTRIBUTE25
, RZR_ATTRIBUTE26 RZR_ATTRIBUTE26
, RZR_ATTRIBUTE27 RZR_ATTRIBUTE27
, RZR_ATTRIBUTE28 RZR_ATTRIBUTE28
, RZR_ATTRIBUTE29 RZR_ATTRIBUTE29
, RZR_ATTRIBUTE3 RZR_ATTRIBUTE3
, RZR_ATTRIBUTE30 RZR_ATTRIBUTE30
, RZR_ATTRIBUTE4 RZR_ATTRIBUTE4
, RZR_ATTRIBUTE5 RZR_ATTRIBUTE5
, RZR_ATTRIBUTE6 RZR_ATTRIBUTE6
, RZR_ATTRIBUTE7 RZR_ATTRIBUTE7
, RZR_ATTRIBUTE8 RZR_ATTRIBUTE8
, RZR_ATTRIBUTE9 RZR_ATTRIBUTE9
, 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
, TO_VALUE TO_VALUE
FROM "BEN"."BEN_PSTL_ZIP_RNG_F"