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


TABLE: MSC.MSC_SYSTEM_ITEMS

Object Details
Object Name: MSC_SYSTEM_ITEMS
Object Type: TABLE
Owner: MSC
FND Design Data: TableMSC.MSC_SYSTEM_ITEMS
Subobject Name:
Status: VALID


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
master table, MTL_SYSTEM_ITEMS.
This table is populated by the Collection and the Snapshot, and is used by the
Planner.


Storage Details
Tablespace: Tablespace
PCT Free:
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSC_SYSTEM_ITEMS_U1 NORMAL UNIQUE Tablespace ColumnPLAN_ID
ColumnSR_INSTANCE_ID
ColumnORGANIZATION_ID
ColumnINVENTORY_ITEM_ID
ColumnNEW_PLAN_ID
ColumnSIMULATION_SET_ID
MSC_SYSTEM_ITEMS_U2 NORMAL UNIQUE Tablespace ColumnPLAN_ID
ColumnSR_INSTANCE_ID
ColumnORGANIZATION_ID
ColumnITEM_NAME
ColumnNEW_PLAN_ID
ColumnSIMULATION_SET_ID
MSC_SYSTEM_ITEMS_U3 NORMAL UNIQUE Tablespace ColumnPLAN_ID
ColumnSR_INSTANCE_ID
ColumnORGANIZATION_ID
ColumnSR_INVENTORY_ITEM_ID
ColumnNEW_PLAN_ID
ColumnSIMULATION_SET_ID
MSC_SYSTEM_ITEMS_N1 NORMAL NONUNIQUE Tablespace ColumnPLAN_ID
ColumnPLANNER_CODE
ColumnORGANIZATION_ID
ColumnSR_INSTANCE_ID
ColumnINVENTORY_ITEM_ID
MSC_SYSTEM_ITEMS_N2 NORMAL NONUNIQUE Tablespace ColumnITEM_NAME
ColumnPLAN_ID
ColumnSR_INSTANCE_ID
ColumnORGANIZATION_ID
MSC_SYSTEM_ITEMS_N3 NORMAL NONUNIQUE Tablespace ColumnPLAN_ID
ColumnSR_INSTANCE_ID
ColumnORGANIZATION_ID
ColumnPRODUCT_FAMILY_ID
MSC_SYSTEM_ITEMS_N4 NORMAL NONUNIQUE Tablespace ColumnPLAN_ID
ColumnINVENTORY_ITEM_ID
ColumnSR_INSTANCE_ID
MSC_SYSTEM_ITEMS_N5 FUNCTION-BASED NORMAL NONUNIQUE Tablespace ColumnUPPER("ITEM_NAME")
MSC_SYSTEM_ITEMS_N6 NORMAL NONUNIQUE Tablespace ColumnPLAN_ID
ColumnSR_INSTANCE_ID
ColumnORGANIZATION_ID
ColumnWIP_SUPPLY_TYPE
Columns
Name Datatype Length Mandatory Comments
PLAN_ID NUMBER
Yes Plan identifier
ORGANIZATION_ID NUMBER
Yes Organization identifier
INVENTORY_ITEM_ID NUMBER
Yes Inventory item identifier
SR_INSTANCE_ID NUMBER
Yes Source application instance identifier
SR_INVENTORY_ITEM_ID NUMBER

Inventory item identifier in the source application instance
ITEM_NAME VARCHAR2 (250)
Name of the inventory item
LOTS_EXPIRATION NUMBER

Shelf_life_days from MTL_SYSTEM_ITEMS???
LOT_CONTROL_CODE NUMBER
Yes Flag indicating if lots_expiration is used or not
SHRINKAGE_RATE NUMBER

Percentage of shinkage for this item
FIXED_DAYS_SUPPLY NUMBER

Period of the supply days (in days)
FIXED_ORDER_QUANTITY NUMBER

Fixed size for the orders
FIXED_LOT_MULTIPLIER NUMBER

Fixed size for the lot
MINIMUM_ORDER_QUANTITY NUMBER

Minimum size of an order
MAXIMUM_ORDER_QUANTITY NUMBER

Maximum size of an order
ROUNDING_CONTROL_TYPE NUMBER
Yes Flag indicating if rounding of the quantity is allowed
PLANNING_TIME_FENCE_DAYS NUMBER

Planning time fences days of the item
PLANNING_TIME_FENCE_DATE DATE

