[Home] [Help] [Dependency Information]
Object Name: | MST_FTE_LANE_VEHICLES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
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 |
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;
APPS.MST_FTE_LANE_VEHICLES_V is not referenced by any database object
|
|
|