FND Design Data [Home] [Help]

Table: XNP_GEO_HIERARCHY

Product: XNP - Number Portability
Description: Holds information about the geographic area hierarchy
Implementation/DBA Data: TableXNP.XNP_GEO_HIERARCHY
Primary Key: XNP_GEO_HIERARCHY_PK
  1. ColumnGEO_HIERARCHY_ID
Primary Key: XNP_GEO_HIERARCHY_UK1
  1. ColumnPARENT_GEO_AREA_ID
  2. ColumnCHILD_GEO_AREA_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
XNP_GEO_HIERARCHY FK Joins to TableXNP_GEO_AREAS_B XNP_GEO_HIERARCHY.CHILD_GEO_AREA_ID
XNP_GEO_HIERARCHY FK Joins to TableXNP_GEO_AREAS_B XNP_GEO_HIERARCHY.PARENT_GEO_AREA_ID