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: HR.PQP_VEH_ALLOC_EXTRA_INFO#

Source

View Text - Preformatted


select VEH_ALLOC_EXTRA_INFO_ID VEH_ALLOC_EXTRA_INFO_ID, VEHICLE_ALLOCATION_ID VEHICLE_ALLOCATION_ID, INFORMATION_TYPE INFORMATION_TYPE, VAEI_ATTRIBUTE_CATEGORY VAEI_ATTRIBUTE_CATEGORY, VAEI_ATTRIBUTE1 VAEI_ATTRIBUTE1, VAEI_ATTRIBUTE2 VAEI_ATTRIBUTE2, VAEI_ATTRIBUTE3 VAEI_ATTRIBUTE3, VAEI_ATTRIBUTE4 VAEI_ATTRIBUTE4, VAEI_ATTRIBUTE5 VAEI_ATTRIBUTE5, VAEI_ATTRIBUTE6 VAEI_ATTRIBUTE6, VAEI_ATTRIBUTE7 VAEI_ATTRIBUTE7, VAEI_ATTRIBUTE8 VAEI_ATTRIBUTE8, VAEI_ATTRIBUTE9 VAEI_ATTRIBUTE9, VAEI_ATTRIBUTE10 VAEI_ATTRIBUTE10, VAEI_ATTRIBUTE11 VAEI_ATTRIBUTE11, VAEI_ATTRIBUTE12 VAEI_ATTRIBUTE12, VAEI_ATTRIBUTE13 VAEI_ATTRIBUTE13, VAEI_ATTRIBUTE14 VAEI_ATTRIBUTE14, VAEI_ATTRIBUTE15 VAEI_ATTRIBUTE15, VAEI_ATTRIBUTE16 VAEI_ATTRIBUTE16, VAEI_ATTRIBUTE17 VAEI_ATTRIBUTE17, VAEI_ATTRIBUTE18 VAEI_ATTRIBUTE18, VAEI_ATTRIBUTE19 VAEI_ATTRIBUTE19, VAEI_ATTRIBUTE20 VAEI_ATTRIBUTE20, VAEI_INFORMATION_CATEGORY VAEI_INFORMATION_CATEGORY, VAEI_INFORMATION1 VAEI_INFORMATION1, VAEI_INFORMATION2 VAEI_INFORMATION2, VAEI_INFORMATION3 VAEI_INFORMATION3, VAEI_INFORMATION4 VAEI_INFORMATION4, VAEI_INFORMATION5 VAEI_INFORMATION5, VAEI_INFORMATION6 VAEI_INFORMATION6, VAEI_INFORMATION7 VAEI_INFORMATION7, VAEI_INFORMATION8 VAEI_INFORMATION8, VAEI_INFORMATION9 VAEI_INFORMATION9, VAEI_INFORMATION10 VAEI_INFORMATION10, VAEI_INFORMATION11 VAEI_INFORMATION11, VAEI_INFORMATION12 VAEI_INFORMATION12, VAEI_INFORMATION13 VAEI_INFORMATION13, VAEI_INFORMATION14 VAEI_INFORMATION14, VAEI_INFORMATION15 VAEI_INFORMATION15, VAEI_INFORMATION16 VAEI_INFORMATION16, VAEI_INFORMATION17 VAEI_INFORMATION17, VAEI_INFORMATION18 VAEI_INFORMATION18, VAEI_INFORMATION19 VAEI_INFORMATION19, VAEI_INFORMATION20 VAEI_INFORMATION20, VAEI_INFORMATION21 VAEI_INFORMATION21, VAEI_INFORMATION22 VAEI_INFORMATION22, VAEI_INFORMATION23 VAEI_INFORMATION23, VAEI_INFORMATION24 VAEI_INFORMATION24, VAEI_INFORMATION25 VAEI_INFORMATION25, VAEI_INFORMATION26 VAEI_INFORMATION26, VAEI_INFORMATION27 VAEI_INFORMATION27, VAEI_INFORMATION28 VAEI_INFORMATION28, VAEI_INFORMATION29 VAEI_INFORMATION29, VAEI_INFORMATION30 VAEI_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, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE from "HR"."PQP_VEH_ALLOC_EXTRA_INFO"

View Text - HTML Formatted

