FND Design Data [Home] [Help]

Table: BOM_CALENDAR_SHIFTS

Product: BOM - Bills of Material
Description: Workday calendar shifts
Implementation/DBA Data: TableBOM.BOM_CALENDAR_SHIFTS
Primary Key: BOM_CALENDAR_SHIFTS_PK
  1. ColumnCALENDAR_CODE
  2. ColumnSHIFT_NUM
Foreign Keys
Table
Foreign Table Foreign Key Column
BOM_CALENDAR_SHIFTS FK Joins to TableBOM_CALENDARS BOM_CALENDAR_SHIFTS.CALENDAR_CODE
TableBOM_SHIFT_DATES FK Joins to BOM_CALENDAR_SHIFTS BOM_SHIFT_DATES.CALENDAR_CODE
BOM_SHIFT_DATES.SHIFT_NUM
TableBOM_SHIFT_EXCEPTIONS FK Joins to BOM_CALENDAR_SHIFTS BOM_SHIFT_EXCEPTIONS.CALENDAR_CODE
BOM_SHIFT_EXCEPTIONS.SHIFT_NUM
TableBOM_SHIFT_TIMES FK Joins to BOM_CALENDAR_SHIFTS BOM_SHIFT_TIMES.CALENDAR_CODE
BOM_SHIFT_TIMES.SHIFT_NUM
TableBOM_WORKDAY_PATTERNS FK Joins to BOM_CALENDAR_SHIFTS BOM_WORKDAY_PATTERNS.CALENDAR_CODE
BOM_WORKDAY_PATTERNS.SHIFT_NUM