1. Tables and Views for SCM
  2. MSC_SYSTEM_ITEMS

MSC_SYSTEM_ITEMS

MSC_SYSTEM_ITEMS stores the organization items defined at source applications. It also stores a copy of items planned by the planning process. Most of the columns in MSC_SYSTEM_ITEMS correspond to columns from the Oracle Inventory Item mast.

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

MSC_SYSTEM_ITEMS_PK

PLAN_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID, NEW_PLAN_ID, SIMULATION_SET_ID, PART_KEY1

Columns

Name Datatype Length Precision Not-null Comments Status
PLAN_ID NUMBER Yes This value indicates the plan identifier for the record. Active
DEMAND_TIME_FENCE_DATE DATE Demand time fence date for this item org in this plan
PLANNING_TIME_FENCE_DATE DATE Planning time fence date for this item org in this
RELEASE_TIME_FENCE_DATE DATE Release time fence date for this item org in this plan
ORGANIZATION_ID NUMBER 18 Yes Organization identifier, foreign key to msc_parameters Active
INVENTORY_ITEM_ID NUMBER 18 Yes Identifies the inventory item id Active
PART_KEY1 NUMBER 18 Yes Source application instance identifier Active
ITEM_NAME VARCHAR2 300 Identifies the inventory item name Active
LOTS_EXPIRATION NUMBER 38 Shelf_life_days from MTL_SYSTEM_ITEMS??? Active
LOT_CONTROL_CODE NUMBER Yes Flag indicating if lots_expiration is used or not Active
SHRINKAGE_RATE NUMBER Percentage of shinkage for this item Active
FIXED_DAYS_SUPPLY NUMBER Period of the supply days (in days) Active
FIXED_ORDER_QUANTITY NUMBER Fixed order quantity for Vendor managed inventory Active
FIXED_LOT_MULTIPLIER NUMBER Fixed quantitiy that a lot can contain Active
MINIMUM_ORDER_QUANTITY NUMBER Minimum size of an order for this item Active
MAXIMUM_ORDER_QUANTITY NUMBER Maximum size of an order for the inventory item. Active
ROUNDING_CONTROL_TYPE NUMBER Yes Flag indicating if rounding of the quantity is allowed Active
PLANNING_TIME_FENCE_CODE NUMBER Planning time fence code of the inventory item. Active
PLANNING_TIME_FENCE_DAYS NUMBER Planning time fences days of the item Active
DEMAND_TIME_FENCE_DAYS NUMBER This value indicates the Demand time fence days. Active
DEMAND_TIME_FENCE_CODE NUMBER Demanding time fence code as computed by the planning engine Active
DESCRIPTION VARCHAR2 240 Textual description of the item for UI and reports Active
RELEASE_TIME_FENCE_CODE NUMBER Release time fence code. Used during Auto release of the supplies within this time fence. Active
RELEASE_TIME_FENCE_DAYS NUMBER Release time fence days. Used during Auto release of the supplies within this time fence. Active
MRP_PLANNING_CODE NUMBER Yes Type of planning required for this item: MRP(3), MPS(4), Not Planned(6), MRP and DRP(7), MPS and DRP(8), DRP(9) Active
FIXED_LEAD_TIME NUMBER Represents the fixed lead time used to calculate the operations start and end date for the supplier operation. Active
VARIABLE_LEAD_TIME NUMBER Variable lead time used in conjunction with the quantity of the item. Active
PREPROCESSING_LEAD_TIME NUMBER Pre processing lead time used in supply network for supply generation. Active
POSTPROCESSING_LEAD_TIME NUMBER Post processing lead time used in supply network for supply generation. Active
FULL_LEAD_TIME NUMBER Full lead time defined for an inventory item at item organization level. Active
CUMULATIVE_TOTAL_LEAD_TIME NUMBER Cumulative total lead time. This is used during item replenishment. Active
CUM_MANUFACTURING_LEAD_TIME NUMBER Cumulative manufacturing lead time Active
UOM_CODE VARCHAR2 3 Yes Unit of measure code of the inventory item. Active
UNIT_WEIGHT NUMBER Unit of measure of the weight class of the item.
UNIT_VOLUME NUMBER Unit of measure of the volume class of the item.
WEIGHT_UOM VARCHAR2 3 This value indicates the unit of measure defined in terms of weight.
VOLUME_UOM VARCHAR2 3 This value indicates the unit of measure defined in terms of volume.
PRODUCT_FAMILY_ID NUMBER 18 This stores the value of Product family identifier if the item is part of product family. Active
ATP_COMPONENTS_FLAG VARCHAR2 1 Yes Flag indicating whether to calculate components ATP Active
BUILD_IN_WIP_FLAG NUMBER Yes Flag to indicate if the item can be built in WIP Active
PURCHASING_ENABLED_FLAG NUMBER Yes Flag to indicate if the item can be purchased Active
PLANNING_MAKE_BUY_CODE NUMBER Yes Indicate if this item should be made or bought. Make(1), Buy(2) Active
CARRYING_COST NUMBER Inventory carrying cost for the inventory item. Active
ORDER_COST NUMBER This value indicates the order cost of the item. Active
MATERIAL_COST NUMBER This value indicates the material cost for the inventory item. Active
RESOURCE_COST NUMBER The value indicates resource code collected from source system. Active
SUPPLIER_CAP_OVERUTIL_COST NUMBER Supplier cap over utilization cost Active
LIST_PRICE NUMBER The list price of this item per unit Active
AVERAGE_DISCOUNT NUMBER Average discount on the price of the item Active
WIP_SUPPLY_TYPE NUMBER Flag to indicate whether this a phantom (order modifiers are not used) Active
SAFETY_STOCK_CODE NUMBER Yes Safety stock code: User-defined quantity(1), User-defined percentage(2), or mean absolute deviation Active
SAFETY_STOCK_PERCENT NUMBER Percent of average gross requirment for dynamically calculated safety-stocks Active
SAFETY_STOCK_BUCKET_DAYS NUMBER Days over which to average demand for MRP Planned safety stock percent Active
PLANNER_CODE VARCHAR2 10 This value indicates the Planner code associated with the record. Active
BOM_ITEM_TYPE NUMBER BOM item type: Model(1), Option Class(2), Planning(3), Standard(4), Product Family(5) Active
ATO_FORECAST_CONTROL NUMBER ATO forecast control code: Consume(1), Consume and derive(2), None(3) Active
EFFECTIVITY_CONTROL NUMBER Yes Effectivity control code: Date Effectivity(1), Unit Number effectivity(2) Active
ORGANIZATION_CODE VARCHAR2 49 Organization code (use for UI and report) Active
ACCEPTABLE_EARLY_DELIVERY NUMBER The value indicates acceptable early delivery range. Active
CALCULATE_ATP NUMBER Yes Flag indicating whether to calculate ATP when planning this part Active
INVENTORY_ITEM_FLAG NUMBER Indicates whether the item is an inventory item Active
BASE_ITEM_ID NUMBER 18 Base item identifier for configuration Active
ATP_FLAG NUMBER Yes Flag used for ATP. Possible values 1(Yes), 2(No). Active
PICK_COMPONENTS_FLAG NUMBER Flag indicating whether all shippable components should be picked Active
REPLENISH_TO_ORDER_FLAG NUMBER Flag indicating item to be planned as replenish to order Active
CREATE_SUPPLY_FLAG NUMBER When Create supply is set to No, new planned orders are not created for the item in constrained plans Active
VMI_FIXED_ORDER_QUANTITY NUMBER Fixed order quantity. Used in vendor managed inventory. Active
LIFE_CYCLE_PHASE VARCHAR2 120 This value indicates the Life cycle phase defined for an item.
SHIPPABLE_ITEM_FLAG NUMBER Flag indicates whether item can shipped. 1-Yes, 2-No.
CUSTOMER_ORDER_FLAG NUMBER Flag indicates whether the item is customer orderable or not. 1-Yes, 2-No.
SHIP_MODEL_COMPLETE_FLAG NUMBER Ship model complete flag. Indicates if the PTO is SMC enabled.
BACK_TO_BACK_FLAG NUMBER Indicates whether a item is a back-to-back item.
ENGINEERING_ITEM_FLAG NUMBER Flag indicating whether this is an ECO item
MIN_SHELF_LIFE_DAYS NUMBER Minimum shelf life days demand for the demand.
REFRESH_NUMBER NUMBER Refresh identifier populated by the collection program. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. Active
PROGRAM_APPLICATION_ID NUMBER This value indicates the Program application identifier. Active
PROGRAM_ID NUMBER This value indicates the Program identifier. Active
PROGRAM_UPDATE_DATE DATE This value indicates the update date of the program. Active
NEW_PLAN_ID NUMBER Yes Incremental plan id used in conjunction with new_plan_list Active
NEW_PLAN_LIST VARCHAR2 256 List indicates the new plan identifiers for the record. Active
SIMULATION_SET_ID NUMBER Yes Simulation set to which the current record is added. Active
APPLIED NUMBER Flag used for online replanning Active
CONSIDER_IN_CTB_FLAG VARCHAR2 1 Yes/No flag indicating CTB calculation to be considered for the item.
CALCULATE_CTB_FLAG VARCHAR2 1 Yes/No flag indicating CTB calculation for the item.
CTB_KPI_HORIZON DATE The value indicates CTB KPI date range.
NO_PL_ORD_BEFORE_WIP_WIN NUMBER This value indicates whether planned order can be generated before WIP WIN.
EXCESS_HORIZON NUMBER This value indicates the excess horizon of the item.
PLANNING_UNITS_OF_WORK NUMBER Planning units of work specified for the inventory item.
OBSOLESCENCE_DATE DATE This value indicates the Obsolescence date specified for the inventory item.
SAFETY_STOCK_QUANTITY NUMBER Safety stock quantity for the inventory item.
SAFETY_STOCK_QUANTITY_OVERRIDE NUMBER Safety stock quantity override value for the inventory item.
FORECAST_NAME VARCHAR2 256 Unique Name assigned to the forecast Obsolete
SERVICE_LEVEL_PERCENT NUMBER Service level percent specified in the shipping method.
FORECAST_ERROR_TYPE VARCHAR2 30 This value indicates the forecast error type.
MAD NUMBER MAD defined for the inventory item. This is populated by engine/UI.
MAD_OVERRIDE NUMBER MAD_OVERRIDE defined for the inventory item. This is populated by engine/UI.
MAPE NUMBER MAPE defined for the inventory item. This is populated by engine/UI.
SS_FORECAST_PLAN_ID NUMBER 18 Safety stock forecast plan identifier value.
SS_FORECAST_MEASURE_ID NUMBER 18 Safety stock forecast measure identifier.
MAPE_OVERRIDE NUMBER MAPE_OVERRIDE defined for the inventory item. This is populated by engine/UI.
INTERMITTENT_DEMAND NUMBER Flag indicates whether the item is for the intermittent demand.
INTERMITTENT_DEMAND_OVERRIDE NUMBER User value to override the system calculated Intermittent Demand
AVG_INTERARRIVAL_TIME NUMBER Average inter-arrival time of the inventory item.
AVG_INTERARRIVAL_TIME_OVERRIDE NUMBER Average inter-arrival time of the inventory item.
SAFETY_STOCK_NEEDS_RECALC NUMBER Flag indicates whether safety stock for the item needs recalculation.
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE1 VARCHAR2 20 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE2 VARCHAR2 20 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE3 VARCHAR2 20 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE4 VARCHAR2 20 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE5 VARCHAR2 20 Descriptive Flexfield: segment of the user descriptive flexfield.
BUYER_NAME VARCHAR2 240 Name of the buyer of the inventory item, used for reporting.
REVISION VARCHAR2 3 Inventory item revision code for the item.
REDUCE_MPS NUMBER 18 This value indicates the Reduce MPS.
DMD_LATENESS_COST NUMBER Demand lateness cost for independent demands
ITEM_COST_OVERRIDE NUMBER Item cost entered from VCP UI to override value collected from source
ABC_CLASS_NAME VARCHAR2 40 This is the name of the ABC class for the item.
SOURCE_ORG_ID NUMBER This value indicates the Organization identifier of the item source.
CRITICAL_COMPONENT_FLAG NUMBER Critical component flag of item.
ENABLE_SUPPLY_ORCHESTRATION NUMBER 1 Enable_Supply_Orchestration values: 1- Yes, 2-No Obsolete
SUPPLY_ORCHESTRATION_ENABLED NUMBER 1 Flag indicates whether the item is enabled for Supply chain orchestration.
AUTO_CREATED_CONFIG_FLAG NUMBER 1 Auto-created Configuration Flag values: 1- Yes, 2-No
AVG_BATCH_SIZE NUMBER 18 Plan measure containing average batch sizes used in safety stock calculations
AVG_BATCH_SIZE_OVERRIDE NUMBER 18 User can override the system generated Average Batch Size by using this field
SAFETY_STOCK_FORECAST_PLAN VARCHAR2 30 Plan name of the measure used for safety stocks. This column is not populated by collection. Obsolete
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
ATTRIBUTE_CHAR1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR16 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR17 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR18 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR19 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR20 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
GLOBAL_ATTRIBUTE_CHAR1 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_CHAR2 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_CHAR3 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_CHAR4 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_CHAR5 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_CHAR6 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_CHAR7 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_CHAR8 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_CHAR9 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_CHAR10 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_CHAR11 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_CHAR12 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_CHAR13 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_CHAR14 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_CHAR15 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_CHAR16 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_CHAR17 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_CHAR18 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_CHAR19 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_CHAR20 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER1 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER2 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER3 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER4 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER5 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE1 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE2 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE3 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE4 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE5 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
CONSUME_BEF_PRIMARY_FLAG NUMBER This attribute controls whether to consume substitutes existing supplies before creating new supplies of this item.
COMP_SUBSTITUTION_FLAG NUMBER This attribute controls whether to consume substitutes existing supplies before creating new supplies of this item.
SIM_EDIT_FLAGS NUMBER Indicates which columns are edited in simulation set records
ORDER_MODIFIER_TO_START_QTY NUMBER Flag indicates Apply Order Modifier to Start Quantity: Yes(1), No(2); if No, it means Apply Order Modifier to Order Quantity.
ENFORCE_PURCHASE_LT NUMBER 1 The column indicates whether the Purchase lead time has to be enforced: Yes(1) means enforced. No(2) means not enforced. Default value is Yes.
SEGMENT_ID NUMBER 18 Foreign key to the msc_segment table, identifies the segment that the item / org belong to
INDIVISIBLE_FLAG NUMBER Attribute indicating whether the item can be ordered in fractions.
SUBINV_FLAG NUMBER 1 Indicates whether its item+org / item+subinv
IN_SOURCE_PLAN NUMBER Flag indicating whether the item is in the plan (the snapshot initially gets more items than the planned items)
HARD_PEGGING_LEVEL VARCHAR2 25 It determines the type of pegging considered by the planning engine during the supply or demand netting process.
COMN_SUPPLY_PRJ_DEMAND_FLAG NUMBER It determines if material can be planned, picked and issued from common inventory if sufficient inventory does not exist in project inventory.
LEAD_TIME_LOT_SIZE NUMBER Attribute indicating quantity used to compute processing lead time.
ASSET_TRACKED_FLAG NUMBER Attribute indicating whether item is tracked as an asset in installed base. Valid values are 1-Yes, 2-No.
LEAD_TIME_OFFSET_WEEK_BKTS NUMBER The constrained planning engine will offset the lead time in week buckets by this number of days.
LEAD_TIME_OFFSET_PERIOD_BKTS NUMBER The constrained planning engine will offset the lead time in period/month buckets by this number of days.
CREATE_SUPPLY_AFTER DATE When Create_supply_flag is set to Yes, this date column indicates from when the new planned orders can be created for the item in constrained plans
FORECAST_CUTOFF_DAYS NUMBER Represents the number of days after the Forecast Demand Date which the forecast can be satisfied. The planning engine will not plan for forecasts, if the supply date is later than these many working days. This field is applicable for constrained planning engine only.
LOW_LEVEL_CODE NUMBER A number indicating the order in which items will be planned by replenishment planning engine. Items with lower value are planned ahead of those with a higher value.

