VIEW: XNP.XNP_SV_SMS#

Source

View Text - Preformatted

select SV_SMS_ID SV_SMS_ID, OBJECT_REFERENCE OBJECT_REFERENCE, ROUTING_NUMBER_ID ROUTING_NUMBER_ID, SUBSCRIPTION_TN SUBSCRIPTION_TN, SUBSCRIPTION_TYPE SUBSCRIPTION_TYPE, MEDIATOR_SP_ID MEDIATOR_SP_ID, PROVISION_SENT_DATE PROVISION_SENT_DATE, PROVISION_DONE_DATE PROVISION_DONE_DATE, CNAM_ADDRESS CNAM_ADDRESS, CNAM_SUBSYSTEM CNAM_SUBSYSTEM, ISVM_ADDRESS ISVM_ADDRESS, ISVM_SUBSYSTEM ISVM_SUBSYSTEM, LIDB_ADDRESS LIDB_ADDRESS, LIDB_SUBSYSTEM LIDB_SUBSYSTEM, CLASS_ADDRESS CLASS_ADDRESS, CLASS_SUBSYSTEM CLASS_SUBSYSTEM, WSMSC_ADDRESS WSMSC_ADDRESS, WSMSC_SUBSYSTEM WSMSC_SUBSYSTEM, RN_ADDRESS RN_ADDRESS, RN_SUBSYSTEM RN_SUBSYSTEM, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, SECURITY_GROUP_ID SECURITY_GROUP_ID from "XNP"."XNP_SV_SMS"

View Text - HTML Formatted

SELECT SV_SMS_ID SV_SMS_ID
, OBJECT_REFERENCE OBJECT_REFERENCE
, ROUTING_NUMBER_ID ROUTING_NUMBER_ID
, SUBSCRIPTION_TN SUBSCRIPTION_TN
, SUBSCRIPTION_TYPE SUBSCRIPTION_TYPE
, MEDIATOR_SP_ID MEDIATOR_SP_ID
, PROVISION_SENT_DATE PROVISION_SENT_DATE
, PROVISION_DONE_DATE PROVISION_DONE_DATE
, CNAM_ADDRESS CNAM_ADDRESS
, CNAM_SUBSYSTEM CNAM_SUBSYSTEM
, ISVM_ADDRESS ISVM_ADDRESS
, ISVM_SUBSYSTEM ISVM_SUBSYSTEM
, LIDB_ADDRESS LIDB_ADDRESS
, LIDB_SUBSYSTEM LIDB_SUBSYSTEM
, CLASS_ADDRESS CLASS_ADDRESS
, CLASS_SUBSYSTEM CLASS_SUBSYSTEM
, WSMSC_ADDRESS WSMSC_ADDRESS
, WSMSC_SUBSYSTEM WSMSC_SUBSYSTEM
, RN_ADDRESS RN_ADDRESS
, RN_SUBSYSTEM RN_SUBSYSTEM
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID SECURITY_GROUP_ID
FROM "XNP"."XNP_SV_SMS"