Product: | MRP - Master Scheduling/MRP |
---|---|
Description: | MRP item master |
Implementation/DBA Data: | MRP.MRP_SYSTEM_ITEMS |
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 |
|
|
|