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_RESERVATIONS_INTERFACE

Product:	INV - Inventory
Description:	Reservations Interface
Implementation/DBA Data:	INV.MTL_RESERVATIONS_INTERFACE

Primary Key: MTL_RESERVATIONS_INTERAFCE_PK

RESERVATION_BATCH_ID
RESERVATION_INTERFACE_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
MTL_RESERVATIONS_INTERFACE	MTL_PARAMETERS	MTL_RESERVATIONS_INTERFACE.ORGANIZATION_ID
MTL_RESERVATIONS_INTERFACE	MTL_LOT_NUMBERS	MTL_RESERVATIONS_INTERFACE.INVENTORY_ITEM_ID MTL_RESERVATIONS_INTERFACE.ORGANIZATION_ID MTL_RESERVATIONS_INTERFACE.LOT_NUMBER
MTL_RESERVATIONS_INTERFACE	MTL_LOT_NUMBERS	MTL_RESERVATIONS_INTERFACE.INVENTORY_ITEM_ID MTL_RESERVATIONS_INTERFACE.ORGANIZATION_ID MTL_RESERVATIONS_INTERFACE.TO_LOT_NUMBER
MTL_RESERVATIONS_INTERFACE	MTL_SECONDARY_INVENTORIES	MTL_RESERVATIONS_INTERFACE.SUBINVENTORY_CODE MTL_RESERVATIONS_INTERFACE.ORGANIZATION_ID
MTL_RESERVATIONS_INTERFACE	MTL_SECONDARY_INVENTORIES	MTL_RESERVATIONS_INTERFACE.TO_SUBINVENTORY_CODE MTL_RESERVATIONS_INTERFACE.ORGANIZATION_ID
MTL_RESERVATIONS_INTERFACE	MTL_ITEM_LOCATIONS	MTL_RESERVATIONS_INTERFACE.LOCATOR_ID MTL_RESERVATIONS_INTERFACE.ORGANIZATION_ID
MTL_RESERVATIONS_INTERFACE	MTL_ITEM_LOCATIONS	MTL_RESERVATIONS_INTERFACE.TO_LOCATOR_ID MTL_RESERVATIONS_INTERFACE.ORGANIZATION_ID
MTL_RESERVATIONS_INTERFACE	MTL_PARAMETERS	MTL_RESERVATIONS_INTERFACE.TO_ORGANIZATION_ID
MTL_RESERVATIONS_INTERFACE	MTL_SYSTEM_ITEMS_B	MTL_RESERVATIONS_INTERFACE.INVENTORY_ITEM_ID MTL_RESERVATIONS_INTERFACE.ORGANIZATION_ID
MTL_RESERVATIONS_INTERFACE	MTL_TXN_SOURCE_TYPES	MTL_RESERVATIONS_INTERFACE.DEMAND_SOURCE_TYPE_ID
MTL_RESERVATIONS_INTERFACE	MTL_TXN_SOURCE_TYPES	MTL_RESERVATIONS_INTERFACE.TO_DEMAND_SOURCE_TYPE_ID
MTL_RESERVATIONS_INTERFACE	MTL_TXN_SOURCE_TYPES	MTL_RESERVATIONS_INTERFACE.SUPPLY_SOURCE_TYPE_ID
MTL_RESERVATIONS_INTERFACE	MTL_TXN_SOURCE_TYPES	MTL_RESERVATIONS_INTERFACE.TO_SUPPLY_SOURCE_TYPE_ID
MTL_RESERVATIONS_INTERFACE	MTL_ITEM_REVISIONS_B	MTL_RESERVATIONS_INTERFACE.INVENTORY_ITEM_ID MTL_RESERVATIONS_INTERFACE.ORGANIZATION_ID MTL_RESERVATIONS_INTERFACE.REVISION
MTL_RESERVATIONS_INTERFACE	MTL_ITEM_REVISIONS_B	MTL_RESERVATIONS_INTERFACE.INVENTORY_ITEM_ID MTL_RESERVATIONS_INTERFACE.ORGANIZATION_ID MTL_RESERVATIONS_INTERFACE.TO_REVISION