Product: | XNP - Number Portability |
---|---|
Description: | Shows porting information broadcasted by the NRC for the intention of network update |
Implementation/DBA Data: | APPS.XNP_SV_SMS_V |
SELECT SVS.SV_SMS_ID
, SVS.OBJECT_REFERENCE PORTING_ID
, SVS.ROUTING_NUMBER_ID
, SVS.SUBSCRIPTION_TN
, SVS.SUBSCRIPTION_TYPE
, SVS.MEDIATOR_SP_ID
, SVS.PROVISION_SENT_DATE
, SVS.PROVISION_DONE_DATE
, SVS.CNAM_ADDRESS
, SVS.CNAM_SUBSYSTEM
, SVS.ISVM_ADDRESS
, SVS.ISVM_SUBSYSTEM
, SVS.LIDB_ADDRESS
, SVS.LIDB_SUBSYSTEM
, SVS.CLASS_ADDRESS
, SVS.CLASS_SUBSYSTEM
, SVS.WSMSC_ADDRESS
, SVS.WSMSC_SUBSYSTEM
, SVS.RN_ADDRESS
, SVS.RN_SUBSYSTEM
, SVS.CREATED_BY
, SVS.CREATION_DATE
, SVS.LAST_UPDATED_BY
, SVS.LAST_UPDATE_DATE
, SVS.LAST_UPDATE_LOGIN
, SPR_NRC.SP_TYPE NRC_SP_TYPE
, SPR_NRC.CODE NRC_CODE
, SPR_NRC.NAME NRC_NAME
, SPR_NRC.TIMEZONE NRC_TIMEZONE
, SPR_NRC.ADDRESS_LINE1 NRC_ADDRESS_LINE1
, SPR_NRC.CITY NRC_CITY
, SPR_NRC.STATE NRC_STATE
, SPR_NRC.ZIP_CODE NRC_ZIP_CODE
, SPR_NRC.COUNTRY NRC_COUNTRY
, SPR_NRC.PHONE NRC_PHONE
, SPR_NRC.ADDRESS_LINE2 NRC_ADDRESS_LINE2
, SPR_NRC.MOBILE NRC_MOBILE
, SPR_NRC.FAX NRC_FAX
, SPR_NRC.PAGER NRC_PAGER
, SPR_NRC.PAGER_PIN NRC_PAGER_PIN
, SPR_NRC.EMAIL NRC_EMAIL
, SPR_NRC.INTERNET_ADDRESS NRC_INTERNET
, SPR_NRC.DEPARTMENT NRC_DEPT
, RNR.OBJECT_REFERENCE ROUTING_REF
, RNR.INTERCONNECT_TYPE INTERCONNECT_TYPE
, RNR.SP_ID ROUTING_SP_ID
, RNR.ROUTING_NUMBER ROUTING_NUMBER
, RNR.STATUS ROUTING_STATUS
, SPR_REC.SP_ID REC_SP_ID
, SPR_REC.SP_TYPE REC_SP_TYPE
, SPR_REC.CODE REC_CODE
, SPR_REC.NAME REC_NAME
, SPR_REC.TIMEZONE REC_TIMEZONE
, SPR_REC.SERVED_BY_FLAG REC_SERVED_BY_FLAG
, SPR_REC.ADDRESS_LINE1 REC_ADDRESS_LINE1
, SPR_REC.CITY REC_CITY
, SPR_REC.STATE REC_STATE
, SPR_REC.ZIP_CODE REC_ZIP_CODE
, SPR_REC.COUNTRY REC_COUNTRY
, SPR_REC.PHONE REC_PHONE
, SPR_REC.ADDRESS_LINE2 REC_ADDRESS_LINE2
, SPR_REC.MOBILE REC_MOBILE
, SPR_REC.FAX REC_FAX
, SPR_REC.PAGER REC_PAGER
, SPR_REC.PAGER_PIN REC_PAGER_PIN
, SPR_REC.EMAIL REC_EMAIL
, SPR_REC.INTERNET_ADDRESS REC_INTERNET
, SPR_REC.DEPARTMENT REC_DEPT
FROM XNP_SV_SMS SVS
, XNP_SERVICE_PROVIDERS SPR_NRC
, XNP_ROUTING_NUMBERS RNR
, XNP_SERVICE_PROVIDERS SPR_REC
WHERE SVS.MEDIATOR_SP_ID = SPR_NRC.SP_ID (+)
AND SVS.ROUTING_NUMBER_ID = RNR.ROUTING_NUMBER_ID
AND RNR.SP_ID = SPR_REC.SP_ID