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

Source

View Text - Preformatted


select PL_EXTRA_INFO_ID PL_EXTRA_INFO_ID, PL_ID PL_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, PLI_ATTRIBUTE_CATEGORY PLI_ATTRIBUTE_CATEGORY, PLI_ATTRIBUTE1 PLI_ATTRIBUTE1, PLI_ATTRIBUTE2 PLI_ATTRIBUTE2, PLI_ATTRIBUTE3 PLI_ATTRIBUTE3, PLI_ATTRIBUTE4 PLI_ATTRIBUTE4, PLI_ATTRIBUTE5 PLI_ATTRIBUTE5, PLI_ATTRIBUTE6 PLI_ATTRIBUTE6, PLI_ATTRIBUTE7 PLI_ATTRIBUTE7, PLI_ATTRIBUTE8 PLI_ATTRIBUTE8, PLI_ATTRIBUTE9 PLI_ATTRIBUTE9, PLI_ATTRIBUTE10 PLI_ATTRIBUTE10, PLI_ATTRIBUTE11 PLI_ATTRIBUTE11, PLI_ATTRIBUTE12 PLI_ATTRIBUTE12, PLI_ATTRIBUTE13 PLI_ATTRIBUTE13, PLI_ATTRIBUTE14 PLI_ATTRIBUTE14, PLI_ATTRIBUTE15 PLI_ATTRIBUTE15, PLI_ATTRIBUTE16 PLI_ATTRIBUTE16, PLI_ATTRIBUTE17 PLI_ATTRIBUTE17, PLI_ATTRIBUTE18 PLI_ATTRIBUTE18, PLI_ATTRIBUTE19 PLI_ATTRIBUTE19, PLI_ATTRIBUTE20 PLI_ATTRIBUTE20, PLI_INFORMATION_CATEGORY PLI_INFORMATION_CATEGORY, PLI_INFORMATION1 PLI_INFORMATION1, PLI_INFORMATION2 PLI_INFORMATION2, PLI_INFORMATION3 PLI_INFORMATION3, PLI_INFORMATION4 PLI_INFORMATION4, PLI_INFORMATION5 PLI_INFORMATION5, PLI_INFORMATION6 PLI_INFORMATION6, PLI_INFORMATION7 PLI_INFORMATION7, PLI_INFORMATION8 PLI_INFORMATION8, PLI_INFORMATION9 PLI_INFORMATION9, PLI_INFORMATION10 PLI_INFORMATION10, PLI_INFORMATION11 PLI_INFORMATION11, PLI_INFORMATION12 PLI_INFORMATION12, PLI_INFORMATION13 PLI_INFORMATION13, PLI_INFORMATION14 PLI_INFORMATION14, PLI_INFORMATION15 PLI_INFORMATION15, PLI_INFORMATION16 PLI_INFORMATION16, PLI_INFORMATION17 PLI_INFORMATION17, PLI_INFORMATION18 PLI_INFORMATION18, PLI_INFORMATION19 PLI_INFORMATION19, PLI_INFORMATION20 PLI_INFORMATION20, PLI_INFORMATION21 PLI_INFORMATION21, PLI_INFORMATION22 PLI_INFORMATION22, PLI_INFORMATION23 PLI_INFORMATION23, PLI_INFORMATION24 PLI_INFORMATION24, PLI_INFORMATION25 PLI_INFORMATION25, PLI_INFORMATION26 PLI_INFORMATION26, PLI_INFORMATION27 PLI_INFORMATION27, PLI_INFORMATION28 PLI_INFORMATION28, PLI_INFORMATION29 PLI_INFORMATION29, PLI_INFORMATION30 PLI_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_PL_EXTRA_INFO"

View Text - HTML Formatted

SELECT PL_EXTRA_INFO_ID PL_EXTRA_INFO_ID
, PL_ID PL_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
, PLI_ATTRIBUTE_CATEGORY PLI_ATTRIBUTE_CATEGORY
, PLI_ATTRIBUTE1 PLI_ATTRIBUTE1
, PLI_ATTRIBUTE2 PLI_ATTRIBUTE2
, PLI_ATTRIBUTE3 PLI_ATTRIBUTE3
, PLI_ATTRIBUTE4 PLI_ATTRIBUTE4
, PLI_ATTRIBUTE5 PLI_ATTRIBUTE5
, PLI_ATTRIBUTE6 PLI_ATTRIBUTE6
, PLI_ATTRIBUTE7 PLI_ATTRIBUTE7
, PLI_ATTRIBUTE8 PLI_ATTRIBUTE8
, PLI_ATTRIBUTE9 PLI_ATTRIBUTE9
, PLI_ATTRIBUTE10 PLI_ATTRIBUTE10
, PLI_ATTRIBUTE11 PLI_ATTRIBUTE11
, PLI_ATTRIBUTE12 PLI_ATTRIBUTE12
, PLI_ATTRIBUTE13 PLI_ATTRIBUTE13
, PLI_ATTRIBUTE14 PLI_ATTRIBUTE14
, PLI_ATTRIBUTE15 PLI_ATTRIBUTE15
, PLI_ATTRIBUTE16 PLI_ATTRIBUTE16
, PLI_ATTRIBUTE17 PLI_ATTRIBUTE17
, PLI_ATTRIBUTE18 PLI_ATTRIBUTE18
, PLI_ATTRIBUTE19 PLI_ATTRIBUTE19
, PLI_ATTRIBUTE20 PLI_ATTRIBUTE20
, PLI_INFORMATION_CATEGORY PLI_INFORMATION_CATEGORY
, PLI_INFORMATION1 PLI_INFORMATION1
, PLI_INFORMATION2 PLI_INFORMATION2
, PLI_INFORMATION3 PLI_INFORMATION3
, PLI_INFORMATION4 PLI_INFORMATION4
, PLI_INFORMATION5 PLI_INFORMATION5
, PLI_INFORMATION6 PLI_INFORMATION6
, PLI_INFORMATION7 PLI_INFORMATION7
, PLI_INFORMATION8 PLI_INFORMATION8
, PLI_INFORMATION9 PLI_INFORMATION9
, PLI_INFORMATION10 PLI_INFORMATION10
, PLI_INFORMATION11 PLI_INFORMATION11
, PLI_INFORMATION12 PLI_INFORMATION12
, PLI_INFORMATION13 PLI_INFORMATION13
, PLI_INFORMATION14 PLI_INFORMATION14
, PLI_INFORMATION15 PLI_INFORMATION15
, PLI_INFORMATION16 PLI_INFORMATION16
, PLI_INFORMATION17 PLI_INFORMATION17
, PLI_INFORMATION18 PLI_INFORMATION18
, PLI_INFORMATION19 PLI_INFORMATION19
, PLI_INFORMATION20 PLI_INFORMATION20
, PLI_INFORMATION21 PLI_INFORMATION21
, PLI_INFORMATION22 PLI_INFORMATION22
, PLI_INFORMATION23 PLI_INFORMATION23
, PLI_INFORMATION24 PLI_INFORMATION24
, PLI_INFORMATION25 PLI_INFORMATION25
, PLI_INFORMATION26 PLI_INFORMATION26
, PLI_INFORMATION27 PLI_INFORMATION27
, PLI_INFORMATION28 PLI_INFORMATION28
, PLI_INFORMATION29 PLI_INFORMATION29
, PLI_INFORMATION30 PLI_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_PL_EXTRA_INFO"