eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: MSC.MSC_PLANS#

Object Details

Object Name:	MSC_PLANS#
Object Type:	VIEW
Owner:	MSC
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
PLAN_ID	NUMBER		Yes
COMPILE_DESIGNATOR	VARCHAR2	(10)	Yes
SR_INSTANCE_ID	NUMBER		Yes
APPEND_PLANNED_ORDERS	NUMBER
ASSIGNMENT_SET_ID	NUMBER
CURR_APPEND_PLANNED_ORDERS	NUMBER		Yes
CURR_ASSIGNMENT_SET_ID	NUMBER
CURR_BILL_OF_RESOURCES	VARCHAR2	(10)
CURR_CONSIDER_PO	NUMBER
CURR_CONSIDER_RESERVATIONS	NUMBER
CURR_CONSIDER_WIP	NUMBER
CURR_CUTOFF_DATE	DATE		Yes
CURR_DEMAND_TIME_FENCE_FLAG	NUMBER		Yes
CURR_HARD_PEGGING_LEVEL	NUMBER
CURR_FULL_PEGGING	NUMBER
CURR_INCLUDED_ITEMS	NUMBER
CURR_OPERATION_SCHEDULE_TYPE	NUMBER		Yes
CURR_OVERWRITE_OPTION	NUMBER		Yes
CURR_PART_INCLUDE_TYPE	NUMBER
CURR_PLANNING_TIME_FENCE_FLAG	NUMBER		Yes
CURR_PLAN_CAPACITY_FLAG	NUMBER
CURR_PLAN_SAFETY_STOCK	NUMBER
CURR_PLAN_TYPE	NUMBER		Yes
CURR_RESERVATION_LEVEL	NUMBER
CURR_SCHEDULE_DESIGNATOR	VARCHAR2	(10)
CURR_SCHEDULE_TYPE	NUMBER
CURR_SIMULATION_SET	VARCHAR2	(10)
CURR_SNAPSHOT_LOCK	NUMBER
CURR_SPLIT_DEMANDS	NUMBER
CURR_START_DATE	DATE		Yes
CUTOFF_DATE	DATE
DAILY_CUTOFF_BUCKET	NUMBER		Yes
DAILY_ITEM_AGGREGATION_LEVEL	NUMBER		Yes
DAILY_MATERIAL_CONSTRAINTS	NUMBER		Yes
DAILY_RESOURCE_CONSTRAINTS	NUMBER		Yes
DAILY_RES_AGGREGATION_LEVEL	NUMBER		Yes
DAILY_TRANS_CONSTRAINTS	NUMBER
DATA_COMPLETION_DATE	DATE
DATA_START_DATE	DATE
DEMAND_TIME_FENCE_FLAG	NUMBER
DESCRIPTION	VARCHAR2	(50)
DMD_LATENESS_PENALTY_COST	NUMBER
HARD_PEGGING_LEVEL	NUMBER
FULL_PEGGING	NUMBER
HOUR_CUTOFF_BUCKET	NUMBER
INCLUDED_ITEMS	NUMBER
MIN_CUTOFF_BUCKET	NUMBER
MONTHLY_CUTOFF_BUCKET	NUMBER
OBJECTIVE_WEIGHT_1	NUMBER
OBJECTIVE_WEIGHT_10	NUMBER
OBJECTIVE_WEIGHT_2	NUMBER
OBJECTIVE_WEIGHT_3	NUMBER
OBJECTIVE_WEIGHT_4	NUMBER
OBJECTIVE_WEIGHT_5	NUMBER
OBJECTIVE_WEIGHT_6	NUMBER
OBJECTIVE_WEIGHT_7	NUMBER
OBJECTIVE_WEIGHT_8	NUMBER
OBJECTIVE_WEIGHT_9	NUMBER
OPERATION_SCHEDULE_TYPE	NUMBER
ORGANIZATION_ID	NUMBER		Yes
ORGANIZATION_SELECTION	NUMBER
OVERWRITE_OPTION	NUMBER
PART_INCLUDE_TYPE	NUMBER
PENALTY_COST_1	NUMBER
PENALTY_COST_10	NUMBER
PENALTY_COST_2	NUMBER
PENALTY_COST_3	NUMBER
PENALTY_COST_4	NUMBER
PENALTY_COST_5	NUMBER
PENALTY_COST_6	NUMBER
PENALTY_COST_7	NUMBER
PENALTY_COST_8	NUMBER
PENALTY_COST_9	NUMBER
PLANNED_REFRESHES	VARCHAR2	(10)
PLANNING_TIME_FENCE_FLAG	NUMBER
PLAN_CAPACITY_FLAG	NUMBER
PLAN_COMPLETION_DATE	DATE
PLAN_START_DATE	DATE
PLAN_TYPE	NUMBER
QTRLY_CUTOFF_BUCKET	NUMBER
RESERVATION_LEVEL	NUMBER
RESOURCE_OVER_UTIL_COST	NUMBER
SCHEDULE_DESIGNATOR	VARCHAR2	(10)
SCHEDULE_TYPE	NUMBER
SLACK_ALLOWED_FLAG_1	NUMBER
SLACK_ALLOWED_FLAG_10	NUMBER
SLACK_ALLOWED_FLAG_2	NUMBER
SLACK_ALLOWED_FLAG_3	NUMBER
SLACK_ALLOWED_FLAG_4	NUMBER
SLACK_ALLOWED_FLAG_5	NUMBER
SLACK_ALLOWED_FLAG_6	NUMBER
SLACK_ALLOWED_FLAG_7	NUMBER
SLACK_ALLOWED_FLAG_8	NUMBER
SLACK_ALLOWED_FLAG_9	NUMBER
SNAPSHOT_LOCK	NUMBER
SPLIT_DEMANDS	NUMBER
START_DATE	DATE
SUPPLIER_CAP_OVER_UTIL_COST	NUMBER
WEEKLY_CUTOFF_BUCKET	NUMBER		Yes
WEEKLY_ITEM_AGGREGATION_LEVEL	NUMBER		Yes
WEEKLY_MATERIAL_CONSTRAINTS	NUMBER		Yes
WEEKLY_RESOURCE_CONSTRAINTS	NUMBER		Yes
WEEKLY_RES_AGGREGATION_LEVEL	NUMBER		Yes
WEEKLY_TRANS_CONSTRAINTS	NUMBER
OPTIMIZE_FLAG	NUMBER		Yes
SCHEDULE_FLAG	NUMBER		Yes
ONLINE_PLANNER_START_DATE	DATE
ONLINE_PLANNER_COMPLETION_DATE	DATE
TRANSPORT_CAP_OVER_UTIL_COST	NUMBER
BILL_OF_RESOURCES	VARCHAR2	(10)
SIMULATION_SET	VARCHAR2	(10)
CONSIDER_WIP	NUMBER
CONSIDER_PO	NUMBER
PLAN_SAFETY_STOCK	NUMBER
CONSIDER_RESERVATIONS	NUMBER
CURR_ENFORCE_DEM_DUE_DATES	NUMBER		Yes
ENFORCE_DEM_DUE_DATES	NUMBER
PLANNED_RESOURCES	NUMBER
CURR_PLANNED_RESOURCES	NUMBER		Yes
DEM_PRIORITY_RULE_ID	NUMBER
CURR_DEM_PRIORITY_RULE_ID	NUMBER
DAILY_RTG_AGGREGATION_LEVEL	NUMBER		Yes
WEEKLY_RTG_AGGREGATION_LEVEL	NUMBER		Yes
PERIOD_RTG_AGGREGATION_LEVEL	NUMBER
PERIOD_CUTOFF_BUCKET	NUMBER		Yes
LOT_FOR_LOT_FLAG	NUMBER
ENFORCE_CAP_CONSTRAINTS	NUMBER
CURR_ENFORCE_CAP_CONSTRAINTS	NUMBER
SERVICE_LEVEL	NUMBER
BOTTLENECK_RES_GROUP	VARCHAR2	(30)
CURR_BOTTLENECK_RES_GROUP	VARCHAR2	(30)
PERIOD_MATERIAL_CONSTRAINTS	NUMBER		Yes
PERIOD_RESOURCE_CONSTRAINTS	NUMBER		Yes
PERIOD_TRANS_CONSTRAINTS	NUMBER
PERIOD_ITEM_AGGREGATION_LEVEL	NUMBER		Yes
PERIOD_RES_AGGREGATION_LEVEL	NUMBER		Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes
CREATION_DATE	DATE		Yes
LOT_FOR_LOT	NUMBER	(1)
CREATED_BY	NUMBER		Yes
LAST_UPDATE_LOGIN	NUMBER
ATTRIBUTE1	VARCHAR2	(150)
ATTRIBUTE2	VARCHAR2	(150)
ATTRIBUTE3	VARCHAR2	(150)
ATTRIBUTE4	VARCHAR2	(150)
ATTRIBUTE5	VARCHAR2	(150)
ATTRIBUTE6	VARCHAR2	(150)
ATTRIBUTE7	VARCHAR2	(150)
ATTRIBUTE8	VARCHAR2	(150)
ATTRIBUTE9	VARCHAR2	(150)
ATTRIBUTE10	VARCHAR2	(150)
ATTRIBUTE11	VARCHAR2	(150)
ATTRIBUTE12	VARCHAR2	(150)
ATTRIBUTE13	VARCHAR2	(150)
ATTRIBUTE14	VARCHAR2	(150)
ATTRIBUTE15	VARCHAR2	(150)
ATTRIBUTE_CATEGORY	VARCHAR2	(30)
REQUEST_ID	NUMBER
PROGRAM_APPLICATION_ID	NUMBER
PROGRAM_ID	NUMBER
PROGRAM_UPDATE_DATE	DATE
MIN_WF_EXCEPT_ID	NUMBER
MAX_WF_EXCEPT_ID	NUMBER
ONLINE_REPLAN	NUMBER
REFRESH_NUMBER	NUMBER
REVISION	VARCHAR2	(30)
PARENT_PLAN_ID	NUMBER
STATUS	NUMBER
PRODUCTION_FLAG	NUMBER
COMPANY_AGG_LEVEL	NUMBER
TP_AGG_LEVEL	NUMBER
PRODUCT_AGG_LEVEL	NUMBER
PURGE	NUMBER
ENFORCE_SL_CONSTRAINTS	NUMBER
CURR_ENFORCE_SL_CONSTRAINTS	NUMBER
PLAN_INVENTORY_POINT	NUMBER
ENABLE_CLOSEST_QTY_PEGGING	NUMBER
CURR_CLOSEST_QTY_PEG	NUMBER
ENABLE_PRIORITY_PEGGING	NUMBER
CURR_PRIORITY_PEGGING	NUMBER
ENFORCE_SRC_CONSTRAINTS	NUMBER
CURR_ENFORCE_SRC_CONSTRAINTS	NUMBER
BACKWARD_DAYS	NUMBER
CURR_BACKWARD_DAYS	NUMBER
FORWARD_DAYS	NUMBER
CURR_FORWARD_DAYS	NUMBER
SUMMARY_FLAG	NUMBER
USE_ALTERNATE_RESOURCES	NUMBER
USE_END_ITEM_SUBSTITUTIONS	NUMBER
USE_ALTERNATE_BOM_ROUTING	NUMBER
USE_SUBSTITUTE_COMPONENTS	NUMBER
USE_ALTERNATE_SOURCES	NUMBER
SUBSTITUTION_DESIGNATOR	VARCHAR2	(50)
KPI_REFRESH	NUMBER
DISPLAY_KPI	NUMBER
FORECAST_ALLOCATION_METHOD	NUMBER
FORECAST_CONSUMPTION_METHOD	NUMBER
COPY_PLAN_ID	NUMBER
EXPLODE_FORECAST	NUMBER
FORECAST_ASSIGNMENT_SET_ID	NUMBER
ENFORCE_SUP_CAP_CONSTRAINTS	NUMBER
ENFORCE_PUR_LT_CONSTRAINTS	NUMBER
TGT_TL_UTIL_PCT	NUMBER
MIN_TL_UTIL_PCT	NUMBER
LOAD_SCHED_TIME_FENCE_DAYS	NUMBER
LOAD_SCHEDULING_DAYS	NUMBER
DAILY_ALLOC_BUCKETS	NUMBER
WKS_PER_WKLY_ALLOC_BUCKET	NUMBER
DMD_PRI_RULE_SET_ID	NUMBER
CIRC_SRCING_SURPLUS_DAYS	NUMBER
SUPPLY_SCHED_ITF	NUMBER
INCLUDE_CRITICAL_COMPONENTS	NUMBER
SCHEDULE_BY	NUMBER
PUBLISH_FCST_VERSION	NUMBER
RELEASE_RESCHEDULES	NUMBER
SAFETY_STK_CHANGE_INTERVAL	NUMBER
SAFETY_STK_THRESHOLD_PCT	NUMBER
COPY_PLAN	NUMBER
ENFORCE_USER_SAFETY_STOCKS	NUMBER
ENFORCE_BUDGET_CONSTRAINTS	NUMBER
BUDGET_ID	NUMBER
BUDGET_VALUE	NUMBER
LATEST_REFRESH_NUMBER	NUMBER
SUPPLIER_ALLOC_METHOD	NUMBER
CUSTOMER_ALLOC_METHOD	NUMBER
DEFAULT_ALLOC_METHOD	NUMBER
USE_FIXED_PERIOD_BKTS	VARCHAR2	(1)
SHIPMENT_CONSOLIDATION_DAYS	NUMBER
ITF_HORIZ_DAYS	NUMBER
USE_ORG_PRIORITY_OVERRIDE	VARCHAR2	(1)
USE_FIXED_PERIOD_ALLOC_BKTS	VARCHAR2	(1)
SCHEDULE_BY_DATE_TYPE	NUMBER
DS_SUBSET_HORIZON_DAYS	NUMBER
SCHEDULE_DAYS_BEFORE	NUMBER
SCHEDULE_START_TIME	NUMBER
SCHEDULE_SUBSET_TYPE	NUMBER
INCLUDE_WO	NUMBER
ENFORCE_PURCH_LEAD_TIME	NUMBER
USER_UPDATE_FIRM	NUMBER
DEMAND_PRIORITY_SENSITIVITY	NUMBER
EARLY_BUILD_PENALTY	NUMBER
AUTO_RELEASE_TIME_FENCE	NUMBER
SUBSET_DESIGNATOR_ID	NUMBER
INCLUDE_PLANNED_ORDER	NUMBER
CURR_INCLUDE_PLANNED_ORDER	NUMBER
CURR_INCLUDE_WO	NUMBER
CURR_DS_HORIZON_DAYS	NUMBER
CURR_SCHEDULE_SUBSET_TYPE	NUMBER
CURR_SUBSET_DESIGNATOR_ID	NUMBER
CALCULATE_SDS_DAYS_TIME	NUMBER
CALCULATE_SDS_WEEKS_TIME	NUMBER
CALCULATE_SDS_PERIODS_TIME	NUMBER
FIRM_OUTSIDE_SUBSET	NUMBER
ENABLE_SO_SPLIT	NUMBER
DS_HORIZON_DAYS	NUMBER
PLANNING_MODE	NUMBER
SDS_DMD_PENALTY	NUMBER
CURR_OLS_HORIZON_DAYS	NUMBER
OLS_FROZEN_HORIZON_DAYS	NUMBER
CALCULATE_LIABILITY	NUMBER
CURR_ENF_FULFILLMENT_LT	NUMBER
ENFORCE_FULFILLMENT_LT	NUMBER
DEMAND_FULFILLMENT_LT	NUMBER
MFG_LT_VAR_PERCENT	NUMBER
SUP_LT_VAR_PERCENT	NUMBER
TRANSIT_LT_VAR_PERCENT	NUMBER
SERVICE_LEVEL_SET_ID	NUMBER
CURR_SERVICE_LEVEL_SET_ID	NUMBER
PLAN_RUN_DATE	DATE
ITEM_SIMULATION_SET_ID	NUMBER
PUBLISH_SUPPLY_COMMIT_VERSION	NUMBER
PLANNED_BUCKET	NUMBER
PLANNED_BUCKET_TYPE	NUMBER
ASSIGNMENT_SET_OUT_ID	NUMBER
CATEGORY_SET_ID	NUMBER
SOP_ENABLED	NUMBER
CONSTRAINED_MODE	NUMBER
MANUAL_FCST_OVERWRITE_OPTION	NUMBER
ENFORCE_CONSTRAINTS	NUMBER
SAFETY_STOCK_VALUE_TYPE	NUMBER
REALLOC_SURPLUS_DAYS	NUMBER
PERFORM_FAIR_SHARE_ALLOC	NUMBER
INCLUDE_ALL_ITEMS	NUMBER
INCLUDE_ALL_CATEGORIES	NUMBER
AUTO_RELEASE_METHOD	NUMBER
INCLUDE_RESCHEDULES	NUMBER
CALENDAR_TYPE	NUMBER
HISTORY_RANGE	NUMBER
HISTORY_RANGE_UOM	NUMBER
FORECAST	NUMBER
FORECAST_UOM	NUMBER
FORECAST_BUCKET	NUMBER
FORECAST_BUCKET_UOM	NUMBER
GENERATE_INLINE_FORECAST	NUMBER
CIRCULAR_SRC	NUMBER
ARCHIVE_FLAG	NUMBER
APPLIED	NUMBER
BASE_PLAN_ID	NUMBER
HAS_RUN	NUMBER
LOADED_FLAG	NUMBER
NEW_PLAN_ID	NUMBER
NEW_PLAN_LIST	VARCHAR2	(256)
PLANNING_ENGINE_TYPE	NUMBER
PREVIOUS_RUN_PLAN_ID	NUMBER
SAVED_FLAG	NUMBER
SIMULATION_SET_ID	NUMBER
COMPUTE_SS_EOQ	NUMBER
PRIVATE_PLAN	NUMBER	(1)
RELEASE_FLAG	VARCHAR2	(1)
SAVE_TO_DB	NUMBER
COMPUTE_CONSTRAINTS	NUMBER
BUILD_READY_PCT	NUMBER
RELEASE_SO	NUMBER
AUTO_RELEASE_RP	NUMBER
PLAN_VERSION	NUMBER
RP_USER_ID	NUMBER
DERIVE_RETURN_FCST_FROM_WO	NUMBER
EXCEP_GROUP_ID	NUMBER
DAILY_MWO_AGGR_LVL	NUMBER
WEEKLY_MWO_AGGR_LVL	NUMBER
PERIOD_MWO_AGGR_LVL	NUMBER
PUB_CAP_TO_CMRO	NUMBER
ENFORCE_WRH_CPTY	NUMBER
ASCP_PLAN_ID	NUMBER
ASCP_PLAN_VERSION	NUMBER
SNAPSHOT_SOURCE	NUMBER
GENERATE_WORKSHEET	NUMBER
SUPPLY_INCLUSION_OPTION	NUMBER
CRITERIA_CHANGED	NUMBER
ENABLE_SAFETY_STOCK_RES	NUMBER

