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

TABLE: MST.MST_PLANS

Object Details
Object Name: MST_PLANS
Object Type: TABLE
Owner: MST
Subobject Name:
Status: VALID


This table stores different plans, with their names, and settings in the Oracle Transportation Planner.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MST_PLANS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPLAN_ID
MST_PLANS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSTART_DATE
Columns
Name Datatype Length Mandatory Comments
PLAN_ID NUMBER
Yes Primary key
PLAN_TYPE NUMBER
Yes 1 => Standard TP plan, 2 => Simulation Plan
COMPILE_DESIGNATOR VARCHAR2 (10) Yes Plan name (designator)
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
PLAN_COMPLETION_DATE DATE

Plan completion date
DATA_START_DATE DATE

Snapshot start time
DATA_COMPLETION_DATE DATE

Snapshot completion date
OUTSIDE_PROCESSING_FLAG NUMBER

1 Yes, 2 No
DROP_SHIPMENT_FLAG NUMBER

1 Yes, 2 No
SHIP_FROM_SUPPLIER_FLAG NUMBER

1 Yes, 2 No
SHIP_TO_CUSTOMER_FLAG NUMBER

1 Yes, 2 No
RETURN_TO_SUPPLIER_FLAG NUMBER

1 Yes, 2 No
RETURN_FROM_CUSTOMER_FLAG NUMBER

1 Yes, 2 No
INT_INBOUND_ALL_FLAG NUMBER

1 Yes, 2 No.
INT_OUTBOUND_ALL_FLAG NUMBER

1 Yes, 2 No.
EXT_OUTBOUND_ALL_FLAG NUMBER

1 Yes, 2 No.
EXT_INBOUND_ALL_FLAG NUMBER

1 Yes, 2 No.
OPTIMIZATION_STRATEGY_FLAG NUMBER
Yes 1 => Mode/carrier selection only, 2 => 1 and simple consolidtaion, 3 => 1 and advance consolidation
POOLING_FLAG NUMBER

Value to specify if the optimization strategic flag is 3
MULTI_STOP_TL_FLAG NUMBER

Value to specify if the optimization strategic flag is 3
CONTINUOUS_MOVE_FLAG NUMBER

Value to specify if the optimization strategic flag is 3
RELEASE_RUNNING_FLAG NUMBER

1 Yes, 2 No
ENGINE_ACTIVE_FLAG NUMBER

1 => Engine is running, 2 or null => Engine is not running
OPTIMIZED_FLAG NUMBER

1 plan is optimized before or not
PALLETIZE_FLAG NUMBER

Whether all loads to be palletized. 1 Yes, 2 or null No
PLAN_OPTION_CHANGED NUMBER

1 => Yes if plan facilities/date/other inbound, outbound flag etc changed after engine run is completed2 => No (default)
TARGET_TL_UTILIZATION NUMBER

Target TL utilization in percentage.
MIN_TL_UTILIZATION NUMBER

Minimum TL in percentage.
LOCAL_POOLING_SHIPMENT_SIZE NUMBER

Local pooling shipment size limit in percentage.
LOCAL_POOLING_RADIUS NUMBER

In distance UOM
STOP_NEIGHBORHOOD_RADIUS NUMBER

Maximum distance between adjacent stops in multiple stop trips in distance UOM
GENERAL_POOLING_RADIUS NUMBER

Maximum distance between O/D facility and pool in distance UOM
MAXIMUM_EMPTY_LEG_LENGTH NUMBER

Maximum dead head distance for a continuous move in distance UOM
POOL_POINT_COUNT NUMBER

Number of candidate pools considered for O/D of an order
LOADING_UNLOADING_CHARGE NUMBER

Whether to consider loading and unloading charges for cost optimization. 1 Yes, 2 or null No.
LAYOVER_CHARGES NUMBER

Whether to consider loading and unloading charges for cost optimization. 1 Yes, 2 or null No.
ORIGIN_DESTINATION_TL_CHRGS NUMBER

Whether to consider origin and destination charges for cost optimization. 1 Yes, 2 or null No.
OTHER_TL_CHARGES NUMBER

Whether to consider other TL charges for cost optimization. 1 Yes ,2 or null No.
OTHER_LTL_CHARGES NUMBER

Other LTL charges. 1 Yes, 2 or null No.
OTHER_PARCEL_CHARGES NUMBER

Other parcel charges. 1 Yes, 2 or null No.
LTL_DISCOUNT NUMBER

