FND Design Data [Home] [Help]

Table: XNP_SV_ORDER_MAPPINGS

Product: XNP - Number Portability
Description: Stores event information associated with subscription versions or messages.
Implementation/DBA Data: TableXNP.XNP_SV_ORDER_MAPPINGS
Primary Key: XNP_SV_ORDER_MAPPINGS_PK
  1. ColumnSV_ORDER_MAPPING_ID
Primary Key: XNP_SV_ORDER_MAPPINGS_UK1
  1. ColumnORDER_ID
  2. ColumnSV_SOA_ID
  3. ColumnSV_SMS_ID
  4. ColumnWORKITEM_INSTANCE_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
XNP_SV_ORDER_MAPPINGS FK Joins to TableXDP_ORDER_HEADERS XNP_SV_ORDER_MAPPINGS.ORDER_ID
XNP_SV_ORDER_MAPPINGS FK Joins to TableXNP_SV_SMS XNP_SV_ORDER_MAPPINGS.SV_SMS_ID
XNP_SV_ORDER_MAPPINGS FK Joins to TableXNP_SV_SOA XNP_SV_ORDER_MAPPINGS.SV_SOA_ID
XNP_SV_ORDER_MAPPINGS FK Joins to TableXDP_FULFILL_WORKLIST XNP_SV_ORDER_MAPPINGS.WORKITEM_INSTANCE_ID