Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - XNP Tables and Views

TABLE - XNP.XNP_AUDIT_DISCREPANCIES
TABLE - XNP.XNP_AUDIT_SMS_FAILURES
TABLE - XNP.XNP_CALLBACK_EVENTS
TABLE - XNP.XNP_DEBUG
TABLE - XNP.XNP_EVENT_SUBSCRIBERS
TABLE - XNP.XNP_GEO_AREAS_B
TABLE - XNP.XNP_GEO_AREAS_TL
TABLE - XNP.XNP_GEO_HIERARCHY
TABLE - XNP.XNP_INTERCONNECT_AREAS
TABLE - XNP.XNP_MSGS
TABLE - XNP.XNP_MSG_ACKS
TABLE - XNP.XNP_MSG_ATTR_VALUES
TABLE - XNP.XNP_MSG_ELEMENTS
TABLE - XNP.XNP_MSG_ELEMENT_ATTR
TABLE - XNP.XNP_MSG_STRUCTURES
TABLE - XNP.XNP_MSG_TYPES_B
TABLE - XNP.XNP_MSG_TYPES_TL
TABLE - XNP.XNP_NETWORK_MAPS
TABLE - XNP.XNP_NUMBER_RANGES
TABLE - XNP.XNP_NUMBER_SPLITS
TABLE - XNP.XNP_ROUTING_NUMBERS
TABLE - XNP.XNP_SERVED_NUM_RANGES
TABLE - XNP.XNP_SERVICE_AREAS
TABLE - XNP.XNP_SERVICE_PROVIDERS
TABLE - XNP.XNP_SP_ADAPTERS
TABLE - XNP.XNP_SP_CONTACTS
TABLE - XNP.XNP_SP_FILTERS
TABLE - XNP.XNP_SV_AUDITS
TABLE - XNP.XNP_SV_EVENT_HISTORY
TABLE - XNP.XNP_SV_FAILURES
TABLE - XNP.XNP_SV_ORDER_MAPPINGS
TABLE - XNP.XNP_SV_SMS
TABLE - XNP.XNP_SV_SMS_FE_MAPS
TABLE - XNP.XNP_SV_SOA
TABLE - XNP.XNP_SV_SOA_JN
TABLE - XNP.XNP_SV_STATUS_TYPES_B
TABLE - XNP.XNP_SV_STATUS_TYPES_TL
TABLE - XNP.XNP_SYNC_REGISTRATION
TABLE - XNP.XNP_TIMER_PUBLISHERS
TABLE - XNP.XNP_TIMER_REGISTRY
VIEW - APPS.XNP_GEO_AREAS_VL
VIEW - APPS.XNP_LOOKUPS
VIEW - APPS.XNP_MSG_TYPES_VL
VIEW - APPS.XNP_SV_FE_MAPP_DETAILS_VL
VIEW - APPS.XNP_SV_ORDER_MAPP_DETAILS_VL
VIEW - APPS.XNP_SV_SMS_V
VIEW - APPS.XNP_SV_SOA_VL
VIEW - APPS.XNP_SV_STATUS_TYPES_VL

Table: XNP_AUDIT_DISCREPANCIES

Description: Stores mismatched network data for a given service provider and subscription version
Primary Key: XNP_AUDIT_DISCREPANCIES_PK
  1. AUDIT_DISCREPANCY_ID
Primary Key: XNP_AUDIT_DISCREPANCIES_UK1
  1. SUBSCRIPTION_TN
  2. SP_ID
  3. AUDIT_ID
  4. ERROR_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
XNP_AUDIT_DISCREPANCIES.AUDIT_ID XNP_SV_AUDITS
XNP_AUDIT_DISCREPANCIES.SP_ID XNP_SERVICE_PROVIDERS

[top of page]

XNP.XNP_AUDIT_DISCREPANCIES does not reference any database object

XNP.XNP_AUDIT_DISCREPANCIES is referenced by following:

APPS
SYNONYM - XNP_AUDIT_DISCREPANCIES

[top of page]

Table: XNP_AUDIT_SMS_FAILURES

Description: Stores a list of service providers that failed to provide the requested audit information. This is an optional list in the audit results.
Primary Key: XNP_AUDIT_SMS_FAILURES_PK
  1. SMS_FAILURE_ID
Primary Key: XNP_AUDIT_SMS_FAILURES_UK1
  1. AUDIT_ID
  2. SP_ID
  3. FAILURE_DATE
Foreign Keys from this table:
Foreign Key Column Foreign Table
XNP_AUDIT_SMS_FAILURES.AUDIT_ID XNP_SV_AUDITS
XNP_AUDIT_SMS_FAILURES.SP_ID XNP_SERVICE_PROVIDERS

[top of page]

XNP.XNP_AUDIT_SMS_FAILURES does not reference any database object

XNP.XNP_AUDIT_SMS_FAILURES is referenced by following:

APPS
SYNONYM - XNP_AUDIT_SMS_FAILURES

[top of page]

Table: XNP_CALLBACK_EVENTS

Description: Contains instances of message types for which one or more applications have registered
Primary Key: XNP_CALLBACK_EVENTS_PK
  1. CALLBACK_EVENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
XNP_CALLBACK_EVENTS.MSG_CODE XNP_MSG_TYPES_B
XNP_CALLBACK_EVENTS.FA_INSTANCE_ID XDP_FA_RUNTIME_LIST
XNP_CALLBACK_EVENTS.ORDER_ID XDP_ORDER_HEADERS
XNP_CALLBACK_EVENTS.WI_INSTANCE_ID XDP_FULFILL_WORKLIST

[top of page]

