VIEW: HR.PQP_VEHICLE_DETAILS#

Source

View Text - Preformatted

select VEHICLE_DETAILS_ID VEHICLE_DETAILS_ID, VEHICLE_TYPE VEHICLE_TYPE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, REGISTRATION_NUMBER REGISTRATION_NUMBER, MAKE MAKE, MODEL MODEL, VEHICLE_IDENTIFICATION_NUMBER VEHICLE_IDENTIFICATION_NUMBER, DATE_FIRST_REGISTERED DATE_FIRST_REGISTERED, ENGINE_CAPACITY_IN_CC ENGINE_CAPACITY_IN_CC, FUEL_TYPE FUEL_TYPE, FUEL_CARD FUEL_CARD, CURRENCY_CODE CURRENCY_CODE, LIST_PRICE LIST_PRICE, ACCESSORY_VALUE_AT_STARTDATE ACCESSORY_VALUE_AT_STARTDATE, ACCESSORY_VALUE_ADDED_LATER ACCESSORY_VALUE_ADDED_LATER, MARKET_VALUE_CLASSIC_CAR MARKET_VALUE_CLASSIC_CAR, CO2_EMISSIONS CO2_EMISSIONS, VEHICLE_PROVIDER VEHICLE_PROVIDER, VEHICLE_OWNERSHIP VEHICLE_OWNERSHIP, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, VHD_ATTRIBUTE_CATEGORY VHD_ATTRIBUTE_CATEGORY, VHD_ATTRIBUTE1 VHD_ATTRIBUTE1, VHD_ATTRIBUTE2 VHD_ATTRIBUTE2, VHD_ATTRIBUTE3 VHD_ATTRIBUTE3, VHD_ATTRIBUTE4 VHD_ATTRIBUTE4, VHD_ATTRIBUTE5 VHD_ATTRIBUTE5, VHD_ATTRIBUTE6 VHD_ATTRIBUTE6, VHD_ATTRIBUTE7 VHD_ATTRIBUTE7, VHD_ATTRIBUTE8 VHD_ATTRIBUTE8, VHD_ATTRIBUTE9 VHD_ATTRIBUTE9, VHD_ATTRIBUTE10 VHD_ATTRIBUTE10, VHD_ATTRIBUTE11 VHD_ATTRIBUTE11, VHD_ATTRIBUTE12 VHD_ATTRIBUTE12, VHD_ATTRIBUTE13 VHD_ATTRIBUTE13, VHD_ATTRIBUTE14 VHD_ATTRIBUTE14, VHD_ATTRIBUTE15 VHD_ATTRIBUTE15, VHD_ATTRIBUTE16 VHD_ATTRIBUTE16, VHD_ATTRIBUTE17 VHD_ATTRIBUTE17, VHD_ATTRIBUTE18 VHD_ATTRIBUTE18, VHD_ATTRIBUTE19 VHD_ATTRIBUTE19, VHD_ATTRIBUTE20 VHD_ATTRIBUTE20, VHD_INFORMATION_CATEGORY VHD_INFORMATION_CATEGORY, VHD_INFORMATION1 VHD_INFORMATION1, VHD_INFORMATION2 VHD_INFORMATION2, VHD_INFORMATION3 VHD_INFORMATION3, VHD_INFORMATION4 VHD_INFORMATION4, VHD_INFORMATION5 VHD_INFORMATION5, VHD_INFORMATION6 VHD_INFORMATION6, VHD_INFORMATION7 VHD_INFORMATION7, VHD_INFORMATION8 VHD_INFORMATION8, VHD_INFORMATION9 VHD_INFORMATION9, VHD_INFORMATION10 VHD_INFORMATION10, VHD_INFORMATION11 VHD_INFORMATION11, VHD_INFORMATION12 VHD_INFORMATION12, VHD_INFORMATION13 VHD_INFORMATION13, VHD_INFORMATION14 VHD_INFORMATION14, VHD_INFORMATION15 VHD_INFORMATION15, VHD_INFORMATION16 VHD_INFORMATION16, VHD_INFORMATION17 VHD_INFORMATION17, VHD_INFORMATION18 VHD_INFORMATION18, VHD_INFORMATION19 VHD_INFORMATION19, VHD_INFORMATION20 VHD_INFORMATION20 from "HR"."PQP_VEHICLE_DETAILS"

View Text - HTML Formatted

