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_SV_SMS

Object Details

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

XNP_SV_SMS stores downloaded network data for porting requests from NRC. The records can only be created, deleted or modified upon instructions from the Number Registratin Center. Data in this table cannot be modified directly from a NP SMS or SOA system.
The five vertical services associated with a telephone line are included in the table. Services 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).

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
XNP_SV_SMS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SV_SMS_ID
XNP_SV_SMS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ROUTING_NUMBER_ID
XNP_SV_SMS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	MEDIATOR_SP_ID
XNP_SV_SMS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OBJECT_REFERENCE
XNP_SV_SMS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SUBSCRIPTION_TYPE
XNP_SV_SMS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SUBSCRIPTION_TN

Columns

Name	Datatype	Length	Mandatory	Comments
SV_SMS_ID	NUMBER		Yes	Subscription version identifier for SMS
OBJECT_REFERENCE	VARCHAR2	(80)	Yes	External reference id
ROUTING_NUMBER_ID	NUMBER		Yes	Routing number identifier of the SMS subscription version
SUBSCRIPTION_TN	VARCHAR2	(20)	Yes	Subscription version telephone number
SUBSCRIPTION_TYPE	VARCHAR2	(10)	Yes	Indicates the portability type of Equal Access or Number Portability
MEDIATOR_SP_ID	NUMBER			Number registration center identifier
PROVISION_SENT_DATE	DATE			Date the network data is sent for provisioning
PROVISION_DONE_DATE	DATE			Date the network data is provisioined
CNAM_ADDRESS	VARCHAR2	(80)		Call naming network address for this subscription version
CNAM_SUBSYSTEM	VARCHAR2	(80)		Call naming application subsystem for this subscription version
ISVM_ADDRESS	VARCHAR2	(80)		Integrated Services Voice Mail network address for this subscription version
ISVM_SUBSYSTEM	VARCHAR2	(80)		Integrated Services Voice Mail application subsystem for this subscription version
LIDB_ADDRESS	VARCHAR2	(80)		Line Information Databases network address for this subscription version
LIDB_SUBSYSTEM	VARCHAR2	(80)		Line Information Databases application subsystem for this subscription version
CLASS_ADDRESS	VARCHAR2	(80)		Custom Local Area Signalling Services network address for this subscription version
CLASS_SUBSYSTEM	VARCHAR2	(80)		Custom Local Area Signalling Services application subsystem for this subscription version
WSMSC_ADDRESS	VARCHAR2	(80)		Wireless Short Message Service Centre network address for this subscription version
WSMSC_SUBSYSTEM	VARCHAR2	(80)		Wireless Short Message Service Centre application subsystem for this subscription version
RN_ADDRESS	VARCHAR2	(80)		Routing number network address for this subscription version
RN_SUBSYSTEM	VARCHAR2	(80)		Routing number application subsystem for this 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 SV_SMS_ID
,      OBJECT_REFERENCE
,      ROUTING_NUMBER_ID
,      SUBSCRIPTION_TN
,      SUBSCRIPTION_TYPE
,      MEDIATOR_SP_ID
,      PROVISION_SENT_DATE
,      PROVISION_DONE_DATE
,      CNAM_ADDRESS
,      CNAM_SUBSYSTEM
,      ISVM_ADDRESS
,      ISVM_SUBSYSTEM
,      LIDB_ADDRESS
,      LIDB_SUBSYSTEM
,      CLASS_ADDRESS
,      CLASS_SUBSYSTEM
,      WSMSC_ADDRESS
,      WSMSC_SUBSYSTEM
,      RN_ADDRESS
,      RN_SUBSYSTEM
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
FROM XNP.XNP_SV_SMS;

Dependencies

[top of page]

XNP.XNP_SV_SMS does not reference any database object

XNP.XNP_SV_SMS is referenced by following:

APPS: XNP_SV_SMS