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_TRUCKLOADS_V

Object Details

Object Name:	MST_TRUCKLOADS_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	FK to PLAN_ID of MST_PLANS.
PLAN_NAME	VARCHAR2	(10)	Yes	Plan Name.
DESCRIPTION	VARCHAR2	(50)		Plan Description.
ROW_ID	ROWID	(10)		Row id of MST_TRIPS.
TRIP_ID	NUMBER		Yes	FK to TRIP_ID of MST_TRIPS.
TRIP_NUMBER	NUMBER			Unique Trip Number in a Plan.
CARRIER_ID	NUMBER			ID of Carrier in a Trip.
CARRIER	VARCHAR2	(30)	Yes	Name of Carrier in a Trip.
SERVICE	VARCHAR2	(30)		ID of Carrier Service in a Trip.
SERVICE_DESC	VARCHAR2	(80)		Description of Carrier Service in a Trip.
VEHICLE_TYPE_ID	NUMBER			ID of Carrier Vehicle in a Trip.
VEHICLE	VARCHAR2	(40)		Description of Carrier Vehicle in a Trip.
ORIGIN_LOCATION_ID	NUMBER			ID of Location of Origin of the Trip.
DESTINATION_LOCATION_ID	NUMBER			ID of Location of Destination of the Trip.
ORIGIN_COMPANY	VARCHAR2	(80)		Company name for Origin Facility of the Trip.
ORIGIN_FACILITY_ID	NUMBER		Yes	ID of Origin Facility of the Trip.
ORIGIN_FACILITY	VARCHAR2	(60)	Yes	Name of Origin Facility of the Trip.
ORIGIN_FACILITY_DESC	VARCHAR2	(250)		Description of Origin Facility of the Trip.
ORIGIN_CITY	VARCHAR2	(120)		Origin City of the Trip.
ORIGIN_STATE	VARCHAR2	(120)		Origin State of the Trip.
ORIGIN_ZIP	VARCHAR2	(60)		Origin Postal Code of the Trip.
ORIGIN_COUNTRY	VARCHAR2	(120)		Origin Country of the Trip.
DESTINATION_COMPANY	VARCHAR2	(80)		Company name for Destination Facility of the Trip.
DESTINATION_FACILITY_ID	NUMBER		Yes	ID of Destination Facility of the Trip.
DESTINATION_FACILITY	VARCHAR2	(60)	Yes	Name of Destination Facility of the Trip.
DESTINATION_FACILITY_DESC	VARCHAR2	(250)		Description of Destination Facility of the Trip.
DESTINATION_CITY	VARCHAR2	(120)		Destination City of the Trip.
DESTINATION_STATE	VARCHAR2	(120)		Destination State of the Trip.
DESTINATION_ZIP	VARCHAR2	(60)		Destination Postal Code of the Trip.
DESTINATION_COUNTRY	VARCHAR2	(120)		Destination Country of the Trip.
TRIP_START_DATE	DATE			Start Date from Trip Origin.
TRIP_END_DATE	DATE			End Date at Trip Destination.
TOTAL_TRIP_DISTANCE	NUMBER			Trip Distance.
DISTANCE_UOM	VARCHAR2	(3)		Unit of Measure for Distance.
CIRCUITY	NUMBER			Circuity for the Trip.
STOPS	NUMBER			Count of Stops in the Trip.
MILEAGE_CHARGE	NUMBER			Transportation Cost for the Trip.
STOP_CHARGE	NUMBER			Total Stop Charges for the Trip.
OTHER_ACCESSORIAL_CHARGE	NUMBER			Accessorial Charges for the Trip.
TOTAL_COST	NUMBER			Total Cost for the Trip.
CURRENCY_UOM1	VARCHAR2	(3)		Unit of Measure for Transportation Cost.
CURRENCY_UOM2	VARCHAR2	(3)		Unit of Measure for Stop Charges.
CURRENCY_UOM3	VARCHAR2	(3)		Unit of Measure for Accessorial Charges.
CURRENCY_UOM4	VARCHAR2	(3)		Unit of Measure for Total Cost.
ORDERS	NUMBER			Count of Orders in the Trip.
FIRM_STATUS	NUMBER		Yes	Status of the Trip.
RELEASED	DATE			Date of Release of the Trip.
RELEASED_CH	VARCHAR2	(4000)
RELEASE_STATUS	NUMBER			Release Status of the Trip.
RELEASE_STATUS_DESC	VARCHAR2	(80)		Description of Release Status of the Trip.
RELEASE	NUMBER			Flag to indicate release of the Trip.
CHANGED_BY_USER	NUMBER			Flag to indicate User edits to the Trip.
LOCKED_FOR_IMPACT	NUMBER			Flag to indicate lock on the Trip.

Query Text

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


SELECT PLAN_ID
,      PLAN_NAME
,      DESCRIPTION
,      ROW_ID
,      TRIP_ID
,      TRIP_NUMBER
,      CARRIER_ID
,      CARRIER
,      SERVICE
,      SERVICE_DESC
,      VEHICLE_TYPE_ID
,      VEHICLE
,      ORIGIN_LOCATION_ID
,      DESTINATION_LOCATION_ID
,      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
,      TRIP_END_DATE
,      TOTAL_TRIP_DISTANCE
,      DISTANCE_UOM
,      CIRCUITY
,      STOPS
,      MILEAGE_CHARGE
,      STOP_CHARGE
,      OTHER_ACCESSORIAL_CHARGE
,      TOTAL_COST
,      CURRENCY_UOM1
,      CURRENCY_UOM2
,      CURRENCY_UOM3
,      CURRENCY_UOM4
,      ORDERS
,      FIRM_STATUS
,      RELEASED
,      RELEASED_CH
,      RELEASE_STATUS
,      RELEASE_STATUS_DESC
,      RELEASE
,      CHANGED_BY_USER
,      LOCKED_FOR_IMPACT
FROM APPS.MST_TRUCKLOADS_V;

Dependencies

[top of page]

APPS.MST_TRUCKLOADS_V references the following:

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

APPS.MST_TRUCKLOADS_V is not referenced by any database object