VIEW: HR.PQP_VEHICLE_ALLOCATIONS_F#

Source

View Text - Preformatted

select VEHICLE_ALLOCATION_ID VEHICLE_ALLOCATION_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, ASSIGNMENT_ID ASSIGNMENT_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, ACROSS_ASSIGNMENTS ACROSS_ASSIGNMENTS, VEHICLE_REPOSITORY_ID VEHICLE_REPOSITORY_ID, USAGE_TYPE USAGE_TYPE, CAPITAL_CONTRIBUTION CAPITAL_CONTRIBUTION, PRIVATE_CONTRIBUTION PRIVATE_CONTRIBUTION, DEFAULT_VEHICLE DEFAULT_VEHICLE, FUEL_CARD FUEL_CARD, FUEL_CARD_NUMBER FUEL_CARD_NUMBER, FUEL_BENEFIT FUEL_BENEFIT, CALCULATION_METHOD CALCULATION_METHOD, RATES_TABLE_ID RATES_TABLE_ID, ELEMENT_TYPE_ID ELEMENT_TYPE_ID, VAL_ATTRIBUTE_CATEGORY VAL_ATTRIBUTE_CATEGORY, VAL_ATTRIBUTE1 VAL_ATTRIBUTE1, VAL_ATTRIBUTE2 VAL_ATTRIBUTE2, VAL_ATTRIBUTE3 VAL_ATTRIBUTE3, VAL_ATTRIBUTE4 VAL_ATTRIBUTE4, VAL_ATTRIBUTE5 VAL_ATTRIBUTE5, VAL_ATTRIBUTE6 VAL_ATTRIBUTE6, VAL_ATTRIBUTE7 VAL_ATTRIBUTE7, VAL_ATTRIBUTE8 VAL_ATTRIBUTE8, VAL_ATTRIBUTE9 VAL_ATTRIBUTE9, VAL_ATTRIBUTE10 VAL_ATTRIBUTE10, VAL_ATTRIBUTE11 VAL_ATTRIBUTE11, VAL_ATTRIBUTE12 VAL_ATTRIBUTE12, VAL_ATTRIBUTE13 VAL_ATTRIBUTE13, VAL_ATTRIBUTE14 VAL_ATTRIBUTE14, VAL_ATTRIBUTE15 VAL_ATTRIBUTE15, VAL_ATTRIBUTE16 VAL_ATTRIBUTE16, VAL_ATTRIBUTE17 VAL_ATTRIBUTE17, VAL_ATTRIBUTE18 VAL_ATTRIBUTE18, VAL_ATTRIBUTE19 VAL_ATTRIBUTE19, VAL_ATTRIBUTE20 VAL_ATTRIBUTE20, VAL_INFORMATION_CATEGORY VAL_INFORMATION_CATEGORY, VAL_INFORMATION1 VAL_INFORMATION1, VAL_INFORMATION2 VAL_INFORMATION2, VAL_INFORMATION3 VAL_INFORMATION3, VAL_INFORMATION4 VAL_INFORMATION4, VAL_INFORMATION5 VAL_INFORMATION5, VAL_INFORMATION6 VAL_INFORMATION6, VAL_INFORMATION7 VAL_INFORMATION7, VAL_INFORMATION8 VAL_INFORMATION8, VAL_INFORMATION9 VAL_INFORMATION9, VAL_INFORMATION10 VAL_INFORMATION10, VAL_INFORMATION11 VAL_INFORMATION11, VAL_INFORMATION12 VAL_INFORMATION12, VAL_INFORMATION13 VAL_INFORMATION13, VAL_INFORMATION14 VAL_INFORMATION14, VAL_INFORMATION15 VAL_INFORMATION15, VAL_INFORMATION16 VAL_INFORMATION16, VAL_INFORMATION17 VAL_INFORMATION17, VAL_INFORMATION18 VAL_INFORMATION18, VAL_INFORMATION19 VAL_INFORMATION19, VAL_INFORMATION20 VAL_INFORMATION20, 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, INSURANCE_NUMBER INSURANCE_NUMBER, INSURANCE_EXPIRY_DATE INSURANCE_EXPIRY_DATE, PRIVATE_USE_FLAG PRIVATE_USE_FLAG, SLIDING_RATES_INFO SLIDING_RATES_INFO from "HR"."PQP_VEHICLE_ALLOCATIONS_F"

View Text - HTML Formatted

