Table: ICX_POR_ITEMS

Product:	ICX - Oracle iProcurement
Description:	Stores information and root descriptors for non translatable data for each item in the catalog. Root descriptor columns are in the format Axxxx where xxxx is an integer. Some of the root descriptors are seeded by Oracle while others may b
Implementation/DBA Data:	ICX.ICX_POR_ITEMS

Primary Key: ICX_POR_ITEMS_PK

1. RT_ITEM_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
ICX_POR_ITEMS		HZ_PARTIES	ICX_POR_ITEMS.SUPPLIER_ID
ICX_POR_CATEGORY_ITEMS		ICX_POR_ITEMS	ICX_POR_CATEGORY_ITEMS.RT_ITEM_ID
ICX_POR_ITEMS_TL		ICX_POR_ITEMS	ICX_POR_ITEMS_TL.RT_ITEM_ID
ICX_POR_PRICE_LIST_LINES_CACHE		ICX_POR_ITEMS	ICX_POR_PRICE_LIST_LINES_CACHE.ITEM_ID
ICX_POR_PRICE_LIST_LINES		ICX_POR_ITEMS	ICX_POR_PRICE_LIST_LINES.ITEM_ID
ICX_POR_THIRD_PARTY_LOGS		ICX_POR_ITEMS	ICX_POR_THIRD_PARTY_LOGS.ITEM_ID
MSC_SUP_DEM_ENTRIES		ICX_POR_ITEMS	MSC_SUP_DEM_ENTRIES.INVENTORY_ITEM_ID