XNP.XNP_CALLBACK_EVENTS does not reference any database object

XNP.XNP_CALLBACK_EVENTS is referenced by following:

APPS
SYNONYM - XNP_CALLBACK_EVENTS

[top of page]

Table: XNP_DEBUG

Description: Stores general debug information in NP system
Primary Key: XNP_DEBUG_PK
  1. DEBUG_ID

[top of page]

XNP.XNP_DEBUG does not reference any database object

XNP.XNP_DEBUG is referenced by following:

APPS
SYNONYM - XNP_DEBUG

[top of page]

Table: XNP_EVENT_SUBSCRIBERS

Description: Stores a list of subscribers for a given message type
Primary Key: XNP_EVENT_SUBSCRIBERS_PK
  1. EVENT_SUBSCRIBER_ID
Primary Key: XNP_EVENT_SUBSCRIBERS_UK1
  1. MSG_CODE
  2. FE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
XNP_EVENT_SUBSCRIBERS.MSG_CODE XNP_MSG_TYPES_B
XNP_EVENT_SUBSCRIBERS.FE_ID XDP_FES

[top of page]

XNP.XNP_EVENT_SUBSCRIBERS does not reference any database object

XNP.XNP_EVENT_SUBSCRIBERS is referenced by following:

APPS
SYNONYM - XNP_EVENT_SUBSCRIBERS

[top of page]

Table: XNP_GEO_AREAS_B

Description: Stores given geographic areas
Primary Key: XNP_GEO_AREAS_B_PK
  1. GEO_AREA_ID
Primary Key: XNP_GEO_AREAS_B_UK1
  1. GEO_AREA_TYPE_CODE
  2. CODE
Foreign Keys to this table:
Foreign Key Column Foreign Table
XNP_GEO_AREAS_TL.GEO_AREA_ID XNP_GEO_AREAS_B
XNP_GEO_HIERARCHY.CHILD_GEO_AREA_ID XNP_GEO_AREAS_B
XNP_GEO_HIERARCHY.PARENT_GEO_AREA_ID XNP_GEO_AREAS_B
XNP_INTERCONNECT_AREAS.GEO_AREA_ID XNP_GEO_AREAS_B
XNP_NUMBER_RANGES.GEO_AREA_ID XNP_GEO_AREAS_B
XNP_SERVICE_AREAS.GEO_AREA_ID XNP_GEO_AREAS_B

[top of page]

XNP.XNP_GEO_AREAS_B does not reference any database object

XNP.XNP_GEO_AREAS_B is referenced by following:

APPS
SYNONYM - XNP_GEO_AREAS_B

[top of page]

Table: XNP_GEO_AREAS_TL

Description: Translation table to XNP_GEO_AREAS_B
Primary Key: XNP_GEO_AREAS_TL_PK
  1. GEO_AREA_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
XNP_GEO_AREAS_TL.GEO_AREA_ID XNP_GEO_AREAS_B

[top of page]

XNP.XNP_GEO_AREAS_TL does not reference any database object

XNP.XNP_GEO_AREAS_TL is referenced by following:

APPS
SYNONYM - XNP_GEO_AREAS_TL

[top of page]

Table: XNP_GEO_HIERARCHY

Description: Holds information about the geographic area hierarchy
Primary Key: XNP_GEO_HIERARCHY_PK
  1. GEO_HIERARCHY_ID
Primary Key: XNP_GEO_HIERARCHY_UK1
  1. PARENT_GEO_AREA_ID
  2. CHILD_GEO_AREA_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
XNP_GEO_HIERARCHY.CHILD_GEO_AREA_ID XNP_GEO_AREAS_B
XNP_GEO_HIERARCHY.PARENT_GEO_AREA_ID XNP_GEO_AREAS_B

[top of page]

XNP.XNP_GEO_HIERARCHY does not reference any database object

XNP.XNP_GEO_HIERARCHY is referenced by following:

APPS
SYNONYM - XNP_GEO_HIERARCHY

[top of page]

Table: XNP_INTERCONNECT_AREAS

Description: Stores geographic area covered by a routing number
Primary Key: XNP_INTERCONNECT_AREAS_PK
  1. INTERCONNECT_AREA_ID
Primary Key: XNP_INTERCONNECT_AREAS_UK1
  1. ROUTING_NUMBER_ID
  2. GEO_AREA_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
XNP_INTERCONNECT_AREAS.GEO_AREA_ID XNP_GEO_AREAS_B
XNP_INTERCONNECT_AREAS.ROUTING_NUMBER_ID XNP_ROUTING_NUMBERS

[top of page]

XNP.XNP_INTERCONNECT_AREAS does not reference any database object

XNP.XNP_INTERCONNECT_AREAS is referenced by following:

APPS
SYNONYM - XNP_INTERCONNECT_AREAS

[top of page]

Table: XNP_MSGS

Description: Stores the actual instance of a message that passes over a network association
Primary Key: XNP_MSGS_PK
  1. MSG_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
XNP_MSGS.MSG_CODE XNP_MSG_TYPES_B
XNP_MSGS.FA_INSTANCE_ID XDP_FA_RUNTIME_LIST
XNP_MSGS.ORDER_ID XDP_ORDER_HEADERS
XNP_MSGS.WI_INSTANCE_ID XDP_FULFILL_WORKLIST
Foreign Keys to this table:
Foreign Key Column Foreign Table
XNP_SV_EVENT_HISTORY.MSG_ID XNP_MSGS

[top of page]

XNP.XNP_MSGS does not reference any database object

XNP.XNP_MSGS is referenced by following:

