eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: XNP.XNP_AUDIT_DISCREPANCIES

Object Details

Object Name:	XNP_AUDIT_DISCREPANCIES
Object Type:	TABLE
Owner:	XNP
FND Design Data:	XNP.XNP_AUDIT_DISCREPANCIES
Subobject Name:
Status:	VALID

XNP_AUDIT_DISCREPENCIES stores discrepencies between a subscription version and the data in a given service provider's network. Discrepancy reports are direct results of an audit.Network data of a subscription version typically includes a Routing Number(RN) and vertical services that are associated with a telephone line.
Services may include Caller Naming (CNAM), Integrated Services Voice Mail (ISVM), Line Information Databases (LIDB) for calling card verification, Custom Local Area Signaling Services (CLASS), and Wireless Short Message Service Center(WSMSC).This table will not be used in the current release.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
XNP_AUDIT_DISCREPANCIES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	AUDIT_DISCREPANCY_ID
XNP_AUDIT_DISCREPANCIES_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	SUBSCRIPTION_TN SP_ID AUDIT_ID ERROR_CODE
XNP_AUDIT_DISCREPANCIES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SP_ID

Columns

Name	Datatype	Length	Mandatory	Comments
AUDIT_DISCREPANCY_ID	NUMBER		Yes	Audit discrepency identifier
AUDIT_ID	NUMBER		Yes	Audit identifier
SP_ID	NUMBER		Yes	Service Provider Identifier where discrepency is found
SUBSCRIPTION_TN	VARCHAR2	(20)	Yes	Telephone number for which discrepancy is found
ERROR_CODE	VARCHAR2	(15)	Yes	Indicates the error code
ROUTING_NUMBER	VARCHAR2	(20)		Switch to which the number is ported
CNAM_ADDRESS	VARCHAR2	(80)		CNAM network address for the subscription version
CNAM_SUBSYSTEM	VARCHAR2	(80)		CNAM application subsystem for the subscription version
ISVM_ADDRESS	VARCHAR2	(80)		ISVM network address for the subscription version
ISVM_SUBSYSTEM	VARCHAR2	(80)		ISVM application subsystem for the subscription version
LIDB_ADDRESS	VARCHAR2	(80)		LIDB network address for the subscription version
LIDB_SUBSYSTEM	VARCHAR2	(80)		LIDB application subsystem for the subscription version
CLASS_ADDRESS	VARCHAR2	(80)		CLASS network address for the subscription version
CLASS_SUBSYSTEM	VARCHAR2	(80)		CLASS application subsystem for the subscription version
WSMSC_ADDRESS	VARCHAR2	(80)		WSMSC network address for the subscription version
WSMSC_SUBSYSTEM	VARCHAR2	(80)		WSMSC application subsystem for the subscription version
RN_ADDRESS	VARCHAR2	(80)		RN network address for the subscription version
RN_SUBSYSTEM	VARCHAR2	(80)		RN application subsystem for the subscription version
EXT_ROUTING_NUMBER	VARCHAR2	(20)		External switch to which the number is ported
EXT_CNAM_ADDRESS	VARCHAR2	(80)		External CNAM network address for the subscription version
EXT_CNAM_SUBSYSTEM	VARCHAR2	(80)		External CNAM application subsystem for the subscription version
EXT_ISVM_ADDRESS	VARCHAR2	(80)		External ISVM network address for the subscription version
EXT_ISVM_SUBSYSTEM	VARCHAR2	(80)		External ISVM application subsystem for the subscription version
EXT_LIDB_ADDRESS	VARCHAR2	(80)		External LIDB network address for the subscription version
EXT_LIDB_SUBSYSTEM	VARCHAR2	(80)		External LIDB application subsystem for the subscription version
EXT_CLASS_ADDRESS	VARCHAR2	(80)		External CLASS network address for the subscription version
EXT_CLASS_SUBSYSTEM	VARCHAR2	(80)		External CLASS application subsystem for the subscription version
EXT_WSMSC_ADDRESS	VARCHAR2	(80)		External WSMSC network address for the subscription version
EXT_WSMSC_SUBSYSTEM	VARCHAR2	(80)		External WSMSC application subsystem for the subscription version
EXT_RN_ADDRESS	VARCHAR2	(80)		External RN network address for the subscription version
EXT_RN_SUBSYSTEM	VARCHAR2	(80)		External RN application subsystem for the subscription version
CREATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
SECURITY_GROUP_ID	NUMBER			Used in hosted environments

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT AUDIT_DISCREPANCY_ID
,      AUDIT_ID
,      SP_ID
,      SUBSCRIPTION_TN
,      ERROR_CODE
,      ROUTING_NUMBER
,      CNAM_ADDRESS
,      CNAM_SUBSYSTEM
,      ISVM_ADDRESS
,      ISVM_SUBSYSTEM
,      LIDB_ADDRESS
,      LIDB_SUBSYSTEM
,      CLASS_ADDRESS
,      CLASS_SUBSYSTEM
,      WSMSC_ADDRESS
,      WSMSC_SUBSYSTEM
,      RN_ADDRESS
,      RN_SUBSYSTEM
,      EXT_ROUTING_NUMBER
,      EXT_CNAM_ADDRESS
,      EXT_CNAM_SUBSYSTEM
,      EXT_ISVM_ADDRESS
,      EXT_ISVM_SUBSYSTEM
,      EXT_LIDB_ADDRESS
,      EXT_LIDB_SUBSYSTEM
,      EXT_CLASS_ADDRESS
,      EXT_CLASS_SUBSYSTEM
,      EXT_WSMSC_ADDRESS
,      EXT_WSMSC_SUBSYSTEM
,      EXT_RN_ADDRESS
,      EXT_RN_SUBSYSTEM
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
FROM XNP.XNP_AUDIT_DISCREPANCIES;

Dependencies

[top of page]

XNP.XNP_AUDIT_DISCREPANCIES does not reference any database object

XNP.XNP_AUDIT_DISCREPANCIES is referenced by following:

APPS: XNP_AUDIT_DISCREPANCIES