DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.MST_ACT_ANALYZE_CREATE_CM_V

Object Details
Object Name: MST_ACT_ANALYZE_CREATE_CM_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
TRIP_ID1 NUMBER
Yes Primary key for table
TRIP_ID2 NUMBER
Yes Primary key for table
CARRIER_ID NUMBER

FK to wsh_carriers
SERVICE_LEVEL VARCHAR2 (30)
Service Level
CARRIER_SERVICE_ID NUMBER

FK to wsh_carrier_services
VEHICLE_TYPE_ID NUMBER

FK to fte_vehicle_types
FREIGHT_CODE VARCHAR2 (30) Yes Carrier name
SERVICE_LEVEL_TL VARCHAR2 (80) Yes Translated value of service level
VEHICLE_TYPE VARCHAR2 (40)
Vehicle type
OPTION_NUMBER NUMBER

Option number for CSV combination available for create CM. (1 to 3)
COST NUMBER

Cost if given option is chosen.
SAVINGS NUMBER

Cost savings if given option is chosen.
Query Text

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


SELECT PLAN_ID
,      IN_REQUEST_ID
,      TRIP_ID1
,      TRIP_ID2
,      CARRIER_ID
,      SERVICE_LEVEL
,      CARRIER_SERVICE_ID
,      VEHICLE_TYPE_ID
,      FREIGHT_CODE
,      SERVICE_LEVEL_TL
,      VEHICLE_TYPE
,      OPTION_NUMBER
,      COST
,      SAVINGS
FROM APPS.MST_ACT_ANALYZE_CREATE_CM_V;

Dependencies

[top of page]

APPS.MST_ACT_ANALYZE_CREATE_CM_V references the following:

SchemaAPPS
SynonymFTE_VEHICLE_TYPES
SynonymMST_OUT_REQUESTS
SynonymMST_TRIPS
PL/SQL PackageMST_WB_UTIL - show dependent code
SynonymMTL_SYSTEM_ITEMS_KFV
SynonymWSH_CARRIERS
ViewWSH_LOOKUPS

APPS.MST_ACT_ANALYZE_CREATE_CM_V is not referenced by any database object