Planning time fence as computed by the planning engine
DEMAND_TIME_FENCE_DAYS NUMBER

Demand time fence days
DEMAND_TIME_FENCE_DATE DATE

Demanding time fence as computed by the planning engine
DESCRIPTION VARCHAR2 (240)
Textual description of the item for UI and reports
RELEASE_TIME_FENCE_CODE NUMBER

Release time fence code
RELEASE_TIME_FENCE_DAYS NUMBER

Release time fence time
IN_SOURCE_PLAN NUMBER
Yes Flag indicating whether the item is in the plan (the snapshot initially gets more items than the planned items)
REVISION VARCHAR2 (3)
Item revision code
SR_CATEGORY_ID NUMBER

Source application category identifier for the planning category set; used for UI and reports
ABC_CLASS NUMBER

Inventory item identifier ABC class (use for UI and reports)
CATEGORY_NAME VARCHAR2 (200)
Category name for the planning category
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)
FIXED_LEAD_TIME NUMBER

Fixed lead time
VARIABLE_LEAD_TIME NUMBER

Variable lead time
PREPROCESSING_LEAD_TIME NUMBER

Preprocessing lead time
POSTPROCESSING_LEAD_TIME NUMBER

Postprocessing lead time
FULL_LEAD_TIME NUMBER

Ful lead time
CUMULATIVE_TOTAL_LEAD_TIME NUMBER

Cumulative total lead time
CUM_MANUFACTURING_LEAD_TIME NUMBER

Cumulative manufacturing lead time
UOM_CODE VARCHAR2 (3) Yes Unit of measure
UNIT_WEIGHT NUMBER

Weight of the item
UNIT_VOLUME NUMBER

Volume of the item
WEIGHT_UOM VARCHAR2 (3)
Unit of measure for the weight
VOLUME_UOM VARCHAR2 (3)
Unit of measure for the volume
PRODUCT_FAMILY_ID NUMBER

Product family identifier
ATP_RULE_ID NUMBER

ATP rule identifier
ATP_COMPONENTS_FLAG VARCHAR2 (1) Yes Flag indicating whether to calculate components ATP
BUILD_IN_WIP_FLAG NUMBER
Yes Flag to indicate if the item can be built in WIP
PURCHASING_ENABLED_FLAG NUMBER
Yes Flag to indicate if the item can be purchased
PLANNING_MAKE_BUY_CODE NUMBER
Yes Indicate if this item should be made or bought. Make(1), Buy(2)
REPETITIVE_TYPE NUMBER
Yes Flag to indicate whether the item is built repetitive
REPETITIVE_VARIANCE NUMBER

Item repetitive variance
STANDARD_COST NUMBER

Standard cost of an item
CARRYING_COST NUMBER

Carrying cost
ORDER_COST NUMBER

Order cost
MATERIAL_COST NUMBER

Item material cost
DMD_LATENESS_COST NUMBER

Demand lateness cost for item
RESOURCE_COST NUMBER

Resource cost for the item
SS_PENALTY_COST NUMBER

Penalty cost for saftety stock violations
SUPPLIER_CAP_OVERUTIL_COST NUMBER

Supplier cap over utilization cost
LIST_PRICE NUMBER

List price of the item
AVERAGE_DISCOUNT NUMBER

Average discount
ENGINEERING_ITEM_FLAG NUMBER
Yes Flag indicating if engineering items are used for prototypes or research. Used for UI and reports
WIP_SUPPLY_TYPE NUMBER

Flag to indicate whether this a phantom (order modifiers are not used)
SAFETY_STOCK_CODE NUMBER
Yes Safety stock code: User-defined quantity(1), User-defined percentage(2), or mean absolute deviation
SAFETY_STOCK_PERCENT NUMBER

Percent of average gross requirment for dynamically calculated safety-stocks
SAFETY_STOCK_BUCKET_DAYS NUMBER

Days over which to average demand for MRP Planned safety stock percent
INVENTORY_USE_UP_DATE DATE

Use-up date
BUYER_NAME VARCHAR2 (240)
Name of buyer (for reporting)
PLANNER_CODE VARCHAR2 (10)
Planner code (for reporting)
PLANNING_EXCEPTION_SET VARCHAR2 (10)
Identifier of the planning exception set
EXCESS_QUANTITY NUMBER

Excess quantity of this item
EXCEPTION_SHORTAGE_DAYS NUMBER

Exception shortage days
EXCEPTION_EXCESS_DAYS NUMBER

