FND Design Data [Home] [Help]

Table: AMS_CELLS_ALL_B

Product: AMS - Marketing
Description: This table stores the definition of marketing cells (Segments). A cell is made up of one to many discoverer workbooks/worksheets. It is better known as Segments in Oracle Marketing.
Implementation/DBA Data: TableAMS.AMS_CELLS_ALL_B
Primary Key: AMS_CELLS_ALL_B_PK
  1. ColumnCELL_ID
Primary Key: AMS_CELLS_ALL_B_UK1
  1. ColumnCELL_CODE
Foreign Keys
Table
Foreign Table Foreign Key Column
AMS_CELLS_ALL_B FK Joins to TableAMS_CELLS_ALL_B AMS_CELLS_ALL_B.PARENT_CELL_ID
AMS_CELLS_ALL_B FK Joins to TableJTF_RS_RESOURCE_EXTNS AMS_CELLS_ALL_B.OWNER_ID
TableAMS_ACT_DISCOVERER_ALL FK Joins to AMS_CELLS_ALL_B AMS_ACT_DISCOVERER_ALL.ACT_DISCOVERER_USED_BY_ID
TableAMS_ACT_MARKET_SEGMENTS FK Joins to AMS_CELLS_ALL_B AMS_ACT_MARKET_SEGMENTS.MARKET_SEGMENT_ID
TableAMS_CELLS_ALL_B FK Joins to AMS_CELLS_ALL_B AMS_CELLS_ALL_B.PARENT_CELL_ID
TableAMS_CELLS_ALL_TL FK Joins to AMS_CELLS_ALL_B AMS_CELLS_ALL_TL.CELL_ID
TableAMS_LIST_SELECT_ACTIONS FK Joins to AMS_CELLS_ALL_B AMS_LIST_SELECT_ACTIONS.INCL_OBJECT_ID
TableAMS_PARTY_MARKET_SEGMENTS FK Joins to AMS_CELLS_ALL_B AMS_PARTY_MARKET_SEGMENTS.MARKET_SEGMENT_ID