VIEW: APPS.XNP_SV_SMS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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