FND Design Data [Home] [Help]

Table: MTL_CYCLE_COUNT_HEADERS

Product: INV - Inventory
Description: Defines cycle count header information
Implementation/DBA Data: TableINV.MTL_CYCLE_COUNT_HEADERS
Primary Key: MTL_CYCLE_COUNT_HEADERS_PK
  1. ColumnCYCLE_COUNT_HEADER_ID
Primary Key: MTL_CYCLE_COUNT_HEADERS_UK1
  1. ColumnCYCLE_COUNT_HEADER_NAME
  2. ColumnORGANIZATION_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
MTL_CYCLE_COUNT_HEADERS FK Joins to TableBOM_EXCEPTION_SETS MTL_CYCLE_COUNT_HEADERS.CALENDAR_EXCEPTION_SET
MTL_CYCLE_COUNT_HEADERS FK Joins to TableMTL_ABC_ASSIGNMENT_GROUPS MTL_CYCLE_COUNT_HEADERS.ABC_ASSIGNMENT_GROUP_ID
MTL_CYCLE_COUNT_HEADERS FK Joins to TableMTL_PARAMETERS MTL_CYCLE_COUNT_HEADERS.ORGANIZATION_ID
MTL_CYCLE_COUNT_HEADERS FK Joins to TableGL_CODE_COMBINATIONS MTL_CYCLE_COUNT_HEADERS.INVENTORY_ADJUSTMENT_ACCOUNT
MTL_CYCLE_COUNT_HEADERS FK Joins to TableBOM_CALENDARS MTL_CYCLE_COUNT_HEADERS.CYCLE_COUNT_CALENDAR
TableMTL_CC_ENTRIES_INTERFACE FK Joins to MTL_CYCLE_COUNT_HEADERS MTL_CC_ENTRIES_INTERFACE.CYCLE_COUNT_HEADER_ID
TableMTL_CC_SCHEDULE_REQUESTS FK Joins to MTL_CYCLE_COUNT_HEADERS MTL_CC_SCHEDULE_REQUESTS.CYCLE_COUNT_HEADER_ID
TableMTL_CC_SUBINVENTORIES FK Joins to MTL_CYCLE_COUNT_HEADERS MTL_CC_SUBINVENTORIES.CYCLE_COUNT_HEADER_ID
TableMTL_CYCLE_COUNT_CLASSES FK Joins to MTL_CYCLE_COUNT_HEADERS MTL_CYCLE_COUNT_CLASSES.CYCLE_COUNT_HEADER_ID
TableMTL_CYCLE_COUNT_ENTRIES FK Joins to MTL_CYCLE_COUNT_HEADERS MTL_CYCLE_COUNT_ENTRIES.CYCLE_COUNT_HEADER_ID
TableMTL_CYCLE_COUNT_ITEMS FK Joins to MTL_CYCLE_COUNT_HEADERS MTL_CYCLE_COUNT_ITEMS.CYCLE_COUNT_HEADER_ID