MSC_SYSTEM_ITEMS

Details

Schema: FUSION
Object owner: MSC
Object type: VIEW

Columns

Name
PLAN_ID ACCEPTABLE_EARLY_DELIVERY ATO_FORECAST_CONTROL ATP_COMPONENTS_FLAG ATP_FLAG ATTRIBUTE_CATEGORY ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 AVERAGE_DISCOUNT BACK_TO_BACK_FLAG BASE_ITEM_ID BOM_ITEM_TYPE BUILD_IN_WIP_FLAG CALCULATE_ATP CARRYING_COST CREATE_SUPPLY_FLAG CREATED_BY CREATION_DATE CUM_MANUFACTURING_LEAD_TIME CUMULATIVE_TOTAL_LEAD_TIME CUSTOMER_ORDER_FLAG DEMAND_TIME_FENCE_CODE DEMAND_TIME_FENCE_DAYS DESCRIPTION EFFECTIVITY_CONTROL ENGINEERING_ITEM_FLAG FIXED_DAYS_SUPPLY FIXED_LEAD_TIME FIXED_LOT_MULTIPLIER FIXED_ORDER_QUANTITY FULL_LEAD_TIME INVENTORY_ITEM_FLAG INVENTORY_ITEM_ID ITEM_COST ITEM_COST_CURRENCY ITEM_COST_UOM ITEM_NAME LAST_UPDATE_DATE LAST_UPDATE_LOGIN LAST_UPDATED_BY LIFE_CYCLE_PHASE LIST_PRICE LOT_CONTROL_CODE LOTS_EXPIRATION MATERIAL_COST MIN_SHELF_LIFE_DAYS MINIMUM_ORDER_QUANTITY MRP_PLANNING_CODE ORDER_COST ORGANIZATION_CODE ORGANIZATION_ID PICK_COMPONENTS_FLAG PLANNER_CODE PLANNING_MAKE_BUY_CODE PLANNING_TIME_FENCE_CODE PLANNING_TIME_FENCE_DAYS POSTPROCESSING_LEAD_TIME PREPROCESSING_LEAD_TIME PRODUCT_FAMILY_ID PROGRAM_APPLICATION_ID PROGRAM_ID PROGRAM_UPDATE_DATE PURCHASING_ENABLED_FLAG REFRESH_NUMBER RELEASE_TIME_FENCE_CODE RELEASE_TIME_FENCE_DAYS REPLENISH_TO_ORDER_FLAG REQUEST_ID RESOURCE_COST ROUNDING_CONTROL_TYPE SAFETY_STOCK_BUCKET_DAYS SAFETY_STOCK_CODE SAFETY_STOCK_PERCENT SHIP_MODEL_COMPLETE_FLAG SHIPPABLE_ITEM_FLAG SHRINKAGE_RATE SOURCE_ORG_ID SUPPLIER_CAP_OVERUTIL_COST UNIT_VOLUME UNIT_WEIGHT UOM_CODE VARIABLE_LEAD_TIME VMI_FIXED_ORDER_QUANTITY VOLUME_UOM WEIGHT_UOM WIP_SUPPLY_TYPE BUYER_NAME ABC_CLASS_NAME CRITICAL_COMPONENT_FLAG

Name

PLAN_ID

ACCEPTABLE_EARLY_DELIVERY

ATO_FORECAST_CONTROL

ATP_COMPONENTS_FLAG

ATP_FLAG

ATTRIBUTE_CATEGORY

ATTRIBUTE_DATE1

ATTRIBUTE_DATE2

ATTRIBUTE_DATE3

ATTRIBUTE_DATE4

ATTRIBUTE_DATE5

ATTRIBUTE_NUMBER1

ATTRIBUTE_NUMBER2

ATTRIBUTE_NUMBER3

ATTRIBUTE_NUMBER4

ATTRIBUTE_NUMBER5

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

AVERAGE_DISCOUNT

BACK_TO_BACK_FLAG

BASE_ITEM_ID

BOM_ITEM_TYPE

BUILD_IN_WIP_FLAG

CALCULATE_ATP

CARRYING_COST

CREATE_SUPPLY_FLAG

CREATED_BY

CREATION_DATE

CUM_MANUFACTURING_LEAD_TIME

CUMULATIVE_TOTAL_LEAD_TIME

