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

Source

View Text - Preformatted


select LER_EXTRA_INFO_ID LER_EXTRA_INFO_ID, LER_ID LER_ID, INFORMATION_TYPE INFORMATION_TYPE, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, LRI_ATTRIBUTE_CATEGORY LRI_ATTRIBUTE_CATEGORY, LRI_ATTRIBUTE1 LRI_ATTRIBUTE1, LRI_ATTRIBUTE2 LRI_ATTRIBUTE2, LRI_ATTRIBUTE3 LRI_ATTRIBUTE3, LRI_ATTRIBUTE4 LRI_ATTRIBUTE4, LRI_ATTRIBUTE5 LRI_ATTRIBUTE5, LRI_ATTRIBUTE6 LRI_ATTRIBUTE6, LRI_ATTRIBUTE7 LRI_ATTRIBUTE7, LRI_ATTRIBUTE8 LRI_ATTRIBUTE8, LRI_ATTRIBUTE9 LRI_ATTRIBUTE9, LRI_ATTRIBUTE10 LRI_ATTRIBUTE10, LRI_ATTRIBUTE11 LRI_ATTRIBUTE11, LRI_ATTRIBUTE12 LRI_ATTRIBUTE12, LRI_ATTRIBUTE13 LRI_ATTRIBUTE13, LRI_ATTRIBUTE14 LRI_ATTRIBUTE14, LRI_ATTRIBUTE15 LRI_ATTRIBUTE15, LRI_ATTRIBUTE16 LRI_ATTRIBUTE16, LRI_ATTRIBUTE17 LRI_ATTRIBUTE17, LRI_ATTRIBUTE18 LRI_ATTRIBUTE18, LRI_ATTRIBUTE19 LRI_ATTRIBUTE19, LRI_ATTRIBUTE20 LRI_ATTRIBUTE20, LRI_INFORMATION_CATEGORY LRI_INFORMATION_CATEGORY, LRI_INFORMATION1 LRI_INFORMATION1, LRI_INFORMATION2 LRI_INFORMATION2, LRI_INFORMATION3 LRI_INFORMATION3, LRI_INFORMATION4 LRI_INFORMATION4, LRI_INFORMATION5 LRI_INFORMATION5, LRI_INFORMATION6 LRI_INFORMATION6, LRI_INFORMATION7 LRI_INFORMATION7, LRI_INFORMATION8 LRI_INFORMATION8, LRI_INFORMATION9 LRI_INFORMATION9, LRI_INFORMATION10 LRI_INFORMATION10, LRI_INFORMATION11 LRI_INFORMATION11, LRI_INFORMATION12 LRI_INFORMATION12, LRI_INFORMATION13 LRI_INFORMATION13, LRI_INFORMATION14 LRI_INFORMATION14, LRI_INFORMATION15 LRI_INFORMATION15, LRI_INFORMATION16 LRI_INFORMATION16, LRI_INFORMATION17 LRI_INFORMATION17, LRI_INFORMATION18 LRI_INFORMATION18, LRI_INFORMATION19 LRI_INFORMATION19, LRI_INFORMATION20 LRI_INFORMATION20, LRI_INFORMATION21 LRI_INFORMATION21, LRI_INFORMATION22 LRI_INFORMATION22, LRI_INFORMATION23 LRI_INFORMATION23, LRI_INFORMATION24 LRI_INFORMATION24, LRI_INFORMATION25 LRI_INFORMATION25, LRI_INFORMATION26 LRI_INFORMATION26, LRI_INFORMATION27 LRI_INFORMATION27, LRI_INFORMATION28 LRI_INFORMATION28, LRI_INFORMATION29 LRI_INFORMATION29, LRI_INFORMATION30 LRI_INFORMATION30, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, 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 from "BEN"."BEN_LER_EXTRA_INFO"

View Text - HTML Formatted