Exception excess days
EXCEPTION_OVERPROMISED_DAYS NUMBER

Exception over-promised days
EXCEPTION_CODE VARCHAR2 (5)
Internal exception message code
BOM_ITEM_TYPE NUMBER

BOM item type: Model(1), Option Class(2), Planning(3), Standard(4), Product Family(5)
ATO_FORECAST_CONTROL NUMBER

ATO forecast control code: Consume(1), Consume and derive(2), None(3)
EFFECTIVITY_CONTROL NUMBER
Yes Effectivity control code: Date Effectivity(1), Unit Number effectivity(2)
ORGANIZATION_CODE VARCHAR2 (7)
Organization code (use for UI and report)
ACCEPTABLE_RATE_INCREASE NUMBER

Acceptable rate increase
ACCEPTABLE_RATE_DECREASE NUMBER

Acceptable rate decrease
EXCEPTION_REP_VARIANCE_DAYS NUMBER

Exception repetitive variance days
OVERRUN_PERCENTAGE NUMBER

Repetitive overrun percentage
INVENTORY_PLANNING_CODE NUMBER
Yes Inventory planning code
ACCEPTABLE_EARLY_DELIVERY NUMBER

Acceptable early days
CALCULATE_ATP NUMBER
Yes Flag indicating whether to calculate ATP when planning this part
END_ASSEMBLY_PEGGING_FLAG VARCHAR2 (1)
Peg to the end assembly on reports
END_ASSEMBLY_PEGGING NUMBER

Peg to the end assembly on reports (value is populated by the plan)
FULL_PEGGING NUMBER

Full pegging flag
INVENTORY_ITEM_FLAG NUMBER

Inventory item flag
SOURCE_ORG_ID NUMBER

Item level default for source organization identifier
BASE_ITEM_ID NUMBER

Base item identifier for configuration
ABC_CLASS_NAME VARCHAR2 (40)
ABC Class Name
FIXED_SAFETY_STOCK_QTY NUMBER

Fixed safety stock quantity on a daily basis
PRIMARY_SUPPLIER_ID NUMBER

Primary supplier identifier
ATP_FLAG VARCHAR2 (1) Yes ATP flag
LOW_LEVEL_CODE NUMBER

Inventory item identifier low level code
PLANNER_STATUS_CODE NUMBER

Status of the item for the Planner
NETTABLE_INVENTORY_QUANTITY NUMBER

Nettable inventory quantity on hand
NONNETTABLE_INVENTORY_QUANTITY NUMBER

Nonnettable inventory quantity on hand
REFRESH_NUMBER NUMBER

Refresh number
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
REQUEST_ID NUMBER

Concurrent Who column
PROGRAM_APPLICATION_ID NUMBER

Concurrent Who column
PROGRAM_ID NUMBER

Concurrent Who column
PROGRAM_UPDATE_DATE DATE

Concurrent Who column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
REVISION_QTY_CONTROL_CODE NUMBER

Revision quantity control code
EXPENSE_ACCOUNT NUMBER

Expense account
INVENTORY_ASSET_FLAG VARCHAR2 (1)
Flag indicating item is an inventory asset
BUYER_ID NUMBER (9)
Buyer identifier
REPETITIVE_PLANNING_FLAG VARCHAR2 (1)
Flag indicating item to be planned as repetitive schedule
PICK_COMPONENTS_FLAG VARCHAR2 (1)
Flag indicating whether all shippable components should be picked
SERVICE_LEVEL NUMBER

Service level
REPLENISH_TO_ORDER_FLAG VARCHAR2 (1)
Flag indicating item to be planned as replenish to order
PIP_FLAG NUMBER

This column describes whether the item is a PIP item or not.
YIELD_CONV_FACTOR NUMBER

Yield Conv Factor
MIN_MINMAX_QUANTITY NUMBER

Min Minmax Quantity
MAX_MINMAX_QUANTITY NUMBER

Max Minmax Quantity
NEW_ATP_FLAG VARCHAR2 (1)
for ATP SUmmary Calculation
SOURCE_TYPE NUMBER

Source Type
SUBSTITUTION_WINDOW NUMBER

Substitution Window used in Product Substitution
CREATE_SUPPLY_FLAG NUMBER

Create Supply Flag used in Product Substitution (1=Yes, 2=No)
REORDER_POINT NUMBER

Reorder Point
AVERAGE_ANNUAL_DEMAND NUMBER

