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_RECOMMENDATIONS

Product:	MRP - Master Scheduling/MRP
Description:	MRP plan recommendations
Implementation/DBA Data:	MRP.MRP_RECOMMENDATIONS

Primary Key: MRP_RECOMMENDATIONS_PK

TRANSACTION_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
MRP_RECOMMENDATIONS	MRP_SYSTEM_ITEMS	MRP_RECOMMENDATIONS.INVENTORY_ITEM_ID MRP_RECOMMENDATIONS.ORGANIZATION_ID MRP_RECOMMENDATIONS.COMPILE_DESIGNATOR
MRP_RECOMMENDATIONS	MRP_ITEM_PURCHASE_ORDERS	MRP_RECOMMENDATIONS.DISPOSITION_ID
MRP_RECOMMENDATIONS	MRP_ITEM_WIP_ENTITIES	MRP_RECOMMENDATIONS.INVENTORY_ITEM_ID MRP_RECOMMENDATIONS.ORGANIZATION_ID MRP_RECOMMENDATIONS.COMPILE_DESIGNATOR MRP_RECOMMENDATIONS.DISPOSITION_ID
MRP_RECOMMENDATIONS	MRP_RECOMMENDATIONS	MRP_RECOMMENDATIONS.DISPOSITION_ID
MRP_RECOMMENDATIONS	WIP_LINES	MRP_RECOMMENDATIONS.LINE_ID
CRP_RESOURCE_PLAN	MRP_RECOMMENDATIONS	CRP_RESOURCE_PLAN.SOURCE_TRANSACTION_ID
MRP_FULL_PEGGING	MRP_RECOMMENDATIONS	MRP_FULL_PEGGING.TRANSACTION_ID
MRP_GROSS_REQUIREMENTS	MRP_RECOMMENDATIONS	MRP_GROSS_REQUIREMENTS.DISPOSITION_ID
MRP_RECOMMENDATIONS	MRP_RECOMMENDATIONS	MRP_RECOMMENDATIONS.DISPOSITION_ID
MRP_RELIEF_INTERFACE	MRP_RECOMMENDATIONS	MRP_RELIEF_INTERFACE.PLANNED_ORDER_ID
MRP_SCHEDULE_DATES	MRP_RECOMMENDATIONS	MRP_SCHEDULE_DATES.REFERENCE_SCHEDULE_ID
MRP_SUGG_REP_SCHEDULES	MRP_RECOMMENDATIONS	MRP_SUGG_REP_SCHEDULES.TRANSACTION_ID
MRP_WORKBENCH_QUERY	MRP_RECOMMENDATIONS	MRP_WORKBENCH_QUERY.TRANSACTION_ID