APPS
SYNONYM - XNP_MSGS

[top of page]

Table: XNP_MSG_ACKS

Description: Contains message relationships
Primary Key: XNP_MSG_ACKS_PK
  1. MSG_ACK_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
XNP_MSG_ACKS.SOURCE_MSG_CODE XNP_MSG_TYPES_B
XNP_MSG_ACKS.ACK_MSG_CODE XNP_MSG_TYPES_B

[top of page]

XNP.XNP_MSG_ACKS does not reference any database object

XNP.XNP_MSG_ACKS is referenced by following:

APPS
SYNONYM - XNP_MSG_ACKS

[top of page]

Table: XNP_MSG_ATTR_VALUES

Description: Contains attribute values for XML message elements
Primary Key: XNP_MSG_ATTR_VALUES_PK
  1. MSG_ATTR_VALUE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
XNP_MSG_ATTR_VALUES.MSG_ELEMENT_ATTR_ID XNP_MSG_ELEMENT_ATTR

[top of page]

XNP.XNP_MSG_ATTR_VALUES does not reference any database object

XNP.XNP_MSG_ATTR_VALUES is referenced by following:

APPS
SYNONYM - XNP_MSG_ATTR_VALUES

[top of page]

Table: XNP_MSG_ELEMENTS

Description: Contains XML message elements
Primary Key: XNP_MSG_ELEMENTS_PK
  1. MSG_ELEMENT_ID
Primary Key: XNP_MSG_ELEMENTS_UK1
  1. NAME
  2. MSG_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
XNP_MSG_ELEMENTS.MSG_CODE XNP_MSG_TYPES_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
XNP_MSG_ELEMENT_ATTR.MSG_ELEMENT_ID XNP_MSG_ELEMENTS
XNP_MSG_STRUCTURES.PARENT_ELEMENT_ID XNP_MSG_ELEMENTS
XNP_MSG_STRUCTURES.CHILD_ELEMENT_ID XNP_MSG_ELEMENTS

[top of page]

XNP.XNP_MSG_ELEMENTS does not reference any database object

XNP.XNP_MSG_ELEMENTS is referenced by following:

APPS
SYNONYM - XNP_MSG_ELEMENTS

[top of page]

Table: XNP_MSG_ELEMENT_ATTR

Description: Contains attributes of XML elements
Primary Key: XNP_MSG_ELEMENT_ATTR_PK
  1. MSG_ELEMENT_ATTR_ID
Primary Key: XNP_MSG_ELEMENT_ATTR_UK1
  1. MSG_ELEMENT_ATTR_ID
  2. NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
XNP_MSG_ELEMENT_ATTR.MSG_ELEMENT_ID XNP_MSG_ELEMENTS
Foreign Keys to this table:
Foreign Key Column Foreign Table
XNP_MSG_ATTR_VALUES.MSG_ELEMENT_ATTR_ID XNP_MSG_ELEMENT_ATTR

[top of page]

XNP.XNP_MSG_ELEMENT_ATTR does not reference any database object

XNP.XNP_MSG_ELEMENT_ATTR is referenced by following:

APPS
SYNONYM - XNP_MSG_ELEMENT_ATTR

[top of page]

Table: XNP_MSG_STRUCTURES

Description: Contains the structural relationship or hierarchy of all the elements in the XML message
Primary Key: XNP_MSG_STRUCTURES_PK
  1. STRUCTURE_ID
Primary Key: XNP_MSG_STRUCTURES_UK1
  1. MSG_CODE
  2. CHILD_ELEMENT_ID
  3. PARENT_ELEMENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
XNP_MSG_STRUCTURES.MSG_CODE XNP_MSG_TYPES_B
XNP_MSG_STRUCTURES.PARENT_ELEMENT_ID XNP_MSG_ELEMENTS
XNP_MSG_STRUCTURES.CHILD_ELEMENT_ID XNP_MSG_ELEMENTS

[top of page]

XNP.XNP_MSG_STRUCTURES does not reference any database object

XNP.XNP_MSG_STRUCTURES is referenced by following:

APPS
SYNONYM - XNP_MSG_STRUCTURES

[top of page]

Table: XNP_MSG_TYPES_B

Description: Contains data dictionary for the message
Primary Key: XNP_MSG_TYPES_B_PK
  1. MSG_CODE
Foreign Keys to this table:
Foreign Key Column Foreign Table
XNP_CALLBACK_EVENTS.MSG_CODE XNP_MSG_TYPES_B
XNP_EVENT_SUBSCRIBERS.MSG_CODE XNP_MSG_TYPES_B
XNP_MSGS.MSG_CODE XNP_MSG_TYPES_B
XNP_MSG_ACKS.SOURCE_MSG_CODE XNP_MSG_TYPES_B
XNP_MSG_ACKS.ACK_MSG_CODE XNP_MSG_TYPES_B
XNP_MSG_ELEMENTS.MSG_CODE XNP_MSG_TYPES_B
XNP_MSG_STRUCTURES.MSG_CODE XNP_MSG_TYPES_B
XNP_MSG_TYPES_TL.MSG_CODE XNP_MSG_TYPES_B
XNP_TIMER_PUBLISHERS.TIMER_MESSAGE_CODE XNP_MSG_TYPES_B
XNP_TIMER_PUBLISHERS.SOURCE_MESSAGE_CODE XNP_MSG_TYPES_B
XNP_TIMER_REGISTRY.TIMER_MESSAGE_CODE XNP_MSG_TYPES_B
XNP_TIMER_REGISTRY.NEXT_TIMER XNP_MSG_TYPES_B

[top of page]

