DROP TABLE C##MSC.C##MSC_SYSTEM_ITEMS CASCADE CONSTRAINTS;
CREATE TABLE C##MSC.C##MSC_SYSTEM_ITEMS
(
PLAN_ID NUMBER NOT NULL,
ORGANIZATION_ID NUMBER NOT NULL,
INVENTORY_ITEM_ID NUMBER NOT NULL,
SR_INSTANCE_ID NUMBER NOT NULL,
SR_INVENTORY_ITEM_ID NUMBER,
ITEM_NAME VARCHAR2(250 BYTE),
LOTS_EXPIRATION NUMBER,
LOT_CONTROL_CODE NUMBER NOT NULL,
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 NOT NULL,
PLANNING_TIME_FENCE_DAYS NUMBER,
PLANNING_TIME_FENCE_DATE DATE,
DEMAND_TIME_FENCE_DAYS NUMBER,
DEMAND_TIME_FENCE_DATE DATE,
DESCRIPTION VARCHAR2(240 BYTE),
RELEASE_TIME_FENCE_CODE NUMBER,
RELEASE_TIME_FENCE_DAYS NUMBER,
IN_SOURCE_PLAN NUMBER NOT NULL,
REVISION VARCHAR2(3 BYTE),
SR_CATEGORY_ID NUMBER,
ABC_CLASS NUMBER,
CATEGORY_NAME VARCHAR2(200 BYTE),
MRP_PLANNING_CODE NUMBER NOT NULL,
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 BYTE) NOT NULL,
UNIT_WEIGHT NUMBER,
UNIT_VOLUME NUMBER,
WEIGHT_UOM VARCHAR2(3 BYTE),
VOLUME_UOM VARCHAR2(3 BYTE),
PRODUCT_FAMILY_ID NUMBER,
ATP_RULE_ID NUMBER,
ATP_COMPONENTS_FLAG VARCHAR2(1 BYTE) NOT NULL,
BUILD_IN_WIP_FLAG NUMBER NOT NULL,
PURCHASING_ENABLED_FLAG NUMBER NOT NULL,
PLANNING_MAKE_BUY_CODE NUMBER NOT NULL,
REPETITIVE_TYPE NUMBER NOT NULL,
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 NOT NULL,
WIP_SUPPLY_TYPE NUMBER,
SAFETY_STOCK_CODE NUMBER NOT NULL,
SAFETY_STOCK_PERCENT NUMBER,
SAFETY_STOCK_BUCKET_DAYS NUMBER,
INVENTORY_USE_UP_DATE DATE,
BUYER_NAME VARCHAR2(240 BYTE),
PLANNER_CODE VARCHAR2(10 BYTE),
PLANNING_EXCEPTION_SET VARCHAR2(10 BYTE),
EXCESS_QUANTITY NUMBER,
EXCEPTION_SHORTAGE_DAYS NUMBER,
EXCEPTION_EXCESS_DAYS NUMBER,
EXCEPTION_OVERPROMISED_DAYS NUMBER,
EXCEPTION_CODE VARCHAR2(5 BYTE),
BOM_ITEM_TYPE NUMBER,
ATO_FORECAST_CONTROL NUMBER,
EFFECTIVITY_CONTROL NUMBER NOT NULL,
ORGANIZATION_CODE VARCHAR2(7 BYTE),
ACCEPTABLE_RATE_INCREASE NUMBER,
ACCEPTABLE_RATE_DECREASE NUMBER,
EXCEPTION_REP_VARIANCE_DAYS NUMBER,
OVERRUN_PERCENTAGE NUMBER,
INVENTORY_PLANNING_CODE NUMBER NOT NULL,
ACCEPTABLE_EARLY_DELIVERY NUMBER,
CALCULATE_ATP NUMBER NOT NULL,
END_ASSEMBLY_PEGGING_FLAG VARCHAR2(1 BYTE),
END_ASSEMBLY_PEGGING NUMBER,
FULL_PEGGING NUMBER,
INVENTORY_ITEM_FLAG NUMBER,
SOURCE_ORG_ID NUMBER,
BASE_ITEM_ID NUMBER,
ABC_CLASS_NAME VARCHAR2(40 BYTE),
FIXED_SAFETY_STOCK_QTY NUMBER,
PRIMARY_SUPPLIER_ID NUMBER,
ATP_FLAG VARCHAR2(1 BYTE) NOT NULL,
LOW_LEVEL_CODE NUMBER,
PLANNER_STATUS_CODE NUMBER,
NETTABLE_INVENTORY_QUANTITY NUMBER,
NONNETTABLE_INVENTORY_QUANTITY NUMBER,
REFRESH_NUMBER NUMBER,
LAST_UPDATE_DATE DATE NOT NULL,
LAST_UPDATED_BY NUMBER NOT NULL,
CREATION_DATE DATE NOT NULL,
CREATED_BY NUMBER NOT NULL,
LAST_UPDATE_LOGIN NUMBER,
REQUEST_ID NUMBER,
PROGRAM_APPLICATION_ID NUMBER,
PROGRAM_ID NUMBER,
PROGRAM_UPDATE_DATE DATE,
ATTRIBUTE_CATEGORY VARCHAR2(30 BYTE),
ATTRIBUTE1 VARCHAR2(150 BYTE),
ATTRIBUTE2 VARCHAR2(150 BYTE),
ATTRIBUTE3 VARCHAR2(150 BYTE),
ATTRIBUTE4 VARCHAR2(150 BYTE),
ATTRIBUTE5 VARCHAR2(150 BYTE),
ATTRIBUTE6 VARCHAR2(150 BYTE),
ATTRIBUTE7 VARCHAR2(150 BYTE),
ATTRIBUTE8 VARCHAR2(150 BYTE),
ATTRIBUTE9 VARCHAR2(150 BYTE),
ATTRIBUTE10 VARCHAR2(150 BYTE),
ATTRIBUTE11 VARCHAR2(150 BYTE),
ATTRIBUTE12 VARCHAR2(150 BYTE),
ATTRIBUTE13 VARCHAR2(150 BYTE),
ATTRIBUTE14 VARCHAR2(150 BYTE),
ATTRIBUTE15 VARCHAR2(150 BYTE),
REVISION_QTY_CONTROL_CODE NUMBER,
EXPENSE_ACCOUNT NUMBER,
INVENTORY_ASSET_FLAG VARCHAR2(1 BYTE),
BUYER_ID NUMBER(9),
REPETITIVE_PLANNING_FLAG VARCHAR2(1 BYTE),
PICK_COMPONENTS_FLAG VARCHAR2(1 BYTE),
SERVICE_LEVEL NUMBER,
REPLENISH_TO_ORDER_FLAG VARCHAR2(1 BYTE),
PIP_FLAG NUMBER,
YIELD_CONV_FACTOR NUMBER,
MIN_MINMAX_QUANTITY NUMBER,
MAX_MINMAX_QUANTITY NUMBER,
NEW_ATP_FLAG VARCHAR2(1 BYTE),
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 NUMBER,
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
)
COMMENT ON TABLE C##MSC.C##MSC_SYSTEM_ITEMS IS 'C##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 C##MSC_SYSTEM_ITEMS correspond to columns from the Oracle Inventory Item mast ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.PLAN_ID IS 'Plan identifier ';
/
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.ORGANIZATION_ID IS 'Organization identifier ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.INVENTORY_ITEM_ID IS 'Inventory item identifier ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.SR_INSTANCE_ID IS 'Source application instance identifier ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.SR_INVENTORY_ITEM_ID IS 'Inventory item identifier in the source application instance ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.ITEM_NAME IS 'Name of the inventory item ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.LOTS_EXPIRATION IS 'Shelf_life_days from MTL_SYSTEM_ITEMS??? ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.LOT_CONTROL_CODE IS 'Flag indicating if lots_expiration is used or not ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.SHRINKAGE_RATE IS 'Percentage of shinkage for this item ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.FIXED_DAYS_SUPPLY IS 'Period of the supply days (in days) ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.FIXED_ORDER_QUANTITY IS 'Fixed size for the orders ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.FIXED_LOT_MULTIPLIER IS 'Fixed size for the lot ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.MINIMUM_ORDER_QUANTITY IS 'Minimum size of an order ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.MAXIMUM_ORDER_QUANTITY IS 'Maximum size of an order ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.ROUNDING_CONTROL_TYPE IS 'Flag indicating if rounding of the quantity is allowed ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.PLANNING_TIME_FENCE_DAYS IS 'Planning time fences days of the item ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.PLANNING_TIME_FENCE_DATE IS 'Planning time fence as computed by the planning engine ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.DEMAND_TIME_FENCE_DAYS IS 'Demand time fence days ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.DEMAND_TIME_FENCE_DATE IS 'Demanding time fence as computed by the planning engine ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.DESCRIPTION IS 'Textual description of the item for UI and reports ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.RELEASE_TIME_FENCE_CODE IS 'Release time fence code ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.RELEASE_TIME_FENCE_DAYS IS 'Release time fence time ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.IN_SOURCE_PLAN IS 'Flag indicating whether the item is in the plan (the snapshot initially gets more items than the planned items) ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.REVISION IS 'Item revision code ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.SR_CATEGORY_ID IS 'Source application category identifier for the planning category set; used for UI and reports ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.ABC_CLASS IS 'Inventory item identifier ABC class (use for UI and reports) ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.CATEGORY_NAME IS 'Category name for the planning category ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.MRP_PLANNING_CODE IS 'Type of planning required for this item: MRP(3), MPS(4), Not Planned(6), MRP and DRP(7), MPS and DRP(8), DRP(9) ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.FIXED_LEAD_TIME IS 'Fixed lead time ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.VARIABLE_LEAD_TIME IS 'Variable lead time ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.PREPROCESSING_LEAD_TIME IS 'Preprocessing lead time ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.POSTPROCESSING_LEAD_TIME IS 'Postprocessing lead time ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.FULL_LEAD_TIME IS 'Ful lead time ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.CUMULATIVE_TOTAL_LEAD_TIME IS 'Cumulative total lead time ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.CUM_MANUFACTURING_LEAD_TIME IS 'Cumulative manufacturing lead time ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.UOM_CODE IS 'Unit of measure ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.UNIT_WEIGHT IS 'Weight of the item ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.UNIT_VOLUME IS 'Volume of the item ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.WEIGHT_UOM IS 'Unit of measure for the weight ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.VOLUME_UOM IS 'Unit of measure for the volume ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.PRODUCT_FAMILY_ID IS 'Product family identifier ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.ATP_RULE_ID IS 'ATP rule identifier ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.ATP_COMPONENTS_FLAG IS 'Flag indicating whether to calculate components ATP ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG IS 'Flag to indicate if the item can be built in WIP ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG IS 'Flag to indicate if the item can be purchased ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.PLANNING_MAKE_BUY_CODE IS 'Indicate if this item should be made or bought. Make(1), Buy(2) ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.REPETITIVE_TYPE IS 'Flag to indicate whether the item is built repetitive ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.REPETITIVE_VARIANCE IS 'Item repetitive variance ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.STANDARD_COST IS 'Standard cost of an item ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.CARRYING_COST IS 'Carrying cost ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.ORDER_COST IS 'Order cost ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.MATERIAL_COST IS 'Item material cost ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.DMD_LATENESS_COST IS 'Demand lateness cost for item ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.RESOURCE_COST IS 'Resource cost for the item ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.SS_PENALTY_COST IS 'Penalty cost for saftety stock violations ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.SUPPLIER_CAP_OVERUTIL_COST IS 'Supplier cap over utilization cost ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.LIST_PRICE IS 'List price of the item ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.AVERAGE_DISCOUNT IS 'Average discount ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.ENGINEERING_ITEM_FLAG IS 'Flag indicating if engineering items are used for prototypes or research. Used for UI and reports ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.WIP_SUPPLY_TYPE IS 'Flag to indicate whether this a phantom (order modifiers are not used) ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.SAFETY_STOCK_CODE IS 'Safety stock code: User-defined quantity(1), User-defined percentage(2), or mean absolute deviation ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.SAFETY_STOCK_PERCENT IS 'Percent of average gross requirment for dynamically calculated safety-stocks ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.SAFETY_STOCK_BUCKET_DAYS IS 'Days over which to average demand for MRP Planned safety stock percent ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.INVENTORY_USE_UP_DATE IS 'Use-up date ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.BUYER_NAME IS 'Name of buyer (for reporting) ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.PLANNER_CODE IS 'Planner code (for reporting) ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.PLANNING_EXCEPTION_SET IS 'Identifier of the planning exception set ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.EXCESS_QUANTITY IS 'Excess quantity of this item ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.EXCEPTION_SHORTAGE_DAYS IS 'Exception shortage days ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.EXCEPTION_EXCESS_DAYS IS 'Exception excess days ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.EXCEPTION_OVERPROMISED_DAYS IS 'Exception over-promised days ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.EXCEPTION_CODE IS 'Internal exception message code ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.BOM_ITEM_TYPE IS 'BOM item type: Model(1), Option Class(2), Planning(3), Standard(4), Product Family(5) ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.ATO_FORECAST_CONTROL IS 'ATO forecast control code: Consume(1), Consume and derive(2), None(3) ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.EFFECTIVITY_CONTROL IS 'Effectivity control code: Date Effectivity(1), Unit Number effectivity(2) ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.ORGANIZATION_CODE IS 'Organization code (use for UI and report) ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.ACCEPTABLE_RATE_INCREASE IS 'Acceptable rate increase ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.ACCEPTABLE_RATE_DECREASE IS 'Acceptable rate decrease ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.EXCEPTION_REP_VARIANCE_DAYS IS 'Exception repetitive variance days ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.OVERRUN_PERCENTAGE IS 'Repetitive overrun percentage ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.INVENTORY_PLANNING_CODE IS 'Inventory planning code ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.ACCEPTABLE_EARLY_DELIVERY IS 'Acceptable early days ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.CALCULATE_ATP IS 'Flag indicating whether to calculate ATP when planning this part ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.END_ASSEMBLY_PEGGING_FLAG IS 'Peg to the end assembly on reports ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.END_ASSEMBLY_PEGGING IS 'Peg to the end assembly on reports (value is populated by the plan) ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.FULL_PEGGING IS 'Full pegging flag ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.INVENTORY_ITEM_FLAG IS 'Inventory item flag ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.SOURCE_ORG_ID IS 'Item level default for source organization identifier ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.BASE_ITEM_ID IS 'Base item identifier for configuration ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.ABC_CLASS_NAME IS 'ABC Class Name ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.FIXED_SAFETY_STOCK_QTY IS 'Fixed safety stock quantity on a daily basis ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.PRIMARY_SUPPLIER_ID IS 'Primary supplier identifier ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.ATP_FLAG IS 'ATP flag ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.LOW_LEVEL_CODE IS 'Inventory item identifier low level code ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.PLANNER_STATUS_CODE IS 'Status of the item for the Planner ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.NETTABLE_INVENTORY_QUANTITY IS 'Nettable inventory quantity on hand ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.NONNETTABLE_INVENTORY_QUANTITY IS 'Nonnettable inventory quantity on hand ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.REFRESH_NUMBER IS 'Refresh number ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.LAST_UPDATE_DATE IS 'Standard Who column ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.LAST_UPDATED_BY IS 'Standard Who column ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.CREATION_DATE IS 'Standard Who column ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.CREATED_BY IS 'Standard Who column ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.LAST_UPDATE_LOGIN IS 'Standard Who column ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.REQUEST_ID IS 'Concurrent Who column ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.PROGRAM_APPLICATION_ID IS 'Concurrent Who column ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.PROGRAM_ID IS 'Concurrent Who column ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.PROGRAM_UPDATE_DATE IS 'Concurrent Who column ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.ATTRIBUTE_CATEGORY IS 'Descriptive flexfield structure defining column ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.ATTRIBUTE1 IS 'Descriptive flexfield segment ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.ATTRIBUTE2 IS 'Descriptive flexfield segment ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.ATTRIBUTE3 IS 'Descriptive flexfield segment ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.ATTRIBUTE4 IS 'Descriptive flexfield segment ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.ATTRIBUTE5 IS 'Descriptive flexfield segment ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.ATTRIBUTE6 IS 'Descriptive flexfield segment ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.ATTRIBUTE7 IS 'Descriptive flexfield segment ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.ATTRIBUTE8 IS 'Descriptive flexfield segment ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.ATTRIBUTE9 IS 'Descriptive flexfield segment ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.ATTRIBUTE10 IS 'Descriptive flexfield segment ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.ATTRIBUTE11 IS 'Descriptive flexfield segment ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.ATTRIBUTE12 IS 'Descriptive flexfield segment ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.ATTRIBUTE13 IS 'Descriptive flexfield segment ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.ATTRIBUTE14 IS 'Descriptive flexfield segment ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.ATTRIBUTE15 IS 'Descriptive flexfield segment ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.REVISION_QTY_CONTROL_CODE IS 'Revision quantity control code ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.EXPENSE_ACCOUNT IS 'Expense account ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.INVENTORY_ASSET_FLAG IS 'Flag indicating item is an inventory asset ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.BUYER_ID IS 'Buyer identifier ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.REPETITIVE_PLANNING_FLAG IS 'Flag indicating item to be planned as repetitive schedule ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.PICK_COMPONENTS_FLAG IS 'Flag indicating whether all shippable components should be picked ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.SERVICE_LEVEL IS 'Service level ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.REPLENISH_TO_ORDER_FLAG IS 'Flag indicating item to be planned as replenish to order ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.PIP_FLAG IS 'This column describes whether the item is a PIP item or not. ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.YIELD_CONV_FACTOR IS 'Yield Conv Factor ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.MIN_MINMAX_QUANTITY IS 'Min Minmax Quantity ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.MAX_MINMAX_QUANTITY IS 'Max Minmax Quantity ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.NEW_ATP_FLAG IS 'for ATP SUmmary Calculation ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.SOURCE_TYPE IS 'Source Type ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.SUBSTITUTION_WINDOW IS 'Substitution Window used in Product Substitution ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.CREATE_SUPPLY_FLAG IS 'Create Supply Flag used in Product Substitution (1=Yes, 2=No) ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.REORDER_POINT IS 'Reorder Point ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.AVERAGE_ANNUAL_DEMAND IS 'Average annual demand ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.ECONOMIC_ORDER_QUANTITY IS 'Economic order quantity ';
COMMENT ON COLUMN C##MSC.C##MSC_SYSTEM_ITEMS.SERIAL_NUMBER_CONTROL_CODE IS 'Serial Number Control Code ';
CREATE INDEX C##MSC.C##MSC_SYSTEM_ITEMS_N1 ON C##MSC.C##MSC_SYSTEM_ITEMS
(PLAN_ID, PLANNER_CODE, ORGANIZATION_ID, SR_INSTANCE_ID, INVENTORY_ITEM_ID)
CREATE INDEX C##MSC.C##MSC_SYSTEM_ITEMS_N2 ON C##MSC.C##MSC_SYSTEM_ITEMS
(ITEM_NAME, PLAN_ID, SR_INSTANCE_ID, ORGANIZATION_ID)
CREATE INDEX C##MSC.C##MSC_SYSTEM_ITEMS_N3 ON C##MSC.C##MSC_SYSTEM_ITEMS
(PLAN_ID, SR_INSTANCE_ID, ORGANIZATION_ID, PRODUCT_FAMILY_ID)
CREATE INDEX C##MSC.C##MSC_SYSTEM_ITEMS_N4 ON C##MSC.C##MSC_SYSTEM_ITEMS
(PLAN_ID, INVENTORY_ITEM_ID, SR_INSTANCE_ID)
CREATE INDEX C##MSC.C##MSC_SYSTEM_ITEMS_N5 ON C##MSC.C##MSC_SYSTEM_ITEMS
(PLAN_ID, UPPER("ITEM_NAME"), SR_INSTANCE_ID)
CREATE INDEX C##MSC.C##MSC_SYSTEM_ITEMS_N9 ON C##MSC.C##MSC_SYSTEM_ITEMS
(PLAN_ID, SR_INSTANCE_ID, PLANNER_CODE)
CREATE UNIQUE INDEX C##MSC.C##MSC_SYSTEM_ITEMS_U1 ON C##MSC.C##MSC_SYSTEM_ITEMS
(PLAN_ID, SR_INSTANCE_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID)
CREATE UNIQUE INDEX C##MSC.C##MSC_SYSTEM_ITEMS_U2 ON C##MSC.C##MSC_SYSTEM_ITEMS
(PLAN_ID, SR_INSTANCE_ID, ORGANIZATION_ID, ITEM_NAME)
CREATE UNIQUE INDEX C##MSC.C##MSC_SYSTEM_ITEMS_U3 ON C##MSC.C##MSC_SYSTEM_ITEMS
(PLAN_ID, SR_INSTANCE_ID, ORGANIZATION_ID, SR_INVENTORY_ITEM_ID)
CREATE OR REPLACE SYNONYM APPS.C##MSC_SYSTEM_ITEMS FOR C##MSC.C##MSC_SYSTEM_ITEMS;
GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG, FLASHBACK ON C##MSC.C##MSC_SYSTEM_ITEMS TO APPS WITH GRANT OPTION;
GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG, FLASHBACK ON C##MSC.C##MSC_SYSTEM_ITEMS TO DEMANTRA;
沒有留言:
張貼留言