FND Design Data [Home] [Help]

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: TableICX.ICX_POR_ITEMS
Primary Key: ICX_POR_ITEMS_PK
  1. ColumnRT_ITEM_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
ICX_POR_ITEMS FK Joins to TableHZ_PARTIES ICX_POR_ITEMS.SUPPLIER_ID
TableICX_POR_CATEGORY_ITEMS FK Joins to ICX_POR_ITEMS ICX_POR_CATEGORY_ITEMS.RT_ITEM_ID
TableICX_POR_ITEMS_TL FK Joins to ICX_POR_ITEMS ICX_POR_ITEMS_TL.RT_ITEM_ID
TableICX_POR_PRICE_LIST_LINES_CACHE FK Joins to ICX_POR_ITEMS ICX_POR_PRICE_LIST_LINES_CACHE.ITEM_ID
TableICX_POR_PRICE_LIST_LINES FK Joins to ICX_POR_ITEMS ICX_POR_PRICE_LIST_LINES.ITEM_ID
TableICX_POR_THIRD_PARTY_LOGS FK Joins to ICX_POR_ITEMS ICX_POR_THIRD_PARTY_LOGS.ITEM_ID
TableMSC_SUP_DEM_ENTRIES FK Joins to ICX_POR_ITEMS MSC_SUP_DEM_ENTRIES.INVENTORY_ITEM_ID