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_WSH_CARRIER_SERV_V

Object Details

Object Name:	MST_WSH_CARRIER_SERV_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
CARRIER_SERVICE_ID	NUMBER
CARRIER_ID	NUMBER	(38)
SERVICE_LEVEL	VARCHAR2	(30)
MODE_OF_TRANSPORT	VARCHAR2	(30)
ALLOW_INTERSPERSE_LOAD	VARCHAR2	(1)
MAX_NUM_STOPS_PERMITTED	NUMBER
MAX_TOTAL_DISTANCE_IN_24HR	NUMBER
MAX_TOTAL_DISTANCE	NUMBER
MAX_TOTAL_TIME	NUMBER
MAX_OUT_OF_ROUTE	NUMBER
MIN_LAYOVER_TIME	NUMBER
MAXIMUM_DRIVING_TIME_IN_24HR	NUMBER
MAXIMUM_DUTY_TIME_IN_24HR	NUMBER
ALLOW_CONTINUOUS_MOVE	VARCHAR2	(1)
CM_FIRST_LOAD_DISCOUNT	VARCHAR2	(1)
MIN_CM_DISTANCE	NUMBER
MIN_CM_TIME	NUMBER
MAX_CM_DISTANCE	NUMBER
MAX_CM_TIME	NUMBER
CM_FREE_DH_DISTANCE	NUMBER
MAX_CM_DH_DISTANCE	NUMBER
MAX_CM_DH_TIME	NUMBER
CM_RATE_VARIANT	VARCHAR2	(30)
MAX_SIZE_WIDTH	NUMBER
MAX_SIZE_HEIGHT	NUMBER
MAX_SIZE_LENGTH	NUMBER
MIN_SIZE_WIDTH	NUMBER
MIN_SIZE_HEIGHT	NUMBER
MIN_SIZE_LENGTH	NUMBER
DISTANCE_UOM	VARCHAR2	(3)
TIME_UOM	VARCHAR2	(10)
DISTANCE_CALCULATION_METHOD	NUMBER
DIMENSION_UOM	VARCHAR2	(3)

Query Text

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


SELECT CARRIER_SERVICE_ID
,      CARRIER_ID
,      SERVICE_LEVEL
,      MODE_OF_TRANSPORT
,      ALLOW_INTERSPERSE_LOAD
,      MAX_NUM_STOPS_PERMITTED
,      MAX_TOTAL_DISTANCE_IN_24HR
,      MAX_TOTAL_DISTANCE
,      MAX_TOTAL_TIME
,      MAX_OUT_OF_ROUTE
,      MIN_LAYOVER_TIME
,      MAXIMUM_DRIVING_TIME_IN_24HR
,      MAXIMUM_DUTY_TIME_IN_24HR
,      ALLOW_CONTINUOUS_MOVE
,      CM_FIRST_LOAD_DISCOUNT
,      MIN_CM_DISTANCE
,      MIN_CM_TIME
,      MAX_CM_DISTANCE
,      MAX_CM_TIME
,      CM_FREE_DH_DISTANCE
,      MAX_CM_DH_DISTANCE
,      MAX_CM_DH_TIME
,      CM_RATE_VARIANT
,      MAX_SIZE_WIDTH
,      MAX_SIZE_HEIGHT
,      MAX_SIZE_LENGTH
,      MIN_SIZE_WIDTH
,      MIN_SIZE_HEIGHT
,      MIN_SIZE_LENGTH
,      DISTANCE_UOM
,      TIME_UOM
,      DISTANCE_CALCULATION_METHOD
,      DIMENSION_UOM
FROM APPS.MST_WSH_CARRIER_SERV_V;

Dependencies

[top of page]

APPS.MST_WSH_CARRIER_SERV_V references the following:

APPS: WSH_CARRIERS; WSH_CARRIER_SERVICES

APPS.MST_WSH_CARRIER_SERV_V is not referenced by any database object