SELECT VEHICLE_DETAILS_ID VEHICLE_DETAILS_ID
, VEHICLE_TYPE VEHICLE_TYPE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, REGISTRATION_NUMBER REGISTRATION_NUMBER
, MAKE MAKE
, MODEL MODEL
, VEHICLE_IDENTIFICATION_NUMBER VEHICLE_IDENTIFICATION_NUMBER
, DATE_FIRST_REGISTERED DATE_FIRST_REGISTERED
, ENGINE_CAPACITY_IN_CC ENGINE_CAPACITY_IN_CC
, FUEL_TYPE FUEL_TYPE
, FUEL_CARD FUEL_CARD
, CURRENCY_CODE CURRENCY_CODE
, LIST_PRICE LIST_PRICE
, ACCESSORY_VALUE_AT_STARTDATE ACCESSORY_VALUE_AT_STARTDATE
, ACCESSORY_VALUE_ADDED_LATER ACCESSORY_VALUE_ADDED_LATER
, MARKET_VALUE_CLASSIC_CAR MARKET_VALUE_CLASSIC_CAR
, CO2_EMISSIONS CO2_EMISSIONS
, VEHICLE_PROVIDER VEHICLE_PROVIDER
, VEHICLE_OWNERSHIP VEHICLE_OWNERSHIP
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, VHD_ATTRIBUTE_CATEGORY VHD_ATTRIBUTE_CATEGORY
, VHD_ATTRIBUTE1 VHD_ATTRIBUTE1
, VHD_ATTRIBUTE2 VHD_ATTRIBUTE2
, VHD_ATTRIBUTE3 VHD_ATTRIBUTE3
, VHD_ATTRIBUTE4 VHD_ATTRIBUTE4
, VHD_ATTRIBUTE5 VHD_ATTRIBUTE5
, VHD_ATTRIBUTE6 VHD_ATTRIBUTE6
, VHD_ATTRIBUTE7 VHD_ATTRIBUTE7
, VHD_ATTRIBUTE8 VHD_ATTRIBUTE8
, VHD_ATTRIBUTE9 VHD_ATTRIBUTE9
, VHD_ATTRIBUTE10 VHD_ATTRIBUTE10
, VHD_ATTRIBUTE11 VHD_ATTRIBUTE11
, VHD_ATTRIBUTE12 VHD_ATTRIBUTE12
, VHD_ATTRIBUTE13 VHD_ATTRIBUTE13
, VHD_ATTRIBUTE14 VHD_ATTRIBUTE14
, VHD_ATTRIBUTE15 VHD_ATTRIBUTE15
, VHD_ATTRIBUTE16 VHD_ATTRIBUTE16
, VHD_ATTRIBUTE17 VHD_ATTRIBUTE17
, VHD_ATTRIBUTE18 VHD_ATTRIBUTE18
, VHD_ATTRIBUTE19 VHD_ATTRIBUTE19
, VHD_ATTRIBUTE20 VHD_ATTRIBUTE20
, VHD_INFORMATION_CATEGORY VHD_INFORMATION_CATEGORY
, VHD_INFORMATION1 VHD_INFORMATION1
, VHD_INFORMATION2 VHD_INFORMATION2
, VHD_INFORMATION3 VHD_INFORMATION3
, VHD_INFORMATION4 VHD_INFORMATION4
, VHD_INFORMATION5 VHD_INFORMATION5
, VHD_INFORMATION6 VHD_INFORMATION6
, VHD_INFORMATION7 VHD_INFORMATION7
, VHD_INFORMATION8 VHD_INFORMATION8
, VHD_INFORMATION9 VHD_INFORMATION9
, VHD_INFORMATION10 VHD_INFORMATION10
, VHD_INFORMATION11 VHD_INFORMATION11
, VHD_INFORMATION12 VHD_INFORMATION12
, VHD_INFORMATION13 VHD_INFORMATION13
, VHD_INFORMATION14 VHD_INFORMATION14
, VHD_INFORMATION15 VHD_INFORMATION15
, VHD_INFORMATION16 VHD_INFORMATION16
, VHD_INFORMATION17 VHD_INFORMATION17
, VHD_INFORMATION18 VHD_INFORMATION18
, VHD_INFORMATION19 VHD_INFORMATION19
, VHD_INFORMATION20 VHD_INFORMATION20
FROM "HR"."PQP_VEHICLE_DETAILS"