FND Design Data [Home] [Help]

Table: MTL_DEMAND

Product: INV - Inventory
Description: Sales order demand and reservations
Implementation/DBA Data: TableINV.MTL_DEMAND
Primary Key: MTL_DEMAND_PK
  1. ColumnINVENTORY_ITEM_ID
  2. ColumnDEMAND_SOURCE_HEADER_ID
  3. ColumnDEMAND_SOURCE_TYPE
  4. ColumnDEMAND_SOURCE_LINE
  5. ColumnDEMAND_SOURCE_DELIVERY
  6. ColumnCOMPONENT_SEQUENCE_ID
Primary Key: MTL_DEMAND_UK
  1. ColumnDEMAND_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
MTL_DEMAND FK Joins to TableMTL_SYSTEM_ITEMS_B MTL_DEMAND.INVENTORY_ITEM_ID
MTL_DEMAND.ORGANIZATION_ID
MTL_DEMAND FK Joins to TableMTL_SALES_ORDERS MTL_DEMAND.DEMAND_SOURCE_HEADER_ID
MTL_DEMAND FK Joins to TableGL_CODE_COMBINATIONS MTL_DEMAND.DEMAND_SOURCE_HEADER_ID
MTL_DEMAND FK Joins to TableMTL_GENERIC_DISPOSITIONS MTL_DEMAND.DEMAND_SOURCE_HEADER_ID
MTL_DEMAND.ORGANIZATION_ID
MTL_DEMAND FK Joins to TableMTL_ITEM_LOCATIONS MTL_DEMAND.LOCATOR_ID
MTL_DEMAND.ORGANIZATION_ID
MTL_DEMAND FK Joins to TableBOM_COMPONENTS_B MTL_DEMAND.COMPONENT_SEQUENCE_ID
MTL_DEMAND FK Joins to TableMTL_SECONDARY_INVENTORIES MTL_DEMAND.SUBINVENTORY
MTL_DEMAND.ORGANIZATION_ID
MTL_DEMAND FK Joins to TableMTL_LOT_NUMBERS MTL_DEMAND.INVENTORY_ITEM_ID
MTL_DEMAND.ORGANIZATION_ID
MTL_DEMAND.LOT_NUMBER
MTL_DEMAND FK Joins to TableMTL_ITEM_REVISIONS_B MTL_DEMAND.INVENTORY_ITEM_ID
MTL_DEMAND.ORGANIZATION_ID
MTL_DEMAND.REVISION
MTL_DEMAND FK Joins to TableMTL_SYSTEM_ITEMS_B MTL_DEMAND.DUPLICATED_CONFIG_ITEM_ID
MTL_DEMAND.ORGANIZATION_ID
MTL_DEMAND FK Joins to TableMTL_TXN_SOURCE_TYPES MTL_DEMAND.DEMAND_SOURCE_TYPE
TableMRP_RELIEF_INTERFACE FK Joins to MTL_DEMAND MRP_RELIEF_INTERFACE.DISPOSITION_ID
TableMRP_SALES_ORDER_UPDATES FK Joins to MTL_DEMAND MRP_SALES_ORDER_UPDATES.SALES_ORDER_ID
TableMTL_DEMAND_INTERFACE FK Joins to MTL_DEMAND MTL_DEMAND_INTERFACE.DEMAND_ID