FND Design Data [Home] [Help]

Table: ICX_POR_CATEGORY_ITEMS

Product: ICX - Oracle iProcurement
Description: Intersection table creating a relationship between categories and all the items they contain.
Implementation/DBA Data: TableICX.ICX_POR_CATEGORY_ITEMS
Primary Key: ICX_POR_CATEGORY_ITEMS_PK
  1. ColumnRT_CATEGORY_ID
  2. ColumnRT_ITEM_ID
Primary Key: ICX_POR_CATEGORY_ITEMS_UK1
  1. ColumnRT_CATEGORY_ID
  2. ColumnRT_ITEM_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
ICX_POR_CATEGORY_ITEMS FK Joins to TableICX_POR_ITEMS ICX_POR_CATEGORY_ITEMS.RT_ITEM_ID