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_CM_V

Object Details

Object Name:	MST_CM_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 mst_plans.plan_id
CONTINUOUS_MOVE_ID	NUMBER		Yes	FK to mst_cm_trips.cm_trip_id
CM_TRIP_NUMBER	NUMBER			Continuous move trip number
CARRIER_ID	NUMBER			Carrier of the continuous move
CARRIER_CODE	VARCHAR2	(30)	Yes	Carrier name of conntinuous move
SERVICE_LEVEL	VARCHAR2	(30)		Untranslated service level of continuous move
SERVICE_LEVEL_TL	VARCHAR2	(80)	Yes	Translated service level of continuous move
VEHICLE_TYPE	VARCHAR2	(40)		Vehicle type used for this continuous move
ORIGIN_ID	NUMBER		Yes	location_id of origin location of continuous move
ORIGIN_FACILITY	VARCHAR2	(60)	Yes	Facility name of origin location of continuous move
ORIGIN_FACILITY_DESC	VARCHAR2	(250)		Facility description of origin location of continuous move
ORIGIN_CITY	VARCHAR2	(120)		City of origin location of continuous move
ORIGIN_STATE	VARCHAR2	(120)		State of origin location of continuous move
ORIGIN_ZIP	VARCHAR2	(60)		Zip of origin location of continuous move
ORIGIN_COUNTRY	VARCHAR2	(120)		Country of origin location of continuous move
DESTINATION_ID	NUMBER		Yes	location_id of destination location of continuous move
DESTINATION_FACILITY	VARCHAR2	(60)	Yes	Facility name of destination location of continuous move
DESTINATION_FACILITY_DESC	VARCHAR2	(250)		Facility description of destination location of continuous move
DESTINATION_CITY	VARCHAR2	(120)		City of destination location of continuous move
DESTINATION_STATE	VARCHAR2	(120)		State of destination location of continuous move
DESTINATION_ZIP	VARCHAR2	(60)		Zip of destination location of continuous move
DESTINATION_COUNTRY	VARCHAR2	(120)		Country of destination location of continuous move
NUMBER_OF_LOADS	NUMBER			Total number of truckloads in this continuous move
DISTANCE	NUMBER			Total distance covered in this continuous move
TOTAL_CM_TRIP_COST	NUMBER			Total of cost of truckloads in this continuous move
CURRENCY_UOM	VARCHAR2	(3)		Currency uom as considered in plan
SAVINGS	NUMBER			Total saving because of formation of this continuous move
FIRST_DEPARTURE	VARCHAR2	(80)		Time of arrival of first truckload of this continuous move at its first stop
LAST_ARRIVAL	VARCHAR2	(80)		Time of departure of last truckload of this continuous move at its last stop
FIRM_STATUS	NUMBER		Yes	1 - Firm, 2 - Not firm, NULL - Not firm
FIRM_STATUS_DESC	VARCHAR2	(80)		Description of firm status in string as per the saved firm status in number
RELEASE	NUMBER			1 - Flagged for release otherwise not flagged for release
RELEASE_DESC	VARCHAR2	(80)	Yes	Description of selected for release in string as per the saved selected for release in number
RELEASED	DATE			DateTime of release as saved in mst_cm_trips
RELEASED_CH	VARCHAR2	(4000)
RELEASE_STATUS	NUMBER			1 - Firm, 2 - Not firm, NULL - Not yet released
RELEASE_STATUS_DESC	VARCHAR2	(80)	Yes	Description of release status in string as per the saved release status in number
AUTO_RELEASE_FLAG	NUMBER			1 - auto relased, 2 or null - not auto released

Query Text

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


SELECT PLAN_ID
,      CONTINUOUS_MOVE_ID
,      CM_TRIP_NUMBER
,      CARRIER_ID
,      CARRIER_CODE
,      SERVICE_LEVEL
,      SERVICE_LEVEL_TL
,      VEHICLE_TYPE
,      ORIGIN_ID
,      ORIGIN_FACILITY
,      ORIGIN_FACILITY_DESC
,      ORIGIN_CITY
,      ORIGIN_STATE
,      ORIGIN_ZIP
,      ORIGIN_COUNTRY
,      DESTINATION_ID
,      DESTINATION_FACILITY
,      DESTINATION_FACILITY_DESC
,      DESTINATION_CITY
,      DESTINATION_STATE
,      DESTINATION_ZIP
,      DESTINATION_COUNTRY
,      NUMBER_OF_LOADS
,      DISTANCE
,      TOTAL_CM_TRIP_COST
,      CURRENCY_UOM
,      SAVINGS
,      FIRST_DEPARTURE
,      LAST_ARRIVAL
,      FIRM_STATUS
,      FIRM_STATUS_DESC
,      RELEASE
,      RELEASE_DESC
,      RELEASED
,      RELEASED_CH
,      RELEASE_STATUS
,      RELEASE_STATUS_DESC
,      AUTO_RELEASE_FLAG
FROM APPS.MST_CM_V;

Dependencies

[top of page]

APPS.MST_CM_V references the following:

APPS: FND_DATE - show dependent code; FTE_LOCATION_PARAMETERS; FTE_VEHICLE_TYPES; MFG_LOOKUPS; MST_CM_DETAILS - show dependent code; MST_CM_TRIPS; MST_PLANS; MST_WB_UTIL - show dependent code; MTL_SYSTEM_ITEMS_KFV; WSH_CARRIERS; WSH_LOCATIONS; WSH_LOOKUPS

APPS.MST_CM_V is not referenced by any database object