Indexes

Index Uniqueness Tablespace Columns Status
MSC_SYSTEM_ITEMS_N1 Non Unique Default PLAN_ID, PLANNER_CODE, ORGANIZATION_ID, INVENTORY_ITEM_ID Active
MSC_SYSTEM_ITEMS_N2 Non Unique Default ITEM_NAME, PLAN_ID, ORGANIZATION_ID Active
MSC_SYSTEM_ITEMS_N3 Non Unique Default PLAN_ID, ORGANIZATION_ID, PRODUCT_FAMILY_ID Active
MSC_SYSTEM_ITEMS_N4 Non Unique Default PLAN_ID, INVENTORY_ITEM_ID Active
MSC_SYSTEM_ITEMS_N5 Non Unique Default PLAN_ID, UPPER("ITEM_NAME") Obsolete
MSC_SYSTEM_ITEMS_N6 Non Unique Default PLAN_ID, ORGANIZATION_ID, WIP_SUPPLY_TYPE Active
MSC_SYSTEM_ITEMS_N7 Non Unique Default UPPER("ITEM_NAME")
MSC_SYSTEM_ITEMS_N8 Non Unique Default PLAN_ID, BUYER_NAME, BOM_ITEM_TYPE Active
MSC_SYSTEM_ITEMS_U1 Unique Default PLAN_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID, NEW_PLAN_ID, SIMULATION_SET_ID, PART_KEY1
MSC_SYSTEM_ITEMS_U2 Unique Default PLAN_ID, ORGANIZATION_ID, ITEM_NAME, NEW_PLAN_ID, SIMULATION_SET_ID, PART_KEY1 Active