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: MSC_SUB_INVENTORIES

Product:	MSC - Advanced Supply Chain Planning
Description:	MSC_SUB_INVENTORIES stores information about the netting type of eachsubinventory defined in Oracle Inventory. Each subinventory will havean entry in MSC_SUB_INVENTORIES and NETTING_TYPE will indicate whetheror not that subinventory should
Implementation/DBA Data:	MSC.MSC_SUB_INVENTORIES

Primary Key: MSC_SUB_INVENTORIES_PK

SR_INSTANCE_ID
ORGANIZATION_ID
SUB_INVENTORY_CODE
PLAN_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
MSC_SUB_INVENTORIES		MSC_PLAN_ORGANIZATIONS	MSC_SUB_INVENTORIES.PLAN_ID MSC_SUB_INVENTORIES.ORGANIZATION_ID MSC_SUB_INVENTORIES.SR_INSTANCE_ID
MSC_RESERVATIONS		MSC_SUB_INVENTORIES	MSC_RESERVATIONS.SR_INSTANCE_ID MSC_RESERVATIONS.PLAN_ID MSC_RESERVATIONS.ORGANIZATION_ID MSC_RESERVATIONS.SUBINVENTORY