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_ITEM_LOCATIONS

Product:	INV - Inventory
Description:	Definitions for stock locators
Implementation/DBA Data:	INV.MTL_ITEM_LOCATIONS

Primary Key: MTL_ITEM_LOCATIONS_PK

INVENTORY_LOCATION_ID
ORGANIZATION_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
MTL_ITEM_LOCATIONS	GL_CODE_COMBINATIONS	MTL_ITEM_LOCATIONS.INVENTORY_ACCOUNT_ID
MTL_ITEM_LOCATIONS	MTL_PARAMETERS	MTL_ITEM_LOCATIONS.ORGANIZATION_ID
MTL_ITEM_LOCATIONS	MTL_SECONDARY_INVENTORIES	MTL_ITEM_LOCATIONS.SUBINVENTORY_CODE MTL_ITEM_LOCATIONS.ORGANIZATION_ID
MTL_ITEM_LOCATIONS	MTL_MATERIAL_STATUSES_B	MTL_ITEM_LOCATIONS.STATUS_ID
AHL_WORKORDER_MTL_TXNS	MTL_ITEM_LOCATIONS	AHL_WORKORDER_MTL_TXNS.LOCATOR_ID AHL_WORKORDER_MTL_TXNS.ORGANIZATION_ID
BOM_OPERATIONAL_ROUTINGS	MTL_ITEM_LOCATIONS	BOM_OPERATIONAL_ROUTINGS.COMPLETION_LOCATOR_ID BOM_OPERATIONAL_ROUTINGS.ORGANIZATION_ID
CSP_INV_LOC_ASSIGNMENTS	MTL_ITEM_LOCATIONS	CSP_INV_LOC_ASSIGNMENTS.LOCATOR_ID CSP_INV_LOC_ASSIGNMENTS.ORGANIZATION_ID
MTL_CC_ENTRIES_INTERFACE	MTL_ITEM_LOCATIONS	MTL_CC_ENTRIES_INTERFACE.LOCATOR_ID MTL_CC_ENTRIES_INTERFACE.ORGANIZATION_ID
MTL_CYCLE_COUNT_ENTRIES	MTL_ITEM_LOCATIONS	MTL_CYCLE_COUNT_ENTRIES.LOCATOR_ID MTL_CYCLE_COUNT_ENTRIES.ORGANIZATION_ID
MTL_DEMAND	MTL_ITEM_LOCATIONS	MTL_DEMAND.LOCATOR_ID MTL_DEMAND.ORGANIZATION_ID
MTL_DEMAND_INTERFACE	MTL_ITEM_LOCATIONS	MTL_DEMAND_INTERFACE.LOCATOR_ID MTL_DEMAND_INTERFACE.ORGANIZATION_ID
MTL_ITEM_LOC_DEFAULTS	MTL_ITEM_LOCATIONS	MTL_ITEM_LOC_DEFAULTS.LOCATOR_ID MTL_ITEM_LOC_DEFAULTS.ORGANIZATION_ID
MTL_MATERIAL_STATUS_HISTORY	MTL_ITEM_LOCATIONS	MTL_MATERIAL_STATUS_HISTORY.LOCATOR_ID MTL_MATERIAL_STATUS_HISTORY.ORGANIZATION_ID
MTL_MATERIAL_TRANSACTIONS	MTL_ITEM_LOCATIONS	MTL_MATERIAL_TRANSACTIONS.LOCATOR_ID MTL_MATERIAL_TRANSACTIONS.ORGANIZATION_ID
MTL_MATERIAL_TRANSACTIONS_TEMP	MTL_ITEM_LOCATIONS	MTL_MATERIAL_TRANSACTIONS_TEMP.LOCATOR_ID MTL_MATERIAL_TRANSACTIONS_TEMP.ORGANIZATION_ID
MTL_MATERIAL_TRANSACTIONS_TEMP	MTL_ITEM_LOCATIONS	MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSFER_TO_LOCATION MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSFER_ORGANIZATION
MTL_ONHAND_QUANTITIES	MTL_ITEM_LOCATIONS	MTL_ONHAND_QUANTITIES.LOCATOR_ID MTL_ONHAND_QUANTITIES.ORGANIZATION_ID
MTL_ONHAND_QUANTITY_TEMP	MTL_ITEM_LOCATIONS	MTL_ONHAND_QUANTITY_TEMP.LOCATOR_ID MTL_ONHAND_QUANTITY_TEMP.ORGANIZATION_ID
MTL_PHYSICAL_INVENTORY_TAGS	MTL_ITEM_LOCATIONS	MTL_PHYSICAL_INVENTORY_TAGS.LOCATOR_ID MTL_PHYSICAL_INVENTORY_TAGS.ORGANIZATION_ID
MTL_REPLENISH_LINES	MTL_ITEM_LOCATIONS	MTL_REPLENISH_LINES.LOCATOR_ID MTL_REPLENISH_LINES.ORGANIZATION_ID
MTL_REPLENISH_LINES_INT	MTL_ITEM_LOCATIONS	MTL_REPLENISH_LINES_INT.LOCATOR_ID MTL_REPLENISH_LINES_INT.ORGANIZATION_ID
MTL_RESERVATIONS	MTL_ITEM_LOCATIONS	MTL_RESERVATIONS.LOCATOR_ID MTL_RESERVATIONS.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_SECONDARY_LOCATORS	MTL_ITEM_LOCATIONS	MTL_SECONDARY_LOCATORS.SECONDARY_LOCATOR MTL_SECONDARY_LOCATORS.ORGANIZATION_ID
MTL_SERIAL_NUMBERS	MTL_ITEM_LOCATIONS	MTL_SERIAL_NUMBERS.CURRENT_LOCATOR_ID MTL_SERIAL_NUMBERS.CURRENT_ORGANIZATION_ID
MTL_SUPPLY	MTL_ITEM_LOCATIONS	MTL_SUPPLY.LOCATION_ID MTL_SUPPLY.TO_ORGANIZATION_ID
MTL_SYSTEM_ITEMS_B	MTL_ITEM_LOCATIONS	MTL_SYSTEM_ITEMS_B.WIP_SUPPLY_LOCATOR_ID MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID
MTL_TRANSACTIONS_INTERFACE	MTL_ITEM_LOCATIONS	MTL_TRANSACTIONS_INTERFACE.LOCATOR_ID MTL_TRANSACTIONS_INTERFACE.ORGANIZATION_ID
MTL_TRANSACTIONS_INTERFACE	MTL_ITEM_LOCATIONS	MTL_TRANSACTIONS_INTERFACE.TRANSFER_LOCATOR MTL_TRANSACTIONS_INTERFACE.TRANSFER_ORGANIZATION
MTL_UNIT_TRANSACTIONS	MTL_ITEM_LOCATIONS	MTL_UNIT_TRANSACTIONS.LOCATOR_ID MTL_UNIT_TRANSACTIONS.ORGANIZATION_ID
RCV_TRANSACTIONS	MTL_ITEM_LOCATIONS	RCV_TRANSACTIONS.LOCATOR_ID RCV_TRANSACTIONS.ORGANIZATION_ID
RCV_TRANSACTIONS_INTERFACE	MTL_ITEM_LOCATIONS	RCV_TRANSACTIONS_INTERFACE.LOCATOR_ID RCV_TRANSACTIONS_INTERFACE.TO_ORGANIZATION_ID
WIP_DISCRETE_JOBS	MTL_ITEM_LOCATIONS	WIP_DISCRETE_JOBS.COMPLETION_LOCATOR_ID WIP_DISCRETE_JOBS.ORGANIZATION_ID
WIP_FLOW_SCHEDULES	MTL_ITEM_LOCATIONS	WIP_FLOW_SCHEDULES.COMPLETION_LOCATOR_ID WIP_FLOW_SCHEDULES.ORGANIZATION_ID
WIP_PARAMETERS	MTL_ITEM_LOCATIONS	WIP_PARAMETERS.DEFAULT_PULL_SUPPLY_LOCATOR_ID WIP_PARAMETERS.ORGANIZATION_ID
WIP_REPETITIVE_ITEMS	MTL_ITEM_LOCATIONS	WIP_REPETITIVE_ITEMS.COMPLETION_LOCATOR_ID WIP_REPETITIVE_ITEMS.ORGANIZATION_ID
WIP_REQUIREMENT_OPERATIONS	MTL_ITEM_LOCATIONS	WIP_REQUIREMENT_OPERATIONS.SUPPLY_LOCATOR_ID WIP_REQUIREMENT_OPERATIONS.ORGANIZATION_ID
WMS_DOCK_APPOINTMENTS_B	MTL_ITEM_LOCATIONS	WMS_DOCK_APPOINTMENTS_B.DOCK_ID WMS_DOCK_APPOINTMENTS_B.ORGANIZATION_ID
WMS_EXCEPTIONS	MTL_ITEM_LOCATIONS	WMS_EXCEPTIONS.INVENTORY_LOCATION_ID WMS_EXCEPTIONS.ORGANIZATION_ID
WMS_LICENSE_PLATE_NUMBERS	MTL_ITEM_LOCATIONS	WMS_LICENSE_PLATE_NUMBERS.LOCATOR_ID WMS_LICENSE_PLATE_NUMBERS.ORGANIZATION_ID
WMS_LPN_HISTORIES	MTL_ITEM_LOCATIONS	WMS_LPN_HISTORIES.LOCATOR_ID WMS_LPN_HISTORIES.ORGANIZATION_ID
WMS_LPN_INTERFACE	MTL_ITEM_LOCATIONS	WMS_LPN_INTERFACE.LOCATOR_ID WMS_LPN_INTERFACE.ORGANIZATION_ID
WMS_SHIPPING_TRANSACTION_TEMP	MTL_ITEM_LOCATIONS	WMS_SHIPPING_TRANSACTION_TEMP.DOCK_DOOR_ID WMS_SHIPPING_TRANSACTION_TEMP.ORGANIZATION_ID
WMS_SKIP_TASK_EXCEPTIONS	MTL_ITEM_LOCATIONS	WMS_SKIP_TASK_EXCEPTIONS.INVENTORY_LOCATION_ID WMS_SKIP_TASK_EXCEPTIONS.ORGANIZATION_ID
WMS_STAGINGLANES_ASSIGNMENTS	MTL_ITEM_LOCATIONS	WMS_STAGINGLANES_ASSIGNMENTS.DOCK_DOOR_ID WMS_STAGINGLANES_ASSIGNMENTS.DOCK_DOOR_ORGANIZATION_ID
WMS_STAGINGLANES_ASSIGNMENTS	MTL_ITEM_LOCATIONS	WMS_STAGINGLANES_ASSIGNMENTS.STAGE_LANE_ID WMS_STAGINGLANES_ASSIGNMENTS.STAGING_LANE_ORGANIZATION_ID
WSM_CO_PRODUCTS	MTL_ITEM_LOCATIONS	WSM_CO_PRODUCTS.SUPPLY_LOCATOR_ID WSM_CO_PRODUCTS.ORGANIZATION_ID
WSM_LOT_JOB_INTERFACE	MTL_ITEM_LOCATIONS	WSM_LOT_JOB_INTERFACE.COMPLETION_LOCATOR_ID WSM_LOT_JOB_INTERFACE.ORGANIZATION_ID
WSM_RESULTING_LOTS_INTERFACE	MTL_ITEM_LOCATIONS	WSM_RESULTING_LOTS_INTERFACE.LOCATOR_ID WSM_RESULTING_LOTS_INTERFACE.ORGANIZATION_ID
WSM_SM_RESULTING_LOTS	MTL_ITEM_LOCATIONS	WSM_SM_RESULTING_LOTS.LOCATOR_ID WSM_SM_RESULTING_LOTS.ORGANIZATION_ID
WSM_SM_STARTING_LOTS	MTL_ITEM_LOCATIONS	WSM_SM_STARTING_LOTS.LOCATOR_ID WSM_SM_STARTING_LOTS.ORGANIZATION_ID
WSM_STARTING_LOTS_INTERFACE	MTL_ITEM_LOCATIONS	WSM_STARTING_LOTS_INTERFACE.LOCATOR_ID WSM_STARTING_LOTS_INTERFACE.ORGANIZATION_ID