FND Design Data [Home] [Help]

Table: XNP_NUMBER_RANGES

Product: XNP - Number Portability
Description: Stores information about the characteristics of a service provider's telephone number ranges
Implementation/DBA Data: TableXNP.XNP_NUMBER_RANGES
Primary Key: XNP_NUMBER_RANGES_PK
  1. ColumnNUMBER_RANGE_ID
Primary Key: XNP_NUMBER_RANGES_UK1
  1. ColumnSTARTING_NUMBER
Primary Key: XNP_NUMBER_RANGES_UK2
  1. ColumnOBJECT_REFERENCE
Foreign Keys
Table
Foreign Table Foreign Key Column
XNP_NUMBER_RANGES FK Joins to TableXNP_GEO_AREAS_B XNP_NUMBER_RANGES.GEO_AREA_ID
XNP_NUMBER_RANGES FK Joins to TableXNP_SERVICE_PROVIDERS XNP_NUMBER_RANGES.OWNING_SP_ID
XNP_NUMBER_RANGES FK Joins to TableXNP_SERVICE_PROVIDERS XNP_NUMBER_RANGES.ASSIGNED_SP_ID
TableXNP_NUMBER_SPLITS FK Joins to XNP_NUMBER_RANGES XNP_NUMBER_SPLITS.NEW_NUMBER_RANGE_ID
TableXNP_NUMBER_SPLITS FK Joins to XNP_NUMBER_RANGES XNP_NUMBER_SPLITS.OLD_NUMBER_RANGE_ID
TableXNP_SERVED_NUM_RANGES FK Joins to XNP_NUMBER_RANGES XNP_SERVED_NUM_RANGES.NUMBER_RANGE_ID
TableXNP_SP_FILTERS FK Joins to XNP_NUMBER_RANGES XNP_SP_FILTERS.NUMBER_RANGE_ID