FND Design Data [Home] [Help]

Table: MTL_MATERIAL_TXN_ALLOCATIONS

Product: INV - Inventory
Description: Unit allocations among repetitive schedules
Implementation/DBA Data: TableINV.MTL_MATERIAL_TXN_ALLOCATIONS
Primary Key: MTL_MATERIAL_TXN_ALLOCATION_PK
  1. ColumnTRANSACTION_ID
  2. ColumnREPETITIVE_SCHEDULE_ID
  3. ColumnORGANIZATION_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
MTL_MATERIAL_TXN_ALLOCATIONS FK Joins to TableMTL_MATERIAL_TRANSACTIONS MTL_MATERIAL_TXN_ALLOCATIONS.TRANSACTION_ID
MTL_MATERIAL_TXN_ALLOCATIONS FK Joins to TableWIP_REPETITIVE_SCHEDULES MTL_MATERIAL_TXN_ALLOCATIONS.REPETITIVE_SCHEDULE_ID
MTL_MATERIAL_TXN_ALLOCATIONS FK Joins to TableMTL_PARAMETERS MTL_MATERIAL_TXN_ALLOCATIONS.ORGANIZATION_ID