[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | MSC_SYSTEM_ITEMS |
|---|---|
| Object Type: | TABLE |
| Owner: | MSC |
| FND Design Data: |  MSC.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.
| Tablespace: |  |
|---|---|
| PCT Free: | |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| MSC_SYSTEM_ITEMS_U1 | NORMAL | UNIQUE |
|
 PLAN_ID
SR_INSTANCE_ID
ORGANIZATION_ID
INVENTORY_ITEM_ID
NEW_PLAN_ID
SIMULATION_SET_ID
|
| MSC_SYSTEM_ITEMS_U2 | NORMAL | UNIQUE |
|
PLAN_ID
SR_INSTANCE_ID
ORGANIZATION_ID
ITEM_NAME
NEW_PLAN_ID
SIMULATION_SET_ID
|
| MSC_SYSTEM_ITEMS_U3 | NORMAL | UNIQUE |
|
PLAN_ID
SR_INSTANCE_ID
ORGANIZATION_ID
SR_INVENTORY_ITEM_ID
NEW_PLAN_ID
SIMULATION_SET_ID
|
| MSC_SYSTEM_ITEMS_N1 | NORMAL | NONUNIQUE |
|
PLAN_ID
PLANNER_CODE
ORGANIZATION_ID
SR_INSTANCE_ID
INVENTORY_ITEM_ID
|
| MSC_SYSTEM_ITEMS_N2 | NORMAL | NONUNIQUE |
|
ITEM_NAME
PLAN_ID
SR_INSTANCE_ID
ORGANIZATION_ID
|
| MSC_SYSTEM_ITEMS_N3 | NORMAL | NONUNIQUE |
|
PLAN_ID
SR_INSTANCE_ID
ORGANIZATION_ID
PRODUCT_FAMILY_ID
|
| MSC_SYSTEM_ITEMS_N4 | NORMAL | NONUNIQUE |
|
PLAN_ID
INVENTORY_ITEM_ID
SR_INSTANCE_ID
|
| MSC_SYSTEM_ITEMS_N5 | FUNCTION-BASED NORMAL | NONUNIQUE |
|
UPPER("ITEM_NAME")
|
| MSC_SYSTEM_ITEMS_N6 | NORMAL | NONUNIQUE |
|
PLAN_ID
SR_INSTANCE_ID
ORGANIZATION_ID
WIP_SUPPLY_TYPE
|
| 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 |
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;
MSC.MSC_SYSTEM_ITEMS does not reference any database object
MSC.MSC_SYSTEM_ITEMS is referenced by following:
APPS
MSC_ATP_PLAN_SN
MSC_ITEM_HIERARCHY_MV
MSC
MSC_SYSTEM_ITEMS#
|
|
|
|