[Home] [Help] [Dependency Information]
Object Name: | MST_REL_PLAN_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
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 |
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;
APPS.MST_REL_PLAN_V is not referenced by any database object
|
|
|