FND Design Data [Home] [Help]

Table: CN_RULES_HIERARCHY_ALL

Product: CN - Incentive Compensation
Description: Hierarchy showing parent/child relationships for rules in CN_RULES.
Implementation/DBA Data: TableCN.CN_RULES_HIERARCHY_ALL
Primary Key: CN_RULES_HIERARCHY_PK
  1. ColumnRULE_ID
Primary Key: CN_RULES_HIERARCHY_UK1
  1. ColumnPARENT_RULE_ID
  2. ColumnSEQUENCE_NUMBER
Foreign Keys
Table
Foreign Table Foreign Key Column
CN_RULES_HIERARCHY_ALL FK Joins to TableCN_RULES_ALL_B CN_RULES_HIERARCHY_ALL.RULE_ID
CN_RULES_HIERARCHY_ALL.RULESET_ID
CN_RULES_HIERARCHY_ALL.ORG_ID
CN_RULES_HIERARCHY_ALL FK Joins to TableCN_RULES_ALL_B CN_RULES_HIERARCHY_ALL.PARENT_RULE_ID
CN_RULES_HIERARCHY_ALL.RULESET_ID
CN_RULES_HIERARCHY_ALL.ORG_ID