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_STOPS_V

Object Details

Object Name:	MST_TL_STOPS_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
STOP_ID	NUMBER		Yes	Id of this stop of current trip
STOP_LOCATION_ID	NUMBER		Yes	locatin_id (wsh_locations.wsh_location_id) of this stop
OWNER_NAME	VARCHAR2	(80)		Name of owner company of this stop
CITY	VARCHAR2	(120)		City of this stop
STATE	VARCHAR2	(120)		State of this stop
POSTAL_CODE	VARCHAR2	(60)		Zip of this stop
COUNTRY	VARCHAR2	(120)		Country of this stop
PLANNED_ARRIVAL_DATE	VARCHAR2	(40)		Planned arrival date of trip at this stop in timezone of this stop concatenated with timezone of this stop.
PLANNED_ARRIVAL_DATE_DT	DATE			Planned arrival date of this trip at this stop in server timezone
PLANNED_DEPARTURE_DATE	VARCHAR2	(40)		Planned departure date of trip from this stop in timezone of this stop concatenated with timezone of this stop.
PLANNED_DEPARTURE_DATE_DT	DATE			Planned departure date of this trip from this stop in server timezone
LOAD_WEIGHT	NUMBER			Total weight loaded on current trip at this stop
LOAD_CUBE	NUMBER			Total volume loaded on current trip at this stop
LOAD_PALLETS	NUMBER			Total pallets loaded on current trip at this stop
LOAD_PIECES	NUMBER			Total pieces loaded on current trip at this stop
LOAD_WEIGHT_UOM	VARCHAR2	(3)		Unit of measurement of weight as considered for entire plan as in mst_plans
LOAD_CUBE_UOM	VARCHAR2	(3)		Unit of measurement of volume as considered for entire plan as in mst_plans
UNLOAD_WEIGHT	NUMBER			Total weight unloaded from current trip at this stop
UNLOAD_CUBE	NUMBER			Total volume unloaded from current trip at this stop
UNLOAD_PALLETS	NUMBER			Total pallets unloaded from current trip at this stop
UNLOAD_PIECES	NUMBER			Total pieces unloaded from current trip at this stop
UNLOAD_WEIGHT_UOM	VARCHAR2	(3)		Unit of measurement of weight as considered for entire plan as in mst_plans
UNLOAD_CUBE_UOM	VARCHAR2	(3)		Unit of measurement of volume as considered for entire plan as in mst_plans

Query Text

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


SELECT PLAN_ID
,      STOP_ID
,      STOP_LOCATION_ID
,      OWNER_NAME
,      CITY
,      STATE
,      POSTAL_CODE
,      COUNTRY
,      PLANNED_ARRIVAL_DATE
,      PLANNED_ARRIVAL_DATE_DT
,      PLANNED_DEPARTURE_DATE
,      PLANNED_DEPARTURE_DATE_DT
,      LOAD_WEIGHT
,      LOAD_CUBE
,      LOAD_PALLETS
,      LOAD_PIECES
,      LOAD_WEIGHT_UOM
,      LOAD_CUBE_UOM
,      UNLOAD_WEIGHT
,      UNLOAD_CUBE
,      UNLOAD_PALLETS
,      UNLOAD_PIECES
,      UNLOAD_WEIGHT_UOM
,      UNLOAD_CUBE_UOM
FROM APPS.MST_TL_STOPS_V;

Dependencies

[top of page]

APPS.MST_TL_STOPS_V references the following:

APPS: MST_DELIVERIES; MST_DELIVERY_LEGS; MST_PLANS; MST_TRIP_STOPS; MST_WB_UTIL - show dependent code; WSH_LOCATIONS

APPS.MST_TL_STOPS_V is not referenced by any database object