VIEW: MSC.MSC_ST_SYSTEM_ITEMS#

Source

View Text - Preformatted

select ORGANIZATION_ID ORGANIZATION_ID, SR_ORGANIZATION_ID SR_ORGANIZATION_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, SR_INVENTORY_ITEM_ID SR_INVENTORY_ITEM_ID, ITEM_NAME ITEM_NAME, LOTS_EXPIRATION LOTS_EXPIRATION, LOT_CONTROL_CODE LOT_CONTROL_CODE, SHRINKAGE_RATE SHRINKAGE_RATE, FIXED_DAYS_SUPPLY FIXED_DAYS_SUPPLY, FIXED_ORDER_QUANTITY FIXED_ORDER_QUANTITY, FIXED_LOT_MULTIPLIER FIXED_LOT_MULTIPLIER, MINIMUM_ORDER_QUANTITY MINIMUM_ORDER_QUANTITY, MAXIMUM_ORDER_QUANTITY MAXIMUM_ORDER_QUANTITY, ROUNDING_CONTROL_TYPE ROUNDING_CONTROL_TYPE, PLANNING_TIME_FENCE_DAYS PLANNING_TIME_FENCE_DAYS, DEMAND_TIME_FENCE_DAYS DEMAND_TIME_FENCE_DAYS, RELEASE_TIME_FENCE_CODE RELEASE_TIME_FENCE_CODE, RELEASE_TIME_FENCE_DAYS RELEASE_TIME_FENCE_DAYS, DESCRIPTION DESCRIPTION, IN_SOURCE_PLAN IN_SOURCE_PLAN, REVISION REVISION, SR_CATEGORY_ID SR_CATEGORY_ID, CATEGORY_NAME CATEGORY_NAME, ABC_CLASS_ID ABC_CLASS_ID, ABC_CLASS_NAME ABC_CLASS_NAME, MRP_PLANNING_CODE MRP_PLANNING_CODE, FIXED_LEAD_TIME FIXED_LEAD_TIME, VARIABLE_LEAD_TIME VARIABLE_LEAD_TIME, PREPROCESSING_LEAD_TIME PREPROCESSING_LEAD_TIME, POSTPROCESSING_LEAD_TIME POSTPROCESSING_LEAD_TIME, FULL_LEAD_TIME FULL_LEAD_TIME, CUMULATIVE_TOTAL_LEAD_TIME CUMULATIVE_TOTAL_LEAD_TIME, CUM_MANUFACTURING_LEAD_TIME CUM_MANUFACTURING_LEAD_TIME, UOM_CODE UOM_CODE, UNIT_WEIGHT UNIT_WEIGHT, UNIT_VOLUME UNIT_VOLUME, WEIGHT_UOM WEIGHT_UOM, VOLUME_UOM VOLUME_UOM, PRODUCT_FAMILY_ID PRODUCT_FAMILY_ID, ATP_RULE_ID ATP_RULE_ID, MRP_CALCULATE_ATP_FLAG MRP_CALCULATE_ATP_FLAG, ATP_COMPONENTS_FLAG ATP_COMPONENTS_FLAG, BUILT_IN_WIP_FLAG BUILT_IN_WIP_FLAG, PURCHASING_ENABLED_FLAG PURCHASING_ENABLED_FLAG, PLANNING_MAKE_BUY_CODE PLANNING_MAKE_BUY_CODE, REPETITIVE_TYPE REPETITIVE_TYPE, STANDARD_COST STANDARD_COST, CARRYING_COST CARRYING_COST, ORDER_COST ORDER_COST, DMD_LATENESS_COST DMD_LATENESS_COST, SS_PENALTY_COST SS_PENALTY_COST, SUPPLIER_CAP_OVERUTIL_COST SUPPLIER_CAP_OVERUTIL_COST, LIST_PRICE LIST_PRICE, AVERAGE_DISCOUNT AVERAGE_DISCOUNT, END_ASSEMBLY_PEGGING_FLAG END_ASSEMBLY_PEGGING_FLAG, END_ASSEMBLY_PEGGING END_ASSEMBLY_PEGGING, FULL_PEGGING FULL_PEGGING, ENGINEERING_ITEM_FLAG ENGINEERING_ITEM_FLAG, WIP_SUPPLY_TYPE WIP_SUPPLY_TYPE, MRP_SAFETY_STOCK_CODE MRP_SAFETY_STOCK_CODE, MRP_SAFETY_STOCK_PERCENT MRP_SAFETY_STOCK_PERCENT, SAFETY_STOCK_BUCKET_DAYS SAFETY_STOCK_BUCKET_DAYS, INVENTORY_USE_UP_DATE INVENTORY_USE_UP_DATE, BUYER_NAME BUYER_NAME, PLANNER_CODE PLANNER_CODE, PLANNING_EXCEPTION_SET PLANNING_EXCEPTION_SET, EXCESS_QUANTITY EXCESS_QUANTITY, EXCEPTION_SHORTAGE_DAYS EXCEPTION_SHORTAGE_DAYS, EXCEPTION_EXCESS_DAYS EXCEPTION_EXCESS_DAYS, EXCEPTION_OVERPROMISED_DAYS EXCEPTION_OVERPROMISED_DAYS, REPETITIVE_VARIANCE_DAYS REPETITIVE_VARIANCE_DAYS, BASE_ITEM_ID BASE_ITEM_ID, BOM_ITEM_TYPE BOM_ITEM_TYPE, ATO_FORECAST_CONTROL ATO_FORECAST_CONTROL, ORGANIZATION_CODE ORGANIZATION_CODE, EFFECTIVITY_CONTROL EFFECTIVITY_CONTROL, ACCEPTABLE_EARLY_DELIVERY ACCEPTABLE_EARLY_DELIVERY, INVENTORY_PLANNING_CODE INVENTORY_PLANNING_CODE, INVENTORY_TYPE INVENTORY_TYPE, ACCEPTABLE_RATE_INCREASE ACCEPTABLE_RATE_INCREASE, ACCEPTABLE_RATE_DECREASE ACCEPTABLE_RATE_DECREASE, PRIMARY_SUPPLIER_ID PRIMARY_SUPPLIER_ID, DELETED_FLAG DELETED_FLAG, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, SR_INSTANCE_ID SR_INSTANCE_ID, REFRESH_ID REFRESH_ID, ATP_FLAG ATP_FLAG, INVENTORY_ITEM_FLAG INVENTORY_ITEM_FLAG, REVISION_QTY_CONTROL_CODE REVISION_QTY_CONTROL_CODE, EXPENSE_ACCOUNT EXPENSE_ACCOUNT, INVENTORY_ASSET_FLAG INVENTORY_ASSET_FLAG, BUYER_ID BUYER_ID, MATERIAL_COST MATERIAL_COST, RESOURCE_COST RESOURCE_COST, SOURCE_ORG_ID SOURCE_ORG_ID, PICK_COMPONENTS_FLAG PICK_COMPONENTS_FLAG, ALLOWED_UNITS_LOOKUP_CODE ALLOWED_UNITS_LOOKUP_CODE, SERVICE_LEVEL SERVICE_LEVEL, REPLENISH_TO_ORDER_FLAG REPLENISH_TO_ORDER_FLAG, PIP_FLAG PIP_FLAG, COMPANY_ID COMPANY_ID, COMPANY_NAME COMPANY_NAME, SR_INSTANCE_CODE SR_INSTANCE_CODE, ATP_RULE_CODE ATP_RULE_CODE, BASE_ITEM_NAME BASE_ITEM_NAME, PRIMARY_SUPPLIER_NAME PRIMARY_SUPPLIER_NAME, SOURCE_ORG_CODE SOURCE_ORG_CODE, MESSAGE_ID MESSAGE_ID, PROCESS_FLAG PROCESS_FLAG, ERROR_TEXT ERROR_TEXT, DATA_SOURCE_TYPE DATA_SOURCE_TYPE, ST_TRANSACTION_ID ST_TRANSACTION_ID, BATCH_ID BATCH_ID, MIN_MINMAX_QUANTITY MIN_MINMAX_QUANTITY, MAX_MINMAX_QUANTITY MAX_MINMAX_QUANTITY, YIELD_CONV_FACTOR YIELD_CONV_FACTOR, SOURCE_TYPE SOURCE_TYPE, SUBSTITUTION_WINDOW SUBSTITUTION_WINDOW, CREATE_SUPPLY_FLAG CREATE_SUPPLY_FLAG, SERIAL_NUMBER_CONTROL_CODE SERIAL_NUMBER_CONTROL_CODE, CRITICAL_COMPONENT_FLAG CRITICAL_COMPONENT_FLAG, REDUCE_MPS REDUCE_MPS, SOURCE_SR_INVENTORY_ITEM_ID SOURCE_SR_INVENTORY_ITEM_ID, SOURCE_SOURCE_ORG_ID SOURCE_SOURCE_ORG_ID, SOURCE_PRIMARY_SUPPLIER_ID SOURCE_PRIMARY_SUPPLIER_ID, SOURCE_BASE_ITEM_ID SOURCE_BASE_ITEM_ID, SOURCE_ABC_CLASS_ID SOURCE_ABC_CLASS_ID, VMI_MINIMUM_UNITS VMI_MINIMUM_UNITS, VMI_MINIMUM_DAYS VMI_MINIMUM_DAYS, VMI_MAXIMUM_UNITS VMI_MAXIMUM_UNITS, VMI_MAXIMUM_DAYS VMI_MAXIMUM_DAYS, VMI_FIXED_ORDER_QUANTITY VMI_FIXED_ORDER_QUANTITY, SO_AUTHORIZATION_FLAG SO_AUTHORIZATION_FLAG, CONSIGNED_FLAG CONSIGNED_FLAG, ASN_AUTOEXPIRE_FLAG ASN_AUTOEXPIRE_FLAG, VMI_FORECAST_TYPE VMI_FORECAST_TYPE, FORECAST_HORIZON FORECAST_HORIZON, BUDGET_CONSTRAINED BUDGET_CONSTRAINED, DAYS_TGT_INV_SUPPLY DAYS_TGT_INV_SUPPLY, DAYS_TGT_INV_WINDOW DAYS_TGT_INV_WINDOW, DAYS_MAX_INV_SUPPLY DAYS_MAX_INV_SUPPLY, DAYS_MAX_INV_WINDOW DAYS_MAX_INV_WINDOW, DRP_PLANNED DRP_PLANNED, CONTINOUS_TRANSFER CONTINOUS_TRANSFER, CONVERGENCE CONVERGENCE, DIVERGENCE DIVERGENCE, PRODUCT_FAMILY_ITEM_NAME PRODUCT_FAMILY_ITEM_NAME, EAM_ITEM_TYPE EAM_ITEM_TYPE, REPAIR_LEAD_TIME REPAIR_LEAD_TIME, PRE_POSITION_INVENTORY PRE_POSITION_INVENTORY, REPAIR_YIELD REPAIR_YIELD, REPAIR_PROGRAM REPAIR_PROGRAM, PREPOSITION_POINT PREPOSITION_POINT, REPAIR_LEADTIME REPAIR_LEADTIME, ITEM_CREATION_DATE ITEM_CREATION_DATE, SHORTAGE_TYPE SHORTAGE_TYPE, EXCESS_TYPE EXCESS_TYPE, PLANNING_TIME_FENCE_CODE PLANNING_TIME_FENCE_CODE, PEGGING_DEMAND_WINDOW_DAYS PEGGING_DEMAND_WINDOW_DAYS, PEGGING_SUPPLY_WINDOW_DAYS PEGGING_SUPPLY_WINDOW_DAYS, UNSATISFIED_DEMAND_FACTOR UNSATISFIED_DEMAND_FACTOR, MIN_SUP_DEM_PERCENT MIN_SUP_DEM_PERCENT, DMD_SATISFIED_PERCENT DMD_SATISFIED_PERCENT from "MSC"."MSC_ST_SYSTEM_ITEMS"

