eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: CSP_CURR_SUP_DEM_SUMS

Product:	CSP - Spares Management
Description:	Summarized supply and demand information.
Implementation/DBA Data:	CSP.CSP_CURR_SUP_DEM_SUMS

Primary Key: CSP_CURR_SUP_DEM_SUMS_PK

SUPPLY_DEMAND_ID

Primary Key: CSP_CURR_SUP_DEM_UK

ORGANIZATION_ID
INVENTORY_ITEM_ID
SUBINVENTORY_CODE

Foreign Keys

Table	Foreign Table	Foreign Key Column
CSP_CURR_SUP_DEM_SUMS	CSP_REP_HIERARCHIES	CSP_CURR_SUP_DEM_SUMS.HIERARCHY_NODE_ID
CSP_CURR_SUP_DEM_SUMS	CSP_PARTS_LOOPS_B	CSP_CURR_SUP_DEM_SUMS.PARTS_LOOP_ID
CSP_CURR_SUP_DEM_SUMS	MTL_SYSTEM_ITEMS_B	CSP_CURR_SUP_DEM_SUMS.INVENTORY_ITEM_ID CSP_CURR_SUP_DEM_SUMS.ORGANIZATION_ID
CSP_CURR_SUP_DEM_SUMS	MTL_SECONDARY_INVENTORIES	CSP_CURR_SUP_DEM_SUMS.SUBINVENTORY_CODE CSP_CURR_SUP_DEM_SUMS.ORGANIZATION_ID