FND Design Data [Home] [Help]

Table: CSP_CURR_SUP_DEM_SUMS

Product: CSP - Spares Management
Description: Summarized supply and demand information.
Implementation/DBA Data: TableCSP.CSP_CURR_SUP_DEM_SUMS
Primary Key: CSP_CURR_SUP_DEM_SUMS_PK
  1. ColumnSUPPLY_DEMAND_ID
Primary Key: CSP_CURR_SUP_DEM_UK
  1. ColumnORGANIZATION_ID
  2. ColumnINVENTORY_ITEM_ID
  3. ColumnSUBINVENTORY_CODE
Foreign Keys
Table
Foreign Table Foreign Key Column
CSP_CURR_SUP_DEM_SUMS FK Joins to TableCSP_REP_HIERARCHIES CSP_CURR_SUP_DEM_SUMS.HIERARCHY_NODE_ID
CSP_CURR_SUP_DEM_SUMS FK Joins to TableCSP_PARTS_LOOPS_B CSP_CURR_SUP_DEM_SUMS.PARTS_LOOP_ID
CSP_CURR_SUP_DEM_SUMS FK Joins to TableMTL_SYSTEM_ITEMS_B CSP_CURR_SUP_DEM_SUMS.INVENTORY_ITEM_ID
CSP_CURR_SUP_DEM_SUMS.ORGANIZATION_ID
CSP_CURR_SUP_DEM_SUMS FK Joins to TableMTL_SECONDARY_INVENTORIES CSP_CURR_SUP_DEM_SUMS.SUBINVENTORY_CODE
CSP_CURR_SUP_DEM_SUMS.ORGANIZATION_ID