CUSTOMER_ORDER_FLAG

DEMAND_TIME_FENCE_CODE

DEMAND_TIME_FENCE_DAYS

DESCRIPTION

EFFECTIVITY_CONTROL

ENGINEERING_ITEM_FLAG

FIXED_DAYS_SUPPLY

FIXED_LEAD_TIME

FIXED_LOT_MULTIPLIER

FIXED_ORDER_QUANTITY

FULL_LEAD_TIME

INVENTORY_ITEM_FLAG

INVENTORY_ITEM_ID

ITEM_COST

ITEM_COST_CURRENCY

ITEM_COST_UOM

ITEM_NAME

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

LAST_UPDATED_BY

LIFE_CYCLE_PHASE

LIST_PRICE

LOT_CONTROL_CODE

LOTS_EXPIRATION

MATERIAL_COST

MIN_SHELF_LIFE_DAYS

MINIMUM_ORDER_QUANTITY

MRP_PLANNING_CODE

ORDER_COST

ORGANIZATION_CODE

ORGANIZATION_ID

PICK_COMPONENTS_FLAG

PLANNER_CODE

PLANNING_MAKE_BUY_CODE

PLANNING_TIME_FENCE_CODE

PLANNING_TIME_FENCE_DAYS

POSTPROCESSING_LEAD_TIME

PREPROCESSING_LEAD_TIME

PRODUCT_FAMILY_ID

PROGRAM_APPLICATION_ID

PROGRAM_ID

PROGRAM_UPDATE_DATE

PURCHASING_ENABLED_FLAG

REFRESH_NUMBER

RELEASE_TIME_FENCE_CODE

RELEASE_TIME_FENCE_DAYS

REPLENISH_TO_ORDER_FLAG

REQUEST_ID

RESOURCE_COST

ROUNDING_CONTROL_TYPE

SAFETY_STOCK_BUCKET_DAYS

SAFETY_STOCK_CODE

SAFETY_STOCK_PERCENT

SHIP_MODEL_COMPLETE_FLAG

SHIPPABLE_ITEM_FLAG

SHRINKAGE_RATE

SOURCE_ORG_ID

SUPPLIER_CAP_OVERUTIL_COST

UNIT_VOLUME

UNIT_WEIGHT

UOM_CODE

VARIABLE_LEAD_TIME

VMI_FIXED_ORDER_QUANTITY

VOLUME_UOM

WEIGHT_UOM

WIP_SUPPLY_TYPE

BUYER_NAME

ABC_CLASS_NAME

CRITICAL_COMPONENT_FLAG

Query

