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_CM_LOADS_V

Object Details

Object Name:	MST_CM_LOADS_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	Unique identifier for plan
ROW_ID	ROWID	(10)		rowid of mst_trips
TRIP_ID	NUMBER		Yes	FK to mst_trips
CONTINUOUS_MOVE_ID	NUMBER		Yes	Continuous move to which this trip is part of
CONTINUOUS_MOVE_SEQUENCE	NUMBER			Sequence of this trip in its continuous move
TRIP_NUMBER	NUMBER			Trip number with in plan
CARRIER_ID	NUMBER		Yes	Id of vendor providing (trip) service
CARRIER_CODE	VARCHAR2	(30)	Yes	Name of vendor providing (trip) service
SERVICE_LEVEL	VARCHAR2	(30)		Untranslated service level of this trip
SERVICE_LEVEL_TL	VARCHAR2	(80)	Yes	Translated service level of this trip
VEHICLE_TYPE	VARCHAR2	(40)		Vehicle type used in this trip (translated)
TRIP_LOADING_STATUS	VARCHAR2	(4000)		Loaded or Empty
ORIGIN_COMPANY	VARCHAR2	(80)		Owner company name of very first facility (first stop) of this truckload
ORIGIN_FACILITY_ID	NUMBER		Yes	facility_id of of first stop of this truckload
ORIGIN_FACILITY	VARCHAR2	(60)	Yes	Facility name of very first facility (first stop) of this truckload
ORIGIN_FACILITY_DESC	VARCHAR2	(250)		Facility description of very first facility (first stop) of this truckload
ORIGIN_CITY	VARCHAR2	(120)		City of very first facility (first stop) of this truckload
ORIGIN_STATE	VARCHAR2	(120)		State of very first facility (first stop) of this truckload
ORIGIN_ZIP	VARCHAR2	(60)		Zip of very first facility (first stop) of this truckload
ORIGIN_COUNTRY	VARCHAR2	(120)		Country of very first facility (first stop) of this truckload
DESTINATION_COMPANY	VARCHAR2	(80)		Owner company name of very last facility (last stop) of this truckload
DESTINATION_FACILITY_ID	NUMBER		Yes	facility_id of last stop of this truckload
DESTINATION_FACILITY	VARCHAR2	(60)	Yes	Facility name of very last facility (last stop) of this truckload
DESTINATION_FACILITY_DESC	VARCHAR2	(250)		Facility description of very last facility (last stop) of this truckload
DESTINATION_CITY	VARCHAR2	(120)		City in which very last facility (last stop) of this truckload is located
DESTINATION_STATE	VARCHAR2	(120)		State in which very last facility (last stop) of this truckload is located
DESTINATION_ZIP	VARCHAR2	(60)		Zip in which very last facility (last stop) of this truckload is located
DESTINATION_COUNTRY	VARCHAR2	(120)		Country in which very last facility (last stop) of this truckload is located
TRIP_START_DATE	DATE			DateTime when truckload vehicle arrive at its first stop
TIME_ZONE1	VARCHAR2	(4000)		Time zone of first stop of trip
TRIP_END_DATE	DATE			DateTime when truckload vehicle depart from its last stop
TOTAL_TRIP_DISTANCE	NUMBER			Total distance travelled by this trip
STOPS	NUMBER			Total number of stops in this trip
TOTAL_TRIP_COST	NUMBER			Total cost of this trip
FIRST_DEPARTURE_DATE	VARCHAR2	(80)		Departure DateTime at first stop
LAST_ARRIVAL_DATE	VARCHAR2	(80)		Arrival DateTime at last stop
WEIGHT	NUMBER			Total weight carried by this trip
CUBE	NUMBER			Total volume carried by this trip
PALLETS	NUMBER			Total pallets carried by this trip
PIECES	NUMBER			Total pieces carried by this trip
ORDERS	NUMBER			Total orders carried by this trip
FIRM_STATUS	NUMBER		Yes	Firm status (planned_flag) as stored in of mst_trips
FIRM_STATUS_DESC	VARCHAR2	(80)	Yes	Routing and Contents Firm, Routing Firm, Not Firm etc.
RELEASE	NUMBER			Flagged for release (selected_for_release in mst_trips)
RELEASE_DESC	VARCHAR2	(80)	Yes	Whether Flagged for release or not
RELEASED	DATE			DateTime of release
RELEASED_CH	VARCHAR2	(4000)
RELEASE_STATUS	NUMBER			Release status (release_status) as stored in of mst_trips
RELEASE_STATUS_DESC	VARCHAR2	(80)	Yes	Firm status at the time of release or failed
CURRENCY_UOM	VARCHAR2	(3)		Currency UOM as considered in plan
WEIGHT_UOM	VARCHAR2	(3)		Weight UOM as considered in plan
CUBE_UOM	VARCHAR2	(3)		Volume UOM as considered in plan

Query Text

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


SELECT PLAN_ID
,      ROW_ID
,      TRIP_ID
,      CONTINUOUS_MOVE_ID
,      CONTINUOUS_MOVE_SEQUENCE
,      TRIP_NUMBER
,      CARRIER_ID
,      CARRIER_CODE
,      SERVICE_LEVEL
,      SERVICE_LEVEL_TL
,      VEHICLE_TYPE
,      TRIP_LOADING_STATUS
,      ORIGIN_COMPANY
,      ORIGIN_FACILITY_ID
,      ORIGIN_FACILITY
,      ORIGIN_FACILITY_DESC
,      ORIGIN_CITY
,      ORIGIN_STATE
,      ORIGIN_ZIP
,      ORIGIN_COUNTRY
,      DESTINATION_COMPANY
,      DESTINATION_FACILITY_ID
,      DESTINATION_FACILITY
,      DESTINATION_FACILITY_DESC
,      DESTINATION_CITY
,      DESTINATION_STATE
,      DESTINATION_ZIP
,      DESTINATION_COUNTRY
,      TRIP_START_DATE
,      TIME_ZONE1
,      TRIP_END_DATE
,      TOTAL_TRIP_DISTANCE
,      STOPS
,      TOTAL_TRIP_COST
,      FIRST_DEPARTURE_DATE
,      LAST_ARRIVAL_DATE
,      WEIGHT
,      CUBE
,      PALLETS
,      PIECES
,      ORDERS
,      FIRM_STATUS
,      FIRM_STATUS_DESC
,      RELEASE
,      RELEASE_DESC
,      RELEASED
,      RELEASED_CH
,      RELEASE_STATUS
,      RELEASE_STATUS_DESC
,      CURRENCY_UOM
,      WEIGHT_UOM
,      CUBE_UOM
FROM APPS.MST_CM_LOADS_V;

Dependencies

[top of page]

APPS.MST_CM_LOADS_V references the following:

APPS: FND_DATE - show dependent code; FTE_LOCATION_PARAMETERS; FTE_VEHICLE_TYPES; MFG_LOOKUPS; MST_CM_DETAILS - show dependent code; MST_CM_TRIPS; MST_GEOCODING - show dependent code; MST_PLANS; MST_TRIPS; MST_WB_UTIL - show dependent code; MTL_SYSTEM_ITEMS_KFV; WSH_CARRIERS; WSH_LOCATIONS; WSH_LOOKUPS

APPS.MST_CM_LOADS_V is not referenced by any database object