VIEW: HR.PQP_VEHICLE_REPOSITORY_F#

Source

View Text - Preformatted

select VEHICLE_REPOSITORY_ID VEHICLE_REPOSITORY_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, REGISTRATION_NUMBER REGISTRATION_NUMBER, VEHICLE_TYPE VEHICLE_TYPE, VEHICLE_ID_NUMBER VEHICLE_ID_NUMBER, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, MAKE MAKE, MODEL MODEL, INITIAL_REGISTRATION INITIAL_REGISTRATION, LAST_REGISTRATION_RENEW_DATE LAST_REGISTRATION_RENEW_DATE, ENGINE_CAPACITY_IN_CC ENGINE_CAPACITY_IN_CC, FUEL_TYPE FUEL_TYPE, 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, FISCAL_RATINGS FISCAL_RATINGS, FISCAL_RATINGS_UOM FISCAL_RATINGS_UOM, VEHICLE_PROVIDER VEHICLE_PROVIDER, VEHICLE_OWNERSHIP VEHICLE_OWNERSHIP, SHARED_VEHICLE SHARED_VEHICLE, VEHICLE_STATUS VEHICLE_STATUS, VEHICLE_INACTIVITY_REASON VEHICLE_INACTIVITY_REASON, ASSET_NUMBER ASSET_NUMBER, LEASE_CONTRACT_NUMBER LEASE_CONTRACT_NUMBER, LEASE_CONTRACT_EXPIRY_DATE LEASE_CONTRACT_EXPIRY_DATE, TAXATION_METHOD TAXATION_METHOD, FLEET_INFO FLEET_INFO, FLEET_TRANSFER_DATE FLEET_TRANSFER_DATE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, VRE_ATTRIBUTE_CATEGORY VRE_ATTRIBUTE_CATEGORY, VRE_ATTRIBUTE1 VRE_ATTRIBUTE1, VRE_ATTRIBUTE2 VRE_ATTRIBUTE2, VRE_ATTRIBUTE3 VRE_ATTRIBUTE3, VRE_ATTRIBUTE4 VRE_ATTRIBUTE4, VRE_ATTRIBUTE5 VRE_ATTRIBUTE5, VRE_ATTRIBUTE6 VRE_ATTRIBUTE6, VRE_ATTRIBUTE7 VRE_ATTRIBUTE7, VRE_ATTRIBUTE8 VRE_ATTRIBUTE8, VRE_ATTRIBUTE9 VRE_ATTRIBUTE9, VRE_ATTRIBUTE10 VRE_ATTRIBUTE10, VRE_ATTRIBUTE11 VRE_ATTRIBUTE11, VRE_ATTRIBUTE12 VRE_ATTRIBUTE12, VRE_ATTRIBUTE13 VRE_ATTRIBUTE13, VRE_ATTRIBUTE14 VRE_ATTRIBUTE14, VRE_ATTRIBUTE15 VRE_ATTRIBUTE15, VRE_ATTRIBUTE16 VRE_ATTRIBUTE16, VRE_ATTRIBUTE17 VRE_ATTRIBUTE17, VRE_ATTRIBUTE18 VRE_ATTRIBUTE18, VRE_ATTRIBUTE19 VRE_ATTRIBUTE19, VRE_ATTRIBUTE20 VRE_ATTRIBUTE20, VRE_INFORMATION_CATEGORY VRE_INFORMATION_CATEGORY, VRE_INFORMATION1 VRE_INFORMATION1, VRE_INFORMATION2 VRE_INFORMATION2, VRE_INFORMATION3 VRE_INFORMATION3, VRE_INFORMATION4 VRE_INFORMATION4, VRE_INFORMATION5 VRE_INFORMATION5, VRE_INFORMATION6 VRE_INFORMATION6, VRE_INFORMATION7 VRE_INFORMATION7, VRE_INFORMATION8 VRE_INFORMATION8, VRE_INFORMATION9 VRE_INFORMATION9, VRE_INFORMATION10 VRE_INFORMATION10, VRE_INFORMATION11 VRE_INFORMATION11, VRE_INFORMATION12 VRE_INFORMATION12, VRE_INFORMATION13 VRE_INFORMATION13, VRE_INFORMATION14 VRE_INFORMATION14, VRE_INFORMATION15 VRE_INFORMATION15, VRE_INFORMATION16 VRE_INFORMATION16, VRE_INFORMATION17 VRE_INFORMATION17, VRE_INFORMATION18 VRE_INFORMATION18, VRE_INFORMATION19 VRE_INFORMATION19, VRE_INFORMATION20 VRE_INFORMATION20, COLOR COLOR, SEATING_CAPACITY SEATING_CAPACITY, WEIGHT WEIGHT, WEIGHT_UOM WEIGHT_UOM, MODEL_YEAR MODEL_YEAR, INSURANCE_NUMBER INSURANCE_NUMBER, INSURANCE_EXPIRY_DATE INSURANCE_EXPIRY_DATE, COMMENTS COMMENTS from "HR"."PQP_VEHICLE_REPOSITORY_F"

View Text - HTML Formatted

