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: MRP_PLANS

Product:	MRP - Master Scheduling/MRP
Description:	Settings for a specific plan name
Implementation/DBA Data:	MRP.MRP_PLANS

Primary Key: MRP_PLANS_PK

ORGANIZATION_ID
COMPILE_DESIGNATOR

Foreign Keys

Table	Foreign Table	Foreign Key Column
MRP_PLANS	MRP_DESIGNATORS	MRP_PLANS.COMPILE_DESIGNATOR MRP_PLANS.ORGANIZATION_ID
MRP_PLANS	MRP_SCHEDULE_DESIGNATORS	MRP_PLANS.CURR_SCHEDULE_DESIGNATOR MRP_PLANS.ORGANIZATION_ID
MRP_PLANS	MRP_SCHEDULE_DESIGNATORS	MRP_PLANS.SCHEDULE_DESIGNATOR MRP_PLANS.ORGANIZATION_ID
MRP_PLANS	MRP_ASSIGNMENT_SETS	MRP_PLANS.ASSIGNMENT_SET_ID
MRP_PLANS	MRP_SCHEDULE_DESIGNATORS	MRP_PLANS.COMPILE_DESIGNATOR MRP_PLANS.ORGANIZATION_ID
MRP_FILES	MRP_PLANS	MRP_FILES.ORGANIZATION_ID MRP_FILES.COMPILE_DESIGNATOR
MRP_PLAN_ORGANIZATIONS	MRP_PLANS	MRP_PLAN_ORGANIZATIONS.ORGANIZATION_ID MRP_PLAN_ORGANIZATIONS.COMPILE_DESIGNATOR
MTL_ABC_COMPILE_HEADERS	MRP_PLANS	MTL_ABC_COMPILE_HEADERS.ORGANIZATION_ID MTL_ABC_COMPILE_HEADERS.MRP_PLAN_NAME