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]

VIEW: APPS.MST_TL_SUMMARY_V

Object Details

Object Name:	MST_TL_SUMMARY_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
PLAN_ID	NUMBER		Yes	Identifier for plan to which record belong
COMPILE_DESIGNATOR	VARCHAR2	(10)	Yes	Plan name
DESCRIPTION	VARCHAR2	(50)		Plan description
TRIP_ID	NUMBER		Yes	Id of current trip
CARRIER_ID	NUMBER			Id of vendor providing (trip) service
MODE_OF_TRANSPORT	VARCHAR2	(30)		Mode of transport provided by vendor (carrier) for this trip as in mst_trips.mode_of_transport. It is not translated string
TRIP_NUMBER	NUMBER			Trip number of this trip
ROW_ID1	ROWID	(10)		rowid of mst_trip_stops of stop corresponding to the first stop of this trip leg
ROW_ID2	ROWID	(10)		rowid of mst_trip_stops of stop corresponding to the next stop of this trip leg
STOP_ID1	NUMBER		Yes	stop corresponding to the first stop of this trip leg
STOP_ID2	NUMBER		Yes	stop corresponding to the next stop of this trip leg
STOP_SEQUENCE_NUMBER	NUMBER		Yes	stop sequence number of stop of first stop of thsi trip leg
LEG	NUMBER			Leg number of this this trip
CARRIER_NAME	VARCHAR2	(30)	Yes	Name of vendor providing (trip) service
SERVICE_LEVEL	VARCHAR2	(30)		Service provided by vendor (carrier) for this trip as in mst_trips. It is not translated string
SERVICE_LEVEL_TL	VARCHAR2	(80)	Yes	Service provided by vendor (carrier) for this trip. It is translated string derived from wsh_lookups for lookup_type = 'WSH_SERVICE_LEVEL'
VEHICLE_TYPE	VARCHAR2	(40)		Type fo vehicle like TATA407, 53ft Trailer. It is not specific vehicle with certain number plate
DISTANCE_TO_NEXT_STOP	NUMBER			Distance between two stops of this trip leg
DISTANCE_UOM	VARCHAR2	(3)		Distance UOM as considered in plan
DISTANCE_COST	NUMBER			Distance cost of this trip leg
CURRENCY_UOM	VARCHAR2	(3)		Currency as considered in the plan
STOP_LOCATION_ID1	NUMBER		Yes	location_id (wsh_locations.wsh_location_id) of first stop of this trip leg
STOP_LOCATION_ID2	NUMBER		Yes	location_id (wsh_locations.wsh_location_id) of next stop of this trip leg
ORIGIN_COMPANY	VARCHAR2	(80)		Owner company name of first facility (stop) of this trip leg
ORIGIN_FACILITY	VARCHAR2	(60)	Yes	Name of first facility (stop) of this trip leg
ORIGIN_FACILITY_DESC	VARCHAR2	(250)		Description of first facility (stop) of this trip leg
ORIGIN_CITY	VARCHAR2	(120)		City of first facility (stop) of this trip leg
ORIGIN_STATE	VARCHAR2	(120)		State of first facility (stop) of this trip leg
ORIGIN_ZIP	VARCHAR2	(60)		Zip of first facility (stop) of this trip leg
ORIGIN_COUNTRY	VARCHAR2	(120)		Country of first facility (stop) of this trip leg
DESTINATION_COMPANY	VARCHAR2	(80)		Owner company name of next facility (stop) of this trip leg
DESTINATION_FACILITY	VARCHAR2	(60)	Yes	Name of next facility (stop) of this trip leg
DESTINATION_FACILITY_DESC	VARCHAR2	(250)		Description of next facility (stop) of this trip leg
DESTINATION_CITY	VARCHAR2	(120)		City of next facility (stop) of this trip leg
DESTINATION_STATE	VARCHAR2	(120)		State of next facility (stop) of this trip leg
DESTINATION_ZIP	VARCHAR2	(60)		Zip of next facility (stop) of this trip leg
DESTINATION_COUNTRY	VARCHAR2	(120)		Country of next facility (stop) of this trip leg
DEPARTURE_GROSS_WEIGHT	NUMBER			Gross weight boarded on trip in this trip leg
DEPARTURE_VOLUME	NUMBER			Volume boarded on trip in this trip leg
DEPARTURE_PALLETS	NUMBER			Pallets boarded on trip in this trip leg
DEPARTURE_PIECES	NUMBER			Pieces boarded on trip in this trip leg
DEPARTURE_ORDERS	NUMBER			Orders boarded on trip in this trip leg
MAX_WEIGHT	NUMBER			Maximum weight which can be boarded on this trip leg
MAX_VOLUME	NUMBER			Maximum volume which can be boarded on this trip leg
MAX_PALLETS	NUMBER			Maximum pallets which can be boarded on this trip leg
WEIGHT_UOM	VARCHAR2	(3)		Unit of measurement of weight as considered for entire plan as in mst_plans
VOLUME_UOM	VARCHAR2	(3)		Unit of measurement of volume as considered for entire plan as in mst_plans
PLANNED_DEPARTURE_DATE	VARCHAR2	(40)		Planned departure date in timezone local to the first stop of this trip leg
PLANNED_DEPARTURE_DATE_ZONE	VARCHAR2	(20)		Local timezone of first stop of this trip leg
PLANNED_ARRIVAL_DATE	VARCHAR2	(40)		Planned arrival date of trip in timezone local to the next stop of this trip leg
PLANNED_ARRIVAL_DATE_ZONE	VARCHAR2	(20)		Local timezone of next stop of this trip leg
DRIVE_TIME	VARCHAR2	(20)		Drive time of trip in this trip leg
DRIVE_TIME_UOM	VARCHAR2	(3)		TIme UOM as considered in plan
LAYOVER_TIME	VARCHAR2	(20)		Layover time allocated to the trip leg
LAYOVER_TIME_UOM	VARCHAR2	(3)		TIme UOM as considered in plan
WAIT_TIME	VARCHAR2	(20)		Wait time allocated to this trip leg
WAIT_TIME_UOM	VARCHAR2	(3)		TIme UOM as considered in plan

