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

Product:	BOM - Bills of Material
Description:	Resources associated with departments
Implementation/DBA Data:	BOM.BOM_DEPARTMENT_RESOURCES

Primary Key: BOM_DEPARTMENT_RESOURCES_PK

DEPARTMENT_ID
RESOURCE_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
BOM_DEPARTMENT_RESOURCES	BOM_DEPARTMENTS	BOM_DEPARTMENT_RESOURCES.DEPARTMENT_ID
BOM_DEPARTMENT_RESOURCES	BOM_RESOURCES	BOM_DEPARTMENT_RESOURCES.RESOURCE_ID
BOM_DEPARTMENT_RESOURCES	MTL_ATP_RULES	BOM_DEPARTMENT_RESOURCES.ATP_RULE_ID
BOM_DEPT_RES_INSTANCES	BOM_DEPARTMENT_RESOURCES	BOM_DEPT_RES_INSTANCES.DEPARTMENT_ID BOM_DEPT_RES_INSTANCES.RESOURCE_ID
BOM_RESOURCE_SHIFTS	BOM_DEPARTMENT_RESOURCES	BOM_RESOURCE_SHIFTS.DEPARTMENT_ID BOM_RESOURCE_SHIFTS.RESOURCE_ID
CRP_PLANNED_RESOURCES	BOM_DEPARTMENT_RESOURCES	CRP_PLANNED_RESOURCES.DEPARTMENT_ID CRP_PLANNED_RESOURCES.RESOURCE_ID
CRP_RESOURCE_HOURS	BOM_DEPARTMENT_RESOURCES	CRP_RESOURCE_HOURS.DEPARTMENT_ID CRP_RESOURCE_HOURS.RESOURCE_ID
MRP_WIP_RESOURCES	BOM_DEPARTMENT_RESOURCES	MRP_WIP_RESOURCES.DEPARTMENT_ID MRP_WIP_RESOURCES.RESOURCE_ID