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

VIEW: MSC.MSC_SYSTEM_ITEMS#

Object Details
Object Name: MSC_SYSTEM_ITEMS#
Object Type: VIEW
Owner: MSC
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
PLAN_ID NUMBER
Yes
ORGANIZATION_ID NUMBER
Yes
INVENTORY_ITEM_ID NUMBER
Yes
SR_INSTANCE_ID NUMBER
Yes
SR_INVENTORY_ITEM_ID NUMBER

ITEM_NAME VARCHAR2 (250)
LOTS_EXPIRATION NUMBER

LOT_CONTROL_CODE NUMBER
Yes
SHRINKAGE_RATE NUMBER

FIXED_DAYS_SUPPLY NUMBER

FIXED_ORDER_QUANTITY NUMBER

FIXED_LOT_MULTIPLIER NUMBER

MINIMUM_ORDER_QUANTITY NUMBER

MAXIMUM_ORDER_QUANTITY NUMBER

ROUNDING_CONTROL_TYPE NUMBER
Yes
PLANNING_TIME_FENCE_DAYS NUMBER

PLANNING_TIME_FENCE_DATE DATE

DEMAND_TIME_FENCE_DAYS NUMBER

DEMAND_TIME_FENCE_DATE DATE

DESCRIPTION VARCHAR2 (240)
RELEASE_TIME_FENCE_CODE NUMBER

RELEASE_TIME_FENCE_DAYS NUMBER

IN_SOURCE_PLAN NUMBER
Yes
REVISION VARCHAR2 (3)
SR_CATEGORY_ID NUMBER

ABC_CLASS NUMBER

CATEGORY_NAME VARCHAR2 (200)
MRP_PLANNING_CODE NUMBER
Yes
FIXED_LEAD_TIME NUMBER

VARIABLE_LEAD_TIME NUMBER

PREPROCESSING_LEAD_TIME NUMBER

POSTPROCESSING_LEAD_TIME NUMBER

FULL_LEAD_TIME NUMBER

CUMULATIVE_TOTAL_LEAD_TIME NUMBER

CUM_MANUFACTURING_LEAD_TIME NUMBER

UOM_CODE VARCHAR2 (3) Yes
UNIT_WEIGHT NUMBER

UNIT_VOLUME NUMBER

WEIGHT_UOM VARCHAR2 (3)
VOLUME_UOM VARCHAR2 (3)
PRODUCT_FAMILY_ID NUMBER

ATP_RULE_ID NUMBER

ATP_COMPONENTS_FLAG VARCHAR2 (1) Yes
BUILD_IN_WIP_FLAG NUMBER
Yes
PURCHASING_ENABLED_FLAG NUMBER
Yes
PLANNING_MAKE_BUY_CODE NUMBER
Yes
REPETITIVE_TYPE NUMBER
Yes
REPETITIVE_VARIANCE NUMBER

STANDARD_COST NUMBER

CARRYING_COST NUMBER

ORDER_COST NUMBER

MATERIAL_COST NUMBER

DMD_LATENESS_COST NUMBER

RESOURCE_COST NUMBER

SS_PENALTY_COST NUMBER

SUPPLIER_CAP_OVERUTIL_COST NUMBER

LIST_PRICE NUMBER

AVERAGE_DISCOUNT NUMBER

ENGINEERING_ITEM_FLAG NUMBER
Yes
WIP_SUPPLY_TYPE NUMBER

SAFETY_STOCK_CODE NUMBER
Yes
SAFETY_STOCK_PERCENT NUMBER

SAFETY_STOCK_BUCKET_DAYS NUMBER

INVENTORY_USE_UP_DATE DATE

BUYER_NAME VARCHAR2 (240)
PLANNER_CODE VARCHAR2 (10)
PLANNING_EXCEPTION_SET VARCHAR2 (10)
EXCESS_QUANTITY NUMBER

EXCEPTION_SHORTAGE_DAYS NUMBER

EXCEPTION_EXCESS_DAYS NUMBER

EXCEPTION_OVERPROMISED_DAYS NUMBER

EXCEPTION_CODE VARCHAR2 (5)
BOM_ITEM_TYPE NUMBER

ATO_FORECAST_CONTROL NUMBER

EFFECTIVITY_CONTROL NUMBER
Yes
ORGANIZATION_CODE VARCHAR2 (7)
ACCEPTABLE_RATE_INCREASE NUMBER

ACCEPTABLE_RATE_DECREASE NUMBER

EXCEPTION_REP_VARIANCE_DAYS NUMBER

OVERRUN_PERCENTAGE NUMBER

INVENTORY_PLANNING_CODE NUMBER
Yes
ACCEPTABLE_EARLY_DELIVERY NUMBER