Query Text

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


SELECT PLAN_ID
,      COMPILE_DESIGNATOR
,      SR_INSTANCE_ID
,      APPEND_PLANNED_ORDERS
,      ASSIGNMENT_SET_ID
,      CURR_APPEND_PLANNED_ORDERS
,      CURR_ASSIGNMENT_SET_ID
,      CURR_BILL_OF_RESOURCES
,      CURR_CONSIDER_PO
,      CURR_CONSIDER_RESERVATIONS
,      CURR_CONSIDER_WIP
,      CURR_CUTOFF_DATE
,      CURR_DEMAND_TIME_FENCE_FLAG
,      CURR_HARD_PEGGING_LEVEL
,      CURR_FULL_PEGGING
,      CURR_INCLUDED_ITEMS
,      CURR_OPERATION_SCHEDULE_TYPE
,      CURR_OVERWRITE_OPTION
,      CURR_PART_INCLUDE_TYPE
,      CURR_PLANNING_TIME_FENCE_FLAG
,      CURR_PLAN_CAPACITY_FLAG
,      CURR_PLAN_SAFETY_STOCK
,      CURR_PLAN_TYPE
,      CURR_RESERVATION_LEVEL
,      CURR_SCHEDULE_DESIGNATOR
,      CURR_SCHEDULE_TYPE
,      CURR_SIMULATION_SET
,      CURR_SNAPSHOT_LOCK
,      CURR_SPLIT_DEMANDS
,      CURR_START_DATE
,      CUTOFF_DATE
,      DAILY_CUTOFF_BUCKET
,      DAILY_ITEM_AGGREGATION_LEVEL
,      DAILY_MATERIAL_CONSTRAINTS
,      DAILY_RESOURCE_CONSTRAINTS
,      DAILY_RES_AGGREGATION_LEVEL
,      DAILY_TRANS_CONSTRAINTS
,      DATA_COMPLETION_DATE
,      DATA_START_DATE
,      DEMAND_TIME_FENCE_FLAG
,      DESCRIPTION
,      DMD_LATENESS_PENALTY_COST
,      HARD_PEGGING_LEVEL
,      FULL_PEGGING
,      HOUR_CUTOFF_BUCKET
,      INCLUDED_ITEMS
,      MIN_CUTOFF_BUCKET
,      MONTHLY_CUTOFF_BUCKET
,      OBJECTIVE_WEIGHT_1
,      OBJECTIVE_WEIGHT_10
,      OBJECTIVE_WEIGHT_2
,      OBJECTIVE_WEIGHT_3
,      OBJECTIVE_WEIGHT_4
,      OBJECTIVE_WEIGHT_5
,      OBJECTIVE_WEIGHT_6
,      OBJECTIVE_WEIGHT_7
,      OBJECTIVE_WEIGHT_8
,      OBJECTIVE_WEIGHT_9
,      OPERATION_SCHEDULE_TYPE
,      ORGANIZATION_ID
,      ORGANIZATION_SELECTION
,      OVERWRITE_OPTION
,      PART_INCLUDE_TYPE
,      PENALTY_COST_1
,      PENALTY_COST_10
,      PENALTY_COST_2
,      PENALTY_COST_3
,      PENALTY_COST_4
,      PENALTY_COST_5
,      PENALTY_COST_6
,      PENALTY_COST_7
,      PENALTY_COST_8
,      PENALTY_COST_9
,      PLANNED_REFRESHES
,      PLANNING_TIME_FENCE_FLAG
,      PLAN_CAPACITY_FLAG
,      PLAN_COMPLETION_DATE
,      PLAN_START_DATE
,      PLAN_TYPE
,      QTRLY_CUTOFF_BUCKET
,      RESERVATION_LEVEL
,      RESOURCE_OVER_UTIL_COST
,      SCHEDULE_DESIGNATOR
,      SCHEDULE_TYPE
,      SLACK_ALLOWED_FLAG_1
,      SLACK_ALLOWED_FLAG_10
,      SLACK_ALLOWED_FLAG_2
,      SLACK_ALLOWED_FLAG_3
,      SLACK_ALLOWED_FLAG_4
,      SLACK_ALLOWED_FLAG_5
,      SLACK_ALLOWED_FLAG_6
,      SLACK_ALLOWED_FLAG_7
,      SLACK_ALLOWED_FLAG_8
,      SLACK_ALLOWED_FLAG_9
,      SNAPSHOT_LOCK
,      SPLIT_DEMANDS
,      START_DATE
,      SUPPLIER_CAP_OVER_UTIL_COST
,      WEEKLY_CUTOFF_BUCKET
,      WEEKLY_ITEM_AGGREGATION_LEVEL
,      WEEKLY_MATERIAL_CONSTRAINTS
,      WEEKLY_RESOURCE_CONSTRAINTS
,      WEEKLY_RES_AGGREGATION_LEVEL
,      WEEKLY_TRANS_CONSTRAINTS
,      OPTIMIZE_FLAG
,      SCHEDULE_FLAG
,      ONLINE_PLANNER_START_DATE
,      ONLINE_PLANNER_COMPLETION_DATE
,      TRANSPORT_CAP_OVER_UTIL_COST
,      BILL_OF_RESOURCES
,      SIMULATION_SET
,      CONSIDER_WIP
,      CONSIDER_PO
,      PLAN_SAFETY_STOCK
,      CONSIDER_RESERVATIONS
,      CURR_ENFORCE_DEM_DUE_DATES
,      ENFORCE_DEM_DUE_DATES
,      PLANNED_RESOURCES
,      CURR_PLANNED_RESOURCES
,      DEM_PRIORITY_RULE_ID
,      CURR_DEM_PRIORITY_RULE_ID
,      DAILY_RTG_AGGREGATION_LEVEL
,      WEEKLY_RTG_AGGREGATION_LEVEL
,      PERIOD_RTG_AGGREGATION_LEVEL
,      PERIOD_CUTOFF_BUCKET
,      LOT_FOR_LOT_FLAG
,      ENFORCE_CAP_CONSTRAINTS
,      CURR_ENFORCE_CAP_CONSTRAINTS
,      SERVICE_LEVEL
,      BOTTLENECK_RES_GROUP
,      CURR_BOTTLENECK_RES_GROUP
,      PERIOD_MATERIAL_CONSTRAINTS
,      PERIOD_RESOURCE_CONSTRAINTS
,      PERIOD_TRANS_CONSTRAINTS
,      PERIOD_ITEM_AGGREGATION_LEVEL
,      PERIOD_RES_AGGREGATION_LEVEL
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      LOT_FOR_LOT
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      MIN_WF_EXCEPT_ID
,      MAX_WF_EXCEPT_ID
,      ONLINE_REPLAN
,      REFRESH_NUMBER
,      REVISION
,      PARENT_PLAN_ID
,      STATUS
,      PRODUCTION_FLAG
,      COMPANY_AGG_LEVEL
,      TP_AGG_LEVEL
,      PRODUCT_AGG_LEVEL
,      PURGE
,      ENFORCE_SL_CONSTRAINTS
,      CURR_ENFORCE_SL_CONSTRAINTS
,      PLAN_INVENTORY_POINT
,      ENABLE_CLOSEST_QTY_PEGGING
,      CURR_CLOSEST_QTY_PEG
,      ENABLE_PRIORITY_PEGGING
,      CURR_PRIORITY_PEGGING
,      ENFORCE_SRC_CONSTRAINTS
,      CURR_ENFORCE_SRC_CONSTRAINTS
,      BACKWARD_DAYS
,      CURR_BACKWARD_DAYS
,      FORWARD_DAYS
,      CURR_FORWARD_DAYS
,      SUMMARY_FLAG
,      USE_ALTERNATE_RESOURCES
,      USE_END_ITEM_SUBSTITUTIONS
,      USE_ALTERNATE_BOM_ROUTING
,      USE_SUBSTITUTE_COMPONENTS
,      USE_ALTERNATE_SOURCES
,      SUBSTITUTION_DESIGNATOR
,      KPI_REFRESH
,      DISPLAY_KPI
,      FORECAST_ALLOCATION_METHOD
,      FORECAST_CONSUMPTION_METHOD
,      COPY_PLAN_ID
,      EXPLODE_FORECAST
,      FORECAST_ASSIGNMENT_SET_ID
,      ENFORCE_SUP_CAP_CONSTRAINTS
,      ENFORCE_PUR_LT_CONSTRAINTS
,      TGT_TL_UTIL_PCT
,      MIN_TL_UTIL_PCT
,      LOAD_SCHED_TIME_FENCE_DAYS
,      LOAD_SCHEDULING_DAYS
,      DAILY_ALLOC_BUCKETS
,      WKS_PER_WKLY_ALLOC_BUCKET
,      DMD_PRI_RULE_SET_ID
,      CIRC_SRCING_SURPLUS_DAYS
,      SUPPLY_SCHED_ITF
,      INCLUDE_CRITICAL_COMPONENTS
,      SCHEDULE_BY
,      PUBLISH_FCST_VERSION
,      RELEASE_RESCHEDULES
,      SAFETY_STK_CHANGE_INTERVAL
,      SAFETY_STK_THRESHOLD_PCT
,      COPY_PLAN
,      ENFORCE_USER_SAFETY_STOCKS
,      ENFORCE_BUDGET_CONSTRAINTS
,      BUDGET_ID
,      BUDGET_VALUE
,      LATEST_REFRESH_NUMBER
,      SUPPLIER_ALLOC_METHOD
,      CUSTOMER_ALLOC_METHOD
,      DEFAULT_ALLOC_METHOD
,      USE_FIXED_PERIOD_BKTS
,      SHIPMENT_CONSOLIDATION_DAYS
,      ITF_HORIZ_DAYS
,      USE_ORG_PRIORITY_OVERRIDE
,      USE_FIXED_PERIOD_ALLOC_BKTS
,      SCHEDULE_BY_DATE_TYPE
,      DS_SUBSET_HORIZON_DAYS
,      SCHEDULE_DAYS_BEFORE
,      SCHEDULE_START_TIME
,      SCHEDULE_SUBSET_TYPE
,      INCLUDE_WO
,      ENFORCE_PURCH_LEAD_TIME
,      USER_UPDATE_FIRM
,      DEMAND_PRIORITY_SENSITIVITY
,      EARLY_BUILD_PENALTY
,      AUTO_RELEASE_TIME_FENCE
,      SUBSET_DESIGNATOR_ID
,      INCLUDE_PLANNED_ORDER
,      CURR_INCLUDE_PLANNED_ORDER
,      CURR_INCLUDE_WO
,      CURR_DS_HORIZON_DAYS
,      CURR_SCHEDULE_SUBSET_TYPE
,      CURR_SUBSET_DESIGNATOR_ID
,      CALCULATE_SDS_DAYS_TIME
,      CALCULATE_SDS_WEEKS_TIME
,      CALCULATE_SDS_PERIODS_TIME
,      FIRM_OUTSIDE_SUBSET
,      ENABLE_SO_SPLIT
,      DS_HORIZON_DAYS
,      PLANNING_MODE
,      SDS_DMD_PENALTY
,      CURR_OLS_HORIZON_DAYS
,      OLS_FROZEN_HORIZON_DAYS
,      CALCULATE_LIABILITY
,      CURR_ENF_FULFILLMENT_LT
,      ENFORCE_FULFILLMENT_LT
,      DEMAND_FULFILLMENT_LT
,      MFG_LT_VAR_PERCENT
,      SUP_LT_VAR_PERCENT
,      TRANSIT_LT_VAR_PERCENT
,      SERVICE_LEVEL_SET_ID
,      CURR_SERVICE_LEVEL_SET_ID
,      PLAN_RUN_DATE
,      ITEM_SIMULATION_SET_ID
,      PUBLISH_SUPPLY_COMMIT_VERSION
,      PLANNED_BUCKET
,      PLANNED_BUCKET_TYPE
,      ASSIGNMENT_SET_OUT_ID
,      CATEGORY_SET_ID
,      SOP_ENABLED
,      CONSTRAINED_MODE
,      MANUAL_FCST_OVERWRITE_OPTION
,      ENFORCE_CONSTRAINTS
,      SAFETY_STOCK_VALUE_TYPE
,      REALLOC_SURPLUS_DAYS
,      PERFORM_FAIR_SHARE_ALLOC
,      INCLUDE_ALL_ITEMS
,      INCLUDE_ALL_CATEGORIES
,      AUTO_RELEASE_METHOD
,      INCLUDE_RESCHEDULES
,      CALENDAR_TYPE
,      HISTORY_RANGE
,      HISTORY_RANGE_UOM
,      FORECAST
,      FORECAST_UOM
,      FORECAST_BUCKET
,      FORECAST_BUCKET_UOM
,      GENERATE_INLINE_FORECAST
,      CIRCULAR_SRC
,      ARCHIVE_FLAG
,      APPLIED
,      BASE_PLAN_ID
,      HAS_RUN
,      LOADED_FLAG
,      NEW_PLAN_ID
,      NEW_PLAN_LIST
,      PLANNING_ENGINE_TYPE
,      PREVIOUS_RUN_PLAN_ID
,      SAVED_FLAG
,      SIMULATION_SET_ID
,      COMPUTE_SS_EOQ
,      PRIVATE_PLAN
,      RELEASE_FLAG
,      SAVE_TO_DB
,      COMPUTE_CONSTRAINTS
,      BUILD_READY_PCT
,      RELEASE_SO
,      AUTO_RELEASE_RP
,      PLAN_VERSION
,      RP_USER_ID
,      DERIVE_RETURN_FCST_FROM_WO
,      EXCEP_GROUP_ID
,      DAILY_MWO_AGGR_LVL
,      WEEKLY_MWO_AGGR_LVL
,      PERIOD_MWO_AGGR_LVL
,      PUB_CAP_TO_CMRO
,      ENFORCE_WRH_CPTY
,      ASCP_PLAN_ID
,      ASCP_PLAN_VERSION
,      SNAPSHOT_SOURCE
,      GENERATE_WORKSHEET
,      SUPPLY_INCLUSION_OPTION
,      CRITERIA_CHANGED
,      ENABLE_SAFETY_STOCK_RES
FROM MSC.MSC_PLANS#;

Dependencies

[top of page]

MSC.MSC_PLANS# references the following:

MSC: MSC_PLANS

MSC.MSC_PLANS# is referenced by following:

APPS: MSC_PLANS