XNP.XNP_MSG_TYPES_B does not reference any database object

XNP.XNP_MSG_TYPES_B is referenced by following:

APPS
SYNONYM - XNP_MSG_TYPES_B

[top of page]

Table: XNP_MSG_TYPES_TL

Description: Translation table to XNP_MSG_TYPES_B
Primary Key: XNP_MSG_TYPES_TL_PK
  1. MSG_CODE
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
XNP_MSG_TYPES_TL.MSG_CODE XNP_MSG_TYPES_B

[top of page]

XNP.XNP_MSG_TYPES_TL does not reference any database object

XNP.XNP_MSG_TYPES_TL is referenced by following:

APPS
SYNONYM - XNP_MSG_TYPES_TL

[top of page]

Table: XNP_NETWORK_MAPS

Description: Stores the relationship between network elements
Primary Key: XNP_NETWORK_MAPS_PK
  1. NETWORK_MAP_ID
Primary Key: XNP_NETWORK_MAPS_UK1
  1. PARENT_FE_ID
  2. CHILD_FE_ID
  3. MAP_TYPE
Foreign Keys from this table:
Foreign Key Column Foreign Table
XNP_NETWORK_MAPS.PARENT_FE_ID XDP_FES
XNP_NETWORK_MAPS.CHILD_FE_ID XDP_FES

[top of page]

XNP.XNP_NETWORK_MAPS does not reference any database object

XNP.XNP_NETWORK_MAPS is referenced by following:

APPS
SYNONYM - XNP_NETWORK_MAPS

[top of page]

Table: XNP_NUMBER_RANGES

Description: Stores information about the characteristics of a service provider's telephone number ranges
Primary Key: XNP_NUMBER_RANGES_PK
  1. NUMBER_RANGE_ID
Primary Key: XNP_NUMBER_RANGES_UK1
  1. STARTING_NUMBER
Primary Key: XNP_NUMBER_RANGES_UK2
  1. OBJECT_REFERENCE
Foreign Keys from this table:
Foreign Key Column Foreign Table
XNP_NUMBER_RANGES.GEO_AREA_ID XNP_GEO_AREAS_B
XNP_NUMBER_RANGES.OWNING_SP_ID XNP_SERVICE_PROVIDERS
XNP_NUMBER_RANGES.ASSIGNED_SP_ID XNP_SERVICE_PROVIDERS
Foreign Keys to this table:
Foreign Key Column Foreign Table
XNP_NUMBER_SPLITS.NEW_NUMBER_RANGE_ID XNP_NUMBER_RANGES
XNP_NUMBER_SPLITS.OLD_NUMBER_RANGE_ID XNP_NUMBER_RANGES
XNP_SERVED_NUM_RANGES.NUMBER_RANGE_ID XNP_NUMBER_RANGES
XNP_SP_FILTERS.NUMBER_RANGE_ID XNP_NUMBER_RANGES

[top of page]

XNP.XNP_NUMBER_RANGES does not reference any database object

XNP.XNP_NUMBER_RANGES is referenced by following:

APPS
TRIGGER - XNP_NRE_BRI
SYNONYM - XNP_NUMBER_RANGES

[top of page]

Table: XNP_NUMBER_SPLITS

Description: Stores information about a number split including the old number range, new number range and algorithm to convert from the old number to the new number range
Primary Key: XNP_NUMBER_SPLITS_PK
  1. NUMBER_SPLIT_ID
Primary Key: XNP_NUMBER_SPLITS_UK1
  1. OLD_NUMBER_RANGE_ID
  2. NEW_NUMBER_RANGE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
XNP_NUMBER_SPLITS.NEW_NUMBER_RANGE_ID XNP_NUMBER_RANGES
XNP_NUMBER_SPLITS.OLD_NUMBER_RANGE_ID XNP_NUMBER_RANGES

[top of page]

XNP.XNP_NUMBER_SPLITS does not reference any database object

XNP.XNP_NUMBER_SPLITS is referenced by following:

APPS
SYNONYM - XNP_NUMBER_SPLITS

[top of page]

Table: XNP_ROUTING_NUMBERS

Description: Stores routing numbers which are used to deliver ported telephone numbers to the appropriate service provider
Primary Key: XNP_ROUTING_NUMBERS_PK
  1. ROUTING_NUMBER_ID
Primary Key: XNP_ROUTING_NUMBERS_UK1
  1. SP_ID
  2. ROUTING_NUMBER
  3. INTERCONNECT_TYPE
Primary Key: XNP_ROUTING_NUMBERS_UK2
  1. OBJECT_REFERENCE
Foreign Keys from this table:
Foreign Key Column Foreign Table
XNP_ROUTING_NUMBERS.SP_ID XNP_SERVICE_PROVIDERS
Foreign Keys to this table:
Foreign Key Column Foreign Table
XNP_INTERCONNECT_AREAS.ROUTING_NUMBER_ID XNP_ROUTING_NUMBERS
XNP_SV_SMS.ROUTING_NUMBER_ID XNP_ROUTING_NUMBERS
XNP_SV_SOA.ROUTING_NUMBER_ID XNP_ROUTING_NUMBERS
XNP_SV_SOA_JN.ROUTING_NUMBER_ID XNP_ROUTING_NUMBERS

[top of page]

XNP.XNP_ROUTING_NUMBERS does not reference any database object

XNP.XNP_ROUTING_NUMBERS is referenced by following:

APPS
SYNONYM - XNP_ROUTING_NUMBERS

[top of page]

Table: XNP_SERVED_NUM_RANGES

