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]

VIEW: APPS.XNP_SV_SMS_V

Object Details

Object Name:	XNP_SV_SMS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	XNP.XNP_SV_SMS_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

XNP_SV_SMS_V shows porting information broadcasted by the NRC for the intention of network update

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SV_SMS_ID	NUMBER		Yes	Subscription version identifier for SMS
PORTING_ID	VARCHAR2	(80)	Yes	Porting identifier
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 network data is sent for provisioning
PROVISION_DONE_DATE	DATE			Date network data is provisioned
CNAM_ADDRESS	VARCHAR2	(80)		Caller naming network address for this subscription version
CNAM_SUBSYSTEM	VARCHAR2	(80)		Caller 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
NRC_SP_TYPE	VARCHAR2	(20)		Type of the service provider acting as NRC
NRC_CODE	VARCHAR2	(20)		Public code of NRC
NRC_NAME	VARCHAR2	(80)		Name of NRC
NRC_TIMEZONE	VARCHAR2	(10)		Timezone where the NRC operates
NRC_ADDRESS_LINE1	VARCHAR2	(40)		Street address of the NRC
NRC_CITY	VARCHAR2	(40)		City of the NRC
NRC_STATE	VARCHAR2	(40)		State of NRC
NRC_ZIP_CODE	VARCHAR2	(20)		Zip code of the NRC
NRC_COUNTRY	VARCHAR2	(40)		Country where the NRC operates
NRC_PHONE	VARCHAR2	(20)		Phone of the NRC
NRC_ADDRESS_LINE2	VARCHAR2	(40)		Street address of the NRC
NRC_MOBILE	VARCHAR2	(20)		Mobile number of NRC
NRC_FAX	VARCHAR2	(20)		Fax number of NRC
NRC_PAGER	VARCHAR2	(20)		Pager number of NRC
NRC_PAGER_PIN	VARCHAR2	(80)		Pager Pin number of NRC
NRC_EMAIL	VARCHAR2	(80)		Email id of NRC
NRC_INTERNET	VARCHAR2	(40)		Web address of NRC
NRC_DEPT	VARCHAR2	(80)		Department of NRC
ROUTING_REF	VARCHAR2	(80)	Yes	External reference id for the routing number
INTERCONNECT_TYPE	VARCHAR2	(10)	Yes	Indicates whether Equal Access or Number Portability
ROUTING_SP_ID	NUMBER		Yes	Service Provider involved in routing
ROUTING_NUMBER	VARCHAR2	(20)	Yes	Routing number
ROUTING_STATUS	VARCHAR2	(10)		Status of the routing number
REC_SP_ID	NUMBER		Yes	Recipient service provider identifier
REC_SP_TYPE	VARCHAR2	(20)	Yes	Receipient service provider type
REC_CODE	VARCHAR2	(20)	Yes	Public code of the recipient service provider
REC_NAME	VARCHAR2	(80)	Yes	Name of the receipient service provider
REC_TIMEZONE	VARCHAR2	(10)	Yes	Timezone where the receipient service provider operates
REC_SERVED_BY_FLAG	VARCHAR2	(1)	Yes	Flag to indicate if the recipient service provider is served by the bureau.
REC_ADDRESS_LINE1	VARCHAR2	(40)	Yes	Street address of recipient service provider
REC_CITY	VARCHAR2	(40)	Yes	City of recipient service provider
REC_STATE	VARCHAR2	(40)		State of recipient service provider
REC_ZIP_CODE	VARCHAR2	(20)	Yes	Zip Code for recipient service provider
REC_COUNTRY	VARCHAR2	(40)	Yes	Country of recipient service provider
REC_PHONE	VARCHAR2	(20)	Yes	Phone num of recipient service provider
REC_ADDRESS_LINE2	VARCHAR2	(40)		Street address of recipient service provider
REC_MOBILE	VARCHAR2	(20)		Mobile number of recipient service provider
REC_FAX	VARCHAR2	(20)		Fax number of recipient service provider
REC_PAGER	VARCHAR2	(20)		Pager number of recipient service provider
REC_PAGER_PIN	VARCHAR2	(80)		Pager Pin number of recipient service provider
REC_EMAIL	VARCHAR2	(80)		Email id of recipient service provider
REC_INTERNET	VARCHAR2	(40)		Web address of recipient service provider
REC_DEPT	VARCHAR2	(80)		Department of recipient service provider

Query Text

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


SELECT SV_SMS_ID
,      PORTING_ID
,      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
,      NRC_SP_TYPE
,      NRC_CODE
,      NRC_NAME
,      NRC_TIMEZONE
,      NRC_ADDRESS_LINE1
,      NRC_CITY
,      NRC_STATE
,      NRC_ZIP_CODE
,      NRC_COUNTRY
,      NRC_PHONE
,      NRC_ADDRESS_LINE2
,      NRC_MOBILE
,      NRC_FAX
,      NRC_PAGER
,      NRC_PAGER_PIN
,      NRC_EMAIL
,      NRC_INTERNET
,      NRC_DEPT
,      ROUTING_REF
,      INTERCONNECT_TYPE
,      ROUTING_SP_ID
,      ROUTING_NUMBER
,      ROUTING_STATUS
,      REC_SP_ID
,      REC_SP_TYPE
,      REC_CODE
,      REC_NAME
,      REC_TIMEZONE
,      REC_SERVED_BY_FLAG
,      REC_ADDRESS_LINE1
,      REC_CITY
,      REC_STATE
,      REC_ZIP_CODE
,      REC_COUNTRY
,      REC_PHONE
,      REC_ADDRESS_LINE2
,      REC_MOBILE
,      REC_FAX
,      REC_PAGER
,      REC_PAGER_PIN
,      REC_EMAIL
,      REC_INTERNET
,      REC_DEPT
FROM APPS.XNP_SV_SMS_V;

Dependencies

[top of page]

APPS.XNP_SV_SMS_V references the following:

APPS: XNP_ROUTING_NUMBERS; XNP_SERVICE_PROVIDERS; XNP_SV_SMS

APPS.XNP_SV_SMS_V is referenced by following:

APPS: XNP_SV_NETWORK$SMS_SV - show dependent code