[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PQP_VEHICLE_REPOSITORY_F# |
|---|---|
| Object Type: | VIEW |
| Owner: | HR |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| VEHICLE_REPOSITORY_ID | NUMBER | (10) | Yes | |
| EFFECTIVE_START_DATE | DATE | Yes | ||
| EFFECTIVE_END_DATE | DATE | Yes | ||
| REGISTRATION_NUMBER | VARCHAR2 | (30) | ||
| VEHICLE_TYPE | VARCHAR2 | (30) | Yes | |
| VEHICLE_ID_NUMBER | VARCHAR2 | (50) | ||
| BUSINESS_GROUP_ID | NUMBER | (15) | Yes | |
| MAKE | VARCHAR2 | (30) | Yes | |
| MODEL | VARCHAR2 | (30) | ||
| INITIAL_REGISTRATION | DATE | |||
| LAST_REGISTRATION_RENEW_DATE | DATE | |||
| ENGINE_CAPACITY_IN_CC | NUMBER | |||
| FUEL_TYPE | VARCHAR2 | (30) | ||
| CURRENCY_CODE | VARCHAR2 | (30) | Yes | |
| LIST_PRICE | NUMBER | (11) | ||
| ACCESSORY_VALUE_AT_STARTDATE | NUMBER | (11) | ||
| ACCESSORY_VALUE_ADDED_LATER | NUMBER | (11) | ||
| MARKET_VALUE_CLASSIC_CAR | NUMBER | (11) | ||
| FISCAL_RATINGS | NUMBER | |||
| FISCAL_RATINGS_UOM | VARCHAR2 | (30) | ||
| VEHICLE_PROVIDER | VARCHAR2 | (60) | ||
| VEHICLE_OWNERSHIP | VARCHAR2 | (30) | ||
| SHARED_VEHICLE | VARCHAR2 | (30) | ||
| VEHICLE_STATUS | VARCHAR2 | (30) | Yes | |
| VEHICLE_INACTIVITY_REASON | VARCHAR2 | (30) | ||
| ASSET_NUMBER | VARCHAR2 | (80) | ||
| LEASE_CONTRACT_NUMBER | VARCHAR2 | (80) | ||
| LEASE_CONTRACT_EXPIRY_DATE | DATE | |||
| TAXATION_METHOD | VARCHAR2 | (80) | ||
| FLEET_INFO | VARCHAR2 | (120) | ||
| FLEET_TRANSFER_DATE | DATE | |||
| CREATED_BY | NUMBER | (15) | Yes | |
| CREATION_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | (15) | Yes | |
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATE_LOGIN | NUMBER | (15) | ||
| OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | |
| VRE_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
| VRE_ATTRIBUTE1 | VARCHAR2 | (150) | ||
| VRE_ATTRIBUTE2 | VARCHAR2 | (150) | ||
| VRE_ATTRIBUTE3 | VARCHAR2 | (150) | ||
| VRE_ATTRIBUTE4 | VARCHAR2 | (150) | ||
| VRE_ATTRIBUTE5 | VARCHAR2 | (150) | ||
| VRE_ATTRIBUTE6 | VARCHAR2 | (150) | ||
| VRE_ATTRIBUTE7 | VARCHAR2 | (150) | ||
| VRE_ATTRIBUTE8 | VARCHAR2 | (150) | ||
| VRE_ATTRIBUTE9 | VARCHAR2 | (150) | ||
| VRE_ATTRIBUTE10 | VARCHAR2 | (150) | ||
| VRE_ATTRIBUTE11 | VARCHAR2 | (150) | ||
| VRE_ATTRIBUTE12 | VARCHAR2 | (150) | ||
| VRE_ATTRIBUTE13 | VARCHAR2 | (150) | ||
| VRE_ATTRIBUTE14 | VARCHAR2 | (150) | ||
| VRE_ATTRIBUTE15 | VARCHAR2 | (150) | ||
| VRE_ATTRIBUTE16 | VARCHAR2 | (150) | ||
| VRE_ATTRIBUTE17 | VARCHAR2 | (150) | ||
| VRE_ATTRIBUTE18 | VARCHAR2 | (150) | ||
| VRE_ATTRIBUTE19 | VARCHAR2 | (150) | ||
| VRE_ATTRIBUTE20 | VARCHAR2 | (150) | ||
| VRE_INFORMATION_CATEGORY | VARCHAR2 | (30) | ||
| VRE_INFORMATION1 | VARCHAR2 | (150) | ||
| VRE_INFORMATION2 | VARCHAR2 | (150) | ||
| VRE_INFORMATION3 | VARCHAR2 | (150) | ||
| VRE_INFORMATION4 | VARCHAR2 | (150) | ||
| VRE_INFORMATION5 | VARCHAR2 | (150) | ||
| VRE_INFORMATION6 | VARCHAR2 | (150) | ||
| VRE_INFORMATION7 | VARCHAR2 | (150) | ||
| VRE_INFORMATION8 | VARCHAR2 | (150) | ||
| VRE_INFORMATION9 | VARCHAR2 | (150) | ||
| VRE_INFORMATION10 | VARCHAR2 | (150) | ||
| VRE_INFORMATION11 | VARCHAR2 | (150) | ||
| VRE_INFORMATION12 | VARCHAR2 | (150) | ||
| VRE_INFORMATION13 | VARCHAR2 | (150) | ||
| VRE_INFORMATION14 | VARCHAR2 | (150) | ||
| VRE_INFORMATION15 | VARCHAR2 | (150) | ||
| VRE_INFORMATION16 | VARCHAR2 | (150) | ||
| VRE_INFORMATION17 | VARCHAR2 | (150) | ||
| VRE_INFORMATION18 | VARCHAR2 | (150) | ||
| VRE_INFORMATION19 | VARCHAR2 | (150) | ||
| VRE_INFORMATION20 | VARCHAR2 | (150) | ||
| COLOR | VARCHAR2 | (30) | ||
| SEATING_CAPACITY | NUMBER | (15) | ||
| WEIGHT | NUMBER | (15) | ||
| WEIGHT_UOM | VARCHAR2 | (30) | ||
| MODEL_YEAR | NUMBER | (9) | ||
| INSURANCE_NUMBER | VARCHAR2 | (80) | ||
| INSURANCE_EXPIRY_DATE | DATE | |||
| COMMENTS | VARCHAR2 | (150) |
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
APPS
PQP_VEHICLE_REPOSITORY_F
PQP_VEHICLE_REPOSITORY_F_WHO
|
|
|
|