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_ACT_ANALYZE_DISSOLVE_CM_V

Object Details

Object Name:	MST_ACT_ANALYZE_DISSOLVE_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
TRIP_ID	NUMBER			FK to mst_trips
IN_REQUEST_ID	NUMBER		Yes	FK to mst_in_requests
LOAD_TYPE	VARCHAR2	(80)		Empty or loaded
TRIP_NUMBER	NUMBER			Trip number with in plan
ORIGIN_FACILITY	VARCHAR2	(60)	Yes	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 zip code of the trip.
ORIGIN_COUNTRY	VARCHAR2	(120)		Origin country 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 zipcode of the trip.
DESTINATION_COUNTRY	VARCHAR2	(120)		Destination country of the trip.
DEPARTURE_DATE	DATE			Departure date of the trip from the origin.
DEPARTURE_TIME	VARCHAR2	(5)		Departure time of the trip in HH:MI format.
DEPARTURE_TIME_ZONE	VARCHAR2	(4000)		Time zone in which departure date/time is displayed.
ARRIVAL_DATE	DATE			Date of arrival of the trip at the destination.
ARRIVAL_TIME	VARCHAR2	(5)		Time of arrival of the trip at the destination.
ARRIVAL_TIME_ZONE	VARCHAR2	(4000)		Time zone in which arrival date/time is displayed.
DISTANCE	NUMBER			Distance
DISTANCE_UOM	VARCHAR2	(3)		Distance UOM
CURRENT_CARRIER	VARCHAR2	(30)	Yes	Carrier of the trip before manual update
CURRENT_COST	NUMBER			Cost of the trip before manual update
NEW_CARRIER	VARCHAR2	(30)		Carrier of the trip after manual update
NEW_COST	NUMBER			Cost of the trip after manual update
CURRENCY_UOM	VARCHAR2	(3)		UOM of currency

Query Text

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


SELECT PLAN_ID
,      TRIP_ID
,      IN_REQUEST_ID
,      LOAD_TYPE
,      TRIP_NUMBER
,      ORIGIN_FACILITY
,      ORIGIN_CITY
,      ORIGIN_STATE
,      ORIGIN_ZIP
,      ORIGIN_COUNTRY
,      DESTINATION_CITY
,      DESTINATION_STATE
,      DESTINATION_ZIP
,      DESTINATION_COUNTRY
,      DEPARTURE_DATE
,      DEPARTURE_TIME
,      DEPARTURE_TIME_ZONE
,      ARRIVAL_DATE
,      ARRIVAL_TIME
,      ARRIVAL_TIME_ZONE
,      DISTANCE
,      DISTANCE_UOM
,      CURRENT_CARRIER
,      CURRENT_COST
,      NEW_CARRIER
,      NEW_COST
,      CURRENCY_UOM
FROM APPS.MST_ACT_ANALYZE_DISSOLVE_CM_V;

Dependencies

[top of page]

APPS.MST_ACT_ANALYZE_DISSOLVE_CM_V references the following:

APPS: FTE_LOCATION_PARAMETERS; MST_GEOCODING - show dependent code; MST_IN_REQUESTS; MST_OUT_REQUESTS; MST_PLANS; MST_TRIPS; MST_WB_UTIL - show dependent code; WSH_CARRIERS; WSH_LOCATIONS

APPS.MST_ACT_ANALYZE_DISSOLVE_CM_V is not referenced by any database object