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_REPOSITORY_F

Object Details

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

This is a date tracked table used to store the details for all private and company vehicles.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PQP_VEHICLE_REPOSITORY_F_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	VEHICLE_REPOSITORY_ID EFFECTIVE_START_DATE EFFECTIVE_END_DATE
PQP_VEHICLE_REPOSITORY_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REGISTRATION_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
VEHICLE_REPOSITORY_ID	NUMBER	(10)	Yes	System generated primary key column using the sequence PQP_VEHICLE_REPOSITORY_F_S.
EFFECTIVE_START_DATE	DATE		Yes	Effective Start Date for this record.
EFFECTIVE_END_DATE	DATE		Yes	Effective End Date for this record.
REGISTRATION_NUMBER	VARCHAR2	(30)		Registration Number for this vehicle.
VEHICLE_TYPE	VARCHAR2	(30)	Yes	Identifies whether the vehicle is a car, motorcycle etc. The codes are from the lookup type PQP_VEHICLE_TYPE.
VEHICLE_ID_NUMBER	VARCHAR2	(50)		The unique Vehicle identification number, commonly referred to as VIN or Chasis number.
BUSINESS_GROUP_ID	NUMBER	(15)	Yes	The Business Group Identifier to which the vehicle belongs to.
MAKE	VARCHAR2	(30)	Yes	The Make (manufacturer) of the vehicle.
MODEL	VARCHAR2	(30)		The model name of the Vehicle. For example, if the make was 'Honda', then model can be 'Accord'.
INITIAL_REGISTRATION	DATE			The date the vehicle was registred for the first time.
LAST_REGISTRATION_RENEW_DATE	DATE			The most recent date on which the vehicle registration was renewed.
ENGINE_CAPACITY_IN_CC	NUMBER			The Vehicle's engine size in cubic capacity.
FUEL_TYPE	VARCHAR2	(30)		The type of fuel used in the vehicle. The codes are from the lookup type PQP_FUEL_TYPE.
CURRENCY_CODE	VARCHAR2	(30)	Yes	The currency code for all the monetary columns used in this record. The value should be the same as the Business groups currency code and is from the table FND_CURRENCIES.
LIST_PRICE	NUMBER	(11)		The basic list price of the Vehicle.
ACCESSORY_VALUE_AT_STARTDATE	NUMBER	(11)		The value of the accessories in the vehicle at Start Date.
ACCESSORY_VALUE_ADDED_LATER	NUMBER	(11)		The value of the accessories added later to the vehicle.
MARKET_VALUE_CLASSIC_CAR	NUMBER	(11)		The market value of the vehicle if it is a Classic vehicle.
FISCAL_RATINGS	NUMBER			The Fiscal Ratings of the vehicle.
FISCAL_RATINGS_UOM	VARCHAR2	(30)		The Fiscal Ratings Unit of Measure for the vehicle.
VEHICLE_PROVIDER	VARCHAR2	(60)		The name of the vehicle provider.
VEHICLE_OWNERSHIP	VARCHAR2	(30)		Identifies whether it is a company or private vehicle.
SHARED_VEHICLE	VARCHAR2	(30)		Flag to indicate whether the vehicle can be shared (allocated) to multiple employees.
VEHICLE_STATUS	VARCHAR2	(30)	Yes	The status of the vehicle, whether it is active or inactive. The values are from the lookup PQP_VEHICLE_STATUS.
VEHICLE_INACTIVITY_REASON	VARCHAR2	(30)		The reason for vehicle inactivity. Only used if the status is Inactive (I). The value is from the lookup PQP_VEHICLE_INACTIVE_REASONS.
ASSET_NUMBER	VARCHAR2	(80)		The asset number, if any for the vehicle.
LEASE_CONTRACT_NUMBER	VARCHAR2	(80)		Lease contract number for the leased company vehicle.
LEASE_CONTRACT_EXPIRY_DATE	DATE			The date when the lease expires for the company vehicle.
TAXATION_METHOD	VARCHAR2	(80)		Taxation Method used for this vehicle. This value is from the lookup PQP_VEHICLE_TAXATION_METHOD.
FLEET_INFO	VARCHAR2	(120)		Additional information for fleet vehicles.
FLEET_TRANSFER_DATE	DATE			The date the vehicle was transferred, for the fleet vehicle.
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	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.
VRE_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield Column
VRE_ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield Column
VRE_ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield Column
VRE_ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield Column
VRE_ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield Column
VRE_ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield Column
VRE_ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield Column
VRE_ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield Column
VRE_ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield Column
VRE_ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield Column
VRE_ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield Column
VRE_ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield Column
VRE_ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield Column
VRE_ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield Column
VRE_ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield Column
VRE_ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield Column
VRE_ATTRIBUTE16	VARCHAR2	(150)		Descriptive Flexfield Column
VRE_ATTRIBUTE17	VARCHAR2	(150)		Descriptive Flexfield Column
VRE_ATTRIBUTE18	VARCHAR2	(150)		Descriptive Flexfield Column
VRE_ATTRIBUTE19	VARCHAR2	(150)		Descriptive Flexfield Column
VRE_ATTRIBUTE20	VARCHAR2	(150)		Descriptive Flexfield Column
VRE_INFORMATION_CATEGORY	VARCHAR2	(30)		Developer Descriptive Flexfield Column
VRE_INFORMATION1	VARCHAR2	(150)		Developer Descriptive Flexfield Column
VRE_INFORMATION2	VARCHAR2	(150)		Developer Descriptive Flexfield Column
VRE_INFORMATION3	VARCHAR2	(150)		Developer Descriptive Flexfield Column
VRE_INFORMATION4	VARCHAR2	(150)		Developer Descriptive Flexfield Column
VRE_INFORMATION5	VARCHAR2	(150)		Developer Descriptive Flexfield Column
VRE_INFORMATION6	VARCHAR2	(150)		Developer Descriptive Flexfield Column
VRE_INFORMATION7	VARCHAR2	(150)		Developer Descriptive Flexfield Column
VRE_INFORMATION8	VARCHAR2	(150)		Developer Descriptive Flexfield Column
VRE_INFORMATION9	VARCHAR2	(150)		Developer Descriptive Flexfield Column
VRE_INFORMATION10	VARCHAR2	(150)		Developer Descriptive Flexfield Column
VRE_INFORMATION11	VARCHAR2	(150)		Developer Descriptive Flexfield Column
VRE_INFORMATION12	VARCHAR2	(150)		Developer Descriptive Flexfield Column
VRE_INFORMATION13	VARCHAR2	(150)		Developer Descriptive Flexfield Column
VRE_INFORMATION14	VARCHAR2	(150)		Developer Descriptive Flexfield Column
VRE_INFORMATION15	VARCHAR2	(150)		Developer Descriptive Flexfield Column
VRE_INFORMATION16	VARCHAR2	(150)		Developer Descriptive Flexfield Column
VRE_INFORMATION17	VARCHAR2	(150)		Developer Descriptive Flexfield Column
VRE_INFORMATION18	VARCHAR2	(150)		Developer Descriptive Flexfield Column
VRE_INFORMATION19	VARCHAR2	(150)		Developer Descriptive Flexfield Column
VRE_INFORMATION20	VARCHAR2	(150)		Developer Descriptive Flexfield Column
COLOR	VARCHAR2	(30)		The color of the vehicle. The value is from the lookkup PQP_VEHICLE_COLOR.
SEATING_CAPACITY	NUMBER	(15)		The passenger seating capacity for the vehicle.
WEIGHT	NUMBER	(15)		The weight of the vehicle, the unit of measure is stored in weight_uom column.
WEIGHT_UOM	VARCHAR2	(30)		The unit of measure for the weight column. The value is from the lookup PQP_WEIGHT_UOM.
MODEL_YEAR	NUMBER	(9)		The model year for the vehicle.
INSURANCE_NUMBER	VARCHAR2	(80)		The insurance details for the vehicle.
INSURANCE_EXPIRY_DATE	DATE			Insurance expiration date for the vehicle.
COMMENTS	VARCHAR2	(150)		Free text to store any comments.

Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

HR.PQP_VEHICLE_REPOSITORY_F does not reference any database object

HR.PQP_VEHICLE_REPOSITORY_F is referenced by following:

HR: PQP_VEHICLE_REPOSITORY_F#