[Home] [Help] [Dependency Information]
Object Name: | XNP_SV_SMS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | XNP.XNP_SV_SMS_V |
Subobject Name: | |
Status: | VALID |
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
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 |
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;
|
|
|