FND Design Data [Home] [Help]

Table: XNP_GEO_AREAS_B

Product: XNP - Number Portability
Description: Stores given geographic areas
Implementation/DBA Data: TableXNP.XNP_GEO_AREAS_B
Primary Key: XNP_GEO_AREAS_B_PK
  1. ColumnGEO_AREA_ID
Primary Key: XNP_GEO_AREAS_B_UK1
  1. ColumnGEO_AREA_TYPE_CODE
  2. ColumnCODE
Foreign Keys
Table
Foreign Table Foreign Key Column
TableXNP_GEO_AREAS_TL FK Joins to XNP_GEO_AREAS_B XNP_GEO_AREAS_TL.GEO_AREA_ID
TableXNP_GEO_HIERARCHY FK Joins to XNP_GEO_AREAS_B XNP_GEO_HIERARCHY.CHILD_GEO_AREA_ID
TableXNP_GEO_HIERARCHY FK Joins to XNP_GEO_AREAS_B XNP_GEO_HIERARCHY.PARENT_GEO_AREA_ID
TableXNP_INTERCONNECT_AREAS FK Joins to XNP_GEO_AREAS_B XNP_INTERCONNECT_AREAS.GEO_AREA_ID
TableXNP_NUMBER_RANGES FK Joins to XNP_GEO_AREAS_B XNP_NUMBER_RANGES.GEO_AREA_ID
TableXNP_SERVICE_AREAS FK Joins to XNP_GEO_AREAS_B XNP_SERVICE_AREAS.GEO_AREA_ID