Average annual demand
ECONOMIC_ORDER_QUANTITY NUMBER

Economic order quantity
SERIAL_NUMBER_CONTROL_CODE NUMBER

Serial Number Control Code
CONVERGENCE NUMBER

Convergent Supply Consumption Pattern (Series - 1, Parallel - 2, Use Global Default Value - 3)
DIVERGENCE NUMBER

Divergent Supply Feeding Pattern (Series - 1, Series with MTQ - 2, Use Global Default Value - 3)
CONTINOUS_TRANSFER NUMBER

Continous Inter Org Transfer (Yes - 1, No - 2, Use Global Default Value - 3)
CRITICAL_COMPONENT_FLAG NUMBER

Flag for indicating item is critical or not
REDUCE_MPS NUMBER

Indicates how MPS orders are reduce when plan is re-run
CONSIGNED_FLAG NUMBER

Consigned flag for VMI in Collaborative planning. 1-consigned,2-unconsigned(default).
VMI_MINIMUM_UNITS NUMBER

Minimum units for customer VMI collaboration
VMI_MINIMUM_DAYS NUMBER

Minimum days for customer VMI collaboration
VMI_MAXIMUM_UNITS NUMBER

Maximum units for customer VMI collaboration
VMI_MAXIMUM_DAYS NUMBER

Maximum days for customer VMI collaboration
AVERAGE_DAILY_DEMAND NUMBER

Average daily demand for customer VMI collaboration
VMI_FIXED_ORDER_QUANTITY NUMBER

Fixed order quantity for customer VMI collaboration
SO_AUTHORIZATION_FLAG NUMBER

SO authorization flag for VMI release. Buyer-1,Seller-2,None-null.
VMI_FORECAST_TYPE NUMBER

Forecast type used in VMI collaboration. 1 - order forecast (default), 2 - sales forecast, 3 - historical sales.
FORECAST_HORIZON NUMBER

Forecast horizon for VMI collaboration
ASN_AUTOEXPIRE_FLAG NUMBER

ASN expiry flag for VMI. 1 - ASN auto-expired (default), 2 - ASN not auto-expired.
VMI_REFRESH_FLAG NUMBER

Internal column for VMI
BUDGET_CONSTRAINED NUMBER

Flag to mark if the item is Budget constrined or not. Its values correspond inversely to EXCLUDE_FROM_BUDGET_FLAG column in table MTL_SYSTEM_ITEMS.1-Budget is constrained, 2-Budget is not constrained.
MAX_QUANTITY NUMBER

Maximum inventory quantity
MAX_QUANTITY_DOS NUMBER

Maximum inventory quantity by days of supplies
DAYS_TGT_INV_WINDOW NUMBER

Target Inventory level calculation window
DAYS_MAX_INV_WINDOW NUMBER

Max inventory level calculation window
DAYS_TGT_INV_SUPPLY NUMBER

Target inventory level days of supply
DAYS_MAX_INV_SUPPLY NUMBER

Max inventory level days of supply
DRP_PLANNED NUMBER

Distribution Planned (0: No 1: Yes)
AGGREGATE_TIME_FENCE_DATE DATE

Aggregate order promising time fence date
INFERRED_CRITICAL_FLAG NUMBER

Flag for indicating if the item has been inferred critical or not from bottleneck resources
SS_WINDOW_SIZE NUMBER

safety Stock Window Size for Dependent Demands
LOWEST_LEVEL_SRC NUMBER

Lowest Level Sourcing Indicator for an Item in DRP plan.
EAM_ITEM_TYPE NUMBER

Asset group, activity, rebuildable
LOTS_EXIST NUMBER

indicates whether demand type(1) or supply type(2)
LEADTIME_VARIABILITY NUMBER

Manufacturing Lead time Variability ( Standard Deviation)
MIN_SHELF_LIFE_DAYS NUMBER

GROUP_ID NUMBER

REPAIR_YIELD NUMBER

REPAIR_PROGRAM NUMBER

REPAIR_LEAD_TIME NUMBER

PRE_POSITION_INVENTORY NUMBER

PREPOSITION_POINT VARCHAR2 (1)
REPAIR_LEADTIME NUMBER

DEMAND_FULFILLMENT_LT NUMBER

Demand Fulfillment lead time
ITEM_CREATION_DATE DATE

Item Creation Date
SHORTAGE_TYPE NUMBER

EXCESS_TYPE NUMBER

