[Home] [Help] [Dependency Information]
Object Name: | PQP_VEHICLE_DETAILS# |
---|---|
Object Type: | VIEW |
Owner: | HR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
VEHICLE_DETAILS_ID | NUMBER | (10) | Yes | |
VEHICLE_TYPE | VARCHAR2 | (30) | Yes | |
BUSINESS_GROUP_ID | NUMBER | (15) | ||
REGISTRATION_NUMBER | VARCHAR2 | (30) | Yes | |
MAKE | VARCHAR2 | (30) | Yes | |
MODEL | VARCHAR2 | (30) | Yes | |
VEHICLE_IDENTIFICATION_NUMBER | VARCHAR2 | (50) | ||
DATE_FIRST_REGISTERED | DATE | Yes | ||
ENGINE_CAPACITY_IN_CC | NUMBER | Yes | ||
FUEL_TYPE | VARCHAR2 | (30) | Yes | |
FUEL_CARD | VARCHAR2 | (30) | Yes | |
CURRENCY_CODE | VARCHAR2 | (30) | Yes | |
LIST_PRICE | NUMBER | Yes | ||
ACCESSORY_VALUE_AT_STARTDATE | NUMBER | |||
ACCESSORY_VALUE_ADDED_LATER | NUMBER | |||
MARKET_VALUE_CLASSIC_CAR | NUMBER | |||
CO2_EMISSIONS | NUMBER | |||
VEHICLE_PROVIDER | VARCHAR2 | (60) | ||
VEHICLE_OWNERSHIP | VARCHAR2 | (30) | ||
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | (15) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | |
VHD_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
VHD_ATTRIBUTE1 | VARCHAR2 | (150) | ||
VHD_ATTRIBUTE2 | VARCHAR2 | (150) | ||
VHD_ATTRIBUTE3 | VARCHAR2 | (150) | ||
VHD_ATTRIBUTE4 | VARCHAR2 | (150) | ||
VHD_ATTRIBUTE5 | VARCHAR2 | (150) | ||
VHD_ATTRIBUTE6 | VARCHAR2 | (150) | ||
VHD_ATTRIBUTE7 | VARCHAR2 | (150) | ||
VHD_ATTRIBUTE8 | VARCHAR2 | (150) | ||
VHD_ATTRIBUTE9 | VARCHAR2 | (150) | ||
VHD_ATTRIBUTE10 | VARCHAR2 | (150) | ||
VHD_ATTRIBUTE11 | VARCHAR2 | (150) | ||
VHD_ATTRIBUTE12 | VARCHAR2 | (150) | ||
VHD_ATTRIBUTE13 | VARCHAR2 | (150) | ||
VHD_ATTRIBUTE14 | VARCHAR2 | (150) | ||
VHD_ATTRIBUTE15 | VARCHAR2 | (150) | ||
VHD_ATTRIBUTE16 | VARCHAR2 | (150) | ||
VHD_ATTRIBUTE17 | VARCHAR2 | (150) | ||
VHD_ATTRIBUTE18 | VARCHAR2 | (150) | ||
VHD_ATTRIBUTE19 | VARCHAR2 | (150) | ||
VHD_ATTRIBUTE20 | VARCHAR2 | (150) | ||
VHD_INFORMATION_CATEGORY | VARCHAR2 | (30) | ||
VHD_INFORMATION1 | VARCHAR2 | (150) | ||
VHD_INFORMATION2 | VARCHAR2 | (150) | ||
VHD_INFORMATION3 | VARCHAR2 | (150) | ||
VHD_INFORMATION4 | VARCHAR2 | (150) | ||
VHD_INFORMATION5 | VARCHAR2 | (150) | ||
VHD_INFORMATION6 | VARCHAR2 | (150) | ||
VHD_INFORMATION7 | VARCHAR2 | (150) | ||
VHD_INFORMATION8 | VARCHAR2 | (150) | ||
VHD_INFORMATION9 | VARCHAR2 | (150) | ||
VHD_INFORMATION10 | VARCHAR2 | (150) | ||
VHD_INFORMATION11 | VARCHAR2 | (150) | ||
VHD_INFORMATION12 | VARCHAR2 | (150) | ||
VHD_INFORMATION13 | VARCHAR2 | (150) | ||
VHD_INFORMATION14 | VARCHAR2 | (150) | ||
VHD_INFORMATION15 | VARCHAR2 | (150) | ||
VHD_INFORMATION16 | VARCHAR2 | (150) | ||
VHD_INFORMATION17 | VARCHAR2 | (150) | ||
VHD_INFORMATION18 | VARCHAR2 | (150) | ||
VHD_INFORMATION19 | VARCHAR2 | (150) | ||
VHD_INFORMATION20 | VARCHAR2 | (150) |
Cut, paste (and edit) the following text to query this object:
SELECT VEHICLE_DETAILS_ID
, VEHICLE_TYPE
, BUSINESS_GROUP_ID
, REGISTRATION_NUMBER
, MAKE
, MODEL
, VEHICLE_IDENTIFICATION_NUMBER
, DATE_FIRST_REGISTERED
, ENGINE_CAPACITY_IN_CC
, FUEL_TYPE
, FUEL_CARD
, CURRENCY_CODE
, LIST_PRICE
, ACCESSORY_VALUE_AT_STARTDATE
, ACCESSORY_VALUE_ADDED_LATER
, MARKET_VALUE_CLASSIC_CAR
, CO2_EMISSIONS
, VEHICLE_PROVIDER
, VEHICLE_OWNERSHIP
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, VHD_ATTRIBUTE_CATEGORY
, VHD_ATTRIBUTE1
, VHD_ATTRIBUTE2
, VHD_ATTRIBUTE3
, VHD_ATTRIBUTE4
, VHD_ATTRIBUTE5
, VHD_ATTRIBUTE6
, VHD_ATTRIBUTE7
, VHD_ATTRIBUTE8
, VHD_ATTRIBUTE9
, VHD_ATTRIBUTE10
, VHD_ATTRIBUTE11
, VHD_ATTRIBUTE12
, VHD_ATTRIBUTE13
, VHD_ATTRIBUTE14
, VHD_ATTRIBUTE15
, VHD_ATTRIBUTE16
, VHD_ATTRIBUTE17
, VHD_ATTRIBUTE18
, VHD_ATTRIBUTE19
, VHD_ATTRIBUTE20
, VHD_INFORMATION_CATEGORY
, VHD_INFORMATION1
, VHD_INFORMATION2
, VHD_INFORMATION3
, VHD_INFORMATION4
, VHD_INFORMATION5
, VHD_INFORMATION6
, VHD_INFORMATION7
, VHD_INFORMATION8
, VHD_INFORMATION9
, VHD_INFORMATION10
, VHD_INFORMATION11
, VHD_INFORMATION12
, VHD_INFORMATION13
, VHD_INFORMATION14
, VHD_INFORMATION15
, VHD_INFORMATION16
, VHD_INFORMATION17
, VHD_INFORMATION18
, VHD_INFORMATION19
, VHD_INFORMATION20
FROM HR.PQP_VEHICLE_DETAILS#;
|
|
|