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_LOAD_LEGS_V

Object Details

Object Name:	MST_LOAD_LEGS_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
LEG	NUMBER			Indicates sequence of stop on trip.
TRIP_ID	NUMBER		Yes	FK to TRIP_ID of MST_TRIPS.
ROW_ID	ROWID	(10)		Row id of MST_TRIP_STOPS.
STOP_ID1	NUMBER		Yes	FK to STOP_ID of MST_TRIP_STOPS
STOP_ID2	NUMBER		Yes	FK to STOP_ID of MST_TRIP_STOPS.
ORIGIN_LOCATION_ID	NUMBER		Yes	ID of Origin Location of Trip Leg.
DESTINATION_LOCATION_ID	NUMBER		Yes	ID of Destination Location of Trip Leg.
ORIGIN_FACILITY_ID	NUMBER		Yes	ID of Origin Facility of Trip Leg.
ORG_COMPANY	VARCHAR2	(80)		Company Name for Origin of Trip Leg.
ORG_CITY	VARCHAR2	(120)		Origin City for Trip Leg.
ORG_STATE	VARCHAR2	(120)		Origin State for Trip Leg.
ORG_ZIP	VARCHAR2	(60)		Origin Postal Code for Trip Leg.
ORG_COUNTRY	VARCHAR2	(120)		Origin Country for Trip Leg.
DESTINATION_FACILITY_ID	NUMBER		Yes	ID of Destination Facility of Trip Leg.
DEST_COMPANY	VARCHAR2	(80)		Company Name for Destination of Trip Leg.
DEST_CITY	VARCHAR2	(120)		Destination City for Trip Leg.
DEST_STATE	VARCHAR2	(120)		Destination State for Trip Leg.
DEST_ZIP	VARCHAR2	(60)		Destination Postal Code for Trip Leg.
DEST_COUNTRY	VARCHAR2	(120)		Destination Country for Trip Leg.
ARRIVAL_DATE_TIME	VARCHAR2	(80)		Arrival date at Destination of the trip leg.
ARR_DATETIME_HIDDEN	DATE			Hidden Field for Arrival date at Destination of the trip leg.
ARRIVAL_TIME_ZONE	VARCHAR2	(10)		Time zone for Arrival Date.
DISTANCE	NUMBER			Trip Leg Distance.
DEPARTURE_DATE_TIME	VARCHAR2	(80)		Departure date From Origin of the trip leg.
DEP_DATETIME_HIDDEN	DATE			Hidden field for Departure date From Origin of the trip leg.
DEPARTURE_TIME_ZONE	VARCHAR2	(10)		Time zone for Departure Date.
MILEAGE_CHARGE	NUMBER			Cost related to distance travelled.
DRIVE_TIME	VARCHAR2	(12)		Drive time between Origin and destination of Trip Leg.
WAIT_TIME	VARCHAR2	(12)		Wait time during Trip Leg.
LAYOVER_TIME	VARCHAR2	(12)		Layover time during Trip Leg.
WEIGHT	NUMBER			Departure Waight from Origin of Trip Leg.
CUBE	NUMBER			Departure Cube from Origin of Trip Leg.
PALLETS	NUMBER			Departure Pallets from Origin of Trip Leg.
PIECES	NUMBER			Departure Pieces from Origin of Trip Leg.
MAX_WEIGHT	NUMBER			Weight Capacity of the Vehicle.
MAX_CUBE	NUMBER			Cube Capacity of the Vehicle.
MAX_PALLETS	NUMBER			Pallets Capacity of the Vehicle.
WEIGHT_UTILIZATION	NUMBER			Utilization of Weight Capacity of the Vehicle.
CUBE_UTILIZATION	NUMBER			Utilization of Cube Capacity of the Vehicle.
PALLET_UTILIZATION	NUMBER			Utilization of Pallet Capacity of the Vehicle.
ORDERS	NUMBER			Count of Orders included in the Trip leg.
CURRENCY_UOM	VARCHAR2	(3)		Unit of Measure for Cost.
WEIGHT_UOM	VARCHAR2	(3)		Unit of Measure for Weight.
VOLUME_UOM	VARCHAR2	(3)		Unit of Measure for Volume.

Query Text

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


SELECT PLAN_ID
,      LEG
,      TRIP_ID
,      ROW_ID
,      STOP_ID1
,      STOP_ID2
,      ORIGIN_LOCATION_ID
,      DESTINATION_LOCATION_ID
,      ORIGIN_FACILITY_ID
,      ORG_COMPANY
,      ORG_CITY
,      ORG_STATE
,      ORG_ZIP
,      ORG_COUNTRY
,      DESTINATION_FACILITY_ID
,      DEST_COMPANY
,      DEST_CITY
,      DEST_STATE
,      DEST_ZIP
,      DEST_COUNTRY
,      ARRIVAL_DATE_TIME
,      ARR_DATETIME_HIDDEN
,      ARRIVAL_TIME_ZONE
,      DISTANCE
,      DEPARTURE_DATE_TIME
,      DEP_DATETIME_HIDDEN
,      DEPARTURE_TIME_ZONE
,      MILEAGE_CHARGE
,      DRIVE_TIME
,      WAIT_TIME
,      LAYOVER_TIME
,      WEIGHT
,      CUBE
,      PALLETS
,      PIECES
,      MAX_WEIGHT
,      MAX_CUBE
,      MAX_PALLETS
,      WEIGHT_UTILIZATION
,      CUBE_UTILIZATION
,      PALLET_UTILIZATION
,      ORDERS
,      CURRENCY_UOM
,      WEIGHT_UOM
,      VOLUME_UOM
FROM APPS.MST_LOAD_LEGS_V;

Dependencies

[top of page]

APPS.MST_LOAD_LEGS_V references the following:

APPS: FTE_LOCATION_PARAMETERS; MST_GEOCODING - show dependent code; MST_PLANS; MST_TRIPS; MST_TRIP_STOPS; MST_WB_UTIL - show dependent code; WSH_LOCATIONS

APPS.MST_LOAD_LEGS_V is not referenced by any database object