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

Product:	INV - Inventory
Description:	Item-subinventory-locator assignments
Implementation/DBA Data:	INV.MTL_SECONDARY_LOCATORS

Primary Key: MTL_SECONDARY_LOCATORS_PK

INVENTORY_ITEM_ID
ORGANIZATION_ID
SECONDARY_LOCATOR

Foreign Keys

Table	Foreign Table	Foreign Key Column
MTL_SECONDARY_LOCATORS	MTL_ITEM_LOCATIONS	MTL_SECONDARY_LOCATORS.SECONDARY_LOCATOR MTL_SECONDARY_LOCATORS.ORGANIZATION_ID
MTL_SECONDARY_LOCATORS	MTL_ITEM_SUB_INVENTORIES	MTL_SECONDARY_LOCATORS.INVENTORY_ITEM_ID MTL_SECONDARY_LOCATORS.ORGANIZATION_ID MTL_SECONDARY_LOCATORS.SUBINVENTORY_CODE
WIP_DISCRETE_JOBS	MTL_SECONDARY_LOCATORS	WIP_DISCRETE_JOBS.PRIMARY_ITEM_ID WIP_DISCRETE_JOBS.ORGANIZATION_ID WIP_DISCRETE_JOBS.COMPLETION_LOCATOR_ID
WIP_REPETITIVE_ITEMS	MTL_SECONDARY_LOCATORS	WIP_REPETITIVE_ITEMS.PRIMARY_ITEM_ID WIP_REPETITIVE_ITEMS.ORGANIZATION_ID WIP_REPETITIVE_ITEMS.COMPLETION_LOCATOR_ID
WIP_REQUIREMENT_OPERATIONS	MTL_SECONDARY_LOCATORS	WIP_REQUIREMENT_OPERATIONS.INVENTORY_ITEM_ID WIP_REQUIREMENT_OPERATIONS.ORGANIZATION_ID WIP_REQUIREMENT_OPERATIONS.SUPPLY_LOCATOR_ID