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

Source

View Text - Preformatted


select PSTL_ZIP_RT_ID PSTL_ZIP_RT_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, PSTL_ZIP_RNG_ID PSTL_ZIP_RNG_ID, EXCLD_FLAG EXCLD_FLAG, VRBL_RT_PRFL_ID VRBL_RT_PRFL_ID, PZR_ATTRIBUTE_CATEGORY PZR_ATTRIBUTE_CATEGORY, PZR_ATTRIBUTE1 PZR_ATTRIBUTE1, PZR_ATTRIBUTE2 PZR_ATTRIBUTE2, PZR_ATTRIBUTE3 PZR_ATTRIBUTE3, PZR_ATTRIBUTE4 PZR_ATTRIBUTE4, PZR_ATTRIBUTE5 PZR_ATTRIBUTE5, PZR_ATTRIBUTE6 PZR_ATTRIBUTE6, PZR_ATTRIBUTE7 PZR_ATTRIBUTE7, PZR_ATTRIBUTE8 PZR_ATTRIBUTE8, PZR_ATTRIBUTE9 PZR_ATTRIBUTE9, PZR_ATTRIBUTE10 PZR_ATTRIBUTE10, PZR_ATTRIBUTE11 PZR_ATTRIBUTE11, PZR_ATTRIBUTE12 PZR_ATTRIBUTE12, PZR_ATTRIBUTE13 PZR_ATTRIBUTE13, PZR_ATTRIBUTE14 PZR_ATTRIBUTE14, PZR_ATTRIBUTE15 PZR_ATTRIBUTE15, PZR_ATTRIBUTE16 PZR_ATTRIBUTE16, PZR_ATTRIBUTE17 PZR_ATTRIBUTE17, PZR_ATTRIBUTE18 PZR_ATTRIBUTE18, PZR_ATTRIBUTE19 PZR_ATTRIBUTE19, PZR_ATTRIBUTE20 PZR_ATTRIBUTE20, PZR_ATTRIBUTE21 PZR_ATTRIBUTE21, PZR_ATTRIBUTE22 PZR_ATTRIBUTE22, PZR_ATTRIBUTE23 PZR_ATTRIBUTE23, PZR_ATTRIBUTE24 PZR_ATTRIBUTE24, PZR_ATTRIBUTE25 PZR_ATTRIBUTE25, PZR_ATTRIBUTE26 PZR_ATTRIBUTE26, PZR_ATTRIBUTE27 PZR_ATTRIBUTE27, PZR_ATTRIBUTE28 PZR_ATTRIBUTE28, PZR_ATTRIBUTE29 PZR_ATTRIBUTE29, PZR_ATTRIBUTE30 PZR_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_PSTL_ZIP_RT_F"

View Text - HTML Formatted

SELECT PSTL_ZIP_RT_ID PSTL_ZIP_RT_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PSTL_ZIP_RNG_ID PSTL_ZIP_RNG_ID
, EXCLD_FLAG EXCLD_FLAG
, VRBL_RT_PRFL_ID VRBL_RT_PRFL_ID
, PZR_ATTRIBUTE_CATEGORY PZR_ATTRIBUTE_CATEGORY
, PZR_ATTRIBUTE1 PZR_ATTRIBUTE1
, PZR_ATTRIBUTE2 PZR_ATTRIBUTE2
, PZR_ATTRIBUTE3 PZR_ATTRIBUTE3
, PZR_ATTRIBUTE4 PZR_ATTRIBUTE4
, PZR_ATTRIBUTE5 PZR_ATTRIBUTE5
, PZR_ATTRIBUTE6 PZR_ATTRIBUTE6
, PZR_ATTRIBUTE7 PZR_ATTRIBUTE7
, PZR_ATTRIBUTE8 PZR_ATTRIBUTE8
, PZR_ATTRIBUTE9 PZR_ATTRIBUTE9
, PZR_ATTRIBUTE10 PZR_ATTRIBUTE10
, PZR_ATTRIBUTE11 PZR_ATTRIBUTE11
, PZR_ATTRIBUTE12 PZR_ATTRIBUTE12
, PZR_ATTRIBUTE13 PZR_ATTRIBUTE13
, PZR_ATTRIBUTE14 PZR_ATTRIBUTE14
, PZR_ATTRIBUTE15 PZR_ATTRIBUTE15
, PZR_ATTRIBUTE16 PZR_ATTRIBUTE16
, PZR_ATTRIBUTE17 PZR_ATTRIBUTE17
, PZR_ATTRIBUTE18 PZR_ATTRIBUTE18
, PZR_ATTRIBUTE19 PZR_ATTRIBUTE19
, PZR_ATTRIBUTE20 PZR_ATTRIBUTE20
, PZR_ATTRIBUTE21 PZR_ATTRIBUTE21
, PZR_ATTRIBUTE22 PZR_ATTRIBUTE22
, PZR_ATTRIBUTE23 PZR_ATTRIBUTE23
, PZR_ATTRIBUTE24 PZR_ATTRIBUTE24
, PZR_ATTRIBUTE25 PZR_ATTRIBUTE25
, PZR_ATTRIBUTE26 PZR_ATTRIBUTE26
, PZR_ATTRIBUTE27 PZR_ATTRIBUTE27
, PZR_ATTRIBUTE28 PZR_ATTRIBUTE28
, PZR_ATTRIBUTE29 PZR_ATTRIBUTE29
, PZR_ATTRIBUTE30 PZR_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_PSTL_ZIP_RT_F"