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_AT_LOADS_V

Object Details

Object Name:	MST_AT_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	Identifier for plan to which record belong
TRIP_ID	NUMBER		Yes	FK -> mst_trips.trip_id, trip_id of curretn truckload
TRIP_NUMBER	NUMBER			Trip number of the current trip with in plan
CARRIER_ID	NUMBER			Id of vendor providing (trip) service
ORIGIN_LOCATION_ID	NUMBER			location_id (wsh_locations.location_id) of first stop of this truckload
DESTINATION_LOCATION_ID	NUMBER			location_id (wsh_locations.location_id) of last stop of this truckload
CARRIER_NAME	VARCHAR2	(30)	Yes	Name of vendor providing (trip) service
SERVICE_LEVEL	VARCHAR2	(30)		Service provided by vendor (carrier) for this trip as in mst_trips. It is not translated string
SERVICE_LEVEL_TL	VARCHAR2	(80)	Yes	Service provided by vendor (carrier) for this trip. It is translated string derived from wsh_lookups for lookup_type = 'WSH_SERVICE_LEVEL'
MODE_OF_TRANSPORT	VARCHAR2	(30)		Mode of transport provided by vendor (carrier) for this trip as in mst_trips.mode_of_transport. It is not translated string
VEHICLE_TYPE	VARCHAR2	(40)		Type fo vehicle like TATA407, 53ft Trailer. It is not specific vehicle with certain number plate.
ORIGIN_COMPANY	VARCHAR2	(80)		Owner company name of very first facility (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 in which very first facility (first stop) of this truckload located
ORIGIN_STATE	VARCHAR2	(120)		State in which very first facility (first stop) of this truckload located
ORIGIN_ZIP	VARCHAR2	(60)		Zip in which very first facility (first stop) of this truckload located
ORIGIN_COUNTRY	VARCHAR2	(120)		Country in which very first facility (first stop) of this truckload located
DESTINATION_COMPANY	VARCHAR2	(80)		Owner company name of very last facility (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
TOTAL_TRIP_DISTANCE	NUMBER			Total distance travelled by this truckload
TOTAL_TRIP_COST	NUMBER			Summation of total basic transport cost, total stop cost, total_accessorial_cost, total load unload cost, total layover cost and total handling cost of truckload
TOTAL_WEIGHT	NUMBER			total weight of deliveries carried by truckload
TOTAL_CUBES	NUMBER			total volume of deliveries carried by truckload
TOTAL_PALLETS	NUMBER			total pallets of deliveries carried by truckload
TOTAL_PIECES	NUMBER			total pieces of deliveries carried by truckload
TOTAL_ORDERS	NUMBER			Count of original snapshot order lines transported by current truckload
WEIGHT_UOM	VARCHAR2	(3)		Unit of measurement of weight as considered for entire plan as in mst_plans
VOLUME_UOM	VARCHAR2	(3)		Unit of measurement of volume as considered for entire plan as in mst_plans
CURRENCY_UOM	VARCHAR2	(3)		Currency considered for this plan
PLANNED_FLAG	VARCHAR2	(80)	Yes	Translated string of Firm Status of trip derived from mfg_lookups for mst_trips.planned_flag
SELECTED_FOR_RELEASE	VARCHAR2	(80)	Yes	String "Yes"/"No" whether flagged for release or not derived for mst_trips.selected_for_release
RELEASE_STATUS	VARCHAR2	(80)	Yes	Translated string of Release Status of trip derived from mfg_lookups for mst_trips.release_status
RELEASE_DATE	DATE			DateTime of release in server timezone as in mst_trips.release_date. This DateTime is datetime of successful release or datetime of release attempt in case of failed release.
RELEASE_DATE_CH	VARCHAR2	(4000)
AUTO_RELEASE_FLAG	NUMBER			Flag whether this trip was auto-released
FLAGGED_FOR_RELEASE	NUMBER			Flag whether this trip has been flagged for release
RELEASE_STATUS_NUM	NUMBER			It is the release status value which is stored in mst_trips

Query Text

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


SELECT PLAN_ID
,      TRIP_ID
,      TRIP_NUMBER
,      CARRIER_ID
,      ORIGIN_LOCATION_ID
,      DESTINATION_LOCATION_ID
,      CARRIER_NAME
,      SERVICE_LEVEL
,      SERVICE_LEVEL_TL
,      MODE_OF_TRANSPORT
,      VEHICLE_TYPE
,      ORIGIN_COMPANY
,      ORIGIN_FACILITY
,      ORIGIN_FACILITY_DESC
,      ORIGIN_CITY
,      ORIGIN_STATE
,      ORIGIN_ZIP
,      ORIGIN_COUNTRY
,      DESTINATION_COMPANY
,      DESTINATION_FACILITY
,      DESTINATION_FACILITY_DESC
,      DESTINATION_CITY
,      DESTINATION_STATE
,      DESTINATION_ZIP
,      DESTINATION_COUNTRY
,      TOTAL_TRIP_DISTANCE
,      TOTAL_TRIP_COST
,      TOTAL_WEIGHT
,      TOTAL_CUBES
,      TOTAL_PALLETS
,      TOTAL_PIECES
,      TOTAL_ORDERS
,      WEIGHT_UOM
,      VOLUME_UOM
,      CURRENCY_UOM
,      PLANNED_FLAG
,      SELECTED_FOR_RELEASE
,      RELEASE_STATUS
,      RELEASE_DATE
,      RELEASE_DATE_CH
,      AUTO_RELEASE_FLAG
,      FLAGGED_FOR_RELEASE
,      RELEASE_STATUS_NUM
FROM APPS.MST_AT_LOADS_V;

Dependencies

[top of page]

APPS.MST_AT_LOADS_V references the following:

APPS: FND_DATE - show dependent code; FTE_LOCATION_PARAMETERS; FTE_VEHICLE_TYPES; MFG_LOOKUPS; MST_DELIVERIES; MST_DELIVERY_LEGS; MST_PLANS; MST_TRIPS; MST_WB_UTIL - show dependent code; MTL_SYSTEM_ITEMS_KFV; WSH_CARRIERS; WSH_LOCATIONS; WSH_LOOKUPS

APPS.MST_AT_LOADS_V is not referenced by any database object