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

VIEW: APPS.MST_ALL_CM_SUMMARY_V

Object Details
Object Name: MST_ALL_CM_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 Mandatory Comments
PLAN_ID NUMBER
Yes FK to mst_plans
COMPILE_DESIGNATOR VARCHAR2 (10) Yes Plan name
DESCRIPTION VARCHAR2 (50)
Plan description
NUMBER_OF_CM NUMBER

Number of continuous move in the plan
TOTAL_COSTS NUMBER

Total cost of continuous moves in the plan
TOTAL_SAVINGS NUMBER

Total saving due to continuous moves in the plan
PERCENT_OF_TL_IN_CM NUMBER

Percentage of truckloads in continuous moves in the plan
NUMBER_OF_EXCEPTIONS NUMBER

Number of exceptions raised on continuous moves in the plan
CURRENCY_UOM VARCHAR2 (3)
Currency UOM used in this plan
Query Text

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


SELECT PLAN_ID
,      COMPILE_DESIGNATOR
,      DESCRIPTION
,      NUMBER_OF_CM
,      TOTAL_COSTS
,      TOTAL_SAVINGS
,      PERCENT_OF_TL_IN_CM
,      NUMBER_OF_EXCEPTIONS
,      CURRENCY_UOM
FROM APPS.MST_ALL_CM_SUMMARY_V;

Dependencies

[top of page]

APPS.MST_ALL_CM_SUMMARY_V references the following:

SchemaAPPS
PL/SQL PackageMST_CM_DETAILS - show dependent code
SynonymMST_CM_TRIPS
SynonymMST_PLANS

APPS.MST_ALL_CM_SUMMARY_V is not referenced by any database object