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

TABLE: FTE.FTE_VEHICLE_FEATURES

Object Details
Object Name: FTE_VEHICLE_FEATURES
Object Type: TABLE
Owner: FTE
FND Design Data: TableFTE.FTE_VEHICLE_FEATURES
Subobject Name:
Status: VALID


stores additional vehicle features of the Vehicle Type. One Vehicle Type can have more than one rows.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FTE_VEHICLE_FEATURES_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnVEHICLE_TYPE_FEATURE_ID
FTE_VEHICLE_FEATURES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnVEHICLE_TYPE_ID
Columns
Name Datatype Length Mandatory Comments
VEHICLE_TYPE_FEATURE_ID NUMBER
Yes Primary key of the table created from the sequence FTE_VEHICLE_FEATURES_S
VEHICLE_TYPE_ID NUMBER
Yes Vehicle Type Id - foreign key to FTE_VEHICLE_TYPES
VEHICLE_FEATURE_CODE VARCHAR2 (30) Yes Lookup Code of the Vehicle Feature
CREATION_DATE DATE
Yes Creation Date
CREATED_BY NUMBER
Yes User Id who created the vehicle feature
LAST_UPDATE_DATE DATE
Yes Last Update Date
LAST_UPDATED_BY NUMBER
Yes User Id who updated the vehicle feature
LAST_UPDATE_LOGIN NUMBER

Login Id who updated the vehicle feature
Query Text

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


SELECT VEHICLE_TYPE_FEATURE_ID
,      VEHICLE_TYPE_ID
,      VEHICLE_FEATURE_CODE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM FTE.FTE_VEHICLE_FEATURES;

Dependencies

[top of page]

FTE.FTE_VEHICLE_FEATURES does not reference any database object

FTE.FTE_VEHICLE_FEATURES is referenced by following:

SchemaAPPS
SynonymFTE_VEHICLE_FEATURES