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_LOAD_STOPS_V

Object Details

Object Name:	MST_LOAD_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	FK to PLAN_ID of MST_PLANS.
TRIP_ID	NUMBER		Yes	Trip id. Foreign key to MST_TRIPS.
STOP_ID	NUMBER		Yes	FK to STOP_ID of MST_TRIP_STOPS.
STOP_NUMBER	NUMBER		Yes	Indicates sequence of stop on trip.
STOP_LOCATION_ID	NUMBER		Yes	Foreign key to WSH_LOCATIONS
ROW_ID	ROWID	(10)		Row id of MST_TRIP_STOPS
COMPANY	VARCHAR2	(80)		Company Name of the Stop Facility.
FACILITY_ID	NUMBER		Yes	ID of Stop Facility.
FACILITY	VARCHAR2	(60)	Yes	Name of Stop Facility.
DESCRIPTION	VARCHAR2	(250)		Description of Stop Facility.
CITY	VARCHAR2	(120)		City of Stop Facility.
STATE	VARCHAR2	(120)		State of Stop Facility.
ZIP	VARCHAR2	(60)		Postal Code of Stop Facility.
COUNTRY	VARCHAR2	(120)		Country of Stop Facility.
ARRIVAL_DATE_TIME	VARCHAR2	(80)		Arrival Date at Stop.
ARR_DATETIME_HIDDEN	DATE			Hidden Field for Arrival Date at Stop.
ARRIVAL_TIME_ZONE	VARCHAR2	(10)		Arrival Date Time zone.
DEPARTURE_DATE_TIME	VARCHAR2	(80)		Departure Date from Stop.
DEP_DATETIME_HIDDEN	DATE			Hidden Field for Departure Date from Stop.
DEPARTURE_TIME_ZONE	VARCHAR2	(10)		Departure Date Time zone.
STOP_TIME	VARCHAR2	(12)		Total Stop Time.
LOAD_WEIGHT	NUMBER			Weight at Departure.
LOAD_CUBE	NUMBER			Cube at Departure.
PALLETS	NUMBER			Pallets at Departure.
PIECES	NUMBER			Pieces at Departure.
WEIGHT_UNLOADED	NUMBER			Weight Unloaded at stop.
CUBE_UNLOADED	NUMBER			Cube Unloaded at stop.
PALLETS_UNLOADED	NUMBER			Pallets Unloaded at stop.
PIECES_UNLOADED	NUMBER			Pieces Unloaded at stop.
WEIGHT_LOADED	NUMBER			Weight loaded at stop.
CUBE_LOADED	NUMBER			Cube loaded at stop.
PALLETS_LOADED	NUMBER			Pallets loaded at stop.
PIECES_LOADED	NUMBER			Pieces loaded at stop.
WEIGHT_UOM	VARCHAR2	(3)		Unit of Measure for Weight.
VOLUME_UOM	VARCHAR2	(3)		Unit of Measure for Volume.

Query Text

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


SELECT PLAN_ID
,      TRIP_ID
,      STOP_ID
,      STOP_NUMBER
,      STOP_LOCATION_ID
,      ROW_ID
,      COMPANY
,      FACILITY_ID
,      FACILITY
,      DESCRIPTION
,      CITY
,      STATE
,      ZIP
,      COUNTRY
,      ARRIVAL_DATE_TIME
,      ARR_DATETIME_HIDDEN
,      ARRIVAL_TIME_ZONE
,      DEPARTURE_DATE_TIME
,      DEP_DATETIME_HIDDEN
,      DEPARTURE_TIME_ZONE
,      STOP_TIME
,      LOAD_WEIGHT
,      LOAD_CUBE
,      PALLETS
,      PIECES
,      WEIGHT_UNLOADED
,      CUBE_UNLOADED
,      PALLETS_UNLOADED
,      PIECES_UNLOADED
,      WEIGHT_LOADED
,      CUBE_LOADED
,      PALLETS_LOADED
,      PIECES_LOADED
,      WEIGHT_UOM
,      VOLUME_UOM
FROM APPS.MST_LOAD_STOPS_V;

Dependencies

[top of page]

APPS.MST_LOAD_STOPS_V references the following:

APPS: FTE_LOCATION_PARAMETERS; MST_GEOCODING - show dependent code; MST_PLANS; MST_TRIPS; MST_TRIP_STOPS; MST_WB_UTIL - show dependent code; WSH_LOCATIONS

APPS.MST_LOAD_STOPS_V is not referenced by any database object