VIEW: XNP.XNP_SERVICE_PROVIDERS#

Source

View Text - Preformatted

select SP_ID SP_ID, SP_TYPE SP_TYPE, CODE CODE, NAME NAME, TIMEZONE TIMEZONE, SERVED_BY_FLAG SERVED_BY_FLAG, ACTIVE_FLAG ACTIVE_FLAG, ADDRESS_LINE1 ADDRESS_LINE1, CITY CITY, STATE STATE, ZIP_CODE ZIP_CODE, COUNTRY COUNTRY, PHONE PHONE, ADDRESS_LINE2 ADDRESS_LINE2, MOBILE MOBILE, FAX FAX, PAGER PAGER, PAGER_PIN PAGER_PIN, EMAIL EMAIL, INTERNET_ADDRESS INTERNET_ADDRESS, DEPARTMENT DEPARTMENT, SOA_MGT_FLAG SOA_MGT_FLAG, SOA_NETWORK_MGT_FLAG SOA_NETWORK_MGT_FLAG, SMS_DOWNLOAD_FLAG SMS_DOWNLOAD_FLAG, SMS_NETWORK_MGT_FLAG SMS_NETWORK_MGT_FLAG, SMS_QUERY_FLAG SMS_QUERY_FLAG, SV_DOWNLOAD_FLAG SV_DOWNLOAD_FLAG, NETWORK_DOWNLOAD_FLAG NETWORK_DOWNLOAD_FLAG, 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, ZD_EDITION_NAME ZD_EDITION_NAME from "XNP"."XNP_SERVICE_PROVIDERS"

View Text - HTML Formatted

SELECT SP_ID SP_ID
, SP_TYPE SP_TYPE
, CODE CODE
, NAME NAME
, TIMEZONE TIMEZONE
, SERVED_BY_FLAG SERVED_BY_FLAG
, ACTIVE_FLAG ACTIVE_FLAG
, ADDRESS_LINE1 ADDRESS_LINE1
, CITY CITY
, STATE STATE
, ZIP_CODE ZIP_CODE
, COUNTRY COUNTRY
, PHONE PHONE
, ADDRESS_LINE2 ADDRESS_LINE2
, MOBILE MOBILE
, FAX FAX
, PAGER PAGER
, PAGER_PIN PAGER_PIN
, EMAIL EMAIL
, INTERNET_ADDRESS INTERNET_ADDRESS
, DEPARTMENT DEPARTMENT
, SOA_MGT_FLAG SOA_MGT_FLAG
, SOA_NETWORK_MGT_FLAG SOA_NETWORK_MGT_FLAG
, SMS_DOWNLOAD_FLAG SMS_DOWNLOAD_FLAG
, SMS_NETWORK_MGT_FLAG SMS_NETWORK_MGT_FLAG
, SMS_QUERY_FLAG SMS_QUERY_FLAG
, SV_DOWNLOAD_FLAG SV_DOWNLOAD_FLAG
, NETWORK_DOWNLOAD_FLAG NETWORK_DOWNLOAD_FLAG
, 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
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "XNP"."XNP_SERVICE_PROVIDERS"