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

VIEW: APPS.MST_REL_PLAN_V

Object Details
Object Name: MST_REL_PLAN_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)
Description of plan
START_DATE DATE
Yes Start date of the planning horizon
CUTOFF_DATE DATE
Yes End date of the planning horizon
PLAN_START_DATE DATE

Plan start date
START_TIME VARCHAR2 (5)
Start time of the planning horizon
CUTOFF_TIME VARCHAR2 (5)
End time of the planning horizon
PLAN_START_TIME VARCHAR2 (5)
Plan start time
TOTAL_DIRECT_TLS NUMBER

No. of direct TLs in the plan
TOTAL_MSTOP_TLS NUMBER

No. of multi stop TLs in the plan
TOTAL_LTLS NUMBER

No. of LTLs in the plan
TOTAL_PARCELS NUMBER

No. of parcels in the plan
TOTAL_CMS NUMBER

No. of continuous moves in the plan
TOTAL_WEIGHT NUMBER

Total weight
WEIGHT_UOM VARCHAR2 (3)
Weight UOM
TOTAL_VOLUME NUMBER

Total volume
VOLUME_UOM VARCHAR2 (3)
Volume UOM
TOTAL_PALLETS NUMBER

No. of pallets
TOTAL_PIECES NUMBER

No. of pieces
TOTAL_ORDERS NUMBER

No. of orders
TOTAL_PLAN_COST NUMBER

Total cost of the plan
TOTAL_COST_NO_CONSOLIDATION NUMBER

Total transportation cost of this plan if no consolidation is carried out
TOTAL_SAVINGS NUMBER

Total savings
PERCENT_TLS_IN_CMS NUMBER

Percent of TLs in continuous moves
CURRENCY_UOM VARCHAR2 (3)
Currency UOM
NUM_EXCEPTIONS NUMBER

No. of exceptions generated for the plan
Query Text

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


SELECT PLAN_ID
,      COMPILE_DESIGNATOR
,      DESCRIPTION
,      START_DATE
,      CUTOFF_DATE
,      PLAN_START_DATE
,      START_TIME
,      CUTOFF_TIME
,      PLAN_START_TIME
,      TOTAL_DIRECT_TLS
,      TOTAL_MSTOP_TLS
,      TOTAL_LTLS
,      TOTAL_PARCELS
,      TOTAL_CMS
,      TOTAL_WEIGHT
,      WEIGHT_UOM
,      TOTAL_VOLUME
,      VOLUME_UOM
,      TOTAL_PALLETS
,      TOTAL_PIECES
,      TOTAL_ORDERS
,      TOTAL_PLAN_COST
,      TOTAL_COST_NO_CONSOLIDATION
,      TOTAL_SAVINGS
,      PERCENT_TLS_IN_CMS
,      CURRENCY_UOM
,      NUM_EXCEPTIONS
FROM APPS.MST_REL_PLAN_V;

Dependencies

[top of page]

APPS.MST_REL_PLAN_V references the following:

SchemaAPPS
PL/SQL PackageMST_AGG_PKG - show dependent code
SynonymMST_PLANS

APPS.MST_REL_PLAN_V is not referenced by any database object