VIEW: XNP.XNP_SP_CONTACTS#

Source

View Text - Preformatted

select SP_CONTACT_ID SP_CONTACT_ID, SP_ID SP_ID, BUSINESS_ROLE BUSINESS_ROLE, NAME NAME, 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, 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_SP_CONTACTS"

View Text - HTML Formatted

SELECT SP_CONTACT_ID SP_CONTACT_ID
, SP_ID SP_ID
, BUSINESS_ROLE BUSINESS_ROLE
, NAME NAME
, 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
, 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_SP_CONTACTS"