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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: HR.PQP_VEHICLE_DETAILS

Object Details

Object Name:	PQP_VEHICLE_DETAILS
Object Type:	TABLE
Owner:	HR
FND Design Data:	PQP.PQP_VEHICLE_DETAILS
Subobject Name:
Status:	VALID

Table to store details about vehicles used by employees. This table is no longer in use and has been superseded by the datetracked table PQP_VEHICLE_REPOSITORY_F.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PQP_VEHICLE_DETAILS_PK

VEHICLE_DETAILS_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PQP_VEHICLE_DETAILS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	VEHICLE_DETAILS_ID

Columns

Name	Datatype	Length	Mandatory	Comments
VEHICLE_DETAILS_ID	NUMBER	(10)	Yes	System generated primary key column
VEHICLE_TYPE	VARCHAR2	(30)	Yes	Identifies the vehicle type
BUSINESS_GROUP_ID	NUMBER	(15)		Foreign Key to HR_ORGANIZATION_UNITS
REGISTRATION_NUMBER	VARCHAR2	(30)	Yes	The registraction number of the vehicle.
MAKE	VARCHAR2	(30)	Yes	The make of the vehicle
MODEL	VARCHAR2	(30)	Yes	Idetifies the vehicle model
VEHICLE_IDENTIFICATION_NUMBER	VARCHAR2	(50)		The unique identification number for the vehicle.
DATE_FIRST_REGISTERED	DATE		Yes	Date the vehicle was registered for the first time.
ENGINE_CAPACITY_IN_CC	NUMBER		Yes	Vehicle's engine size in cubic capacity.
FUEL_TYPE	VARCHAR2	(30)	Yes	Vehicle's fuel type
FUEL_CARD	VARCHAR2	(30)	Yes	Fuel card for the vehicle.
CURRENCY_CODE	VARCHAR2	(30)	Yes	Identifies the currency code for all the monetary columns in this table.
LIST_PRICE	NUMBER		Yes	The list price of the vehicle.
ACCESSORY_VALUE_AT_STARTDATE	NUMBER			Price of optional accessories fitted when the vehicle was first made available to the employee.
ACCESSORY_VALUE_ADDED_LATER	NUMBER			Price of optional accessories fitted after the vehicle was first made available to the employee.
MARKET_VALUE_CLASSIC_CAR	NUMBER			The market value for the classic car.
CO2_EMISSIONS	NUMBER			CO2 emissions in grams per kilometer.
VEHICLE_PROVIDER	VARCHAR2	(60)		The name of the vehicle provider.
VEHICLE_OWNERSHIP	VARCHAR2	(30)		The ownerships of the vehicle.
CREATED_BY	NUMBER	(15)	Yes	Standard WHO column
CREATION_DATE	DATE		Yes	Standard WHO column
LAST_UPDATE_DATE	DATE			Standard WHO column
LAST_UPDATED_BY	NUMBER	(15)		Standard WHO column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO column
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	System generated version of row. Increments by one with each update.
VHD_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Developer descriptive flexfield column
VHD_ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield column
VHD_ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield column
VHD_ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield column
VHD_ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield column
VHD_ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield column
VHD_ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield column
VHD_ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield column
VHD_ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield column
VHD_ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield column
VHD_ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield column
VHD_ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield column
VHD_ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield column
VHD_ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield column
VHD_ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield column
VHD_ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield column
VHD_ATTRIBUTE16	VARCHAR2	(150)		Descriptive flexfield column
VHD_ATTRIBUTE17	VARCHAR2	(150)		Descriptive flexfield column
VHD_ATTRIBUTE18	VARCHAR2	(150)		Descriptive flexfield column
VHD_ATTRIBUTE19	VARCHAR2	(150)		Descriptive flexfield column
VHD_ATTRIBUTE20	VARCHAR2	(150)		Descriptive flexfield column
VHD_INFORMATION_CATEGORY	VARCHAR2	(30)		Developer descriptive flexfield column
VHD_INFORMATION1	VARCHAR2	(150)		Developer descriptive flexfield column
VHD_INFORMATION2	VARCHAR2	(150)		Developer descriptive flexfield column
VHD_INFORMATION3	VARCHAR2	(150)		Developer descriptive flexfield column
VHD_INFORMATION4	VARCHAR2	(150)		Developer descriptive flexfield column
VHD_INFORMATION5	VARCHAR2	(150)		Developer descriptive flexfield column
VHD_INFORMATION6	VARCHAR2	(150)		Developer descriptive flexfield column
VHD_INFORMATION7	VARCHAR2	(150)		Developer descriptive flexfield column
VHD_INFORMATION8	VARCHAR2	(150)		Developer descriptive flexfield column
VHD_INFORMATION9	VARCHAR2	(150)		Developer descriptive flexfield column
VHD_INFORMATION10	VARCHAR2	(150)		Developer descriptive flexfield column
VHD_INFORMATION11	VARCHAR2	(150)		Developer descriptive flexfield column
VHD_INFORMATION12	VARCHAR2	(150)		Developer descriptive flexfield column
VHD_INFORMATION13	VARCHAR2	(150)		Developer descriptive flexfield column
VHD_INFORMATION14	VARCHAR2	(150)		Developer descriptive flexfield column
VHD_INFORMATION15	VARCHAR2	(150)		Developer descriptive flexfield column
VHD_INFORMATION16	VARCHAR2	(150)		Developer descriptive flexfield column
VHD_INFORMATION17	VARCHAR2	(150)		Developer descriptive flexfield column
VHD_INFORMATION18	VARCHAR2	(150)		Developer descriptive flexfield column
VHD_INFORMATION19	VARCHAR2	(150)		Developer descriptive flexfield column
VHD_INFORMATION20	VARCHAR2	(150)		Developer descriptive flexfield column

Query Text

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;

Dependencies

[top of page]

HR.PQP_VEHICLE_DETAILS does not reference any database object

HR.PQP_VEHICLE_DETAILS is referenced by following:

APPS: PQP_VEHICLE_DETAILS; PQP_VEHICLE_DETAILS_WHO
PUBLIC: PQP_VEHICLE_DETAILS