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_SR_SUMMARY_V

Object Details

Object Name:	MST_SR_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	Comments
PLAN_ID	NUMBER		Identifier for plan to which record belong
COMPILE_DESIGNATOR	VARCHAR2	(10)	Plan name
DESCRIPTION	VARCHAR2	(50)	Plan description
CARRIER_ID	NUMBER		Id of vendor providing (trip) service
CARRIER_NAME	VARCHAR2	(30)	Name of vendor providing (trip) service
SERVICE_LEVEL	VARCHAR2	(30)	Service provided by vendor (carrier) for this trip as in mst_trips. It is not translated string
SERVICE_LEVEL_TL	VARCHAR2	(80)	Translated service provided by vendor (carrier) for this trip as in mst_trips.
MODE_OF_TRANSPORT	VARCHAR2	(30)	Mode of transport provided by vendor (carrier) for this trip as in mst_trips.mode_of_transport. It is not translated string
MODE_OF_TRANSPORT_TL	VARCHAR2	(80)	Translated mode of transport provided by vendor (carrier) for this trip as in mst_trips.mode_of_transport.
TOTAL_LOADS	NUMBER		Total count of trips of this service in current plan
TOTAL_COST	NUMBER		Total cost of trips of this service in current plan
CURRENCY_UOM	VARCHAR2	(3)	Currency considered for this plan
WEIGHT_UOM	VARCHAR2	(3)	Unit of measurement of weight as considered for entire plan as in mst_plans
VOLUME_UOM	VARCHAR2	(3)	Unit of measurement of volume as considered for entire plan as in mst_plans

Query Text

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


SELECT PLAN_ID
,      COMPILE_DESIGNATOR
,      DESCRIPTION
,      CARRIER_ID
,      CARRIER_NAME
,      SERVICE_LEVEL
,      SERVICE_LEVEL_TL
,      MODE_OF_TRANSPORT
,      MODE_OF_TRANSPORT_TL
,      TOTAL_LOADS
,      TOTAL_COST
,      CURRENCY_UOM
,      WEIGHT_UOM
,      VOLUME_UOM
FROM APPS.MST_SR_SUMMARY_V;

Dependencies

[top of page]

APPS.MST_SR_SUMMARY_V references the following:

APPS: MST_PLANS; MST_TRIPS; WSH_CARRIERS; WSH_CARRIER_SERVICES; WSH_LOOKUPS

APPS.MST_SR_SUMMARY_V is not referenced by any database object