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

Product:	CRP - Capacity
Description:	Results of the rollup for rough cut capacity
Implementation/DBA Data:	CRP.CRP_RESOURCE_HOURS

Primary Key: CRP_RESOURCE_HOURS_PK

TRANSACTION_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
CRP_RESOURCE_HOURS	CRP_BILL_OF_RESOURCE_ITEMS	CRP_RESOURCE_HOURS.ASSEMBLY_ITEM_ID CRP_RESOURCE_HOURS.BILL_OF_RESOURCES CRP_RESOURCE_HOURS.ORGANIZATION_ID
CRP_RESOURCE_HOURS	BOM_DEPARTMENT_RESOURCES	CRP_RESOURCE_HOURS.DEPARTMENT_ID CRP_RESOURCE_HOURS.RESOURCE_ID
CRP_RESOURCE_HOURS	MTL_SYSTEM_ITEMS_B	CRP_RESOURCE_HOURS.SOURCE_ITEM_ID CRP_RESOURCE_HOURS.ORGANIZATION_ID
CRP_RESOURCE_HOURS	BOM_OPERATION_RESOURCES	CRP_RESOURCE_HOURS.OPERATION_SEQUENCE_ID CRP_RESOURCE_HOURS.RESOURCE_SEQ_NUM