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_BEFORE_AFTER_V

Object Details

Object Name:	MST_ACT_BEFORE_AFTER_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	Comments
PLAN_ID	NUMBER		Unique identifier for plan
MASTER_TRIP_ID	NUMBER		trip_id of load to which trip/delivery is being added
TRIP_ID	NUMBER		trip_id of trip being added to another trip
CARRIER_ID	NUMBER		FK to wsh_carriers
CARRIER_SERVICE_ID	NUMBER		FK to wsh_carrier_services
VEHICLE_TYPE_ID	NUMBER		FK to fte_vehicle_types
DELIVERY_ID	NUMBER		Delivery_id of delivery being added to another trip
IN_REQUEST_ID	NUMBER		FK to mst_in_requests
TRIP_DELIVERY_NUMBER	NUMBER		Trip number or delivery number depending on type
MODE_OR_DELIVERY_TL	VARCHAR2	(80)	translated value of mode if trip_id is not null and string "Delivery" otherwise
TOTAL_WEIGHT	NUMBER		Total weight
WEIGHT_UOM	VARCHAR2	(3)	Weight UOM
VOLUME	NUMBER		Total volume
VOLUME_UOM	VARCHAR2	(3)	Volume UOM
TOTAL_PALLETS	NUMBER		Total pallets
TOTAL_PIECES	NUMBER		Total pieces
DISTANCE	NUMBER		Distance
DISTANCE_UOM	VARCHAR2	(3)	Distance UOM
STOPS	NUMBER		Total number of stops
CIRCUITY	NUMBER		trip circuity
TOTAL_COST	NUMBER		Total cost
CURRENCY_UOM	VARCHAR2	(3)	Currency UOM
TRIP_OR_DELIVERY	VARCHAR2	(8)	'TRIP' or 'DELIVERY'
LINE_NUMBER	NUMBER		Serial no. in view

Query Text

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


SELECT PLAN_ID
,      MASTER_TRIP_ID
,      TRIP_ID
,      CARRIER_ID
,      CARRIER_SERVICE_ID
,      VEHICLE_TYPE_ID
,      DELIVERY_ID
,      IN_REQUEST_ID
,      TRIP_DELIVERY_NUMBER
,      MODE_OR_DELIVERY_TL
,      TOTAL_WEIGHT
,      WEIGHT_UOM
,      VOLUME
,      VOLUME_UOM
,      TOTAL_PALLETS
,      TOTAL_PIECES
,      DISTANCE
,      DISTANCE_UOM
,      STOPS
,      CIRCUITY
,      TOTAL_COST
,      CURRENCY_UOM
,      TRIP_OR_DELIVERY
,      LINE_NUMBER
FROM APPS.MST_ACT_BEFORE_AFTER_V;

Dependencies

[top of page]

APPS.MST_ACT_BEFORE_AFTER_V references the following:

APPS: MST_AGG_PKG - show dependent code; MST_DELIVERIES; MST_IN_REQUESTS; MST_OUT_REQUESTS; MST_PLANS; MST_TRIPS; MST_WB_UTIL - show dependent code; WSH_LOOKUPS

APPS.MST_ACT_BEFORE_AFTER_V is not referenced by any database object