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_TS_SUMMARY_V

Object Details

Object Name:	MST_TS_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
CARRIER_ID	NUMBER			Id of vendor providing (trip) service
TRIP_ID	NUMBER		Yes	Id of trip of this stop
TRIP_NUMBER	NUMBER			Trip number of trip of this stop
ROW_ID	ROWID	(10)		rowid of mst_trip_stops
STOP_ID	NUMBER		Yes	Id of this stop FK -> mst_trip_stops.stop_id
STOP_SEQUENCE_NUMBER	NUMBER		Yes	Stop sequence number of thsi stop
STOP_LOCATION_ID	NUMBER		Yes	location_id (wsh_locations.wsh_location_id) of this stop
COMPANY_NAME	VARCHAR2	(80)		Owner company name of this stop (facility)
FACILITY_CODE	VARCHAR2	(60)	Yes	Name of this stop (facility)
FACILITY_DESC	VARCHAR2	(250)		Description of this stop (facility)
ADDRESS1	VARCHAR2	(240)		Addess of this stop (facility)
CITY	VARCHAR2	(120)		City of this stop (facility)
STATE	VARCHAR2	(120)		State of this stop (facility)
POSTAL_CODE	VARCHAR2	(60)		Zip of this stop (facility)
COUNTRY	VARCHAR2	(120)		Country of this stop (facility)
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'
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
VEHICLE_TYPE	VARCHAR2	(40)		Type fo vehicle like TATA407, 53ft Trailer. It is not specific vehicle with certain number plate
PLANNED_ARRIVAL_DATE	VARCHAR2	(40)		Planned arrival date of trip at this stop in local timezone
PLANNED_ARRIVAL_DATE_ZONE	VARCHAR2	(20)		Timezone of this stop
PLANNED_DEPARTURE_DATE	VARCHAR2	(40)		Planned departure date of trip at this stop in local timezone
PLANNED_DEPARTURE_DATE_ZONE	VARCHAR2	(20)		Timezone of this stop
STOP_TIME	VARCHAR2	(20)		Stop time of trip at this stop
STOP_TIME_UOM	VARCHAR2	(3)		Time UOM as considered in the plan
REQUIRED_LOAD_TIME	VARCHAR2	(20)		Required load time at trip at this stop
REQUIRED_LOAD_TIME_UOM	VARCHAR2	(3)		Time UOM as considered in the plan
REQUIRED_UNLOAD_TIME	VARCHAR2	(20)		Required unload time from trip at this stop
REQUIRED_UNLOAD_TIME_UOM	VARCHAR2	(3)		Time UOM as considered in the plan
LOAD_COST	NUMBER			Cost of loading delivery into trip at this stop
LOAD_COST_UOM	VARCHAR2	(3)		Currency UOM as considered in the plan
UNLOAD_COST	NUMBER			Cost of unloading delivery into trip at this stop
UNLOAD_COST_UOM	VARCHAR2	(3)		Currency UOM as considered in the plan
WEIGHT_UNLOADED	NUMBER			Total weight unloaded from trip at this stop
WEIGHT_UNLOADED_UOM	VARCHAR2	(3)		Weight UOM as considered in the plan
CUBE_UNLOADED	NUMBER			Total volume unloaded from trip at this stop
CUBE_UNLOADED_UOM	VARCHAR2	(3)		Volume UOM as considered in the plan
PALLETS_UNLOADED	NUMBER			Total pallets unloaded from trip at this stop
PIECES_UNLOADED	NUMBER			Total pieces unloaded from trip at this stop
WEIGHT_LOADED	NUMBER			Total weight loaded into trip at this stop
WEIGHT_LOADED_UOM	VARCHAR2	(3)		Weight UOM as considered in the plan
CUBE_LOADED	NUMBER			Total volume loaded into trip at this stop
CUBE_LOADED_UOM	VARCHAR2	(3)		Volume UOM as considered in the plan
PALLETS_LOADED	NUMBER			Total pallets loaded into trip at this stop
PIECES_LOADED	NUMBER			Total pieces loaded into trip at this stop

Query Text

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


SELECT PLAN_ID
,      COMPILE_DESIGNATOR
,      DESCRIPTION
,      CARRIER_ID
,      TRIP_ID
,      TRIP_NUMBER
,      ROW_ID
,      STOP_ID
,      STOP_SEQUENCE_NUMBER
,      STOP_LOCATION_ID
,      COMPANY_NAME
,      FACILITY_CODE
,      FACILITY_DESC
,      ADDRESS1
,      CITY
,      STATE
,      POSTAL_CODE
,      COUNTRY
,      CARRIER_NAME
,      SERVICE_LEVEL
,      SERVICE_LEVEL_TL
,      MODE_OF_TRANSPORT
,      VEHICLE_TYPE
,      PLANNED_ARRIVAL_DATE
,      PLANNED_ARRIVAL_DATE_ZONE
,      PLANNED_DEPARTURE_DATE
,      PLANNED_DEPARTURE_DATE_ZONE
,      STOP_TIME
,      STOP_TIME_UOM
,      REQUIRED_LOAD_TIME
,      REQUIRED_LOAD_TIME_UOM
,      REQUIRED_UNLOAD_TIME
,      REQUIRED_UNLOAD_TIME_UOM
,      LOAD_COST
,      LOAD_COST_UOM
,      UNLOAD_COST
,      UNLOAD_COST_UOM
,      WEIGHT_UNLOADED
,      WEIGHT_UNLOADED_UOM
,      CUBE_UNLOADED
,      CUBE_UNLOADED_UOM
,      PALLETS_UNLOADED
,      PIECES_UNLOADED
,      WEIGHT_LOADED
,      WEIGHT_LOADED_UOM
,      CUBE_LOADED
,      CUBE_LOADED_UOM
,      PALLETS_LOADED
,      PIECES_LOADED
FROM APPS.MST_TS_SUMMARY_V;

Dependencies

[top of page]

APPS.MST_TS_SUMMARY_V references the following:

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

APPS.MST_TS_SUMMARY_V is not referenced by any database object