SELECT LER_EXTRA_INFO_ID LER_EXTRA_INFO_ID
, LER_ID LER_ID
, INFORMATION_TYPE INFORMATION_TYPE
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, LRI_ATTRIBUTE_CATEGORY LRI_ATTRIBUTE_CATEGORY
, LRI_ATTRIBUTE1 LRI_ATTRIBUTE1
, LRI_ATTRIBUTE2 LRI_ATTRIBUTE2
, LRI_ATTRIBUTE3 LRI_ATTRIBUTE3
, LRI_ATTRIBUTE4 LRI_ATTRIBUTE4
, LRI_ATTRIBUTE5 LRI_ATTRIBUTE5
, LRI_ATTRIBUTE6 LRI_ATTRIBUTE6
, LRI_ATTRIBUTE7 LRI_ATTRIBUTE7
, LRI_ATTRIBUTE8 LRI_ATTRIBUTE8
, LRI_ATTRIBUTE9 LRI_ATTRIBUTE9
, LRI_ATTRIBUTE10 LRI_ATTRIBUTE10
, LRI_ATTRIBUTE11 LRI_ATTRIBUTE11
, LRI_ATTRIBUTE12 LRI_ATTRIBUTE12
, LRI_ATTRIBUTE13 LRI_ATTRIBUTE13
, LRI_ATTRIBUTE14 LRI_ATTRIBUTE14
, LRI_ATTRIBUTE15 LRI_ATTRIBUTE15
, LRI_ATTRIBUTE16 LRI_ATTRIBUTE16
, LRI_ATTRIBUTE17 LRI_ATTRIBUTE17
, LRI_ATTRIBUTE18 LRI_ATTRIBUTE18
, LRI_ATTRIBUTE19 LRI_ATTRIBUTE19
, LRI_ATTRIBUTE20 LRI_ATTRIBUTE20
, LRI_INFORMATION_CATEGORY LRI_INFORMATION_CATEGORY
, LRI_INFORMATION1 LRI_INFORMATION1
, LRI_INFORMATION2 LRI_INFORMATION2
, LRI_INFORMATION3 LRI_INFORMATION3
, LRI_INFORMATION4 LRI_INFORMATION4
, LRI_INFORMATION5 LRI_INFORMATION5
, LRI_INFORMATION6 LRI_INFORMATION6
, LRI_INFORMATION7 LRI_INFORMATION7
, LRI_INFORMATION8 LRI_INFORMATION8
, LRI_INFORMATION9 LRI_INFORMATION9
, LRI_INFORMATION10 LRI_INFORMATION10
, LRI_INFORMATION11 LRI_INFORMATION11
, LRI_INFORMATION12 LRI_INFORMATION12
, LRI_INFORMATION13 LRI_INFORMATION13
, LRI_INFORMATION14 LRI_INFORMATION14
, LRI_INFORMATION15 LRI_INFORMATION15
, LRI_INFORMATION16 LRI_INFORMATION16
, LRI_INFORMATION17 LRI_INFORMATION17
, LRI_INFORMATION18 LRI_INFORMATION18
, LRI_INFORMATION19 LRI_INFORMATION19
, LRI_INFORMATION20 LRI_INFORMATION20
, LRI_INFORMATION21 LRI_INFORMATION21
, LRI_INFORMATION22 LRI_INFORMATION22
, LRI_INFORMATION23 LRI_INFORMATION23
, LRI_INFORMATION24 LRI_INFORMATION24
, LRI_INFORMATION25 LRI_INFORMATION25
, LRI_INFORMATION26 LRI_INFORMATION26
, LRI_INFORMATION27 LRI_INFORMATION27
, LRI_INFORMATION28 LRI_INFORMATION28
, LRI_INFORMATION29 LRI_INFORMATION29
, LRI_INFORMATION30 LRI_INFORMATION30
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, 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
FROM "BEN"."BEN_LER_EXTRA_INFO"