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

Source

View Text - Preformatted


select PREM_CSTG_BY_SGMT_ID PREM_CSTG_BY_SGMT_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, SGMT_NUM SGMT_NUM, SGMT_CSTG_MTHD_CD SGMT_CSTG_MTHD_CD, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, ACTL_PREM_ID ACTL_PREM_ID, CBS_ATTRIBUTE_CATEGORY CBS_ATTRIBUTE_CATEGORY, CBS_ATTRIBUTE1 CBS_ATTRIBUTE1, CBS_ATTRIBUTE2 CBS_ATTRIBUTE2, CBS_ATTRIBUTE3 CBS_ATTRIBUTE3, CBS_ATTRIBUTE4 CBS_ATTRIBUTE4, CBS_ATTRIBUTE5 CBS_ATTRIBUTE5, CBS_ATTRIBUTE6 CBS_ATTRIBUTE6, CBS_ATTRIBUTE7 CBS_ATTRIBUTE7, CBS_ATTRIBUTE8 CBS_ATTRIBUTE8, CBS_ATTRIBUTE9 CBS_ATTRIBUTE9, CBS_ATTRIBUTE10 CBS_ATTRIBUTE10, CBS_ATTRIBUTE11 CBS_ATTRIBUTE11, CBS_ATTRIBUTE12 CBS_ATTRIBUTE12, CBS_ATTRIBUTE13 CBS_ATTRIBUTE13, CBS_ATTRIBUTE14 CBS_ATTRIBUTE14, CBS_ATTRIBUTE15 CBS_ATTRIBUTE15, CBS_ATTRIBUTE16 CBS_ATTRIBUTE16, CBS_ATTRIBUTE17 CBS_ATTRIBUTE17, CBS_ATTRIBUTE18 CBS_ATTRIBUTE18, CBS_ATTRIBUTE19 CBS_ATTRIBUTE19, CBS_ATTRIBUTE20 CBS_ATTRIBUTE20, CBS_ATTRIBUTE21 CBS_ATTRIBUTE21, CBS_ATTRIBUTE22 CBS_ATTRIBUTE22, CBS_ATTRIBUTE23 CBS_ATTRIBUTE23, CBS_ATTRIBUTE24 CBS_ATTRIBUTE24, CBS_ATTRIBUTE25 CBS_ATTRIBUTE25, CBS_ATTRIBUTE26 CBS_ATTRIBUTE26, CBS_ATTRIBUTE27 CBS_ATTRIBUTE27, CBS_ATTRIBUTE28 CBS_ATTRIBUTE28, CBS_ATTRIBUTE29 CBS_ATTRIBUTE29, CBS_ATTRIBUTE30 CBS_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, SGMT_CSTG_MTHD_RL SGMT_CSTG_MTHD_RL from "BEN"."BEN_PREM_CSTG_BY_SGMT_F"

View Text - HTML Formatted

SELECT PREM_CSTG_BY_SGMT_ID PREM_CSTG_BY_SGMT_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, SGMT_NUM SGMT_NUM
, SGMT_CSTG_MTHD_CD SGMT_CSTG_MTHD_CD
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, ACTL_PREM_ID ACTL_PREM_ID
, CBS_ATTRIBUTE_CATEGORY CBS_ATTRIBUTE_CATEGORY
, CBS_ATTRIBUTE1 CBS_ATTRIBUTE1
, CBS_ATTRIBUTE2 CBS_ATTRIBUTE2
, CBS_ATTRIBUTE3 CBS_ATTRIBUTE3
, CBS_ATTRIBUTE4 CBS_ATTRIBUTE4
, CBS_ATTRIBUTE5 CBS_ATTRIBUTE5
, CBS_ATTRIBUTE6 CBS_ATTRIBUTE6
, CBS_ATTRIBUTE7 CBS_ATTRIBUTE7
, CBS_ATTRIBUTE8 CBS_ATTRIBUTE8
, CBS_ATTRIBUTE9 CBS_ATTRIBUTE9
, CBS_ATTRIBUTE10 CBS_ATTRIBUTE10
, CBS_ATTRIBUTE11 CBS_ATTRIBUTE11
, CBS_ATTRIBUTE12 CBS_ATTRIBUTE12
, CBS_ATTRIBUTE13 CBS_ATTRIBUTE13
, CBS_ATTRIBUTE14 CBS_ATTRIBUTE14
, CBS_ATTRIBUTE15 CBS_ATTRIBUTE15
, CBS_ATTRIBUTE16 CBS_ATTRIBUTE16
, CBS_ATTRIBUTE17 CBS_ATTRIBUTE17
, CBS_ATTRIBUTE18 CBS_ATTRIBUTE18
, CBS_ATTRIBUTE19 CBS_ATTRIBUTE19
, CBS_ATTRIBUTE20 CBS_ATTRIBUTE20
, CBS_ATTRIBUTE21 CBS_ATTRIBUTE21
, CBS_ATTRIBUTE22 CBS_ATTRIBUTE22
, CBS_ATTRIBUTE23 CBS_ATTRIBUTE23
, CBS_ATTRIBUTE24 CBS_ATTRIBUTE24
, CBS_ATTRIBUTE25 CBS_ATTRIBUTE25
, CBS_ATTRIBUTE26 CBS_ATTRIBUTE26
, CBS_ATTRIBUTE27 CBS_ATTRIBUTE27
, CBS_ATTRIBUTE28 CBS_ATTRIBUTE28
, CBS_ATTRIBUTE29 CBS_ATTRIBUTE29
, CBS_ATTRIBUTE30 CBS_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
, SGMT_CSTG_MTHD_RL SGMT_CSTG_MTHD_RL
FROM "BEN"."BEN_PREM_CSTG_BY_SGMT_F"