Query Text

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


SELECT PLAN_ID
,      COMPILE_DESIGNATOR
,      DESCRIPTION
,      TRIP_ID
,      CARRIER_ID
,      MODE_OF_TRANSPORT
,      TRIP_NUMBER
,      ROW_ID1
,      ROW_ID2
,      STOP_ID1
,      STOP_ID2
,      STOP_SEQUENCE_NUMBER
,      LEG
,      CARRIER_NAME
,      SERVICE_LEVEL
,      SERVICE_LEVEL_TL
,      VEHICLE_TYPE
,      DISTANCE_TO_NEXT_STOP
,      DISTANCE_UOM
,      DISTANCE_COST
,      CURRENCY_UOM
,      STOP_LOCATION_ID1
,      STOP_LOCATION_ID2
,      ORIGIN_COMPANY
,      ORIGIN_FACILITY
,      ORIGIN_FACILITY_DESC
,      ORIGIN_CITY
,      ORIGIN_STATE
,      ORIGIN_ZIP
,      ORIGIN_COUNTRY
,      DESTINATION_COMPANY
,      DESTINATION_FACILITY
,      DESTINATION_FACILITY_DESC
,      DESTINATION_CITY
,      DESTINATION_STATE
,      DESTINATION_ZIP
,      DESTINATION_COUNTRY
,      DEPARTURE_GROSS_WEIGHT
,      DEPARTURE_VOLUME
,      DEPARTURE_PALLETS
,      DEPARTURE_PIECES
,      DEPARTURE_ORDERS
,      MAX_WEIGHT
,      MAX_VOLUME
,      MAX_PALLETS
,      WEIGHT_UOM
,      VOLUME_UOM
,      PLANNED_DEPARTURE_DATE
,      PLANNED_DEPARTURE_DATE_ZONE
,      PLANNED_ARRIVAL_DATE
,      PLANNED_ARRIVAL_DATE_ZONE
,      DRIVE_TIME
,      DRIVE_TIME_UOM
,      LAYOVER_TIME
,      LAYOVER_TIME_UOM
,      WAIT_TIME
,      WAIT_TIME_UOM
FROM APPS.MST_TL_SUMMARY_V;

Dependencies

[top of page]

APPS.MST_TL_SUMMARY_V references the following:

APPS: FTE_LOCATION_PARAMETERS; FTE_VEHICLE_TYPES; MST_DELIVERIES; MST_DELIVERY_ASSIGNMENTS; MST_DELIVERY_DETAILS; MST_DELIVERY_LEGS; MST_GEOCODING - show dependent code; MST_PLANS; MST_TRIPS; MST_TRIP_STOPS; MST_WB_UTIL - show dependent code; MTL_SYSTEM_ITEMS; MTL_SYSTEM_ITEMS_KFV; WSH_CARRIERS; WSH_LOCATIONS; WSH_LOOKUPS

APPS.MST_TL_SUMMARY_V is not referenced by any database object