SELECT VEHICLE_ALLOCATION_ID VEHICLE_ALLOCATION_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, ASSIGNMENT_ID ASSIGNMENT_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, ACROSS_ASSIGNMENTS ACROSS_ASSIGNMENTS
, VEHICLE_REPOSITORY_ID VEHICLE_REPOSITORY_ID
, USAGE_TYPE USAGE_TYPE
, CAPITAL_CONTRIBUTION CAPITAL_CONTRIBUTION
, PRIVATE_CONTRIBUTION PRIVATE_CONTRIBUTION
, DEFAULT_VEHICLE DEFAULT_VEHICLE
, FUEL_CARD FUEL_CARD
, FUEL_CARD_NUMBER FUEL_CARD_NUMBER
, FUEL_BENEFIT FUEL_BENEFIT
, CALCULATION_METHOD CALCULATION_METHOD
, RATES_TABLE_ID RATES_TABLE_ID
, ELEMENT_TYPE_ID ELEMENT_TYPE_ID
, VAL_ATTRIBUTE_CATEGORY VAL_ATTRIBUTE_CATEGORY
, VAL_ATTRIBUTE1 VAL_ATTRIBUTE1
, VAL_ATTRIBUTE2 VAL_ATTRIBUTE2
, VAL_ATTRIBUTE3 VAL_ATTRIBUTE3
, VAL_ATTRIBUTE4 VAL_ATTRIBUTE4
, VAL_ATTRIBUTE5 VAL_ATTRIBUTE5
, VAL_ATTRIBUTE6 VAL_ATTRIBUTE6
, VAL_ATTRIBUTE7 VAL_ATTRIBUTE7
, VAL_ATTRIBUTE8 VAL_ATTRIBUTE8
, VAL_ATTRIBUTE9 VAL_ATTRIBUTE9
, VAL_ATTRIBUTE10 VAL_ATTRIBUTE10
, VAL_ATTRIBUTE11 VAL_ATTRIBUTE11
, VAL_ATTRIBUTE12 VAL_ATTRIBUTE12
, VAL_ATTRIBUTE13 VAL_ATTRIBUTE13
, VAL_ATTRIBUTE14 VAL_ATTRIBUTE14
, VAL_ATTRIBUTE15 VAL_ATTRIBUTE15
, VAL_ATTRIBUTE16 VAL_ATTRIBUTE16
, VAL_ATTRIBUTE17 VAL_ATTRIBUTE17
, VAL_ATTRIBUTE18 VAL_ATTRIBUTE18
, VAL_ATTRIBUTE19 VAL_ATTRIBUTE19
, VAL_ATTRIBUTE20 VAL_ATTRIBUTE20
, VAL_INFORMATION_CATEGORY VAL_INFORMATION_CATEGORY
, VAL_INFORMATION1 VAL_INFORMATION1
, VAL_INFORMATION2 VAL_INFORMATION2
, VAL_INFORMATION3 VAL_INFORMATION3
, VAL_INFORMATION4 VAL_INFORMATION4
, VAL_INFORMATION5 VAL_INFORMATION5
, VAL_INFORMATION6 VAL_INFORMATION6
, VAL_INFORMATION7 VAL_INFORMATION7
, VAL_INFORMATION8 VAL_INFORMATION8
, VAL_INFORMATION9 VAL_INFORMATION9
, VAL_INFORMATION10 VAL_INFORMATION10
, VAL_INFORMATION11 VAL_INFORMATION11
, VAL_INFORMATION12 VAL_INFORMATION12
, VAL_INFORMATION13 VAL_INFORMATION13
, VAL_INFORMATION14 VAL_INFORMATION14
, VAL_INFORMATION15 VAL_INFORMATION15
, VAL_INFORMATION16 VAL_INFORMATION16
, VAL_INFORMATION17 VAL_INFORMATION17
, VAL_INFORMATION18 VAL_INFORMATION18
, VAL_INFORMATION19 VAL_INFORMATION19
, VAL_INFORMATION20 VAL_INFORMATION20
, 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
, INSURANCE_NUMBER INSURANCE_NUMBER
, INSURANCE_EXPIRY_DATE INSURANCE_EXPIRY_DATE
, PRIVATE_USE_FLAG PRIVATE_USE_FLAG
, SLIDING_RATES_INFO SLIDING_RATES_INFO
FROM "HR"."PQP_VEHICLE_ALLOCATIONS_F"