eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: MSC_SYSTEM_ITEMS

Product:	MSC - Advanced Supply Chain Planning
Description:	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 mast
Implementation/DBA Data:	MSC.MSC_SYSTEM_ITEMS

Primary Key: MSC_SYSTEM_ITEMS_PK

SR_INSTANCE_ID
PLAN_ID
INVENTORY_ITEM_ID
ORGANIZATION_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
MSC_SYSTEM_ITEMS	MSC_PLAN_ORGANIZATIONS	MSC_SYSTEM_ITEMS.PLAN_ID MSC_SYSTEM_ITEMS.ORGANIZATION_ID MSC_SYSTEM_ITEMS.SR_INSTANCE_ID
MSC_SYSTEM_ITEMS	MSC_ABC_CLASSES	MSC_SYSTEM_ITEMS.ABC_CLASS MSC_SYSTEM_ITEMS.SR_INSTANCE_ID
MSC_AVAILABLE_TO_PROMISE	MSC_SYSTEM_ITEMS	MSC_AVAILABLE_TO_PROMISE.INVENTORY_ITEM_ID MSC_AVAILABLE_TO_PROMISE.PLAN_ID MSC_AVAILABLE_TO_PROMISE.SR_INSTANCE_ID MSC_AVAILABLE_TO_PROMISE.ORGANIZATION_ID
%	MSC_SYSTEM_ITEMS
MSC_BOMS	MSC_SYSTEM_ITEMS	MSC_BOMS.ASSEMBLY_ITEM_ID MSC_BOMS.PLAN_ID MSC_BOMS.SR_INSTANCE_ID MSC_BOMS.ORGANIZATION_ID
MSC_BOM_COMPONENTS	MSC_SYSTEM_ITEMS	MSC_BOM_COMPONENTS.INVENTORY_ITEM_ID MSC_BOM_COMPONENTS.PLAN_ID MSC_BOM_COMPONENTS.SR_INSTANCE_ID MSC_BOM_COMPONENTS.ORGANIZATION_ID
MSC_BOR_REQUIREMENTS	MSC_SYSTEM_ITEMS	MSC_BOR_REQUIREMENTS.ASSEMBLY_ITEM_ID MSC_BOR_REQUIREMENTS.PLAN_ID MSC_BOR_REQUIREMENTS.SR_INSTANCE_ID MSC_BOR_REQUIREMENTS.ORGANIZATION_ID
MSC_DEMANDS	MSC_SYSTEM_ITEMS	MSC_DEMANDS.INVENTORY_ITEM_ID MSC_DEMANDS.PLAN_ID MSC_DEMANDS.SR_INSTANCE_ID MSC_DEMANDS.ORGANIZATION_ID
MSC_DEMANDS	MSC_SYSTEM_ITEMS	MSC_DEMANDS.USING_ASSEMBLY_ITEM_ID MSC_DEMANDS.PLAN_ID MSC_DEMANDS.SR_INSTANCE_ID MSC_DEMANDS.ORGANIZATION_ID
MSC_EXCEPTION_DETAILS	MSC_SYSTEM_ITEMS	MSC_EXCEPTION_DETAILS.INVENTORY_ITEM_ID MSC_EXCEPTION_DETAILS.PLAN_ID MSC_EXCEPTION_DETAILS.SR_INSTANCE_ID MSC_EXCEPTION_DETAILS.ORGANIZATION_ID
MSC_FORECAST_UPDATES	MSC_SYSTEM_ITEMS	MSC_FORECAST_UPDATES.INVENTORY_ITEM_ID MSC_FORECAST_UPDATES.PLAN_ID MSC_FORECAST_UPDATES.SR_INSTANCE_ID MSC_FORECAST_UPDATES.ORGANIZATION_ID
MSC_FULL_PEGGING	MSC_SYSTEM_ITEMS	MSC_FULL_PEGGING.INVENTORY_ITEM_ID MSC_FULL_PEGGING.PLAN_ID MSC_FULL_PEGGING.SR_INSTANCE_ID MSC_FULL_PEGGING.ORGANIZATION_ID
MSC_ITEM_EXCEPTIONS	MSC_SYSTEM_ITEMS	MSC_ITEM_EXCEPTIONS.INVENTORY_ITEM_ID MSC_ITEM_EXCEPTIONS.PLAN_ID MSC_ITEM_EXCEPTIONS.SR_INSTANCE_ID MSC_ITEM_EXCEPTIONS.ORGANIZATION_ID
MSC_ITEM_SOURCING	MSC_SYSTEM_ITEMS	MSC_ITEM_SOURCING.INVENTORY_ITEM_ID MSC_ITEM_SOURCING.PLAN_ID MSC_ITEM_SOURCING.SR_INSTANCE_ID MSC_ITEM_SOURCING.ORGANIZATION_ID
MSC_ITEM_SUPPLIERS	MSC_SYSTEM_ITEMS	MSC_ITEM_SUPPLIERS.INVENTORY_ITEM_ID MSC_ITEM_SUPPLIERS.PLAN_ID MSC_ITEM_SUPPLIERS.SR_INSTANCE_ID MSC_ITEM_SUPPLIERS.ORGANIZATION_ID
MSC_PROCESS_EFFECTIVITY	MSC_SYSTEM_ITEMS	MSC_PROCESS_EFFECTIVITY.ITEM_ID MSC_PROCESS_EFFECTIVITY.PLAN_ID MSC_PROCESS_EFFECTIVITY.SR_INSTANCE_ID MSC_PROCESS_EFFECTIVITY.ORGANIZATION_ID
MSC_RESERVATIONS	MSC_SYSTEM_ITEMS	MSC_RESERVATIONS.INVENTORY_ITEM_ID MSC_RESERVATIONS.PLAN_ID MSC_RESERVATIONS.SR_INSTANCE_ID MSC_RESERVATIONS.ORGANIZATION_ID
MSC_ROUTINGS	MSC_SYSTEM_ITEMS	MSC_ROUTINGS.ASSEMBLY_ITEM_ID MSC_ROUTINGS.PLAN_ID MSC_ROUTINGS.SR_INSTANCE_ID MSC_ROUTINGS.ORGANIZATION_ID
MSC_SAFETY_STOCKS	MSC_SYSTEM_ITEMS	MSC_SAFETY_STOCKS.INVENTORY_ITEM_ID MSC_SAFETY_STOCKS.PLAN_ID MSC_SAFETY_STOCKS.SR_INSTANCE_ID MSC_SAFETY_STOCKS.ORGANIZATION_ID
MSC_SEQUENCE_DEPENDENT_SETUPS	MSC_SYSTEM_ITEMS	MSC_SEQUENCE_DEPENDENT_SETUPS.FROM_ITEM MSC_SEQUENCE_DEPENDENT_SETUPS.PLAN_ID MSC_SEQUENCE_DEPENDENT_SETUPS.SR_INSTANCE_ID MSC_SEQUENCE_DEPENDENT_SETUPS.ORGANIZATION_ID
MSC_SEQUENCE_DEPENDENT_SETUPS	MSC_SYSTEM_ITEMS	MSC_SEQUENCE_DEPENDENT_SETUPS.TO_ITEM MSC_SEQUENCE_DEPENDENT_SETUPS.PLAN_ID MSC_SEQUENCE_DEPENDENT_SETUPS.SR_INSTANCE_ID MSC_SEQUENCE_DEPENDENT_SETUPS.ORGANIZATION_ID
MSC_SUPPLIES	MSC_SYSTEM_ITEMS	MSC_SUPPLIES.INVENTORY_ITEM_ID MSC_SUPPLIES.PLAN_ID MSC_SUPPLIES.SR_INSTANCE_ID MSC_SUPPLIES.ORGANIZATION_ID
MSC_COMPONENT_SUBSTITUTES	MSC_SYSTEM_ITEMS	MSC_COMPONENT_SUBSTITUTES.SUBSTITUTE_ITEM_ID MSC_COMPONENT_SUBSTITUTES.PLAN_ID MSC_COMPONENT_SUBSTITUTES.SR_INSTANCE_ID MSC_COMPONENT_SUBSTITUTES.ORGANIZATION_ID