SELECT VEHICLE_REPOSITORY_ID VEHICLE_REPOSITORY_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, REGISTRATION_NUMBER REGISTRATION_NUMBER
, VEHICLE_TYPE VEHICLE_TYPE
, VEHICLE_ID_NUMBER VEHICLE_ID_NUMBER
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, MAKE MAKE
, MODEL MODEL
, INITIAL_REGISTRATION INITIAL_REGISTRATION
, LAST_REGISTRATION_RENEW_DATE LAST_REGISTRATION_RENEW_DATE
, ENGINE_CAPACITY_IN_CC ENGINE_CAPACITY_IN_CC
, FUEL_TYPE FUEL_TYPE
, 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
, FISCAL_RATINGS FISCAL_RATINGS
, FISCAL_RATINGS_UOM FISCAL_RATINGS_UOM
, VEHICLE_PROVIDER VEHICLE_PROVIDER
, VEHICLE_OWNERSHIP VEHICLE_OWNERSHIP
, SHARED_VEHICLE SHARED_VEHICLE
, VEHICLE_STATUS VEHICLE_STATUS
, VEHICLE_INACTIVITY_REASON VEHICLE_INACTIVITY_REASON
, ASSET_NUMBER ASSET_NUMBER
, LEASE_CONTRACT_NUMBER LEASE_CONTRACT_NUMBER
, LEASE_CONTRACT_EXPIRY_DATE LEASE_CONTRACT_EXPIRY_DATE
, TAXATION_METHOD TAXATION_METHOD
, FLEET_INFO FLEET_INFO
, FLEET_TRANSFER_DATE FLEET_TRANSFER_DATE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, VRE_ATTRIBUTE_CATEGORY VRE_ATTRIBUTE_CATEGORY
, VRE_ATTRIBUTE1 VRE_ATTRIBUTE1
, VRE_ATTRIBUTE2 VRE_ATTRIBUTE2
, VRE_ATTRIBUTE3 VRE_ATTRIBUTE3
, VRE_ATTRIBUTE4 VRE_ATTRIBUTE4
, VRE_ATTRIBUTE5 VRE_ATTRIBUTE5
, VRE_ATTRIBUTE6 VRE_ATTRIBUTE6
, VRE_ATTRIBUTE7 VRE_ATTRIBUTE7
, VRE_ATTRIBUTE8 VRE_ATTRIBUTE8
, VRE_ATTRIBUTE9 VRE_ATTRIBUTE9
, VRE_ATTRIBUTE10 VRE_ATTRIBUTE10
, VRE_ATTRIBUTE11 VRE_ATTRIBUTE11
, VRE_ATTRIBUTE12 VRE_ATTRIBUTE12
, VRE_ATTRIBUTE13 VRE_ATTRIBUTE13
, VRE_ATTRIBUTE14 VRE_ATTRIBUTE14
, VRE_ATTRIBUTE15 VRE_ATTRIBUTE15
, VRE_ATTRIBUTE16 VRE_ATTRIBUTE16
, VRE_ATTRIBUTE17 VRE_ATTRIBUTE17
, VRE_ATTRIBUTE18 VRE_ATTRIBUTE18
, VRE_ATTRIBUTE19 VRE_ATTRIBUTE19
, VRE_ATTRIBUTE20 VRE_ATTRIBUTE20
, VRE_INFORMATION_CATEGORY VRE_INFORMATION_CATEGORY
, VRE_INFORMATION1 VRE_INFORMATION1
, VRE_INFORMATION2 VRE_INFORMATION2
, VRE_INFORMATION3 VRE_INFORMATION3
, VRE_INFORMATION4 VRE_INFORMATION4
, VRE_INFORMATION5 VRE_INFORMATION5
, VRE_INFORMATION6 VRE_INFORMATION6
, VRE_INFORMATION7 VRE_INFORMATION7
, VRE_INFORMATION8 VRE_INFORMATION8
, VRE_INFORMATION9 VRE_INFORMATION9
, VRE_INFORMATION10 VRE_INFORMATION10
, VRE_INFORMATION11 VRE_INFORMATION11
, VRE_INFORMATION12 VRE_INFORMATION12
, VRE_INFORMATION13 VRE_INFORMATION13
, VRE_INFORMATION14 VRE_INFORMATION14
, VRE_INFORMATION15 VRE_INFORMATION15
, VRE_INFORMATION16 VRE_INFORMATION16
, VRE_INFORMATION17 VRE_INFORMATION17
, VRE_INFORMATION18 VRE_INFORMATION18
, VRE_INFORMATION19 VRE_INFORMATION19
, VRE_INFORMATION20 VRE_INFORMATION20
, COLOR COLOR
, SEATING_CAPACITY SEATING_CAPACITY
, WEIGHT WEIGHT
, WEIGHT_UOM WEIGHT_UOM
, MODEL_YEAR MODEL_YEAR
, INSURANCE_NUMBER INSURANCE_NUMBER
, INSURANCE_EXPIRY_DATE INSURANCE_EXPIRY_DATE
, COMMENTS COMMENTS
FROM "HR"."PQP_VEHICLE_REPOSITORY_F"