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_PHYSICAL_INVENTORIES

Product:	INV - Inventory
Description:	Physical inventory definitions
Implementation/DBA Data:	INV.MTL_PHYSICAL_INVENTORIES

Primary Key: MTL_PHYSICAL_INVENTORIES_PK

ORGANIZATION_ID
PHYSICAL_INVENTORY_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
MTL_PHYSICAL_INVENTORIES	MTL_PARAMETERS	MTL_PHYSICAL_INVENTORIES.ORGANIZATION_ID
MTL_PHYSICAL_INVENTORIES	GL_CODE_COMBINATIONS	MTL_PHYSICAL_INVENTORIES.DEFAULT_GL_ADJUST_ACCOUNT
MTL_PHYSICAL_ADJUSTMENTS	MTL_PHYSICAL_INVENTORIES	MTL_PHYSICAL_ADJUSTMENTS.ORGANIZATION_ID MTL_PHYSICAL_ADJUSTMENTS.PHYSICAL_INVENTORY_ID
MTL_PHYSICAL_INVENTORY_TAGS	MTL_PHYSICAL_INVENTORIES	MTL_PHYSICAL_INVENTORY_TAGS.ORGANIZATION_ID MTL_PHYSICAL_INVENTORY_TAGS.PHYSICAL_INVENTORY_ID
MTL_PHYSICAL_SUBINVENTORIES	MTL_PHYSICAL_INVENTORIES	MTL_PHYSICAL_SUBINVENTORIES.ORGANIZATION_ID MTL_PHYSICAL_SUBINVENTORIES.PHYSICAL_INVENTORY_ID