FND Design Data [Home] [Help]

Table: AMS_ACT_GEO_AREAS

Product: AMS - Marketing
Description: Holds the geographical regions in which a campaign or an event is active
Implementation/DBA Data: TableAMS.AMS_ACT_GEO_AREAS
Primary Key: AMS_ACT_GEO_AREAS_PK
  1. ColumnACTIVITY_GEO_AREA_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
AMS_ACT_GEO_AREAS FK Joins to TableJTF_LOC_TYPES_B AMS_ACT_GEO_AREAS.GEO_AREA_TYPE_CODE
AMS_ACT_GEO_AREAS FK Joins to TableJTF_LOC_HIERARCHIES_B AMS_ACT_GEO_AREAS.GEO_HIERARCHY_ID
AMS_ACT_GEO_AREAS FK Joins to TableAMS_CAMPAIGNS_ALL_B AMS_ACT_GEO_AREAS.ACT_GEO_AREA_USED_BY_ID
TableAMS_ACT_METRIC_FACTS_ALL FK Joins to AMS_ACT_GEO_AREAS AMS_ACT_METRIC_FACTS_ALL.ACTIVITY_GEO_AREA_ID