Description: Stores the mapping of number ranges served by network element for each feature type
Primary Key: XNP_SERVED_NUM_RANGES_PK
  1. SERVED_NUMBER_RANGE_ID
Primary Key: XNP_SERVED_NUM_RANGES_UK1
  1. NUMBER_RANGE_ID
  2. FE_ID
  3. FEATURE_TYPE
Foreign Keys from this table:
Foreign Key Column Foreign Table
XNP_SERVED_NUM_RANGES.NUMBER_RANGE_ID XNP_NUMBER_RANGES
XNP_SERVED_NUM_RANGES.FE_ID XDP_FES

[top of page]

XNP.XNP_SERVED_NUM_RANGES does not reference any database object

XNP.XNP_SERVED_NUM_RANGES is referenced by following:

APPS
SYNONYM - XNP_SERVED_NUM_RANGES

[top of page]

Table: XNP_SERVICE_AREAS

Description: Stores geographic areas served by a service provider
Primary Key: XNP_SERVICE_AREAS_PK
  1. SERVICE_AREA_ID
Primary Key: XNP_SERVICE_AREAS_UK1
  1. SP_ID
  2. GEO_AREA_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
XNP_SERVICE_AREAS.GEO_AREA_ID XNP_GEO_AREAS_B
XNP_SERVICE_AREAS.SP_ID XNP_SERVICE_PROVIDERS

[top of page]

XNP.XNP_SERVICE_AREAS does not reference any database object

XNP.XNP_SERVICE_AREAS is referenced by following:

APPS
SYNONYM - XNP_SERVICE_AREAS

[top of page]

Table: XNP_SERVICE_PROVIDERS

Description: Stores service provider definitions
Primary Key: XNP_SERVICE_PROVIDERS_PK
  1. SP_ID
Primary Key: XNP_SERVICE_PROVIDERS_UK1
  1. CODE
Foreign Keys to this table:
Foreign Key Column Foreign Table
XNP_AUDIT_DISCREPANCIES.SP_ID XNP_SERVICE_PROVIDERS
XNP_AUDIT_SMS_FAILURES.SP_ID XNP_SERVICE_PROVIDERS
XNP_NUMBER_RANGES.OWNING_SP_ID XNP_SERVICE_PROVIDERS
XNP_NUMBER_RANGES.ASSIGNED_SP_ID XNP_SERVICE_PROVIDERS
XNP_ROUTING_NUMBERS.SP_ID XNP_SERVICE_PROVIDERS
XNP_SERVICE_AREAS.SP_ID XNP_SERVICE_PROVIDERS
XNP_SP_ADAPTERS.SP_ID XNP_SERVICE_PROVIDERS
XNP_SP_CONTACTS.SP_ID XNP_SERVICE_PROVIDERS
XNP_SP_FILTERS.SP_ID XNP_SERVICE_PROVIDERS
XNP_SV_AUDITS.FOR_SP_ID XNP_SERVICE_PROVIDERS
XNP_SV_AUDITS.SP_ID XNP_SERVICE_PROVIDERS
XNP_SV_FAILURES.SP_ID XNP_SERVICE_PROVIDERS
XNP_SV_SMS.MEDIATOR_SP_ID XNP_SERVICE_PROVIDERS
XNP_SV_SOA.DONOR_SP_ID XNP_SERVICE_PROVIDERS
XNP_SV_SOA.RECIPIENT_SP_ID XNP_SERVICE_PROVIDERS
XNP_SV_SOA.CREATED_BY_SP_ID XNP_SERVICE_PROVIDERS
XNP_SV_SOA.CHANGED_BY_SP_ID XNP_SERVICE_PROVIDERS
XNP_SV_SOA.MEDIATOR_SP_ID XNP_SERVICE_PROVIDERS
XNP_SV_SOA_JN.CHANGED_BY_SP_ID XNP_SERVICE_PROVIDERS
XNP_SV_SOA_JN.CREATED_BY_SP_ID XNP_SERVICE_PROVIDERS
XNP_SV_SOA_JN.DONOR_SP_ID XNP_SERVICE_PROVIDERS
XNP_SV_SOA_JN.RECIPIENT_SP_ID XNP_SERVICE_PROVIDERS
XNP_SV_SOA_JN.MEDIATOR_SP_ID XNP_SERVICE_PROVIDERS

[top of page]

XNP.XNP_SERVICE_PROVIDERS does not reference any database object

XNP.XNP_SERVICE_PROVIDERS is referenced by following:

APPS
SYNONYM - XNP_SERVICE_PROVIDERS

[top of page]

Table: XNP_SP_ADAPTERS

Description: Stores mapping of a service provider to an external system
Primary Key: XNP_SP_ADAPTERS_PK
  1. SP_ADAPTER_ID
Primary Key: XNP_SP_ADAPTERS_UK1
  1. FE_ID
  2. SP_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
XNP_SP_ADAPTERS.SP_ID XNP_SERVICE_PROVIDERS
XNP_SP_ADAPTERS.FE_ID XDP_FES

[top of page]

XNP.XNP_SP_ADAPTERS does not reference any database object

XNP.XNP_SP_ADAPTERS is referenced by following:

APPS
SYNONYM - XNP_SP_ADAPTERS

[top of page]

Table: XNP_SP_CONTACTS

Description: Stores contact information for a service provider
Primary Key: XNP_SP_CONTACTS_PK
  1. SP_CONTACT_ID
Primary Key: XNP_SP_CONTACTS_UK1
  1. BUSINESS_ROLE
  2. SP_ID
  3. NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
XNP_SP_CONTACTS.SP_ID XNP_SERVICE_PROVIDERS

[top of page]

