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

Source

View Text - Preformatted


select CM_TYP_TRGR_ID CM_TYP_TRGR_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, CM_TRGR_ID CM_TRGR_ID, CM_TYP_ID CM_TYP_ID, CM_TYP_TRGR_RL CM_TYP_TRGR_RL, CTT_ATTRIBUTE_CATEGORY CTT_ATTRIBUTE_CATEGORY, CTT_ATTRIBUTE1 CTT_ATTRIBUTE1, CTT_ATTRIBUTE2 CTT_ATTRIBUTE2, CTT_ATTRIBUTE3 CTT_ATTRIBUTE3, CTT_ATTRIBUTE4 CTT_ATTRIBUTE4, CTT_ATTRIBUTE5 CTT_ATTRIBUTE5, CTT_ATTRIBUTE6 CTT_ATTRIBUTE6, CTT_ATTRIBUTE7 CTT_ATTRIBUTE7, CTT_ATTRIBUTE8 CTT_ATTRIBUTE8, CTT_ATTRIBUTE9 CTT_ATTRIBUTE9, CTT_ATTRIBUTE10 CTT_ATTRIBUTE10, CTT_ATTRIBUTE11 CTT_ATTRIBUTE11, CTT_ATTRIBUTE12 CTT_ATTRIBUTE12, CTT_ATTRIBUTE13 CTT_ATTRIBUTE13, CTT_ATTRIBUTE14 CTT_ATTRIBUTE14, CTT_ATTRIBUTE15 CTT_ATTRIBUTE15, CTT_ATTRIBUTE16 CTT_ATTRIBUTE16, CTT_ATTRIBUTE17 CTT_ATTRIBUTE17, CTT_ATTRIBUTE18 CTT_ATTRIBUTE18, CTT_ATTRIBUTE19 CTT_ATTRIBUTE19, CTT_ATTRIBUTE20 CTT_ATTRIBUTE20, CTT_ATTRIBUTE21 CTT_ATTRIBUTE21, CTT_ATTRIBUTE22 CTT_ATTRIBUTE22, CTT_ATTRIBUTE23 CTT_ATTRIBUTE23, CTT_ATTRIBUTE24 CTT_ATTRIBUTE24, CTT_ATTRIBUTE25 CTT_ATTRIBUTE25, CTT_ATTRIBUTE26 CTT_ATTRIBUTE26, CTT_ATTRIBUTE27 CTT_ATTRIBUTE27, CTT_ATTRIBUTE28 CTT_ATTRIBUTE28, CTT_ATTRIBUTE29 CTT_ATTRIBUTE29, CTT_ATTRIBUTE30 CTT_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_CM_TYP_TRGR_F"

View Text - HTML Formatted

SELECT CM_TYP_TRGR_ID CM_TYP_TRGR_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, CM_TRGR_ID CM_TRGR_ID
, CM_TYP_ID CM_TYP_ID
, CM_TYP_TRGR_RL CM_TYP_TRGR_RL
, CTT_ATTRIBUTE_CATEGORY CTT_ATTRIBUTE_CATEGORY
, CTT_ATTRIBUTE1 CTT_ATTRIBUTE1
, CTT_ATTRIBUTE2 CTT_ATTRIBUTE2
, CTT_ATTRIBUTE3 CTT_ATTRIBUTE3
, CTT_ATTRIBUTE4 CTT_ATTRIBUTE4
, CTT_ATTRIBUTE5 CTT_ATTRIBUTE5
, CTT_ATTRIBUTE6 CTT_ATTRIBUTE6
, CTT_ATTRIBUTE7 CTT_ATTRIBUTE7
, CTT_ATTRIBUTE8 CTT_ATTRIBUTE8
, CTT_ATTRIBUTE9 CTT_ATTRIBUTE9
, CTT_ATTRIBUTE10 CTT_ATTRIBUTE10
, CTT_ATTRIBUTE11 CTT_ATTRIBUTE11
, CTT_ATTRIBUTE12 CTT_ATTRIBUTE12
, CTT_ATTRIBUTE13 CTT_ATTRIBUTE13
, CTT_ATTRIBUTE14 CTT_ATTRIBUTE14
, CTT_ATTRIBUTE15 CTT_ATTRIBUTE15
, CTT_ATTRIBUTE16 CTT_ATTRIBUTE16
, CTT_ATTRIBUTE17 CTT_ATTRIBUTE17
, CTT_ATTRIBUTE18 CTT_ATTRIBUTE18
, CTT_ATTRIBUTE19 CTT_ATTRIBUTE19
, CTT_ATTRIBUTE20 CTT_ATTRIBUTE20
, CTT_ATTRIBUTE21 CTT_ATTRIBUTE21
, CTT_ATTRIBUTE22 CTT_ATTRIBUTE22
, CTT_ATTRIBUTE23 CTT_ATTRIBUTE23
, CTT_ATTRIBUTE24 CTT_ATTRIBUTE24
, CTT_ATTRIBUTE25 CTT_ATTRIBUTE25
, CTT_ATTRIBUTE26 CTT_ATTRIBUTE26
, CTT_ATTRIBUTE27 CTT_ATTRIBUTE27
, CTT_ATTRIBUTE28 CTT_ATTRIBUTE28
, CTT_ATTRIBUTE29 CTT_ATTRIBUTE29
, CTT_ATTRIBUTE30 CTT_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_CM_TYP_TRGR_F"