Discount for LTL. 1 Yes, 2 or null No.
PARCEL_DISCOUNT NUMBER

Discounts for parcels. 1 Yes, 2 or null No.
AUTO_RELEASE NUMBER
Yes 1 => do not auto release, 2 => auto release entire plan, 3 => auto release based on auto release rules
AUTO_REL_RULE_SET_ID NUMBER

Auto release individual loads using this rule set
COMMITMENT_SET_ID NUMBER

Carrier contractual commitment set id. FK to fte_sel_groups
CURRENCY_UOM VARCHAR2 (3)
Global currency UOM defined in global parameters
DIMENSION_UOM VARCHAR2 (3)
Global dimension UOM
DISTANCE_UOM VARCHAR2 (3)
Global distance UOM defined in global parameters
TIME_UOM VARCHAR2 (3)
Global time UOM defined in global parameters
VOLUME_UOM VARCHAR2 (3)
Global volume UOM defined in global parameters
WEIGHT_UOM VARCHAR2 (3)
Global weight UOM defined in global parameters
TOTAL_ORDERS NUMBER

Total number of distinct orders in this plan
TOTAL_PALLETS NUMBER

Total numbe of pallets in this plan
TOTAL_PIECES NUMBER

Sum of all request_quantity of deliveries in this plan
TOTAL_VOLUME NUMBER

Total volume of the orders in the plan
TOTAL_WEIGHT NUMBER

Total weight of the orders in the plan
TOTAL_PLAN_COST NUMBER

Total plan cost
TOTAL_TL_COST NUMBER

Total cost of truckloads in plan
TOTAL_TL_ORDERS NUMBER

Total number of orders carried by truckloads in this plan
TOTAL_TL_PALLETS NUMBER

Total number of pallets carried by truckloads in this plan
TOTAL_TL_PIECES NUMBER

Total number of pieces carried by truckloads in this plan
TOTAL_TL_VOLUME NUMBER

Total volume carried by truckloads in this plan
TOTAL_TL_WEIGHT NUMBER

Total weight carried by truckloads in this plan
TOTAL_LTL_WEIGHT NUMBER

Total weight carried by LTLs in this plan
TOTAL_LTL_VOLUME NUMBER

Total volume carried by LTLs in this plan
TOTAL_LTL_ORDERS NUMBER

Total number of orders carried by LTLs in this plan
TOTAL_LTL_PALLETS NUMBER

Total number of pallets carried by LTLs in this plan
TOTAL_LTL_COST NUMBER

Total cost of LTLs in this plan
TOTAL_LTL_PIECES NUMBER

Total number of pieces carried by LTLs in this plan
TOTAL_PARCEL_PIECES NUMBER

Total number of pieces carried by Parcels in this plan
TOTAL_PARCEL_WEIGHT NUMBER

Total weight carried by Parcels in this plan
TOTAL_PARCEL_VOLUME NUMBER

Total volume carried by Parcels in this plan
TOTAL_PARCEL_ORDERS NUMBER

Total number of orders carried by Parcels in this plan
TOTAL_PARCEL_PALLETS NUMBER

Total number of pallets carried by Parcels in this plan
TOTAL_PARCEL_COST NUMBER

Total cost of Parcels in this plan
TOTAL_CM_COST NUMBER

Total cost of continuous moves in this plan
TOTAL_CM_WEIGHT NUMBER

Total delivery weight in continuous moves
TOTAL_CM_VOLUME NUMBER

Total delivery volume in continuous moves
TOTAL_CM_PALLETS NUMBER

Total number of palltes in continuous moves
TOTAL_CM_ORDERS NUMBER

Total distinct orders in continuous moves
TOTAL_CM_PIECES NUMBER

Total number of request_quantity in continuous moves
TOTAL_COST_NO_CONSOLIDATION NUMBER

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

Audit Request Id
REQUEST_ID NUMBER

Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
DISABLE_DATE DATE

not in use
REFRESH_NUMBER NUMBER

refresh number for snapshot
SYSTEM_DATE_OFFSET NUMBER

Plan start date offset from current date defind in template plan
PLAN_DAYS NUMBER

Default number of plan days defined in template
PROGRAM NUMBER

NULL:no program is running; 1: update orders; 2: launch plan; 3:reoptimize; 4: start online planner; 5: stop online planner; 6: recalculate exceptions; 7: recalculate KPIs; 8: audit reports
STATE NUMBER

