FND Design Data [Home] [Help]

Table: AMS_CATEGORIES_B

Product: AMS - Marketing
Description: This table stores the definition for categories and is used by Events, Metrics and the Deliverables area.
Implementation/DBA Data: TableAMS.AMS_CATEGORIES_B
Primary Key: AMS_CATEGORIES_B_PK
  1. ColumnCATEGORY_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
AMS_CATEGORIES_B FK Joins to TableAMS_CATEGORIES_B AMS_CATEGORIES_B.PARENT_CATEGORY_ID
TableAMS_ACT_CATEGORIES FK Joins to AMS_CATEGORIES_B AMS_ACT_CATEGORIES.CATEGORY_ID
TableAMS_ACT_PRODUCTS FK Joins to AMS_CATEGORIES_B AMS_ACT_PRODUCTS.CATEGORY_ID
TableAMS_CATEGORIES_B FK Joins to AMS_CATEGORIES_B AMS_CATEGORIES_B.PARENT_CATEGORY_ID
TableAMS_CATEGORIES_TL FK Joins to AMS_CATEGORIES_B AMS_CATEGORIES_TL.CATEGORY_ID
TableAMS_CAT_ACTIVITIES FK Joins to AMS_CATEGORIES_B AMS_CAT_ACTIVITIES.CATEGORY_ID
TableAMS_DELIVERABLES_ALL_B FK Joins to AMS_CATEGORIES_B AMS_DELIVERABLES_ALL_B.CATEGORY_SUB_TYPE_ID
TableAMS_DELIVERABLES_ALL_B FK Joins to AMS_CATEGORIES_B AMS_DELIVERABLES_ALL_B.CATEGORY_TYPE_ID
TableAMS_METRICS_ALL_B FK Joins to AMS_CATEGORIES_B AMS_METRICS_ALL_B.METRIC_CATEGORY
TableAMS_METRICS_ALL_B FK Joins to AMS_CATEGORIES_B AMS_METRICS_ALL_B.METRIC_SUB_CATEGORY
TableAMS_METRIC_FORMULAS FK Joins to AMS_CATEGORIES_B AMS_METRIC_FORMULAS.SOURCE_ID