SQL_Statement
SELECT msi.PLAN_ID, msi.ACCEPTABLE_EARLY_DELIVERY, msi.ATO_FORECAST_CONTROL, msi.ATP_COMPONENTS_FLAG, msi.ATP_FLAG, msi.ATTRIBUTE_CATEGORY, msi.ATTRIBUTE_DATE1, msi.ATTRIBUTE_DATE2, msi.ATTRIBUTE_DATE3, msi.ATTRIBUTE_DATE4, msi.ATTRIBUTE_DATE5, msi.ATTRIBUTE_NUMBER1, msi.ATTRIBUTE_NUMBER2, msi.ATTRIBUTE_NUMBER3, msi.ATTRIBUTE_NUMBER4, msi.ATTRIBUTE_NUMBER5, msi.ATTRIBUTE1, msi.ATTRIBUTE2, msi.ATTRIBUTE3, msi.ATTRIBUTE4, msi.ATTRIBUTE5, msi.AVERAGE_DISCOUNT, msi.BACK_TO_BACK_FLAG, msi.BASE_ITEM_ID, msi.BOM_ITEM_TYPE, msi.BUILD_IN_WIP_FLAG, msi.CALCULATE_ATP, msi.CARRYING_COST, msi.CREATE_SUPPLY_FLAG, msi.CREATED_BY, msi.CREATION_DATE, msi.CUM_MANUFACTURING_LEAD_TIME, msi.CUMULATIVE_TOTAL_LEAD_TIME, msi.CUSTOMER_ORDER_FLAG, msi.DEMAND_TIME_FENCE_CODE, msi.DEMAND_TIME_FENCE_DAYS, msi.DESCRIPTION, msi.EFFECTIVITY_CONTROL, msi.ENGINEERING_ITEM_FLAG, msi.FIXED_DAYS_SUPPLY, msi.FIXED_LEAD_TIME, msi.FIXED_LOT_MULTIPLIER, msi.FIXED_ORDER_QUANTITY, msi.FULL_LEAD_TIME, msi.INVENTORY_ITEM_FLAG, msi.INVENTORY_ITEM_ID, attr.ITEM_COST, attr.CURRENCY_CODE ITEM_COST_CURRENCY, attr.UOM_CODE ITEM_COST_UOM, msi.ITEM_NAME, msi.LAST_UPDATE_DATE, msi.LAST_UPDATE_LOGIN, msi.LAST_UPDATED_BY, msi.LIFE_CYCLE_PHASE, msi.LIST_PRICE, msi.LOT_CONTROL_CODE, msi.LOTS_EXPIRATION, msi.MATERIAL_COST, msi.MIN_SHELF_LIFE_DAYS, msi.MINIMUM_ORDER_QUANTITY, msi.MRP_PLANNING_CODE, msi.ORDER_COST, msi.ORGANIZATION_CODE, msi.ORGANIZATION_ID, msi.PICK_COMPONENTS_FLAG, msi.PLANNER_CODE, msi.PLANNING_MAKE_BUY_CODE, msi.PLANNING_TIME_FENCE_CODE, msi.PLANNING_TIME_FENCE_DAYS, msi.POSTPROCESSING_LEAD_TIME, msi.PREPROCESSING_LEAD_TIME, msi.PRODUCT_FAMILY_ID, msi.PROGRAM_APPLICATION_ID, msi.PROGRAM_ID, msi.PROGRAM_UPDATE_DATE, msi.PURCHASING_ENABLED_FLAG, msi.REFRESH_NUMBER, msi.RELEASE_TIME_FENCE_CODE, msi.RELEASE_TIME_FENCE_DAYS, msi.REPLENISH_TO_ORDER_FLAG, msi.REQUEST_ID, msi.RESOURCE_COST, msi.ROUNDING_CONTROL_TYPE, msi.SAFETY_STOCK_BUCKET_DAYS, msi.SAFETY_STOCK_CODE, msi.SAFETY_STOCK_PERCENT, msi.SHIP_MODEL_COMPLETE_FLAG, msi.SHIPPABLE_ITEM_FLAG, msi.SHRINKAGE_RATE, msi.SOURCE_ORG_ID, msi.SUPPLIER_CAP_OVERUTIL_COST, msi.UNIT_VOLUME, msi.UNIT_WEIGHT, msi.UOM_CODE, msi.VARIABLE_LEAD_TIME, msi.VMI_FIXED_ORDER_QUANTITY, msi.VOLUME_UOM, msi.WEIGHT_UOM, msi.WIP_SUPPLY_TYPE, msi.BUYER_NAME, msi.ABC_CLASS_NAME, msi.CRITICAL_COMPONENT_FLAG FROM MSC_SYSTEM_ITEMS msi , MSC_ITEMS_ADDTL_ATTRIB attr WHERE msi.INVENTORY_ITEM_ID = attr.INVENTORY_ITEM_ID (+) AND msi.ORGANIZATION_ID = attr.ORGANIZATION_ID (+)

SQL_Statement

SELECT msi.PLAN_ID,

msi.ACCEPTABLE_EARLY_DELIVERY,

msi.ATO_FORECAST_CONTROL,

msi.ATP_COMPONENTS_FLAG,

msi.ATP_FLAG,

msi.ATTRIBUTE_CATEGORY,

msi.ATTRIBUTE_DATE1,

msi.ATTRIBUTE_DATE2,

msi.ATTRIBUTE_DATE3,

msi.ATTRIBUTE_DATE4,

msi.ATTRIBUTE_DATE5,

msi.ATTRIBUTE_NUMBER1,

msi.ATTRIBUTE_NUMBER2,

msi.ATTRIBUTE_NUMBER3,

msi.ATTRIBUTE_NUMBER4,

msi.ATTRIBUTE_NUMBER5,

msi.ATTRIBUTE1,

msi.ATTRIBUTE2,

msi.ATTRIBUTE3,

msi.ATTRIBUTE4,

