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

Source

View Text - Preformatted


select CMBN_PTIP_ID CMBN_PTIP_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, NAME NAME, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, PGM_ID PGM_ID, CBP_ATTRIBUTE_CATEGORY CBP_ATTRIBUTE_CATEGORY, CBP_ATTRIBUTE1 CBP_ATTRIBUTE1, CBP_ATTRIBUTE2 CBP_ATTRIBUTE2, CBP_ATTRIBUTE3 CBP_ATTRIBUTE3, CBP_ATTRIBUTE4 CBP_ATTRIBUTE4, CBP_ATTRIBUTE5 CBP_ATTRIBUTE5, CBP_ATTRIBUTE6 CBP_ATTRIBUTE6, CBP_ATTRIBUTE7 CBP_ATTRIBUTE7, CBP_ATTRIBUTE8 CBP_ATTRIBUTE8, CBP_ATTRIBUTE9 CBP_ATTRIBUTE9, CBP_ATTRIBUTE10 CBP_ATTRIBUTE10, CBP_ATTRIBUTE11 CBP_ATTRIBUTE11, CBP_ATTRIBUTE12 CBP_ATTRIBUTE12, CBP_ATTRIBUTE13 CBP_ATTRIBUTE13, CBP_ATTRIBUTE14 CBP_ATTRIBUTE14, CBP_ATTRIBUTE15 CBP_ATTRIBUTE15, CBP_ATTRIBUTE16 CBP_ATTRIBUTE16, CBP_ATTRIBUTE17 CBP_ATTRIBUTE17, CBP_ATTRIBUTE18 CBP_ATTRIBUTE18, CBP_ATTRIBUTE19 CBP_ATTRIBUTE19, CBP_ATTRIBUTE20 CBP_ATTRIBUTE20, CBP_ATTRIBUTE21 CBP_ATTRIBUTE21, CBP_ATTRIBUTE22 CBP_ATTRIBUTE22, CBP_ATTRIBUTE23 CBP_ATTRIBUTE23, CBP_ATTRIBUTE24 CBP_ATTRIBUTE24, CBP_ATTRIBUTE25 CBP_ATTRIBUTE25, CBP_ATTRIBUTE26 CBP_ATTRIBUTE26, CBP_ATTRIBUTE27 CBP_ATTRIBUTE27, CBP_ATTRIBUTE28 CBP_ATTRIBUTE28, CBP_ATTRIBUTE29 CBP_ATTRIBUTE29, CBP_ATTRIBUTE30 CBP_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_CMBN_PTIP_F"

View Text - HTML Formatted

SELECT CMBN_PTIP_ID CMBN_PTIP_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, NAME NAME
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PGM_ID PGM_ID
, CBP_ATTRIBUTE_CATEGORY CBP_ATTRIBUTE_CATEGORY
, CBP_ATTRIBUTE1 CBP_ATTRIBUTE1
, CBP_ATTRIBUTE2 CBP_ATTRIBUTE2
, CBP_ATTRIBUTE3 CBP_ATTRIBUTE3
, CBP_ATTRIBUTE4 CBP_ATTRIBUTE4
, CBP_ATTRIBUTE5 CBP_ATTRIBUTE5
, CBP_ATTRIBUTE6 CBP_ATTRIBUTE6
, CBP_ATTRIBUTE7 CBP_ATTRIBUTE7
, CBP_ATTRIBUTE8 CBP_ATTRIBUTE8
, CBP_ATTRIBUTE9 CBP_ATTRIBUTE9
, CBP_ATTRIBUTE10 CBP_ATTRIBUTE10
, CBP_ATTRIBUTE11 CBP_ATTRIBUTE11
, CBP_ATTRIBUTE12 CBP_ATTRIBUTE12
, CBP_ATTRIBUTE13 CBP_ATTRIBUTE13
, CBP_ATTRIBUTE14 CBP_ATTRIBUTE14
, CBP_ATTRIBUTE15 CBP_ATTRIBUTE15
, CBP_ATTRIBUTE16 CBP_ATTRIBUTE16
, CBP_ATTRIBUTE17 CBP_ATTRIBUTE17
, CBP_ATTRIBUTE18 CBP_ATTRIBUTE18
, CBP_ATTRIBUTE19 CBP_ATTRIBUTE19
, CBP_ATTRIBUTE20 CBP_ATTRIBUTE20
, CBP_ATTRIBUTE21 CBP_ATTRIBUTE21
, CBP_ATTRIBUTE22 CBP_ATTRIBUTE22
, CBP_ATTRIBUTE23 CBP_ATTRIBUTE23
, CBP_ATTRIBUTE24 CBP_ATTRIBUTE24
, CBP_ATTRIBUTE25 CBP_ATTRIBUTE25
, CBP_ATTRIBUTE26 CBP_ATTRIBUTE26
, CBP_ATTRIBUTE27 CBP_ATTRIBUTE27
, CBP_ATTRIBUTE28 CBP_ATTRIBUTE28
, CBP_ATTRIBUTE29 CBP_ATTRIBUTE29
, CBP_ATTRIBUTE30 CBP_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_CMBN_PTIP_F"