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

VIEW: APPS.MST_PLAN_SUMMARY_V

Object Details
Object Name: MST_PLAN_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

Identifier of plan to which current record belong
OUTPUT_TYPE VARCHAR2 (17)
Identifier for type of record (Totals, TLs, LTLs, Parcels, Continuous Moves, Unassigned Orders)
COUNT NUMBER

Total count of OUTPUT_TYPE data in entire plan
COST NUMBER

Total cost of OUTPUT_TYPE data in entire plan
WEIGHT NUMBER

Total weight of OUTPUT_TYPE data in entire plan
CUBE NUMBER

Total volume of OUTPUT_TYPE data in entire plan
PALLETS NUMBER

Total pallets of OUTPUT_TYPE data in entire plan
PIECES NUMBER

Total pieces of OUTPUT_TYPE data in entire plan
ORDERS NUMBER

Total orders of OUTPUT_TYPE data in entire plan
TYPE_ID NUMBER

Identifier of OUTPUT_TYPE for internal code purpose
CURRENCY_UOM VARCHAR2 (3)
Currency considered for this plan
WEIGHT_UOM VARCHAR2 (3)
Unit of measurement of weight as considered for entire plan as in mst_plans
VOLUME_UOM VARCHAR2 (3)
Unit of measurement of volume as considered for entire plan as in mst_plans
Query Text

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


SELECT PLAN_ID
,      OUTPUT_TYPE
,      COUNT
,      COST
,      WEIGHT
,      CUBE
,      PALLETS
,      PIECES
,      ORDERS
,      TYPE_ID
,      CURRENCY_UOM
,      WEIGHT_UOM
,      VOLUME_UOM
FROM APPS.MST_PLAN_SUMMARY_V;

Dependencies

[top of page]

APPS.MST_PLAN_SUMMARY_V references the following:

SchemaAPPS
PL/SQL PackageMST_AGG_PKG - show dependent code
SynonymMST_PLANS

APPS.MST_PLAN_SUMMARY_V is not referenced by any database object