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.

Skip to content FND Design Data

[Home] [Help]

Table: WMS_DEPARTMENT_SUBINVENTORIES

Product:	WMS - Warehouse Management
Description:	This is a cross reference table for departments and subinventories.
Implementation/DBA Data:	WMS.WMS_DEPARTMENT_SUBINVENTORIES

Primary Key: WMS_DEPARTMENT_SUBINVENTORI_PK

ORGANIZATION_ID
SUBINVENTORY_CODE
DEPARTMENT_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
WMS_DEPARTMENT_SUBINVENTORIES	MTL_SECONDARY_INVENTORIES	WMS_DEPARTMENT_SUBINVENTORIES.SUBINVENTORY_CODE WMS_DEPARTMENT_SUBINVENTORIES.ORGANIZATION_ID
WMS_DEPARTMENT_SUBINVENTORIES	BOM_DEPARTMENTS	WMS_DEPARTMENT_SUBINVENTORIES.DEPARTMENT_ID
WMS_DEPARTMENT_SUBINVENTORIES	MTL_PARAMETERS	WMS_DEPARTMENT_SUBINVENTORIES.ORGANIZATION_ID