Table: MRP_SYSTEM_ITEMS

Product:	MRP - Master Scheduling/MRP
Description:	MRP item master
Implementation/DBA Data:	MRP.MRP_SYSTEM_ITEMS

Primary Key: MRP_SYSTEM_ITEMS_PK

1. INVENTORY_ITEM_ID
2. ORGANIZATION_ID
3. COMPILE_DESIGNATOR

Foreign Keys

Table		Foreign Table	Foreign Key Column
MRP_SYSTEM_ITEMS		MTL_CATEGORIES_B	MRP_SYSTEM_ITEMS.CATEGORY_ID
MRP_SYSTEM_ITEMS		MRP_SYSTEM_ITEMS	MRP_SYSTEM_ITEMS.BASE_ITEM_ID MRP_SYSTEM_ITEMS.ORGANIZATION_ID MRP_SYSTEM_ITEMS.COMPILE_DESIGNATOR
MRP_SYSTEM_ITEMS		PO_AGENTS	MRP_SYSTEM_ITEMS.BUYER_ID
MRP_SYSTEM_ITEMS		MTL_ITEM_REVISIONS_B	MRP_SYSTEM_ITEMS.INVENTORY_ITEM_ID MRP_SYSTEM_ITEMS.ORGANIZATION_ID MRP_SYSTEM_ITEMS.REVISION
MRP_SYSTEM_ITEMS		MTL_SYSTEM_ITEMS_B	MRP_SYSTEM_ITEMS.INVENTORY_ITEM_ID MRP_SYSTEM_ITEMS.ORGANIZATION_ID
MRP_SYSTEM_ITEMS		MRP_PLANNING_EXCEPTION_SETS	MRP_SYSTEM_ITEMS.PLANNING_EXCEPTION_SET MRP_SYSTEM_ITEMS.ORGANIZATION_ID
MRP_SYSTEM_ITEMS		MTL_ABC_CLASSES	MRP_SYSTEM_ITEMS.ABC_CLASS
MRP_AGGREGATE_RATES		MRP_SYSTEM_ITEMS	MRP_AGGREGATE_RATES.INVENTORY_ITEM_ID MRP_AGGREGATE_RATES.ORGANIZATION_ID MRP_AGGREGATE_RATES.COMPILE_DESIGNATOR
MRP_ASSEMBLY_OPERATIONS		MRP_SYSTEM_ITEMS	MRP_ASSEMBLY_OPERATIONS.INVENTORY_ITEM_ID MRP_ASSEMBLY_OPERATIONS.ORGANIZATION_ID MRP_ASSEMBLY_OPERATIONS.COMPILE_DESIGNATOR
MRP_ASSEMBLY_OPERATIONS		MRP_SYSTEM_ITEMS	MRP_ASSEMBLY_OPERATIONS.USING_ASSEMBLY_ITEM_ID MRP_ASSEMBLY_OPERATIONS.ORGANIZATION_ID MRP_ASSEMBLY_OPERATIONS.COMPILE_DESIGNATOR
MRP_AVAILABLE_TO_PROMISE		MRP_SYSTEM_ITEMS	MRP_AVAILABLE_TO_PROMISE.INVENTORY_ITEM_ID MRP_AVAILABLE_TO_PROMISE.ORGANIZATION_ID MRP_AVAILABLE_TO_PROMISE.COMPILE_DESIGNATOR
MRP_BOM_COMPONENTS		MRP_SYSTEM_ITEMS	MRP_BOM_COMPONENTS.INVENTORY_ITEM_ID MRP_BOM_COMPONENTS.ORGANIZATION_ID MRP_BOM_COMPONENTS.COMPILE_DESIGNATOR
MRP_BOM_COMPONENTS		MRP_SYSTEM_ITEMS	MRP_BOM_COMPONENTS.USING_ASSEMBLY_ID MRP_BOM_COMPONENTS.ORGANIZATION_ID MRP_BOM_COMPONENTS.COMPILE_DESIGNATOR
MRP_COMPONENT_SUBSTITUTES		MRP_SYSTEM_ITEMS	MRP_COMPONENT_SUBSTITUTES.INVENTORY_ITEM_ID MRP_COMPONENT_SUBSTITUTES.ORGANIZATION_ID MRP_COMPONENT_SUBSTITUTES.COMPILE_DESIGNATOR
MRP_COMPONENT_SUBSTITUTES		MRP_SYSTEM_ITEMS	MRP_COMPONENT_SUBSTITUTES.SUBSTITUTE_ITEM_ID MRP_COMPONENT_SUBSTITUTES.ORGANIZATION_ID MRP_COMPONENT_SUBSTITUTES.COMPILE_DESIGNATOR
MRP_COMPONENT_SUBSTITUTES		MRP_SYSTEM_ITEMS	MRP_COMPONENT_SUBSTITUTES.USING_ASSEMBLY_ITEM_ID MRP_COMPONENT_SUBSTITUTES.ORGANIZATION_ID MRP_COMPONENT_SUBSTITUTES.COMPILE_DESIGNATOR
MRP_END_ASSEMBLIES		MRP_SYSTEM_ITEMS	MRP_END_ASSEMBLIES.INVENTORY_ITEM_ID MRP_END_ASSEMBLIES.ORGANIZATION_ID MRP_END_ASSEMBLIES.COMPILE_DESIGNATOR
MRP_END_ASSEMBLIES		MRP_SYSTEM_ITEMS	MRP_END_ASSEMBLIES.END_ASSEMBLY_ID MRP_END_ASSEMBLIES.ORGANIZATION_ID MRP_END_ASSEMBLIES.COMPILE_DESIGNATOR
MRP_END_ASSEMBLIES		MRP_SYSTEM_ITEMS	MRP_END_ASSEMBLIES.USING_ASSEMBLY_ID MRP_END_ASSEMBLIES.ORGANIZATION_ID MRP_END_ASSEMBLIES.COMPILE_DESIGNATOR
MRP_GROSS_REQUIREMENTS		MRP_SYSTEM_ITEMS	MRP_GROSS_REQUIREMENTS.INVENTORY_ITEM_ID MRP_GROSS_REQUIREMENTS.ORGANIZATION_ID MRP_GROSS_REQUIREMENTS.COMPILE_DESIGNATOR
MRP_GROSS_REQUIREMENTS		MRP_SYSTEM_ITEMS	MRP_GROSS_REQUIREMENTS.USING_ASSEMBLY_ITEM_ID MRP_GROSS_REQUIREMENTS.ORGANIZATION_ID MRP_GROSS_REQUIREMENTS.COMPILE_DESIGNATOR
MRP_INVENTORY_LOTS		MRP_SYSTEM_ITEMS	MRP_INVENTORY_LOTS.INVENTORY_ITEM_ID MRP_INVENTORY_LOTS.ORGANIZATION_ID MRP_INVENTORY_LOTS.COMPILE_DESIGNATOR
MRP_ITEM_EXCEPTIONS		MRP_SYSTEM_ITEMS	MRP_ITEM_EXCEPTIONS.INVENTORY_ITEM_ID MRP_ITEM_EXCEPTIONS.ORGANIZATION_ID MRP_ITEM_EXCEPTIONS.COMPILE_DESIGNATOR
MRP_ITEM_PURCHASE_ORDERS		MRP_SYSTEM_ITEMS	MRP_ITEM_PURCHASE_ORDERS.INVENTORY_ITEM_ID MRP_ITEM_PURCHASE_ORDERS.ORGANIZATION_ID MRP_ITEM_PURCHASE_ORDERS.COMPILE_DESIGNATOR
MRP_ITEM_SOURCING		MRP_SYSTEM_ITEMS	MRP_ITEM_SOURCING.INVENTORY_ITEM_ID MRP_ITEM_SOURCING.ORGANIZATION_ID MRP_ITEM_SOURCING.COMPILE_DESIGNATOR
MRP_ITEM_WIP_ENTITIES		MRP_SYSTEM_ITEMS	MRP_ITEM_WIP_ENTITIES.INVENTORY_ITEM_ID MRP_ITEM_WIP_ENTITIES.ORGANIZATION_ID MRP_ITEM_WIP_ENTITIES.COMPILE_DESIGNATOR
MRP_MATERIAL_PLANS		MRP_SYSTEM_ITEMS	MRP_MATERIAL_PLANS.INVENTORY_ITEM_ID MRP_MATERIAL_PLANS.ORGANIZATION_ID MRP_MATERIAL_PLANS.COMPILE_DESIGNATOR
MRP_ONHAND_QUANTITIES		MRP_SYSTEM_ITEMS	MRP_ONHAND_QUANTITIES.INVENTORY_ITEM_ID MRP_ONHAND_QUANTITIES.ORGANIZATION_ID MRP_ONHAND_QUANTITIES.COMPILE_DESIGNATOR
MRP_PENDING_ENG_CHANGES		MRP_SYSTEM_ITEMS	MRP_PENDING_ENG_CHANGES.INVENTORY_ITEM_ID MRP_PENDING_ENG_CHANGES.ORGANIZATION_ID MRP_PENDING_ENG_CHANGES.COMPILE_DESIGNATOR
MRP_PENDING_ENG_CHANGES		MRP_SYSTEM_ITEMS	MRP_PENDING_ENG_CHANGES.ENG_CHANGE_USING_ASSY_ID MRP_PENDING_ENG_CHANGES.ORGANIZATION_ID MRP_PENDING_ENG_CHANGES.COMPILE_DESIGNATOR
MRP_PENDING_ENG_CHANGES		MRP_SYSTEM_ITEMS	MRP_PENDING_ENG_CHANGES.DRIVING_ITEM_ID MRP_PENDING_ENG_CHANGES.ORGANIZATION_ID MRP_PENDING_ENG_CHANGES.COMPILE_DESIGNATOR
MRP_PLANNED_RESOURCE_REQS		MRP_SYSTEM_ITEMS	MRP_PLANNED_RESOURCE_REQS.USING_ASSEMBLY_ITEM_ID MRP_PLANNED_RESOURCE_REQS.ORGANIZATION_ID MRP_PLANNED_RESOURCE_REQS.COMPILE_DESIGNATOR
MRP_RECOMMENDATIONS		MRP_SYSTEM_ITEMS	MRP_RECOMMENDATIONS.INVENTORY_ITEM_ID MRP_RECOMMENDATIONS.ORGANIZATION_ID MRP_RECOMMENDATIONS.COMPILE_DESIGNATOR
MRP_REPETITIVE_SCHEDULES		MRP_SYSTEM_ITEMS	MRP_REPETITIVE_SCHEDULES.INVENTORY_ITEM_ID MRP_REPETITIVE_SCHEDULES.ORGANIZATION_ID MRP_REPETITIVE_SCHEDULES.COMPILE_DESIGNATOR
MRP_RESERVATIONS		MRP_SYSTEM_ITEMS	MRP_RESERVATIONS.INVENTORY_ITEM_ID MRP_RESERVATIONS.ORGANIZATION_ID MRP_RESERVATIONS.COMPILE_DESIGNATOR
MRP_SAFETY_STOCK		MRP_SYSTEM_ITEMS	MRP_SAFETY_STOCK.INVENTORY_ITEM_ID MRP_SAFETY_STOCK.ORGANIZATION_ID MRP_SAFETY_STOCK.COMPILE_DESIGNATOR
MRP_SUGG_REP_SCHEDULES		MRP_SYSTEM_ITEMS	MRP_SUGG_REP_SCHEDULES.INVENTORY_ITEM_ID MRP_SUGG_REP_SCHEDULES.ORGANIZATION_ID MRP_SUGG_REP_SCHEDULES.COMPILE_DESIGNATOR
MRP_SYSTEM_ITEMS		MRP_SYSTEM_ITEMS	MRP_SYSTEM_ITEMS.BASE_ITEM_ID MRP_SYSTEM_ITEMS.ORGANIZATION_ID MRP_SYSTEM_ITEMS.COMPILE_DESIGNATOR
MRP_WIP_COMPONENTS		MRP_SYSTEM_ITEMS	MRP_WIP_COMPONENTS.INVENTORY_ITEM_ID MRP_WIP_COMPONENTS.ORGANIZATION_ID MRP_WIP_COMPONENTS.COMPILE_DESIGNATOR
MRP_WIP_COMPONENTS		MRP_SYSTEM_ITEMS	MRP_WIP_COMPONENTS.JOB_REFERENCE_ITEM_ID MRP_WIP_COMPONENTS.ORGANIZATION_ID MRP_WIP_COMPONENTS.COMPILE_DESIGNATOR
MRP_WORKBENCH_QUERY		MRP_SYSTEM_ITEMS	MRP_WORKBENCH_QUERY.INVENTORY_ITEM_ID MRP_WORKBENCH_QUERY.ORGANIZATION_ID MRP_WORKBENCH_QUERY.DESIGNATOR