msi.ATTRIBUTE5,

msi.AVERAGE_DISCOUNT,

msi.BACK_TO_BACK_FLAG,

msi.BASE_ITEM_ID,

msi.BOM_ITEM_TYPE,

msi.BUILD_IN_WIP_FLAG,

msi.CALCULATE_ATP,

msi.CARRYING_COST,

msi.CREATE_SUPPLY_FLAG,

msi.CREATED_BY,

msi.CREATION_DATE,

msi.CUM_MANUFACTURING_LEAD_TIME,

msi.CUMULATIVE_TOTAL_LEAD_TIME,

msi.CUSTOMER_ORDER_FLAG,

msi.DEMAND_TIME_FENCE_CODE,

msi.DEMAND_TIME_FENCE_DAYS,

msi.DESCRIPTION,

msi.EFFECTIVITY_CONTROL,

msi.ENGINEERING_ITEM_FLAG,

msi.FIXED_DAYS_SUPPLY,

msi.FIXED_LEAD_TIME,

msi.FIXED_LOT_MULTIPLIER,

msi.FIXED_ORDER_QUANTITY,

msi.FULL_LEAD_TIME,

msi.INVENTORY_ITEM_FLAG,

msi.INVENTORY_ITEM_ID,

attr.ITEM_COST,

attr.CURRENCY_CODE ITEM_COST_CURRENCY,

attr.UOM_CODE ITEM_COST_UOM,

msi.ITEM_NAME,

msi.LAST_UPDATE_DATE,

msi.LAST_UPDATE_LOGIN,

msi.LAST_UPDATED_BY,

msi.LIFE_CYCLE_PHASE,

msi.LIST_PRICE,

msi.LOT_CONTROL_CODE,

msi.LOTS_EXPIRATION,

msi.MATERIAL_COST,

msi.MIN_SHELF_LIFE_DAYS,

msi.MINIMUM_ORDER_QUANTITY,

msi.MRP_PLANNING_CODE,

msi.ORDER_COST,

msi.ORGANIZATION_CODE,

msi.ORGANIZATION_ID,

msi.PICK_COMPONENTS_FLAG,

msi.PLANNER_CODE,

msi.PLANNING_MAKE_BUY_CODE,

msi.PLANNING_TIME_FENCE_CODE,

msi.PLANNING_TIME_FENCE_DAYS,

msi.POSTPROCESSING_LEAD_TIME,

msi.PREPROCESSING_LEAD_TIME,

msi.PRODUCT_FAMILY_ID,

msi.PROGRAM_APPLICATION_ID,

msi.PROGRAM_ID,

msi.PROGRAM_UPDATE_DATE,

msi.PURCHASING_ENABLED_FLAG,

msi.REFRESH_NUMBER,

msi.RELEASE_TIME_FENCE_CODE,

msi.RELEASE_TIME_FENCE_DAYS,

msi.REPLENISH_TO_ORDER_FLAG,

msi.REQUEST_ID,

msi.RESOURCE_COST,

msi.ROUNDING_CONTROL_TYPE,

msi.SAFETY_STOCK_BUCKET_DAYS,

msi.SAFETY_STOCK_CODE,

msi.SAFETY_STOCK_PERCENT,

msi.SHIP_MODEL_COMPLETE_FLAG,

msi.SHIPPABLE_ITEM_FLAG,

msi.SHRINKAGE_RATE,

msi.SOURCE_ORG_ID,

msi.SUPPLIER_CAP_OVERUTIL_COST,

msi.UNIT_VOLUME,

msi.UNIT_WEIGHT,

msi.UOM_CODE,

msi.VARIABLE_LEAD_TIME,

msi.VMI_FIXED_ORDER_QUANTITY,

msi.VOLUME_UOM,

msi.WEIGHT_UOM,

msi.WIP_SUPPLY_TYPE,

msi.BUYER_NAME,

msi.ABC_CLASS_NAME,

msi.CRITICAL_COMPONENT_FLAG

FROM MSC_SYSTEM_ITEMS msi ,

MSC_ITEMS_ADDTL_ATTRIB attr

WHERE msi.INVENTORY_ITEM_ID = attr.INVENTORY_ITEM_ID (+)

AND msi.ORGANIZATION_ID = attr.ORGANIZATION_ID (+)