FND Design Data [Home] [Help]

Table: BOM_RESOURCE_SHIFTS

Product: BOM - Bills of Material
Description: Resource shift information
Implementation/DBA Data: TableBOM.BOM_RESOURCE_SHIFTS
Primary Key: BOM_RESOURCE_SHIFTS_PK
  1. ColumnDEPARTMENT_ID
  2. ColumnRESOURCE_ID
  3. ColumnSHIFT_NUM
Foreign Keys
Table
Foreign Table Foreign Key Column
BOM_RESOURCE_SHIFTS FK Joins to TableBOM_DEPARTMENT_RESOURCES BOM_RESOURCE_SHIFTS.DEPARTMENT_ID
BOM_RESOURCE_SHIFTS.RESOURCE_ID
TableBOM_RESOURCE_CHANGES FK Joins to BOM_RESOURCE_SHIFTS BOM_RESOURCE_CHANGES.DEPARTMENT_ID
BOM_RESOURCE_CHANGES.RESOURCE_ID
BOM_RESOURCE_CHANGES.SHIFT_NUM