eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: FTE.FTE_LANE_VEHICLES

Object Details

Object Name:	FTE_LANE_VEHICLES
Object Type:	TABLE
Owner:	FTE
FND Design Data:	FTE.FTE_LANE_VEHICLES
Subobject Name:
Status:	VALID

Stores the Vehicle associated to Lanes and Lane Groups

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FTE_LANE_VEHICLES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	LANE_VEHICLE_ID
FTE_LANE_VEHICLES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LANE_ID
FTE_LANE_VEHICLES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LANE_GROUP_ID
FTE_LANE_VEHICLES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORIGIN_ID DESTINATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
LANE_VEHICLE_ID	NUMBER		Yes	Primary Key of the Lane Vehicles
LANE_ID	NUMBER			Stores Associated Lane
LANE_GROUP_ID	NUMBER			Stores Associated Lane Group
VEHICLE_TYPE_ID	NUMBER		Yes	Stores the Vehicle
QUANTITY	NUMBER		Yes	Stores Quantity
FREQUENCY_UOM	VARCHAR2	(10)		Frequency UOM
EFFECTIVE_START_DATE	DATE		Yes	Stores effective start date
EFFECTIVE_END_DATE	DATE			Stores Effective end Date
ORIGIN_ID	NUMBER			ORIGIN_ID of LANE : added for query performance
DESTINATION_ID	NUMBER			DESTINATION_ID of LANE : added for query performance
CARRIER_ID	NUMBER			CARRIER_ID of LANE : added for query performance
MODE_OF_TRANSPORT_CODE	VARCHAR2	(30)		MODE_OF_TRANSPORT_CODE of LANE : added for query performance
CREATION_DATE	DATE			Standard WHO Column
CREATED_BY	NUMBER			Standard WHO Column
LAST_UPDATE_DATE	DATE			Standard WHO Column
LAST_UPDATED_BY	NUMBER			Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER			Standard WHO Column

Query Text

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


SELECT LANE_VEHICLE_ID
,      LANE_ID
,      LANE_GROUP_ID
,      VEHICLE_TYPE_ID
,      QUANTITY
,      FREQUENCY_UOM
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      ORIGIN_ID
,      DESTINATION_ID
,      CARRIER_ID
,      MODE_OF_TRANSPORT_CODE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM FTE.FTE_LANE_VEHICLES;

Dependencies

[top of page]

FTE.FTE_LANE_VEHICLES does not reference any database object

FTE.FTE_LANE_VEHICLES is referenced by following:

FTE: FTE_LANE_VEHICLES#