PLANNING_TIME_FENCE_CODE NUMBER

PEGGING_DEMAND_WINDOW_DAYS NUMBER

PEGGING_SUPPLY_WINDOW_DAYS NUMBER

FORECAST_RULE_FOR_DEMANDS NUMBER

FORECAST_RULE_FOR_RETURNS NUMBER

DEMAND_DISTRIBUTION VARCHAR2 (20)
INTERARRIVAL_TIME NUMBER

END_OF_LIFE_DATE DATE

STD_DMD_OVER_HORIZON NUMBER

LIFE_TIME_BUY_DATE DATE

REPAIR_COST NUMBER

CRITICALITY_CATEGORY NUMBER

AVG_DEMAND_BEYOND_PH NUMBER

Average Demand beyond Planning Horizon
AVG_RETURNS_BEYOND_PH NUMBER

Average Returns beyond Planning horizon
RETURN_FORECAST_TIME_FENCE NUMBER

Return Forecast Time fence (defined in simulation set)
DEFECTIVE_ITEM_COST NUMBER

Item Cost for defective Part
STD_DEVIATION_FOR_DEMAND NUMBER

Standard Deviation for Daily demand
MEAN_INTER_ARRIVAL NUMBER

Mean Inter Arrival
STD_DEVIATION_INTER_ARRIVAL NUMBER

Standard Deviation for inter Arrival
INTERARRIVAL_DIST_METHOD VARCHAR2 (30)
Inter Arrival distribution method
BASIS_AVG_DAILY_DEMAND NUMBER

Basis for Average daily demand
COEFFICIENT_OF_VARIATION NUMBER

Coefficient of Variation
STANDARD_DEVIATION NUMBER

Standard Deviation
LAST_REPLAN_DATE DATE

NETCHANGE_REPLAN_FLAG NUMBER

REPLAN_PERIOD NUMBER

SAFETY_LEAD_TIME NUMBER

UNSATISFIED_DEMAND_FACTOR NUMBER

MAX_USAGE_FACTOR NUMBER

MIN_SUP_DEM_PERCENT NUMBER

DMD_SATISFIED_PERCENT NUMBER

NEW_PLAN_ID NUMBER

NEW_PLAN_LIST VARCHAR2 (256)
SIMULATION_SET_ID NUMBER

NO_PL_ORD_BEFORE_WIP_WIN NUMBER

PLANNING_UNITS_OF_WORK NUMBER

EXCESS_HORIZON NUMBER

OBSOLESCENCE_DATE DATE

COMPUTE_EOQ NUMBER

COMPUTE_SS NUMBER

ROP_SAFETY_STOCK NUMBER

CONSIDER_IN_CTB_FLAG VARCHAR2 (1)
CALCULATE_CTB_FLAG VARCHAR2 (1)
CTB_KPI_HORIZON DATE

APPLIED NUMBER

IS_MODIFIED NUMBER

INTERMITTENT_DEMAND NUMBER

intermittent_demand
REPAIR_MODULE NUMBER

SCRAP_RATE NUMBER

REBUILD_ACTIVITY NUMBER

ORDER_PERIOD NUMBER

INV_DAYS_INCREMENT NUMBER

AVERAGE_CYCLE_STOCK NUMBER

COMP_SUBSTITUTION_FLAG NUMBER

CONSUME_BEF_PRIMARY_FLAG NUMBER

Query Text

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


