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_SR_LOADS_V

Object Details

Object Name:	MST_SR_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 current trip
CARRIER_ID	NUMBER			Id 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
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
ORIGIN_LOCATION_ID	NUMBER			location_id (wsh_locations.wsh_location_id) of first stop of this trip
DESTINATION_LOCATION_ID	NUMBER			location_id (wsh_locations.wsh_location_id) of last stop of this truckload
TRIP_NUMBER	NUMBER			Trip number of the current trip with in plan
MODE_OF_TRANSPORT_TL	VARCHAR2	(80)	Yes	Translated mode of transport of current trip
ORIGIN_COMPANY	VARCHAR2	(80)		Owner company name of very first facility (first stop) of this trip
ORIGIN_FACILITY	VARCHAR2	(60)	Yes	Facility name of very first facility (first stop) of this trip
ORIGIN_FACILITY_DESC	VARCHAR2	(250)		Facility description of very first facility (first stop) of this trip
ORIGIN_CITY	VARCHAR2	(120)		City in which very first facility (first stop) of this trip located
ORIGIN_STATE	VARCHAR2	(120)		State in which very first facility (first stop) of this trip located
ORIGIN_ZIP	VARCHAR2	(60)		Zip in which very first facility (first stop) of this trip located
ORIGIN_COUNTRY	VARCHAR2	(120)		Country in which very first facility (first stop) of this trip located
DESTINATION_COMPANY	VARCHAR2	(80)		Owner company name of very last facility (last stop) of this trip
DESTINATION_FACILITY	VARCHAR2	(60)	Yes	Facility name of very last facility (last stop) of this trip
DESTINATION_FACILITY_DESC	VARCHAR2	(250)		Facility description of very last facility (last stop) of this trip
DESTINATION_CITY	VARCHAR2	(120)		City in which very last facility (last stop) of this trip is located
DESTINATION_STATE	VARCHAR2	(120)		State in which very last facility (last stop) of this trip is located
DESTINATION_ZIP	VARCHAR2	(60)		Zip in which very last facility (last stop) of this trip is located
DESTINATION_COUNTRY	VARCHAR2	(120)		Country in which very last facility (last stop) of this trip is located
TOTAL_BASIC_TRANSPORT_COST	NUMBER			Total basic transport cost of the trip
COST_UOM	VARCHAR2	(3)		Currency considered for this plan
WEIGHT	NUMBER			total weight of deliveries carried by trip
CUBE	NUMBER			total volume of deliveries carried by this trip
PALLETS	NUMBER			total pallets of deliveries carried by this trip
PIECES	NUMBER			total pieces of deliveries carried by this trip
ORDERS	NUMBER			total orders in deliveries carried by this trip
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
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_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)
RELEASE_STATUS	VARCHAR2	(80)		Translated string of Release Status of trip derived from mfg_lookups for mst_trips.release_status

Query Text

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


SELECT PLAN_ID
,      TRIP_ID
,      CARRIER_ID
,      SERVICE_LEVEL
,      MODE_OF_TRANSPORT
,      ORIGIN_LOCATION_ID
,      DESTINATION_LOCATION_ID
,      TRIP_NUMBER
,      MODE_OF_TRANSPORT_TL
,      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_BASIC_TRANSPORT_COST
,      COST_UOM
,      WEIGHT
,      CUBE
,      PALLETS
,      PIECES
,      ORDERS
,      WEIGHT_UOM
,      VOLUME_UOM
,      PLANNED_FLAG
,      SELECTED_FOR_RELEASE
,      RELEASE_DATE
,      RELEASE_DATE_CH
,      RELEASE_STATUS
FROM APPS.MST_SR_LOADS_V;

Dependencies

[top of page]

APPS.MST_SR_LOADS_V references the following:

APPS: FND_DATE - show dependent code; FTE_LOCATION_PARAMETERS; MFG_LOOKUPS; MST_DELIVERIES; MST_DELIVERY_ASSIGNMENTS; MST_DELIVERY_DETAILS; MST_DELIVERY_LEGS; MST_PLANS; MST_TRIPS; MST_WB_UTIL - show dependent code; WSH_LOCATIONS; WSH_LOOKUPS

APPS.MST_SR_LOADS_V is not referenced by any database object