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_TL_V

Object Details

Object Name:	MST_ACT_BEFORE_AFTER_TL_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 TL
TRIP_ID	NUMBER		trip_id of LTL/Parcel
DELIVERY_ID	NUMBER		delivery_id of delivery being assigned to TL
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
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
,      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
,      TRIP_OR_DELIVERY
,      LINE_NUMBER
FROM APPS.MST_ACT_BEFORE_AFTER_TL_V;

Dependencies

[top of page]

APPS.MST_ACT_BEFORE_AFTER_TL_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_TL_V is not referenced by any database object