View Text - HTML Formatted

SELECT ORGANIZATION_ID ORGANIZATION_ID
, SR_ORGANIZATION_ID SR_ORGANIZATION_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, SR_INVENTORY_ITEM_ID SR_INVENTORY_ITEM_ID
, ITEM_NAME ITEM_NAME
, LOTS_EXPIRATION LOTS_EXPIRATION
, LOT_CONTROL_CODE LOT_CONTROL_CODE
, SHRINKAGE_RATE SHRINKAGE_RATE
, FIXED_DAYS_SUPPLY FIXED_DAYS_SUPPLY
, FIXED_ORDER_QUANTITY FIXED_ORDER_QUANTITY
, FIXED_LOT_MULTIPLIER FIXED_LOT_MULTIPLIER
, MINIMUM_ORDER_QUANTITY MINIMUM_ORDER_QUANTITY
, MAXIMUM_ORDER_QUANTITY MAXIMUM_ORDER_QUANTITY
, ROUNDING_CONTROL_TYPE ROUNDING_CONTROL_TYPE
, PLANNING_TIME_FENCE_DAYS PLANNING_TIME_FENCE_DAYS
, DEMAND_TIME_FENCE_DAYS DEMAND_TIME_FENCE_DAYS
, RELEASE_TIME_FENCE_CODE RELEASE_TIME_FENCE_CODE
, RELEASE_TIME_FENCE_DAYS RELEASE_TIME_FENCE_DAYS
, DESCRIPTION DESCRIPTION
, IN_SOURCE_PLAN IN_SOURCE_PLAN
, REVISION REVISION
, SR_CATEGORY_ID SR_CATEGORY_ID
, CATEGORY_NAME CATEGORY_NAME
, ABC_CLASS_ID ABC_CLASS_ID
, ABC_CLASS_NAME ABC_CLASS_NAME
, MRP_PLANNING_CODE MRP_PLANNING_CODE
, FIXED_LEAD_TIME FIXED_LEAD_TIME
, VARIABLE_LEAD_TIME VARIABLE_LEAD_TIME
, PREPROCESSING_LEAD_TIME PREPROCESSING_LEAD_TIME
, POSTPROCESSING_LEAD_TIME POSTPROCESSING_LEAD_TIME
, FULL_LEAD_TIME FULL_LEAD_TIME
, CUMULATIVE_TOTAL_LEAD_TIME CUMULATIVE_TOTAL_LEAD_TIME
, CUM_MANUFACTURING_LEAD_TIME CUM_MANUFACTURING_LEAD_TIME
, UOM_CODE UOM_CODE
, UNIT_WEIGHT UNIT_WEIGHT
, UNIT_VOLUME UNIT_VOLUME
, WEIGHT_UOM WEIGHT_UOM
, VOLUME_UOM VOLUME_UOM
, PRODUCT_FAMILY_ID PRODUCT_FAMILY_ID
, ATP_RULE_ID ATP_RULE_ID
, MRP_CALCULATE_ATP_FLAG MRP_CALCULATE_ATP_FLAG
, ATP_COMPONENTS_FLAG ATP_COMPONENTS_FLAG
, BUILT_IN_WIP_FLAG BUILT_IN_WIP_FLAG
, PURCHASING_ENABLED_FLAG PURCHASING_ENABLED_FLAG
, PLANNING_MAKE_BUY_CODE PLANNING_MAKE_BUY_CODE
, REPETITIVE_TYPE REPETITIVE_TYPE
, STANDARD_COST STANDARD_COST
, CARRYING_COST CARRYING_COST
, ORDER_COST ORDER_COST
, DMD_LATENESS_COST DMD_LATENESS_COST
, SS_PENALTY_COST SS_PENALTY_COST
, SUPPLIER_CAP_OVERUTIL_COST SUPPLIER_CAP_OVERUTIL_COST
, LIST_PRICE LIST_PRICE
, AVERAGE_DISCOUNT AVERAGE_DISCOUNT
, END_ASSEMBLY_PEGGING_FLAG END_ASSEMBLY_PEGGING_FLAG
, END_ASSEMBLY_PEGGING END_ASSEMBLY_PEGGING
, FULL_PEGGING FULL_PEGGING
, ENGINEERING_ITEM_FLAG ENGINEERING_ITEM_FLAG
, WIP_SUPPLY_TYPE WIP_SUPPLY_TYPE
, MRP_SAFETY_STOCK_CODE MRP_SAFETY_STOCK_CODE
, MRP_SAFETY_STOCK_PERCENT MRP_SAFETY_STOCK_PERCENT
, SAFETY_STOCK_BUCKET_DAYS SAFETY_STOCK_BUCKET_DAYS
, INVENTORY_USE_UP_DATE INVENTORY_USE_UP_DATE
, BUYER_NAME BUYER_NAME
, PLANNER_CODE PLANNER_CODE
, PLANNING_EXCEPTION_SET PLANNING_EXCEPTION_SET
, EXCESS_QUANTITY EXCESS_QUANTITY
, EXCEPTION_SHORTAGE_DAYS EXCEPTION_SHORTAGE_DAYS
, EXCEPTION_EXCESS_DAYS EXCEPTION_EXCESS_DAYS
, EXCEPTION_OVERPROMISED_DAYS EXCEPTION_OVERPROMISED_DAYS
, REPETITIVE_VARIANCE_DAYS REPETITIVE_VARIANCE_DAYS
, BASE_ITEM_ID BASE_ITEM_ID
, BOM_ITEM_TYPE BOM_ITEM_TYPE
, ATO_FORECAST_CONTROL ATO_FORECAST_CONTROL
, ORGANIZATION_CODE ORGANIZATION_CODE
, EFFECTIVITY_CONTROL EFFECTIVITY_CONTROL
, ACCEPTABLE_EARLY_DELIVERY ACCEPTABLE_EARLY_DELIVERY
, INVENTORY_PLANNING_CODE INVENTORY_PLANNING_CODE
, INVENTORY_TYPE INVENTORY_TYPE
, ACCEPTABLE_RATE_INCREASE ACCEPTABLE_RATE_INCREASE
, ACCEPTABLE_RATE_DECREASE ACCEPTABLE_RATE_DECREASE
, PRIMARY_SUPPLIER_ID PRIMARY_SUPPLIER_ID
, DELETED_FLAG DELETED_FLAG
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, SR_INSTANCE_ID SR_INSTANCE_ID
, REFRESH_ID REFRESH_ID
, ATP_FLAG ATP_FLAG
, INVENTORY_ITEM_FLAG INVENTORY_ITEM_FLAG
, REVISION_QTY_CONTROL_CODE REVISION_QTY_CONTROL_CODE
, EXPENSE_ACCOUNT EXPENSE_ACCOUNT
, INVENTORY_ASSET_FLAG INVENTORY_ASSET_FLAG
, BUYER_ID BUYER_ID
, MATERIAL_COST MATERIAL_COST
, RESOURCE_COST RESOURCE_COST
, SOURCE_ORG_ID SOURCE_ORG_ID
, PICK_COMPONENTS_FLAG PICK_COMPONENTS_FLAG
, ALLOWED_UNITS_LOOKUP_CODE ALLOWED_UNITS_LOOKUP_CODE
, SERVICE_LEVEL SERVICE_LEVEL
, REPLENISH_TO_ORDER_FLAG REPLENISH_TO_ORDER_FLAG
, PIP_FLAG PIP_FLAG
, COMPANY_ID COMPANY_ID
, COMPANY_NAME COMPANY_NAME
, SR_INSTANCE_CODE SR_INSTANCE_CODE
, ATP_RULE_CODE ATP_RULE_CODE
, BASE_ITEM_NAME BASE_ITEM_NAME
, PRIMARY_SUPPLIER_NAME PRIMARY_SUPPLIER_NAME
, SOURCE_ORG_CODE SOURCE_ORG_CODE
, MESSAGE_ID MESSAGE_ID
, PROCESS_FLAG PROCESS_FLAG
, ERROR_TEXT ERROR_TEXT
, DATA_SOURCE_TYPE DATA_SOURCE_TYPE
, ST_TRANSACTION_ID ST_TRANSACTION_ID
, BATCH_ID BATCH_ID
, MIN_MINMAX_QUANTITY MIN_MINMAX_QUANTITY
, MAX_MINMAX_QUANTITY MAX_MINMAX_QUANTITY
, YIELD_CONV_FACTOR YIELD_CONV_FACTOR
, SOURCE_TYPE SOURCE_TYPE
, SUBSTITUTION_WINDOW SUBSTITUTION_WINDOW
, CREATE_SUPPLY_FLAG CREATE_SUPPLY_FLAG
, SERIAL_NUMBER_CONTROL_CODE SERIAL_NUMBER_CONTROL_CODE
, CRITICAL_COMPONENT_FLAG CRITICAL_COMPONENT_FLAG
, REDUCE_MPS REDUCE_MPS
, SOURCE_SR_INVENTORY_ITEM_ID SOURCE_SR_INVENTORY_ITEM_ID
, SOURCE_SOURCE_ORG_ID SOURCE_SOURCE_ORG_ID
, SOURCE_PRIMARY_SUPPLIER_ID SOURCE_PRIMARY_SUPPLIER_ID
, SOURCE_BASE_ITEM_ID SOURCE_BASE_ITEM_ID
, SOURCE_ABC_CLASS_ID SOURCE_ABC_CLASS_ID
, VMI_MINIMUM_UNITS VMI_MINIMUM_UNITS
, VMI_MINIMUM_DAYS VMI_MINIMUM_DAYS
, VMI_MAXIMUM_UNITS VMI_MAXIMUM_UNITS
, VMI_MAXIMUM_DAYS VMI_MAXIMUM_DAYS
, VMI_FIXED_ORDER_QUANTITY VMI_FIXED_ORDER_QUANTITY
, SO_AUTHORIZATION_FLAG SO_AUTHORIZATION_FLAG
, CONSIGNED_FLAG CONSIGNED_FLAG
, ASN_AUTOEXPIRE_FLAG ASN_AUTOEXPIRE_FLAG
, VMI_FORECAST_TYPE VMI_FORECAST_TYPE
, FORECAST_HORIZON FORECAST_HORIZON
, BUDGET_CONSTRAINED BUDGET_CONSTRAINED
, DAYS_TGT_INV_SUPPLY DAYS_TGT_INV_SUPPLY
, DAYS_TGT_INV_WINDOW DAYS_TGT_INV_WINDOW
, DAYS_MAX_INV_SUPPLY DAYS_MAX_INV_SUPPLY
, DAYS_MAX_INV_WINDOW DAYS_MAX_INV_WINDOW
, DRP_PLANNED DRP_PLANNED
, CONTINOUS_TRANSFER CONTINOUS_TRANSFER
, CONVERGENCE CONVERGENCE
, DIVERGENCE DIVERGENCE
, PRODUCT_FAMILY_ITEM_NAME PRODUCT_FAMILY_ITEM_NAME
, EAM_ITEM_TYPE EAM_ITEM_TYPE
, REPAIR_LEAD_TIME REPAIR_LEAD_TIME
, PRE_POSITION_INVENTORY PRE_POSITION_INVENTORY
, REPAIR_YIELD REPAIR_YIELD
, REPAIR_PROGRAM REPAIR_PROGRAM
, PREPOSITION_POINT PREPOSITION_POINT
, REPAIR_LEADTIME REPAIR_LEADTIME
, ITEM_CREATION_DATE ITEM_CREATION_DATE
, SHORTAGE_TYPE SHORTAGE_TYPE
, EXCESS_TYPE EXCESS_TYPE
, PLANNING_TIME_FENCE_CODE PLANNING_TIME_FENCE_CODE
, PEGGING_DEMAND_WINDOW_DAYS PEGGING_DEMAND_WINDOW_DAYS
, PEGGING_SUPPLY_WINDOW_DAYS PEGGING_SUPPLY_WINDOW_DAYS
, UNSATISFIED_DEMAND_FACTOR UNSATISFIED_DEMAND_FACTOR
, MIN_SUP_DEM_PERCENT MIN_SUP_DEM_PERCENT
, DMD_SATISFIED_PERCENT DMD_SATISFIED_PERCENT
FROM "MSC"."MSC_ST_SYSTEM_ITEMS"