CALCULATE_ATP NUMBER
Yes
END_ASSEMBLY_PEGGING_FLAG VARCHAR2 (1)
END_ASSEMBLY_PEGGING NUMBER

FULL_PEGGING NUMBER

INVENTORY_ITEM_FLAG NUMBER

SOURCE_ORG_ID NUMBER

BASE_ITEM_ID NUMBER

ABC_CLASS_NAME VARCHAR2 (40)
FIXED_SAFETY_STOCK_QTY NUMBER

PRIMARY_SUPPLIER_ID NUMBER

ATP_FLAG VARCHAR2 (1) Yes
LOW_LEVEL_CODE NUMBER

PLANNER_STATUS_CODE NUMBER

NETTABLE_INVENTORY_QUANTITY NUMBER

NONNETTABLE_INVENTORY_QUANTITY NUMBER

REFRESH_NUMBER NUMBER

LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

ATTRIBUTE_CATEGORY VARCHAR2 (30)
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)
REVISION_QTY_CONTROL_CODE NUMBER

EXPENSE_ACCOUNT NUMBER

INVENTORY_ASSET_FLAG VARCHAR2 (1)
BUYER_ID NUMBER (9)
REPETITIVE_PLANNING_FLAG VARCHAR2 (1)
PICK_COMPONENTS_FLAG VARCHAR2 (1)
SERVICE_LEVEL NUMBER

REPLENISH_TO_ORDER_FLAG VARCHAR2 (1)
PIP_FLAG NUMBER

YIELD_CONV_FACTOR NUMBER

MIN_MINMAX_QUANTITY NUMBER

MAX_MINMAX_QUANTITY NUMBER

NEW_ATP_FLAG VARCHAR2 (1)
SOURCE_TYPE NUMBER

SUBSTITUTION_WINDOW NUMBER

CREATE_SUPPLY_FLAG NUMBER

REORDER_POINT NUMBER

AVERAGE_ANNUAL_DEMAND NUMBER

ECONOMIC_ORDER_QUANTITY NUMBER

SERIAL_NUMBER_CONTROL_CODE NUMBER

CONVERGENCE NUMBER

DIVERGENCE NUMBER

CONTINOUS_TRANSFER NUMBER

CRITICAL_COMPONENT_FLAG NUMBER

REDUCE_MPS NUMBER

CONSIGNED_FLAG NUMBER

VMI_MINIMUM_UNITS NUMBER

VMI_MINIMUM_DAYS NUMBER

VMI_MAXIMUM_UNITS NUMBER

VMI_MAXIMUM_DAYS NUMBER

AVERAGE_DAILY_DEMAND NUMBER

VMI_FIXED_ORDER_QUANTITY NUMBER

SO_AUTHORIZATION_FLAG NUMBER

VMI_FORECAST_TYPE NUMBER

FORECAST_HORIZON NUMBER

ASN_AUTOEXPIRE_FLAG NUMBER

VMI_REFRESH_FLAG NUMBER

BUDGET_CONSTRAINED NUMBER

MAX_QUANTITY NUMBER

MAX_QUANTITY_DOS NUMBER

DAYS_TGT_INV_WINDOW NUMBER

DAYS_MAX_INV_WINDOW NUMBER

DAYS_TGT_INV_SUPPLY NUMBER

DAYS_MAX_INV_SUPPLY NUMBER

DRP_PLANNED NUMBER

AGGREGATE_TIME_FENCE_DATE DATE

INFERRED_CRITICAL_FLAG NUMBER

SS_WINDOW_SIZE NUMBER

LOWEST_LEVEL_SRC NUMBER

EAM_ITEM_TYPE NUMBER

LOTS_EXIST NUMBER

LEADTIME_VARIABILITY NUMBER

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

ITEM_CREATION_DATE 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

AVG_RETURNS_BEYOND_PH NUMBER

RETURN_FORECAST_TIME_FENCE NUMBER

DEFECTIVE_ITEM_COST NUMBER

STD_DEVIATION_FOR_DEMAND NUMBER

MEAN_INTER_ARRIVAL NUMBER

STD_DEVIATION_INTER_ARRIVAL NUMBER

INTERARRIVAL_DIST_METHOD VARCHAR2 (30)
BASIS_AVG_DAILY_DEMAND NUMBER

COEFFICIENT_OF_VARIATION NUMBER

STANDARD_DEVIATION NUMBER

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

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# references the following:

SchemaMSC
TableMSC_SYSTEM_ITEMS
MSC.MSC_SYSTEM_ITEMS# is referenced by following:

SchemaAPPS
SynonymMSC_SYSTEM_ITEMS