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_ASTL_OPTIONS_V

Object Details

Object Name:	MST_ACT_ASTL_OPTIONS_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	FK to mst_plans
IN_REQUEST_ID	NUMBER		Yes	FK to mst_in_requests
OUT_REQUEST_ID	NUMBER		Yes	FK to mst_out_requests
TRIP_ID1	NUMBER			trip_id of LTL/Parcel
TRIP_ID2	NUMBER			trip_id of TL
CARRIER_ID	NUMBER			FK to wsh_carriers
CARRIER_SERVICE_ID	NUMBER			FK to wsh_carrier_services
CARRIER_NAME	VARCHAR2	(30)	Yes	Carrier name
SERVICE_LEVEL	VARCHAR2	(30)		Service level
SERVICE_LEVEL_TL	VARCHAR2	(80)	Yes	Translated value of service level
VEHICLE_TYPE_ID	NUMBER			FK to fte_vehicle_types
VEHICLE_TYPE	VARCHAR2	(40)		Vehicle type
COST	NUMBER			Cost if given option is used for adding ltl/parcel to tl.
CURRENCY_UOM	VARCHAR2	(3)		Currency UOM
MODE_OF_TRANSPORT	VARCHAR2	(80)		mode of transport of resulting trip
MODE_OF_TRANSPORT_TL	VARCHAR2	(80)	Yes	Translated value of mode of transport
OPTION_NUM	NUMBER			Cost option type

Query Text

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


SELECT PLAN_ID
,      IN_REQUEST_ID
,      OUT_REQUEST_ID
,      TRIP_ID1
,      TRIP_ID2
,      CARRIER_ID
,      CARRIER_SERVICE_ID
,      CARRIER_NAME
,      SERVICE_LEVEL
,      SERVICE_LEVEL_TL
,      VEHICLE_TYPE_ID
,      VEHICLE_TYPE
,      COST
,      CURRENCY_UOM
,      MODE_OF_TRANSPORT
,      MODE_OF_TRANSPORT_TL
,      OPTION_NUM
FROM APPS.MST_ACT_ASTL_OPTIONS_V;

Dependencies

[top of page]

APPS.MST_ACT_ASTL_OPTIONS_V references the following:

APPS: FTE_VEHICLE_TYPES; MST_IN_REQUESTS; MST_OUT_REQUESTS; MST_PLANS; MTL_SYSTEM_ITEMS_KFV; WSH_CARRIERS; WSH_LOOKUPS

APPS.MST_ACT_ASTL_OPTIONS_V is not referenced by any database object