XNP.XNP_SP_CONTACTS does not reference any database object

XNP.XNP_SP_CONTACTS is referenced by following:

APPS
SYNONYM - XNP_SP_CONTACTS

[top of page]

Table: XNP_SP_FILTERS

Description: Stores the number ranges for which a service provider does not want to be informed of subscription broadcasts
Primary Key: XNP_SP_FILTERS_PK
  1. SP_FILTER_ID
Primary Key: XNP_SP_FILTERS_UK1
  1. OBJECT_REFERENCE
Primary Key: XNP_SP_FILTERS_UK2
  1. SP_ID
  2. NUMBER_RANGE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
XNP_SP_FILTERS.NUMBER_RANGE_ID XNP_NUMBER_RANGES
XNP_SP_FILTERS.SP_ID XNP_SERVICE_PROVIDERS

[top of page]

XNP.XNP_SP_FILTERS does not reference any database object

XNP.XNP_SP_FILTERS is referenced by following:

APPS
SYNONYM - XNP_SP_FILTERS

[top of page]

Table: XNP_SV_AUDITS

Description: Stores all subscription audits issued from a service provider
Primary Key: XNP_SV_AUDITS_PK
  1. SV_AUDIT_ID
Primary Key: XNP_SV_AUDITS_UK1
  1. OBJECT_REFERENCE
Primary Key: XNP_SV_AUDITS_UK2
  1. SP_ID
  2. STARTING_NUMBER
Foreign Keys from this table:
Foreign Key Column Foreign Table
XNP_SV_AUDITS.FOR_SP_ID XNP_SERVICE_PROVIDERS
XNP_SV_AUDITS.SP_ID XNP_SERVICE_PROVIDERS
Foreign Keys to this table:
Foreign Key Column Foreign Table
XNP_AUDIT_DISCREPANCIES.AUDIT_ID XNP_SV_AUDITS
XNP_AUDIT_SMS_FAILURES.AUDIT_ID XNP_SV_AUDITS

[top of page]

XNP.XNP_SV_AUDITS does not reference any database object

XNP.XNP_SV_AUDITS is referenced by following:

APPS
SYNONYM - XNP_SV_AUDITS

[top of page]

Table: XNP_SV_EVENT_HISTORY

Description: Stores information about any kind of event on the porting number or message
Primary Key: XNP_SV_EVENT_HISTORY_PK
  1. SV_EVENT_HISTORY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
XNP_SV_EVENT_HISTORY.MSG_ID XNP_MSGS
XNP_SV_EVENT_HISTORY.SV_SOA_ID XNP_SV_SOA

[top of page]

XNP.XNP_SV_EVENT_HISTORY does not reference any database object

XNP.XNP_SV_EVENT_HISTORY is referenced by following:

APPS
SYNONYM - XNP_SV_EVENT_HISTORY

[top of page]

Table: XNP_SV_FAILURES

Description: Stores a list of service providers that failed to download subscription version data
Primary Key: XNP_SV_FAILURES_PK
  1. SV_FAILURE_ID
Primary Key: XNP_SV_FAILURES_UK1
  1. SP_ID
  2. SV_SOA_ID
  3. FAILURE_DATE
Foreign Keys from this table:
Foreign Key Column Foreign Table
XNP_SV_FAILURES.SP_ID XNP_SERVICE_PROVIDERS
XNP_SV_FAILURES.SV_SOA_ID XNP_SV_SOA

[top of page]

XNP.XNP_SV_FAILURES does not reference any database object

XNP.XNP_SV_FAILURES is referenced by following:

APPS
SYNONYM - XNP_SV_FAILURES

[top of page]

Table: XNP_SV_ORDER_MAPPINGS

Description: Stores event information associated with subscription versions or messages.
Primary Key: XNP_SV_ORDER_MAPPINGS_PK
  1. SV_ORDER_MAPPING_ID
Primary Key: XNP_SV_ORDER_MAPPINGS_UK1
  1. ORDER_ID
  2. SV_SOA_ID
  3. SV_SMS_ID
  4. WORKITEM_INSTANCE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
XNP_SV_ORDER_MAPPINGS.ORDER_ID XDP_ORDER_HEADERS
XNP_SV_ORDER_MAPPINGS.SV_SMS_ID XNP_SV_SMS
XNP_SV_ORDER_MAPPINGS.SV_SOA_ID XNP_SV_SOA
XNP_SV_ORDER_MAPPINGS.WORKITEM_INSTANCE_ID XDP_FULFILL_WORKLIST

[top of page]

XNP.XNP_SV_ORDER_MAPPINGS does not reference any database object

XNP.XNP_SV_ORDER_MAPPINGS is referenced by following:

APPS
SYNONYM - XNP_SV_ORDER_MAPPINGS

[top of page]

Table: XNP_SV_SMS

Description: Container object for subscription versions downloaded to the network
Primary Key: XNP_SV_SMS_PK
  1. SV_SMS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
XNP_SV_SMS.ROUTING_NUMBER_ID XNP_ROUTING_NUMBERS
XNP_SV_SMS.MEDIATOR_SP_ID XNP_SERVICE_PROVIDERS
Foreign Keys to this table:
Foreign Key Column Foreign Table
XNP_SV_ORDER_MAPPINGS.SV_SMS_ID XNP_SV_SMS
XNP_SV_SMS_FE_MAPS.SV_SMS_ID XNP_SV_SMS

[top of page]

XNP.XNP_SV_SMS does not reference any database object

XNP.XNP_SV_SMS is referenced by following:

APPS
SYNONYM - XNP_SV_SMS

[top of page]

Table: XNP_SV_SMS_FE_MAPS

