[Home] [Help] [Dependency Information]
Object Name: | PQP_VEHICLE_ALLOCATIONS_F |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PQP.PQP_VEHICLE_ALLOCATIONS_F |
Subobject Name: | |
Status: | VALID |
This datetracked table is used to store the vehicle allocation details for an assignment. Along with the vehicle repository id, it also holds details like vehicle usage type, rate table and element information for payroll.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PQP_VEHICLE_ALLOCATIONS_F_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ASSIGNMENT_ID
VEHICLE_REPOSITORY_ID BUSINESS_GROUP_ID |
PQP_VEHICLE_ALLOCATIONS_F_PK | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
VEHICLE_ALLOCATION_ID
EFFECTIVE_START_DATE EFFECTIVE_END_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
VEHICLE_ALLOCATION_ID | NUMBER | (10) | Yes | System generated primary key column from the sequence PQP_VEHICLE_ALLOCATIONS_F_S. |
EFFECTIVE_START_DATE | DATE | Yes | Effective Start Date for this record. | |
EFFECTIVE_END_DATE | DATE | Yes | Effective end date for this record. | |
ASSIGNMENT_ID | NUMBER | (10) | Yes | The Assignment Id of the person having this vehicle allocation. |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Business Group Identifier |
ACROSS_ASSIGNMENTS | VARCHAR2 | (30) | Identifies whether the vehicle allocation is across assignments if there are multiple assignments for this employee. | |
VEHICLE_REPOSITORY_ID | NUMBER | (10) | The vehicle which is being allocated to this assignment. The id is from PQP_VEHICLE_REPOSITORY_F table. | |
USAGE_TYPE | VARCHAR2 | (30) | The usage type for this allocation. This value depends on the type of vehicle being allocated and is from the lookups PQP_COMPANY_VEHICLE_USER or PQP_PRIVATE_VEHICLE_USER. | |
CAPITAL_CONTRIBUTION | NUMBER | (11) | The Capital Contribution from the employee towards this vehicle. | |
PRIVATE_CONTRIBUTION | NUMBER | (11) | The private contribution from the em.ployee towards this vehicle. | |
DEFAULT_VEHICLE | VARCHAR2 | (1) | Identifies whether this vehicle should be treated as the default vehicle for mileage claims when more than one vehicle is allocated. | |
FUEL_CARD | VARCHAR2 | (30) | Identifies whether a fuel card has been given for this allocation. | |
FUEL_CARD_NUMBER | VARCHAR2 | (30) | The Fuel card number if fuel card has been given | |
FUEL_BENEFIT | VARCHAR2 | (30) | Identifies whether there is any additional fuel benefit for this allocation. | |
CALCULATION_METHOD | VARCHAR2 | (80) | The calculation method used for mileage calculation. The value is from the lookup PQP_VEHICLE_CALC_METHOD. | |
RATES_TABLE_ID | NUMBER | (10) | The rates table Identifier if the mileage rates should be based on a particular user defined table. | |
ELEMENT_TYPE_ID | NUMBER | (10) | The Element Type Id if a particular element should be used for mileage calculations. | |
VAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Column | |
VAL_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
VAL_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
VAL_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
VAL_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
VAL_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
VAL_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
VAL_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
VAL_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
VAL_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
VAL_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
VAL_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
VAL_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
VAL_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
VAL_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
VAL_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
VAL_ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
VAL_ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
VAL_ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
VAL_ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
VAL_ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
VAL_INFORMATION_CATEGORY | VARCHAR2 | (30) | Developer Descriptive Flexfield Column | |
VAL_INFORMATION1 | VARCHAR2 | (150) | Developer Descriptive Flexfield Column | |
VAL_INFORMATION2 | VARCHAR2 | (150) | Developer Descriptive Flexfield Column | |
VAL_INFORMATION3 | VARCHAR2 | (150) | Developer Descriptive Flexfield Column | |
VAL_INFORMATION4 | VARCHAR2 | (150) | Developer Descriptive Flexfield Column | |
VAL_INFORMATION5 | VARCHAR2 | (150) | Developer Descriptive Flexfield Column | |
VAL_INFORMATION6 | VARCHAR2 | (150) | Developer Descriptive Flexfield Column | |
VAL_INFORMATION7 | VARCHAR2 | (150) | Developer Descriptive Flexfield Column | |
VAL_INFORMATION8 | VARCHAR2 | (150) | Developer Descriptive Flexfield Column | |
VAL_INFORMATION9 | VARCHAR2 | (150) | Developer Descriptive Flexfield Column | |
VAL_INFORMATION10 | VARCHAR2 | (150) | Developer Descriptive Flexfield Column | |
VAL_INFORMATION11 | VARCHAR2 | (150) | Developer Descriptive Flexfield Column | |
VAL_INFORMATION12 | VARCHAR2 | (150) | Developer Descriptive Flexfield Column | |
VAL_INFORMATION13 | VARCHAR2 | (150) | Developer Descriptive Flexfield Column | |
VAL_INFORMATION14 | VARCHAR2 | (150) | Developer Descriptive Flexfield Column | |
VAL_INFORMATION15 | VARCHAR2 | (150) | Developer Descriptive Flexfield Column | |
VAL_INFORMATION16 | VARCHAR2 | (150) | Developer Descriptive Flexfield Column | |
VAL_INFORMATION17 | VARCHAR2 | (150) | Developer Descriptive Flexfield Column | |
VAL_INFORMATION18 | VARCHAR2 | (150) | Developer Descriptive Flexfield Column | |
VAL_INFORMATION19 | VARCHAR2 | (150) | Developer Descriptive Flexfield Column | |
VAL_INFORMATION20 | VARCHAR2 | (150) | Developer Descriptive Flexfield Column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
CREATION_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | 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. |
INSURANCE_NUMBER | VARCHAR2 | (80) | The insurance details for the vehicle. | |
INSURANCE_EXPIRY_DATE | DATE | Insurance expiration date. | ||
PRIVATE_USE_FLAG | VARCHAR2 | (30) | Indicates whether the company vehicle user can use this vehicle for private purposes. | |
SLIDING_RATES_INFO | VARCHAR2 | (150) | The Sliding rates table information using the lookup PQP_SLIDING_RATES. |
Cut, paste (and edit) the following text to query this object:
SELECT VEHICLE_ALLOCATION_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, ASSIGNMENT_ID
, BUSINESS_GROUP_ID
, ACROSS_ASSIGNMENTS
, VEHICLE_REPOSITORY_ID
, USAGE_TYPE
, CAPITAL_CONTRIBUTION
, PRIVATE_CONTRIBUTION
, DEFAULT_VEHICLE
, FUEL_CARD
, FUEL_CARD_NUMBER
, FUEL_BENEFIT
, CALCULATION_METHOD
, RATES_TABLE_ID
, ELEMENT_TYPE_ID
, VAL_ATTRIBUTE_CATEGORY
, VAL_ATTRIBUTE1
, VAL_ATTRIBUTE2
, VAL_ATTRIBUTE3
, VAL_ATTRIBUTE4
, VAL_ATTRIBUTE5
, VAL_ATTRIBUTE6
, VAL_ATTRIBUTE7
, VAL_ATTRIBUTE8
, VAL_ATTRIBUTE9
, VAL_ATTRIBUTE10
, VAL_ATTRIBUTE11
, VAL_ATTRIBUTE12
, VAL_ATTRIBUTE13
, VAL_ATTRIBUTE14
, VAL_ATTRIBUTE15
, VAL_ATTRIBUTE16
, VAL_ATTRIBUTE17
, VAL_ATTRIBUTE18
, VAL_ATTRIBUTE19
, VAL_ATTRIBUTE20
, VAL_INFORMATION_CATEGORY
, VAL_INFORMATION1
, VAL_INFORMATION2
, VAL_INFORMATION3
, VAL_INFORMATION4
, VAL_INFORMATION5
, VAL_INFORMATION6
, VAL_INFORMATION7
, VAL_INFORMATION8
, VAL_INFORMATION9
, VAL_INFORMATION10
, VAL_INFORMATION11
, VAL_INFORMATION12
, VAL_INFORMATION13
, VAL_INFORMATION14
, VAL_INFORMATION15
, VAL_INFORMATION16
, VAL_INFORMATION17
, VAL_INFORMATION18
, VAL_INFORMATION19
, VAL_INFORMATION20
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, INSURANCE_NUMBER
, INSURANCE_EXPIRY_DATE
, PRIVATE_USE_FLAG
, SLIDING_RATES_INFO
FROM HR.PQP_VEHICLE_ALLOCATIONS_F;
HR.PQP_VEHICLE_ALLOCATIONS_F does not reference any database object
HR.PQP_VEHICLE_ALLOCATIONS_F is referenced by following:
|
|
|