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]

TABLE: MST.MST_TRIP_STOPS

Object Details

Object Name:	MST_TRIP_STOPS
Object Type:	TABLE
Owner:	MST
Subobject Name:
Status:	VALID

MST_TRIP_STOPS has vehicle trip stop records

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MST_TRIP_STOPS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PLAN_ID STOP_ID
MST_TRIP_STOPS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PLAN_ID TRIP_ID
MST_TRIP_STOPS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PLAN_ID PLANNED_ARRIVAL_DATE
MST_TRIP_STOPS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PLAN_ID STOP_LOCATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
STOP_ID	NUMBER		Yes	Primary key for table
TRIP_ID	NUMBER		Yes	Trip id. Foreign key to MST_TRIPS.
SR_STOP_ID	NUMBER			Stop Id in TE instance
STOP_LOCATION_ID	NUMBER		Yes	Foreign key to WSH_LOCATIONS
STOP_SEQUENCE_NUMBER	NUMBER		Yes	Indicates sequence of stop on trip.
PLAN_ID	NUMBER		Yes	This column stores the plan id that owns the trip that has this trip stops
PLANNED_ARRIVAL_DATE	DATE			Date on which the trip is planned to arrive at the stop
PLANNED_DEPARTURE_DATE	DATE			Date on which the trip is planned to depart from the stop
PLN_LOADING_START_TIME	DATE			Time when the loading starts
PLN_LOADING_END_TIME	DATE			Time when the loading ends
PLN_UNLOADING_START_TIME	DATE			Time when the unloading should start
PLN_UNLOADING_END_TIME	DATE			Time when the unloading should end
DEPARTURE_GROSS_WEIGHT	NUMBER			Required for dynamic planning
DEPARTURE_NET_WEIGHT	NUMBER			Required for dynamic planning
DEPARTURE_VOLUME	NUMBER			Required for dynamic planning
DEPARTURE_FILL_PERCENT	NUMBER			Required for dynamic planning
DEPARTURE_PIECES	NUMBER			Total pieces departed from this stop. Denormalized for UI.
DEPARTURE_PALLETS	NUMBER			Total pallets departed from this stop. Denormalized for UI.
DISTANCE_TO_NEXT_STOP	NUMBER			Planned driving distance between next stop and this stop
DRV_TIME_TO_NEXT_STOP	NUMBER			Planned driving time to next stop
WKEND_LAYOVER_STOPS	NUMBER			Number of weekend layover stops from previous stops
WKDAY_LAYOVER_STOPS	NUMBER			Number of weekdays layover stops from previous stops
TOTAL_LAYOVER_DURATION	NUMBER			Total layover stop duration
DISTANCE_COST	NUMBER			This column stores the distance cost from this stop to the next stop in the same trip
CARRIER_LOADING_COST	NUMBER			This column stores the loading cost at this stop
CARRIER_UNLOADING_COST	NUMBER			This column stores the unloading cost at this stop
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).

Query Text

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


SELECT STOP_ID
,      TRIP_ID
,      SR_STOP_ID
,      STOP_LOCATION_ID
,      STOP_SEQUENCE_NUMBER
,      PLAN_ID
,      PLANNED_ARRIVAL_DATE
,      PLANNED_DEPARTURE_DATE
,      PLN_LOADING_START_TIME
,      PLN_LOADING_END_TIME
,      PLN_UNLOADING_START_TIME
,      PLN_UNLOADING_END_TIME
,      DEPARTURE_GROSS_WEIGHT
,      DEPARTURE_NET_WEIGHT
,      DEPARTURE_VOLUME
,      DEPARTURE_FILL_PERCENT
,      DEPARTURE_PIECES
,      DEPARTURE_PALLETS
,      DISTANCE_TO_NEXT_STOP
,      DRV_TIME_TO_NEXT_STOP
,      WKEND_LAYOVER_STOPS
,      WKDAY_LAYOVER_STOPS
,      TOTAL_LAYOVER_DURATION
,      DISTANCE_COST
,      CARRIER_LOADING_COST
,      CARRIER_UNLOADING_COST
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM MST.MST_TRIP_STOPS;

Dependencies

[top of page]

MST.MST_TRIP_STOPS does not reference any database object

MST.MST_TRIP_STOPS is referenced by following:

APPS: MST_TRIP_STOPS