Description: Stores a list of fulfillment elements provisioned with subscription version data
Primary Key: XNP_SV_SMS_FE_MAPS_PK
  1. SMS_FE_MAP_ID
Primary Key: XNP_SV_SMS_FE_MAPS_UK
  1. SV_SMS_ID
  2. FEATURE_TYPE
  3. FE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
XNP_SV_SMS_FE_MAPS.SV_SMS_ID XNP_SV_SMS
XNP_SV_SMS_FE_MAPS.FE_ID XDP_FES

[top of page]

XNP.XNP_SV_SMS_FE_MAPS does not reference any database object

XNP.XNP_SV_SMS_FE_MAPS is referenced by following:

APPS
SYNONYM - XNP_SV_SMS_FE_MAPS

[top of page]

Table: XNP_SV_SOA

Description: Container object for a porting request on a single telephone number
Primary Key: XNP_SV_SOA_PK
  1. SV_SOA_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
XNP_SV_SOA.ROUTING_NUMBER_ID XNP_ROUTING_NUMBERS
XNP_SV_SOA.DONOR_SP_ID XNP_SERVICE_PROVIDERS
XNP_SV_SOA.RECIPIENT_SP_ID XNP_SERVICE_PROVIDERS
XNP_SV_SOA.CREATED_BY_SP_ID XNP_SERVICE_PROVIDERS
XNP_SV_SOA.CHANGED_BY_SP_ID XNP_SERVICE_PROVIDERS
XNP_SV_SOA.MEDIATOR_SP_ID XNP_SERVICE_PROVIDERS
XNP_SV_SOA.STATUS_TYPE_CODE XNP_SV_STATUS_TYPES_B
XNP_SV_SOA.PREV_STATUS_TYPE_CODE XNP_SV_STATUS_TYPES_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
XNP_SV_EVENT_HISTORY.SV_SOA_ID XNP_SV_SOA
XNP_SV_FAILURES.SV_SOA_ID XNP_SV_SOA
XNP_SV_ORDER_MAPPINGS.SV_SOA_ID XNP_SV_SOA

[top of page]

XNP.XNP_SV_SOA does not reference any database object

XNP.XNP_SV_SOA is referenced by following:

APPS
TRIGGER - XNP_SVA_ARD
TRIGGER - XNP_SVA_ARI
TRIGGER - XNP_SVA_ARU
SYNONYM - XNP_SV_SOA

[top of page]

Table: XNP_SV_SOA_JN

Description: Journalling table for the XNP_SV_SOA table
Primary Key: XNP_SV_SOA_JN_PK
  1. SV_SOA_ID
  2. JN_ORACLE_USER
  3. JN_DATETIME
  4. JN_OPERATION
Foreign Keys from this table:
Foreign Key Column Foreign Table
XNP_SV_SOA_JN.CHANGED_BY_SP_ID XNP_SERVICE_PROVIDERS
XNP_SV_SOA_JN.CREATED_BY_SP_ID XNP_SERVICE_PROVIDERS
XNP_SV_SOA_JN.DONOR_SP_ID XNP_SERVICE_PROVIDERS
XNP_SV_SOA_JN.RECIPIENT_SP_ID XNP_SERVICE_PROVIDERS
XNP_SV_SOA_JN.MEDIATOR_SP_ID XNP_SERVICE_PROVIDERS
XNP_SV_SOA_JN.ROUTING_NUMBER_ID XNP_ROUTING_NUMBERS

[top of page]

XNP.XNP_SV_SOA_JN does not reference any database object

XNP.XNP_SV_SOA_JN is referenced by following:

APPS
SYNONYM - XNP_SV_SOA_JN

[top of page]

Table: XNP_SV_STATUS_TYPES_B

Description: Subsription version status definition
Primary Key: XNP_SV_STATUS_TYPES_B_PK
  1. STATUS_TYPE_CODE
Foreign Keys to this table:
Foreign Key Column Foreign Table
XNP_SV_SOA.STATUS_TYPE_CODE XNP_SV_STATUS_TYPES_B
XNP_SV_SOA.PREV_STATUS_TYPE_CODE XNP_SV_STATUS_TYPES_B
XNP_SV_STATUS_TYPES_TL.STATUS_TYPE_CODE XNP_SV_STATUS_TYPES_B

[top of page]

XNP.XNP_SV_STATUS_TYPES_B does not reference any database object

XNP.XNP_SV_STATUS_TYPES_B is referenced by following:

APPS
SYNONYM - XNP_SV_STATUS_TYPES_B

[top of page]

Table: XNP_SV_STATUS_TYPES_TL

Description: Translation table to XNP_SV_STATUS_TYPES_B
Primary Key: XNP_SV_STATUS_TYPES_TL_PK
  1. STATUS_TYPE_CODE
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
XNP_SV_STATUS_TYPES_TL.STATUS_TYPE_CODE XNP_SV_STATUS_TYPES_B

[top of page]

XNP.XNP_SV_STATUS_TYPES_TL does not reference any database object

XNP.XNP_SV_STATUS_TYPES_TL is referenced by following:

APPS
SYNONYM - XNP_SV_STATUS_TYPES_TL

[top of page]

Table: XNP_SYNC_REGISTRATION

Description: Maintains the state of synchronized workflows
Primary Key: XNP_SYNC_REGISTRATION_PK
  1. SYNC_REGISTRATION_ID
Primary Key: XNP_SYNC_REGISTRATION_UK1
  1. ORDER_ID
  2. SYNC_LABEL
Foreign Keys from this table:
Foreign Key Column Foreign Table
XNP_SYNC_REGISTRATION.ORDER_ID XDP_ORDER_HEADERS

