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_CUSTOMER_ITEMS

Product:	INV - Inventory
Description:	Customer item Information
Implementation/DBA Data:	INV.MTL_CUSTOMER_ITEMS

Primary Key: MTL_CUSTOMER_ITEMS_PK

CUSTOMER_ITEM_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
MTL_CUSTOMER_ITEMS	RA_CUSTOMERS	MTL_CUSTOMER_ITEMS.CUSTOMER_ID
MTL_CUSTOMER_ITEMS	RA_ADDRESSES_ALL	MTL_CUSTOMER_ITEMS.ADDRESS_ID
MTL_CUSTOMER_ITEMS	MTL_CUSTOMER_ITEMS	MTL_CUSTOMER_ITEMS.MODEL_CUSTOMER_ITEM_ID
MTL_CUSTOMER_ITEMS	MTL_COMMODITY_CODES	MTL_CUSTOMER_ITEMS.COMMODITY_CODE_ID
MTL_CUSTOMER_ITEMS	MTL_PARAMETERS	MTL_CUSTOMER_ITEMS.CONTAINER_ITEM_ORG_ID
MTL_CI_INTERFACE	MTL_CUSTOMER_ITEMS	MTL_CI_INTERFACE.MODEL_CUSTOMER_ITEM_ID
MTL_CI_XREFS_INTERFACE	MTL_CUSTOMER_ITEMS	MTL_CI_XREFS_INTERFACE.CUSTOMER_ITEM_ID
MTL_CUSTOMER_ITEMS	MTL_CUSTOMER_ITEMS	MTL_CUSTOMER_ITEMS.MODEL_CUSTOMER_ITEM_ID
MTL_CUSTOMER_ITEM_XREFS	MTL_CUSTOMER_ITEMS	MTL_CUSTOMER_ITEM_XREFS.CUSTOMER_ITEM_ID
OE_ORDER_LINES_ALL	MTL_CUSTOMER_ITEMS	OE_ORDER_LINES_ALL.ORDERED_ITEM_ID