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

Source

View Text - Preformatted


select LER_RQRS_ENRT_CTFN_ID LER_RQRS_ENRT_CTFN_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, EXCLD_FLAG EXCLD_FLAG, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, LRE_ATTRIBUTE_CATEGORY LRE_ATTRIBUTE_CATEGORY, LRE_ATTRIBUTE1 LRE_ATTRIBUTE1, LRE_ATTRIBUTE2 LRE_ATTRIBUTE2, LRE_ATTRIBUTE3 LRE_ATTRIBUTE3, LRE_ATTRIBUTE4 LRE_ATTRIBUTE4, LRE_ATTRIBUTE5 LRE_ATTRIBUTE5, LRE_ATTRIBUTE6 LRE_ATTRIBUTE6, LRE_ATTRIBUTE7 LRE_ATTRIBUTE7, LRE_ATTRIBUTE8 LRE_ATTRIBUTE8, LRE_ATTRIBUTE9 LRE_ATTRIBUTE9, LRE_ATTRIBUTE10 LRE_ATTRIBUTE10, LRE_ATTRIBUTE11 LRE_ATTRIBUTE11, LRE_ATTRIBUTE12 LRE_ATTRIBUTE12, LRE_ATTRIBUTE13 LRE_ATTRIBUTE13, LRE_ATTRIBUTE14 LRE_ATTRIBUTE14, LRE_ATTRIBUTE15 LRE_ATTRIBUTE15, LRE_ATTRIBUTE16 LRE_ATTRIBUTE16, LRE_ATTRIBUTE17 LRE_ATTRIBUTE17, LRE_ATTRIBUTE18 LRE_ATTRIBUTE18, LRE_ATTRIBUTE19 LRE_ATTRIBUTE19, LRE_ATTRIBUTE20 LRE_ATTRIBUTE20, LRE_ATTRIBUTE21 LRE_ATTRIBUTE21, LRE_ATTRIBUTE22 LRE_ATTRIBUTE22, LRE_ATTRIBUTE23 LRE_ATTRIBUTE23, LRE_ATTRIBUTE24 LRE_ATTRIBUTE24, LRE_ATTRIBUTE25 LRE_ATTRIBUTE25, LRE_ATTRIBUTE26 LRE_ATTRIBUTE26, LRE_ATTRIBUTE27 LRE_ATTRIBUTE27, LRE_ATTRIBUTE28 LRE_ATTRIBUTE28, LRE_ATTRIBUTE29 LRE_ATTRIBUTE29, LRE_ATTRIBUTE30 LRE_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, CTFN_RQD_WHEN_RL CTFN_RQD_WHEN_RL, OIPL_ID OIPL_ID, PL_ID PL_ID, PLIP_ID PLIP_ID, LER_ID LER_ID, SUSP_IF_CTFN_NOT_PRVD_FLAG SUSP_IF_CTFN_NOT_PRVD_FLAG, CTFN_DETERMINE_CD CTFN_DETERMINE_CD from "BEN"."BEN_LER_RQRS_ENRT_CTFN_F"

View Text - HTML Formatted

SELECT LER_RQRS_ENRT_CTFN_ID LER_RQRS_ENRT_CTFN_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, EXCLD_FLAG EXCLD_FLAG
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, LRE_ATTRIBUTE_CATEGORY LRE_ATTRIBUTE_CATEGORY
, LRE_ATTRIBUTE1 LRE_ATTRIBUTE1
, LRE_ATTRIBUTE2 LRE_ATTRIBUTE2
, LRE_ATTRIBUTE3 LRE_ATTRIBUTE3
, LRE_ATTRIBUTE4 LRE_ATTRIBUTE4
, LRE_ATTRIBUTE5 LRE_ATTRIBUTE5
, LRE_ATTRIBUTE6 LRE_ATTRIBUTE6
, LRE_ATTRIBUTE7 LRE_ATTRIBUTE7
, LRE_ATTRIBUTE8 LRE_ATTRIBUTE8
, LRE_ATTRIBUTE9 LRE_ATTRIBUTE9
, LRE_ATTRIBUTE10 LRE_ATTRIBUTE10
, LRE_ATTRIBUTE11 LRE_ATTRIBUTE11
, LRE_ATTRIBUTE12 LRE_ATTRIBUTE12
, LRE_ATTRIBUTE13 LRE_ATTRIBUTE13
, LRE_ATTRIBUTE14 LRE_ATTRIBUTE14
, LRE_ATTRIBUTE15 LRE_ATTRIBUTE15
, LRE_ATTRIBUTE16 LRE_ATTRIBUTE16
, LRE_ATTRIBUTE17 LRE_ATTRIBUTE17
, LRE_ATTRIBUTE18 LRE_ATTRIBUTE18
, LRE_ATTRIBUTE19 LRE_ATTRIBUTE19
, LRE_ATTRIBUTE20 LRE_ATTRIBUTE20
, LRE_ATTRIBUTE21 LRE_ATTRIBUTE21
, LRE_ATTRIBUTE22 LRE_ATTRIBUTE22
, LRE_ATTRIBUTE23 LRE_ATTRIBUTE23
, LRE_ATTRIBUTE24 LRE_ATTRIBUTE24
, LRE_ATTRIBUTE25 LRE_ATTRIBUTE25
, LRE_ATTRIBUTE26 LRE_ATTRIBUTE26
, LRE_ATTRIBUTE27 LRE_ATTRIBUTE27
, LRE_ATTRIBUTE28 LRE_ATTRIBUTE28
, LRE_ATTRIBUTE29 LRE_ATTRIBUTE29
, LRE_ATTRIBUTE30 LRE_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
, CTFN_RQD_WHEN_RL CTFN_RQD_WHEN_RL
, OIPL_ID OIPL_ID
, PL_ID PL_ID
, PLIP_ID PLIP_ID
, LER_ID LER_ID
, SUSP_IF_CTFN_NOT_PRVD_FLAG SUSP_IF_CTFN_NOT_PRVD_FLAG
, CTFN_DETERMINE_CD CTFN_DETERMINE_CD
FROM "BEN"."BEN_LER_RQRS_ENRT_CTFN_F"