FND Design Data [Home] [Help]

Table: MTL_CYCLE_COUNT_ITEMS

Product: INV - Inventory
Description: Defines items to be used in cycle count
Implementation/DBA Data: TableINV.MTL_CYCLE_COUNT_ITEMS
Primary Key: MTL_CYCLE_COUNT_ITEMS_PK
  1. ColumnCYCLE_COUNT_HEADER_ID
  2. ColumnINVENTORY_ITEM_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
MTL_CYCLE_COUNT_ITEMS FK Joins to TableMTL_CYCLE_COUNT_HEADERS MTL_CYCLE_COUNT_ITEMS.CYCLE_COUNT_HEADER_ID
MTL_CYCLE_COUNT_ITEMS FK Joins to TableMTL_ABC_CLASSES MTL_CYCLE_COUNT_ITEMS.ABC_CLASS_ID
MTL_CYCLE_COUNT_ITEMS FK Joins to TableMTL_CYCLE_COUNT_CLASSES MTL_CYCLE_COUNT_ITEMS.ABC_CLASS_ID
MTL_CYCLE_COUNT_ITEMS.CYCLE_COUNT_HEADER_ID
TableMTL_CC_SCHEDULE_REQUESTS FK Joins to MTL_CYCLE_COUNT_ITEMS MTL_CC_SCHEDULE_REQUESTS.CYCLE_COUNT_HEADER_ID
MTL_CC_SCHEDULE_REQUESTS.INVENTORY_ITEM_ID