SELECT PLAN_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      SR_INSTANCE_ID
,      SR_INVENTORY_ITEM_ID
,      ITEM_NAME
,      LOTS_EXPIRATION
,      LOT_CONTROL_CODE
,      SHRINKAGE_RATE
,      FIXED_DAYS_SUPPLY
,      FIXED_ORDER_QUANTITY
,      FIXED_LOT_MULTIPLIER
,      MINIMUM_ORDER_QUANTITY
,      MAXIMUM_ORDER_QUANTITY
,      ROUNDING_CONTROL_TYPE
,      PLANNING_TIME_FENCE_DAYS
,      PLANNING_TIME_FENCE_DATE
,      DEMAND_TIME_FENCE_DAYS
,      DEMAND_TIME_FENCE_DATE
,      DESCRIPTION
,      RELEASE_TIME_FENCE_CODE
,      RELEASE_TIME_FENCE_DAYS
,      IN_SOURCE_PLAN
,      REVISION
,      SR_CATEGORY_ID
,      ABC_CLASS
,      CATEGORY_NAME
,      MRP_PLANNING_CODE
,      FIXED_LEAD_TIME
,      VARIABLE_LEAD_TIME
,      PREPROCESSING_LEAD_TIME
,      POSTPROCESSING_LEAD_TIME
,      FULL_LEAD_TIME
,      CUMULATIVE_TOTAL_LEAD_TIME
,      CUM_MANUFACTURING_LEAD_TIME
,      UOM_CODE
,      UNIT_WEIGHT
,      UNIT_VOLUME
,      WEIGHT_UOM
,      VOLUME_UOM
,      PRODUCT_FAMILY_ID
,      ATP_RULE_ID
,      ATP_COMPONENTS_FLAG
,      BUILD_IN_WIP_FLAG
,      PURCHASING_ENABLED_FLAG
,      PLANNING_MAKE_BUY_CODE
,      REPETITIVE_TYPE
,      REPETITIVE_VARIANCE
,      STANDARD_COST
,      CARRYING_COST
,      ORDER_COST
,      MATERIAL_COST
,      DMD_LATENESS_COST
,      RESOURCE_COST
,      SS_PENALTY_COST
,      SUPPLIER_CAP_OVERUTIL_COST
,      LIST_PRICE
,      AVERAGE_DISCOUNT
,      ENGINEERING_ITEM_FLAG
,      WIP_SUPPLY_TYPE
,      SAFETY_STOCK_CODE
,      SAFETY_STOCK_PERCENT
,      SAFETY_STOCK_BUCKET_DAYS
,      INVENTORY_USE_UP_DATE
,      BUYER_NAME
,      PLANNER_CODE
,      PLANNING_EXCEPTION_SET
,      EXCESS_QUANTITY
,      EXCEPTION_SHORTAGE_DAYS
,      EXCEPTION_EXCESS_DAYS
,      EXCEPTION_OVERPROMISED_DAYS
,      EXCEPTION_CODE
,      BOM_ITEM_TYPE
,      ATO_FORECAST_CONTROL
,      EFFECTIVITY_CONTROL
,      ORGANIZATION_CODE
,      ACCEPTABLE_RATE_INCREASE
,      ACCEPTABLE_RATE_DECREASE
,      EXCEPTION_REP_VARIANCE_DAYS
,      OVERRUN_PERCENTAGE
,      INVENTORY_PLANNING_CODE
,      ACCEPTABLE_EARLY_DELIVERY
,      CALCULATE_ATP
,      END_ASSEMBLY_PEGGING_FLAG
,      END_ASSEMBLY_PEGGING
,      FULL_PEGGING
,      INVENTORY_ITEM_FLAG
,      SOURCE_ORG_ID
,      BASE_ITEM_ID
,      ABC_CLASS_NAME
,      FIXED_SAFETY_STOCK_QTY
,      PRIMARY_SUPPLIER_ID
,      ATP_FLAG
,      LOW_LEVEL_CODE
,      PLANNER_STATUS_CODE
,      NETTABLE_INVENTORY_QUANTITY
,      NONNETTABLE_INVENTORY_QUANTITY
,      REFRESH_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      REVISION_QTY_CONTROL_CODE
,      EXPENSE_ACCOUNT
,      INVENTORY_ASSET_FLAG
,      BUYER_ID
,      REPETITIVE_PLANNING_FLAG
,      PICK_COMPONENTS_FLAG
,      SERVICE_LEVEL
,      REPLENISH_TO_ORDER_FLAG
,      PIP_FLAG
,      YIELD_CONV_FACTOR
,      MIN_MINMAX_QUANTITY
,      MAX_MINMAX_QUANTITY
,      NEW_ATP_FLAG
,      SOURCE_TYPE
,      SUBSTITUTION_WINDOW
,      CREATE_SUPPLY_FLAG
,      REORDER_POINT
,      AVERAGE_ANNUAL_DEMAND
,      ECONOMIC_ORDER_QUANTITY
,      SERIAL_NUMBER_CONTROL_CODE
,      CONVERGENCE
,      DIVERGENCE
,      CONTINOUS_TRANSFER
,      CRITICAL_COMPONENT_FLAG
,      REDUCE_MPS
,      CONSIGNED_FLAG
,      VMI_MINIMUM_UNITS
,      VMI_MINIMUM_DAYS
,      VMI_MAXIMUM_UNITS
,      VMI_MAXIMUM_DAYS
,      AVERAGE_DAILY_DEMAND
,      VMI_FIXED_ORDER_QUANTITY
,      SO_AUTHORIZATION_FLAG
,      VMI_FORECAST_TYPE
,      FORECAST_HORIZON
,      ASN_AUTOEXPIRE_FLAG
,      VMI_REFRESH_FLAG
,      BUDGET_CONSTRAINED
,      MAX_QUANTITY
,      MAX_QUANTITY_DOS
,      DAYS_TGT_INV_WINDOW
,      DAYS_MAX_INV_WINDOW
,      DAYS_TGT_INV_SUPPLY
,      DAYS_MAX_INV_SUPPLY
,      DRP_PLANNED
,      AGGREGATE_TIME_FENCE_DATE
,      INFERRED_CRITICAL_FLAG
,      SS_WINDOW_SIZE
,      LOWEST_LEVEL_SRC
,      EAM_ITEM_TYPE
,      LOTS_EXIST
,      LEADTIME_VARIABILITY
,      MIN_SHELF_LIFE_DAYS
,      GROUP_ID
,      REPAIR_YIELD
,      REPAIR_PROGRAM
,      REPAIR_LEAD_TIME
,      PRE_POSITION_INVENTORY
,      PREPOSITION_POINT
,      REPAIR_LEADTIME
,      DEMAND_FULFILLMENT_LT
,      ITEM_CREATION_DATE
,      SHORTAGE_TYPE
,      EXCESS_TYPE
,      PLANNING_TIME_FENCE_CODE
,      PEGGING_DEMAND_WINDOW_DAYS
,      PEGGING_SUPPLY_WINDOW_DAYS
,      FORECAST_RULE_FOR_DEMANDS
,      FORECAST_RULE_FOR_RETURNS
,      DEMAND_DISTRIBUTION
,      INTERARRIVAL_TIME
,      END_OF_LIFE_DATE
,      STD_DMD_OVER_HORIZON
,      LIFE_TIME_BUY_DATE
,      REPAIR_COST
,      CRITICALITY_CATEGORY
,      AVG_DEMAND_BEYOND_PH
,      AVG_RETURNS_BEYOND_PH
,      RETURN_FORECAST_TIME_FENCE
,      DEFECTIVE_ITEM_COST
,      STD_DEVIATION_FOR_DEMAND
,      MEAN_INTER_ARRIVAL
,      STD_DEVIATION_INTER_ARRIVAL
,      INTERARRIVAL_DIST_METHOD
,      BASIS_AVG_DAILY_DEMAND
,      COEFFICIENT_OF_VARIATION
,      STANDARD_DEVIATION
,      LAST_REPLAN_DATE
,      NETCHANGE_REPLAN_FLAG
,      REPLAN_PERIOD
,      SAFETY_LEAD_TIME
,      UNSATISFIED_DEMAND_FACTOR
,      MAX_USAGE_FACTOR
,      MIN_SUP_DEM_PERCENT
,      DMD_SATISFIED_PERCENT
,      NEW_PLAN_ID
,      NEW_PLAN_LIST
,      SIMULATION_SET_ID
,      NO_PL_ORD_BEFORE_WIP_WIN
,      PLANNING_UNITS_OF_WORK
,      EXCESS_HORIZON
,      OBSOLESCENCE_DATE
,      COMPUTE_EOQ
,      COMPUTE_SS
,      ROP_SAFETY_STOCK
,      CONSIDER_IN_CTB_FLAG
,      CALCULATE_CTB_FLAG
,      CTB_KPI_HORIZON
,      APPLIED
,      IS_MODIFIED
,      INTERMITTENT_DEMAND
,      REPAIR_MODULE
,      SCRAP_RATE
,      REBUILD_ACTIVITY
,      ORDER_PERIOD
,      INV_DAYS_INCREMENT
,      AVERAGE_CYCLE_STOCK
,      COMP_SUBSTITUTION_FLAG
,      CONSUME_BEF_PRIMARY_FLAG
FROM MSC.MSC_SYSTEM_ITEMS;

Dependencies

[top of page]

MSC.MSC_SYSTEM_ITEMS does not reference any database object

MSC.MSC_SYSTEM_ITEMS is referenced by following:

SchemaAPPS
Materialized ViewMSC_ATP_PLAN_SN
Materialized ViewMSC_ITEM_HIERARCHY_MV
SchemaMSC
ViewMSC_SYSTEM_ITEMS#