FND Design Data [Home] [Help]

Table: MTL_CYCLE_COUNT_ENTRIES

Product: INV - Inventory
Description: Defines cycle count entries
Implementation/DBA Data: TableINV.MTL_CYCLE_COUNT_ENTRIES
Primary Key: MTL_CYCLE_COUNT_ENTRIES_PK
  1. ColumnCYCLE_COUNT_ENTRY_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
MTL_CYCLE_COUNT_ENTRIES FK Joins to TableMTL_ITEM_REVISIONS_B MTL_CYCLE_COUNT_ENTRIES.INVENTORY_ITEM_ID
MTL_CYCLE_COUNT_ENTRIES.ORGANIZATION_ID
MTL_CYCLE_COUNT_ENTRIES.REVISION
MTL_CYCLE_COUNT_ENTRIES FK Joins to TableMTL_LOT_NUMBERS MTL_CYCLE_COUNT_ENTRIES.INVENTORY_ITEM_ID
MTL_CYCLE_COUNT_ENTRIES.ORGANIZATION_ID
MTL_CYCLE_COUNT_ENTRIES.LOT_NUMBER
MTL_CYCLE_COUNT_ENTRIES FK Joins to TableMTL_TRANSACTION_REASONS MTL_CYCLE_COUNT_ENTRIES.TRANSACTION_REASON_ID
MTL_CYCLE_COUNT_ENTRIES FK Joins to TableCST_COST_GROUPS MTL_CYCLE_COUNT_ENTRIES.COST_GROUP_ID
MTL_CYCLE_COUNT_ENTRIES FK Joins to TableWMS_LICENSE_PLATE_NUMBERS MTL_CYCLE_COUNT_ENTRIES.PARENT_LPN_ID
MTL_CYCLE_COUNT_ENTRIES FK Joins to TableWMS_LICENSE_PLATE_NUMBERS MTL_CYCLE_COUNT_ENTRIES.OUTERMOST_LPN_ID
MTL_CYCLE_COUNT_ENTRIES FK Joins to TableMTL_SYSTEM_ITEMS_B MTL_CYCLE_COUNT_ENTRIES.INVENTORY_ITEM_ID
MTL_CYCLE_COUNT_ENTRIES.ORGANIZATION_ID
MTL_CYCLE_COUNT_ENTRIES FK Joins to TableMTL_SECONDARY_INVENTORIES MTL_CYCLE_COUNT_ENTRIES.SUBINVENTORY
MTL_CYCLE_COUNT_ENTRIES.ORGANIZATION_ID
MTL_CYCLE_COUNT_ENTRIES FK Joins to TableMTL_PARAMETERS MTL_CYCLE_COUNT_ENTRIES.ORGANIZATION_ID
MTL_CYCLE_COUNT_ENTRIES FK Joins to TableMTL_CYCLE_COUNT_HEADERS MTL_CYCLE_COUNT_ENTRIES.CYCLE_COUNT_HEADER_ID
MTL_CYCLE_COUNT_ENTRIES FK Joins to TableMTL_ITEM_LOCATIONS MTL_CYCLE_COUNT_ENTRIES.LOCATOR_ID
MTL_CYCLE_COUNT_ENTRIES.ORGANIZATION_ID
MTL_CYCLE_COUNT_ENTRIES FK Joins to TableGL_CODE_COMBINATIONS MTL_CYCLE_COUNT_ENTRIES.INVENTORY_ADJUSTMENT_ACCOUNT
TableMTL_CC_ENTRIES_INTERFACE FK Joins to MTL_CYCLE_COUNT_ENTRIES MTL_CC_ENTRIES_INTERFACE.CYCLE_COUNT_ENTRY_ID
TableMTL_CC_SCHED_COUNT_XREFS FK Joins to MTL_CYCLE_COUNT_ENTRIES MTL_CC_SCHED_COUNT_XREFS.CYCLE_COUNT_ENTRY_ID
TableMTL_CC_SERIAL_NUMBERS FK Joins to MTL_CYCLE_COUNT_ENTRIES MTL_CC_SERIAL_NUMBERS.CYCLE_COUNT_ENTRY_ID
TableMTL_MATERIAL_TRANSACTIONS FK Joins to MTL_CYCLE_COUNT_ENTRIES MTL_MATERIAL_TRANSACTIONS.CYCLE_COUNT_ID