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

TABLE: HR.PQP_VEHICLE_DETAILS_EFC

Object Details
Object Name: PQP_VEHICLE_DETAILS_EFC
Object Type: TABLE
Owner: HR
FND Design Data: TablePQP.PQP_VEHICLE_DETAILS_EFC
Subobject Name:
Status: VALID


Table used for the EFC conversion of the PQP_VEHICLE_DETAILS.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PQP_VEHICLE_DETAILS_EFC_PK NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnVEHICLE_DETAILS_ID
ColumnEFC_ACTION_ID
Columns
Name Datatype Length Mandatory Comments
VEHICLE_DETAILS_ID NUMBER (10) Yes Foreign key colum for the table PQP_VEHICLE_DETAILS (vehicle_details_id).
CURRENCY_CODE VARCHAR2 (30) Yes Currency code to identify the conversion.
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

Market value of the classic car.
EFC_ACTION_ID NUMBER
Yes System generated primary key column
Query Text

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


SELECT VEHICLE_DETAILS_ID
,      CURRENCY_CODE
,      LIST_PRICE
,      ACCESSORY_VALUE_AT_STARTDATE
,      ACCESSORY_VALUE_ADDED_LATER
,      MARKET_VALUE_CLASSIC_CAR
,      EFC_ACTION_ID
FROM HR.PQP_VEHICLE_DETAILS_EFC;

Dependencies

[top of page]

HR.PQP_VEHICLE_DETAILS_EFC does not reference any database object

HR.PQP_VEHICLE_DETAILS_EFC is referenced by following:

SchemaAPPS
SynonymPQP_VEHICLE_DETAILS_EFC
SchemaPUBLIC
SynonymPQP_VEHICLE_DETAILS_EFC