[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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. |
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;
HR.PQP_VEHICLE_REPOSITORY_F does not reference any database object
HR.PQP_VEHICLE_REPOSITORY_F is referenced by following:
|
|
|