SELECT VEH_ALLOC_EXTRA_INFO_ID VEH_ALLOC_EXTRA_INFO_ID
, VEHICLE_ALLOCATION_ID VEHICLE_ALLOCATION_ID
, INFORMATION_TYPE INFORMATION_TYPE
, VAEI_ATTRIBUTE_CATEGORY VAEI_ATTRIBUTE_CATEGORY
, VAEI_ATTRIBUTE1 VAEI_ATTRIBUTE1
, VAEI_ATTRIBUTE2 VAEI_ATTRIBUTE2
, VAEI_ATTRIBUTE3 VAEI_ATTRIBUTE3
, VAEI_ATTRIBUTE4 VAEI_ATTRIBUTE4
, VAEI_ATTRIBUTE5 VAEI_ATTRIBUTE5
, VAEI_ATTRIBUTE6 VAEI_ATTRIBUTE6
, VAEI_ATTRIBUTE7 VAEI_ATTRIBUTE7
, VAEI_ATTRIBUTE8 VAEI_ATTRIBUTE8
, VAEI_ATTRIBUTE9 VAEI_ATTRIBUTE9
, VAEI_ATTRIBUTE10 VAEI_ATTRIBUTE10
, VAEI_ATTRIBUTE11 VAEI_ATTRIBUTE11
, VAEI_ATTRIBUTE12 VAEI_ATTRIBUTE12
, VAEI_ATTRIBUTE13 VAEI_ATTRIBUTE13
, VAEI_ATTRIBUTE14 VAEI_ATTRIBUTE14
, VAEI_ATTRIBUTE15 VAEI_ATTRIBUTE15
, VAEI_ATTRIBUTE16 VAEI_ATTRIBUTE16
, VAEI_ATTRIBUTE17 VAEI_ATTRIBUTE17
, VAEI_ATTRIBUTE18 VAEI_ATTRIBUTE18
, VAEI_ATTRIBUTE19 VAEI_ATTRIBUTE19
, VAEI_ATTRIBUTE20 VAEI_ATTRIBUTE20
, VAEI_INFORMATION_CATEGORY VAEI_INFORMATION_CATEGORY
, VAEI_INFORMATION1 VAEI_INFORMATION1
, VAEI_INFORMATION2 VAEI_INFORMATION2
, VAEI_INFORMATION3 VAEI_INFORMATION3
, VAEI_INFORMATION4 VAEI_INFORMATION4
, VAEI_INFORMATION5 VAEI_INFORMATION5
, VAEI_INFORMATION6 VAEI_INFORMATION6
, VAEI_INFORMATION7 VAEI_INFORMATION7
, VAEI_INFORMATION8 VAEI_INFORMATION8
, VAEI_INFORMATION9 VAEI_INFORMATION9
, VAEI_INFORMATION10 VAEI_INFORMATION10
, VAEI_INFORMATION11 VAEI_INFORMATION11
, VAEI_INFORMATION12 VAEI_INFORMATION12
, VAEI_INFORMATION13 VAEI_INFORMATION13
, VAEI_INFORMATION14 VAEI_INFORMATION14
, VAEI_INFORMATION15 VAEI_INFORMATION15
, VAEI_INFORMATION16 VAEI_INFORMATION16
, VAEI_INFORMATION17 VAEI_INFORMATION17
, VAEI_INFORMATION18 VAEI_INFORMATION18
, VAEI_INFORMATION19 VAEI_INFORMATION19
, VAEI_INFORMATION20 VAEI_INFORMATION20
, VAEI_INFORMATION21 VAEI_INFORMATION21
, VAEI_INFORMATION22 VAEI_INFORMATION22
, VAEI_INFORMATION23 VAEI_INFORMATION23
, VAEI_INFORMATION24 VAEI_INFORMATION24
, VAEI_INFORMATION25 VAEI_INFORMATION25
, VAEI_INFORMATION26 VAEI_INFORMATION26
, VAEI_INFORMATION27 VAEI_INFORMATION27
, VAEI_INFORMATION28 VAEI_INFORMATION28
, VAEI_INFORMATION29 VAEI_INFORMATION29
, VAEI_INFORMATION30 VAEI_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
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
FROM "HR"."PQP_VEH_ALLOC_EXTRA_INFO"