NULL:initial state or no plan has been launched; 0:pending; 1:lauch plan with snapshot only has finished; 2:launch plan iwth optimization finished; 3:start online planner is done; 4:program is running
Query Text

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


SELECT PLAN_ID
,      PLAN_TYPE
,      COMPILE_DESIGNATOR
,      DESCRIPTION
,      START_DATE
,      CUTOFF_DATE
,      PLAN_START_DATE
,      PLAN_COMPLETION_DATE
,      DATA_START_DATE
,      DATA_COMPLETION_DATE
,      OUTSIDE_PROCESSING_FLAG
,      DROP_SHIPMENT_FLAG
,      SHIP_FROM_SUPPLIER_FLAG
,      SHIP_TO_CUSTOMER_FLAG
,      RETURN_TO_SUPPLIER_FLAG
,      RETURN_FROM_CUSTOMER_FLAG
,      INT_INBOUND_ALL_FLAG
,      INT_OUTBOUND_ALL_FLAG
,      EXT_OUTBOUND_ALL_FLAG
,      EXT_INBOUND_ALL_FLAG
,      OPTIMIZATION_STRATEGY_FLAG
,      POOLING_FLAG
,      MULTI_STOP_TL_FLAG
,      CONTINUOUS_MOVE_FLAG
,      RELEASE_RUNNING_FLAG
,      ENGINE_ACTIVE_FLAG
,      OPTIMIZED_FLAG
,      PALLETIZE_FLAG
,      PLAN_OPTION_CHANGED
,      TARGET_TL_UTILIZATION
,      MIN_TL_UTILIZATION
,      LOCAL_POOLING_SHIPMENT_SIZE
,      LOCAL_POOLING_RADIUS
,      STOP_NEIGHBORHOOD_RADIUS
,      GENERAL_POOLING_RADIUS
,      MAXIMUM_EMPTY_LEG_LENGTH
,      POOL_POINT_COUNT
,      LOADING_UNLOADING_CHARGE
,      LAYOVER_CHARGES
,      ORIGIN_DESTINATION_TL_CHRGS
,      OTHER_TL_CHARGES
,      OTHER_LTL_CHARGES
,      OTHER_PARCEL_CHARGES
,      LTL_DISCOUNT
,      PARCEL_DISCOUNT
,      AUTO_RELEASE
,      AUTO_REL_RULE_SET_ID
,      COMMITMENT_SET_ID
,      CURRENCY_UOM
,      DIMENSION_UOM
,      DISTANCE_UOM
,      TIME_UOM
,      VOLUME_UOM
,      WEIGHT_UOM
,      TOTAL_ORDERS
,      TOTAL_PALLETS
,      TOTAL_PIECES
,      TOTAL_VOLUME
,      TOTAL_WEIGHT
,      TOTAL_PLAN_COST
,      TOTAL_TL_COST
,      TOTAL_TL_ORDERS
,      TOTAL_TL_PALLETS
,      TOTAL_TL_PIECES
,      TOTAL_TL_VOLUME
,      TOTAL_TL_WEIGHT
,      TOTAL_LTL_WEIGHT
,      TOTAL_LTL_VOLUME
,      TOTAL_LTL_ORDERS
,      TOTAL_LTL_PALLETS
,      TOTAL_LTL_COST
,      TOTAL_LTL_PIECES
,      TOTAL_PARCEL_PIECES
,      TOTAL_PARCEL_WEIGHT
,      TOTAL_PARCEL_VOLUME
,      TOTAL_PARCEL_ORDERS
,      TOTAL_PARCEL_PALLETS
,      TOTAL_PARCEL_COST
,      TOTAL_CM_COST
,      TOTAL_CM_WEIGHT
,      TOTAL_CM_VOLUME
,      TOTAL_CM_PALLETS
,      TOTAL_CM_ORDERS
,      TOTAL_CM_PIECES
,      TOTAL_COST_NO_CONSOLIDATION
,      AUDIT_REQUEST_ID
,      REQUEST_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      DISABLE_DATE
,      REFRESH_NUMBER
,      SYSTEM_DATE_OFFSET
,      PLAN_DAYS
,      PROGRAM
,      STATE
FROM MST.MST_PLANS;

Dependencies

[top of page]

MST.MST_PLANS does not reference any database object

MST.MST_PLANS is referenced by following:

SchemaAPPS
SynonymMST_PLANS