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_CNT_MOVE_LOADS_V

Object Details

Object Name:	MST_CNT_MOVE_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. FK to PLAN_ID of MST_PLANS.
ROW_ID	ROWID	(10)		Row id of MST_TRIPS.
TRIP_ID	NUMBER		Yes	Unique Identifier for a trip. FK to TRIP_ID of MST_TRIPS.
CONTINUOUS_MOVE_ID	NUMBER		Yes	Unique Identifier for a Continuous move. FK to CONTINUOUS_MOVE_ID of MST_CM_TRIPS.
TRIP_NUMBER	NUMBER			TP trip number within the a Plan.
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 of the Trip.
TIME_ZONE1	VARCHAR2	(10)		Time Zone for Trip Start Date.
TRIP_END_DATE	DATE			End date of the Trip.
TOTAL_TRIP_DISTANCE	NUMBER			Distance between Origin and Destination of the trip.
STOPS	NUMBER			Count of Stops in a Trip.
TOTAL_COST	NUMBER			Trip Cost.
FIRST_DEPARTURE_DATE	VARCHAR2	(80)		Departure Date From the Origin of Continuous Move.
LAST_ARRIVAL_DATE	VARCHAR2	(80)		Arrival Date at the Origin of Continuous Move.
FIRST_DEPARTURE_DATE_HIDDEN	DATE			Hidden field for Departure Date From the Origin of Continuous Move.
LAST_ARRIVAL_DATE_HIDDEN	DATE			Hidden field for Arrival Date From the Origin of Continuous Move.
WEIGHT	NUMBER			Weight related to Trip.
CUBE	NUMBER			Cube related to Trip.
PALLETS	NUMBER			Pallets related to Trip.
PIECES	NUMBER			Pieces related to Trip.
ORDERS	NUMBER			Orders related to Trip.
FIRM_STATUS	NUMBER		Yes	Trip Status
FIRM_STATUS_DESC	VARCHAR2	(80)		Description of Trip Status.
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.
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
,      ROW_ID
,      TRIP_ID
,      CONTINUOUS_MOVE_ID
,      TRIP_NUMBER
,      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_COST
,      FIRST_DEPARTURE_DATE
,      LAST_ARRIVAL_DATE
,      FIRST_DEPARTURE_DATE_HIDDEN
,      LAST_ARRIVAL_DATE_HIDDEN
,      WEIGHT
,      CUBE
,      PALLETS
,      PIECES
,      ORDERS
,      FIRM_STATUS
,      FIRM_STATUS_DESC
,      RELEASED
,      RELEASED_CH
,      RELEASE_STATUS
,      RELEASE_STATUS_DESC
,      RELEASE
,      CURRENCY_UOM
,      WEIGHT_UOM
,      VOLUME_UOM
FROM APPS.MST_CNT_MOVE_LOADS_V;

Dependencies

[top of page]

APPS.MST_CNT_MOVE_LOADS_V references the following:

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

APPS.MST_CNT_MOVE_LOADS_V is not referenced by any database object