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_AT_SUMMARY_V

Object Details

Object Name:	MST_AT_SUMMARY_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	Identifier of plan to which current record belong
COMPILE_DESIGNATOR	VARCHAR2	(10)	Yes	Plan name
DESCRIPTION	VARCHAR2	(50)		Plan description
NUMBER_OF_LOADS	NUMBER			Number of truckloads in plan
TOTAL_TL_WEIGHT	NUMBER			Total weight carried by truckloads in the plan
WEIGHT_UOM	VARCHAR2	(3)		Unit of measurement of weight in current plan
TOTAL_TL_VOLUME	NUMBER			Total volume carried by truckloads in the plan
VOLUME_UOM	VARCHAR2	(3)		Unit of measurement of volume in current plan
TOTAL_TL_PALLETS	NUMBER			Total pallets transportaed by truckloads in the plan
TOTAL_TL_PIECES	NUMBER			Total pieces transportaed by truckloads in the plan
TOTAL_TL_ORDERS	NUMBER			Total orders() transportaed by truckloads in the plan
FIXED_CHARGES	NUMBER			Total basic transport cost of truckloads in plan
FIXED_CHARGES_UOM	VARCHAR2	(3)		Global currency UOM defined in global parameters
STOP_CHARGES	NUMBER			Total stop charges of truckloads in plan
STOP_CHARGES_UOM	VARCHAR2	(3)		Global currency UOM defined in global parameters
LOAD_UNLOAD_CHARGES	NUMBER			Total load + unload cost of truckloads in plan
LOAD_UNLOAD_CHARGES_UOM	VARCHAR2	(3)		Global currency UOM defined in global parameters
LAYOVER_CHARGES	NUMBER			Total layover charges of truckloads in entire plan
LAYOVER_CHARGES_UOM	VARCHAR2	(3)		Global currency UOM defined in global parameters
OTHER_CHARGES	NUMBER			Total of accessorial charges and handling charges of truckloads in plan
OTHER_CHARGES_UOM	VARCHAR2	(3)		Global currency UOM defined in global parameters
TOTAL_CHARGES_UOM	VARCHAR2	(3)		Global currency UOM defined in global parameters

Query Text

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


SELECT PLAN_ID
,      COMPILE_DESIGNATOR
,      DESCRIPTION
,      NUMBER_OF_LOADS
,      TOTAL_TL_WEIGHT
,      WEIGHT_UOM
,      TOTAL_TL_VOLUME
,      VOLUME_UOM
,      TOTAL_TL_PALLETS
,      TOTAL_TL_PIECES
,      TOTAL_TL_ORDERS
,      FIXED_CHARGES
,      FIXED_CHARGES_UOM
,      STOP_CHARGES
,      STOP_CHARGES_UOM
,      LOAD_UNLOAD_CHARGES
,      LOAD_UNLOAD_CHARGES_UOM
,      LAYOVER_CHARGES
,      LAYOVER_CHARGES_UOM
,      OTHER_CHARGES
,      OTHER_CHARGES_UOM
,      TOTAL_CHARGES_UOM
FROM APPS.MST_AT_SUMMARY_V;

Dependencies

[top of page]

APPS.MST_AT_SUMMARY_V references the following:

APPS: MST_PLANS; MST_TRIPS

APPS.MST_AT_SUMMARY_V is not referenced by any database object