[top of page]

XNP.XNP_SYNC_REGISTRATION does not reference any database object

XNP.XNP_SYNC_REGISTRATION is referenced by following:

APPS
SYNONYM - XNP_SYNC_REGISTRATION

[top of page]

Table: XNP_TIMER_PUBLISHERS

Description: Stores timers related to a message
Primary Key: XNP_TIMER_PUBLISHERS_PK
  1. TIMER_PUBLISHER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
XNP_TIMER_PUBLISHERS.TIMER_MESSAGE_CODE XNP_MSG_TYPES_B
XNP_TIMER_PUBLISHERS.SOURCE_MESSAGE_CODE XNP_MSG_TYPES_B

[top of page]

XNP.XNP_TIMER_PUBLISHERS does not reference any database object

XNP.XNP_TIMER_PUBLISHERS is referenced by following:

APPS
SYNONYM - XNP_TIMER_PUBLISHERS

[top of page]

Table: XNP_TIMER_REGISTRY

Description: Stores a list of all timers in progress
Primary Key: XNP_TIMER_REGISTRY_PK
  1. TIMER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
XNP_TIMER_REGISTRY.TIMER_MESSAGE_CODE XNP_MSG_TYPES_B
XNP_TIMER_REGISTRY.NEXT_TIMER XNP_MSG_TYPES_B
XNP_TIMER_REGISTRY.ORDER_ID XDP_ORDER_HEADERS
XNP_TIMER_REGISTRY.FA_INSTANCE_ID XDP_FA_RUNTIME_LIST
XNP_TIMER_REGISTRY.WI_INSTANCE_ID XDP_FULFILL_WORKLIST

[top of page]

XNP.XNP_TIMER_REGISTRY does not reference any database object

XNP.XNP_TIMER_REGISTRY is referenced by following:

APPS
SYNONYM - XNP_TIMER_REGISTRY

[top of page]

View: XNP_GEO_AREAS_VL

[top of page]

APPS.XNP_GEO_AREAS_VL references the following:

APPS
SYNONYM - XNP_GEO_AREAS_B
SYNONYM - XNP_GEO_AREAS_TL

APPS.XNP_GEO_AREAS_VL is not referenced by any database object

[top of page]

View: XNP_LOOKUPS

[top of page]

APPS.XNP_LOOKUPS references the following:

APPS
SYNONYM - FND_LOOKUP_VALUES

APPS.XNP_LOOKUPS is not referenced by any database object

[top of page]

View: XNP_MSG_TYPES_VL

[top of page]

APPS.XNP_MSG_TYPES_VL references the following:

APPS
SYNONYM - XNP_MSG_TYPES_B
SYNONYM - XNP_MSG_TYPES_TL
APPS.XNP_MSG_TYPES_VL is referenced by following:

APPS
PACKAGE BODY - XNP_CVU_PKG
PACKAGE BODY - XNP_MSG_BUILDER

[top of page]

View: XNP_SV_FE_MAPP_DETAILS_VL

[top of page]

APPS.XNP_SV_FE_MAPP_DETAILS_VL references the following:

APPS
SYNONYM - FND_LOOKUP_VALUES
SYNONYM - XDP_FES
SYNONYM - XDP_FES_TL
SYNONYM - XDP_FE_TYPES
SYNONYM - XNP_SV_SMS_FE_MAPS

APPS.XNP_SV_FE_MAPP_DETAILS_VL is not referenced by any database object

[top of page]

View: XNP_SV_ORDER_MAPP_DETAILS_VL

[top of page]

APPS.XNP_SV_ORDER_MAPP_DETAILS_VL references the following:

APPS
SYNONYM - XDP_FULFILL_WORKLIST
SYNONYM - XDP_ORDER_HEADERS
SYNONYM - XDP_WORKITEMS
SYNONYM - XDP_WORKITEMS_TL
SYNONYM - XNP_SV_ORDER_MAPPINGS

APPS.XNP_SV_ORDER_MAPP_DETAILS_VL is not referenced by any database object

[top of page]

View: XNP_SV_SMS_V

[top of page]

APPS.XNP_SV_SMS_V references the following:

APPS
SYNONYM - XNP_ROUTING_NUMBERS
SYNONYM - XNP_SERVICE_PROVIDERS
SYNONYM - XNP_SV_SMS
APPS.XNP_SV_SMS_V is referenced by following:

APPS
PACKAGE BODY - XNP_SV_NETWORK$SMS_SV

[top of page]

View: XNP_SV_SOA_VL

[top of page]

APPS.XNP_SV_SOA_VL references the following:

APPS
SYNONYM - XNP_ROUTING_NUMBERS
SYNONYM - XNP_SERVICE_PROVIDERS
SYNONYM - XNP_SV_SOA
SYNONYM - XNP_SV_STATUS_TYPES_B
SYNONYM - XNP_SV_STATUS_TYPES_TL
APPS.XNP_SV_SOA_VL is referenced by following:

APPS
PACKAGE BODY - XNP_SV_ORDERS$SOA_SV
PACKAGE BODY - XNP_WEB_UTILS

[top of page]

View: XNP_SV_STATUS_TYPES_VL

[top of page]

APPS.XNP_SV_STATUS_TYPES_VL references the following:

APPS
SYNONYM - XNP_SV_STATUS_TYPES_B
SYNONYM - XNP_SV_STATUS_TYPES_TL
APPS.XNP_SV_STATUS_TYPES_VL is referenced by following:

APPS
PACKAGE BODY - XNP_CVU_PKG

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract