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

VIEW: APPS.MST_FTE_LANE_VEHICLES_V

Object Details
Object Name: MST_FTE_LANE_VEHICLES_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
LANE_VEHICLE_ID NUMBER
Yes primary key
LANE_GROUP_ID NUMBER

foreign key to FTE_LANE_SETS, either LANE_ID or LANE_SET_ID is populated for any record
LANE_ID NUMBER

foreign key to FTE_LANE_SERVICE_ID
VEHICLE_TYPE_ID NUMBER
Yes foreign key to FTE_VEHICLE_TPYES
QUANTITY NUMBER
Yes Maximum load permited per day/week/month
FREQUENCY_UOM VARCHAR2 (10)
1-day, 2-week, 3-month, 4 year
EFFECTIVE_START_DATE DATE
Yes effective from date
EFFECTIVE_END_DATE DATE

effective to date
CARRIER_ID VARCHAR2 (40)
This column stores the carrier ID
Query Text

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


SELECT LANE_VEHICLE_ID
,      LANE_GROUP_ID
,      LANE_ID
,      VEHICLE_TYPE_ID
,      QUANTITY
,      FREQUENCY_UOM
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      CARRIER_ID
FROM APPS.MST_FTE_LANE_VEHICLES_V;

Dependencies

[top of page]

APPS.MST_FTE_LANE_VEHICLES_V references the following:

SchemaAPPS
SynonymFTE_LANES
SynonymFTE_LANE_GROUPS
SynonymFTE_LANE_VEHICLES

APPS.MST_FTE_LANE_VEHICLES_V is not referenced by any database object