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_USAGE_HISTORIES

Product:	CSP - Spares Management
Description:	Summarized usage history information
Implementation/DBA Data:	CSP.CSP_USAGE_HISTORIES

Primary Key: CSP_USAGE_HISTORIES_PK

ORGANIZATION_ID
SUBINVENTORY_CODE
INVENTORY_ITEM_ID
HISTORY_DATA_TYPE
PERIOD_START_DATE
PERIOD_TYPE

Foreign Keys

Table	Foreign Table	Foreign Key Column
CSP_USAGE_HISTORIES	CSP_PARTS_LOOPS_B	CSP_USAGE_HISTORIES.PARTS_LOOP_ID
CSP_USAGE_HISTORIES	CSP_REP_HIERARCHIES	CSP_USAGE_HISTORIES.HIERARCHY_NODE_ID
CSP_USAGE_HISTORIES	MTL_SYSTEM_ITEMS_B	CSP_USAGE_HISTORIES.INVENTORY_ITEM_ID CSP_USAGE_HISTORIES.ORGANIZATION_ID
CSP_USAGE_HISTORIES	MTL_SECONDARY_INVENTORIES	CSP_USAGE_HISTORIES.SUBINVENTORY_CODE CSP_USAGE_HISTORIES.ORGANIZATION_ID
CSP_USAGE_HISTORIES	MTL_TRANSACTION_TYPES	CSP_USAGE_HISTORIES.TRANSACTION_TYPE_ID