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_WSH_TRIPS_V

Object Details

Object Name:	MST_WSH_TRIPS_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
TRIP_ID	NUMBER		Yes
MODE_OF_TRANSPORT	VARCHAR2	(30)
CONTINUOUS_MOVE_ID	NUMBER
CONTINUOUS_MOVE_SEQUENCE	NUMBER
MOVE_TYPE	NUMBER
PLANNED_FLAG	VARCHAR2	(1)	Yes
STATUS_CODE	VARCHAR2	(2)	Yes
LANE_ID	NUMBER
CARRIER_ID	NUMBER
SERVICE_LEVEL	VARCHAR2	(30)
VEHICLE_TYPE_ID	NUMBER
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
ORIGIN_LOCATION_ID	NUMBER
DESTINATION_LOCATION_ID	NUMBER
TRIP_START_DATE	DATE
TRIP_END_DATE	DATE
TOTAL_TRIP_DISTANCE	NUMBER
TOTAL_DIRECT_DISTANCE	NUMBER
TOTAL_BASIC_TRANSPORT_COST	NUMBER
TOTAL_STOP_COST	NUMBER
TOTAL_LAYOVER_COST	NUMBER
TOTAL_LOAD_UNLOAD_COST	NUMBER
TOTAL_ACCESSORIAL_COST	NUMBER
TOTAL_HANDLING_COST	NUMBER
PEAK_PALLET_UTILIZATION	NUMBER
PEAK_VOLUME_UTILIZATION	NUMBER
PEAK_WEIGHT_UTILIZATION	NUMBER
CARRIER_SERVICE_ID	NUMBER

Query Text

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


SELECT TRIP_ID
,      MODE_OF_TRANSPORT
,      CONTINUOUS_MOVE_ID
,      CONTINUOUS_MOVE_SEQUENCE
,      MOVE_TYPE
,      PLANNED_FLAG
,      STATUS_CODE
,      LANE_ID
,      CARRIER_ID
,      SERVICE_LEVEL
,      VEHICLE_TYPE_ID
,      CREATED_BY
,      LAST_UPDATED_BY
,      ORIGIN_LOCATION_ID
,      DESTINATION_LOCATION_ID
,      TRIP_START_DATE
,      TRIP_END_DATE
,      TOTAL_TRIP_DISTANCE
,      TOTAL_DIRECT_DISTANCE
,      TOTAL_BASIC_TRANSPORT_COST
,      TOTAL_STOP_COST
,      TOTAL_LAYOVER_COST
,      TOTAL_LOAD_UNLOAD_COST
,      TOTAL_ACCESSORIAL_COST
,      TOTAL_HANDLING_COST
,      PEAK_PALLET_UTILIZATION
,      PEAK_VOLUME_UTILIZATION
,      PEAK_WEIGHT_UTILIZATION
,      CARRIER_SERVICE_ID
FROM APPS.MST_WSH_TRIPS_V;

Dependencies

[top of page]

APPS.MST_WSH_TRIPS_V references the following:

APPS: FTE_MOVES; FTE_TRIP_MOVES; FTE_VEHICLE_TYPES; WSH_CARRIER_SERVICES; WSH_TRIPS

APPS.MST_WSH_TRIPS_V is not referenced by any database object