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_INV_LOC_ASSIGNMENTS

Product:	CSP - Spares Management
Description:	Inventory location assignments to resources
Implementation/DBA Data:	CSP.CSP_INV_LOC_ASSIGNMENTS

Primary Key: CSP_INV_LOC_ASSIGNMENTS_PK

CSP_INV_LOC_ASSIGNMENT_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
CSP_INV_LOC_ASSIGNMENTS		MTL_SECONDARY_INVENTORIES	CSP_INV_LOC_ASSIGNMENTS.SUBINVENTORY_CODE CSP_INV_LOC_ASSIGNMENTS.ORGANIZATION_ID
CSP_INV_LOC_ASSIGNMENTS		MTL_ITEM_LOCATIONS	CSP_INV_LOC_ASSIGNMENTS.LOCATOR_ID CSP_INV_LOC_ASSIGNMENTS.ORGANIZATION_ID