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_CR_SERVICES_V

Object Details

Object Name:	MST_CR_SERVICES_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 of plan to which current record belong
CARRIER_ID	NUMBER		vendor id providing services
SERVICE_LEVEL	VARCHAR2	(30)	Un translated string showing service level of current record
SERVICE_LEVEL_TL	VARCHAR2	(80)	Translated string showing service level of current service record
MODE_OF_TRANSPORT	VARCHAR2	(30)	Un translated string showing mode of transport of current service record
MODE_OF_TRANSPORT_TL	VARCHAR2	(80)	Un translated string showing mode of transport of current service record
TOTAL_LOADS	NUMBER		Total number of trips in this service in this plan
TOTAL_COST	NUMBER		Total cost of trips in this service in this plan
COST_UOM	VARCHAR2	(3)	Global currency UOM defined in global parameters
TOTAL_WEIGHT	NUMBER		Total weight transported by trips in this service in this plan
WEIGHT_UOM	VARCHAR2	(3)	Unit of measurement of weight in current plan
TOTAL_CUBE	NUMBER		Total volume transported by trips in this service in this plan
VOLUME_UOM	VARCHAR2	(3)	Unit of measurement of volume in current plan
TOTAL_PALLETS	NUMBER		Total pallets transported by trips in this service in this plan
TOTAL_PIECES	NUMBER		Total pieces transported by trips in this service in this plan
TOTAL_ORDERS	NUMBER		Total orders() transported by trips in this service in this plan

Query Text

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


SELECT PLAN_ID
,      CARRIER_ID
,      SERVICE_LEVEL
,      SERVICE_LEVEL_TL
,      MODE_OF_TRANSPORT
,      MODE_OF_TRANSPORT_TL
,      TOTAL_LOADS
,      TOTAL_COST
,      COST_UOM
,      TOTAL_WEIGHT
,      WEIGHT_UOM
,      TOTAL_CUBE
,      VOLUME_UOM
,      TOTAL_PALLETS
,      TOTAL_PIECES
,      TOTAL_ORDERS
FROM APPS.MST_CR_SERVICES_V;

Dependencies

[top of page]

APPS.MST_CR_SERVICES_V references the following:

APPS: MST_DELIVERIES; MST_DELIVERY_ASSIGNMENTS; MST_DELIVERY_DETAILS; MST_DELIVERY_LEGS; MST_PLANS; MST_TRIPS; WSH_CARRIER_SERVICES; WSH_LOOKUPS

APPS.MST_CR_SERVICES_V is not referenced by any database object