VIEW: MSC.MSC_PARTNER_CONTACTS#

Source

View Text - Preformatted

select NAME NAME, DISPLAY_NAME DISPLAY_NAME, PARTNER_ID PARTNER_ID, PARTNER_SITE_ID PARTNER_SITE_ID, PARTNER_TYPE PARTNER_TYPE, EMAIL EMAIL, FAX FAX, ENABLED_FLAG ENABLED_FLAG, REFRESH_NUMBER REFRESH_NUMBER, SR_INSTANCE_ID SR_INSTANCE_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE from "MSC"."MSC_PARTNER_CONTACTS"

View Text - HTML Formatted

SELECT NAME NAME
, DISPLAY_NAME DISPLAY_NAME
, PARTNER_ID PARTNER_ID
, PARTNER_SITE_ID PARTNER_SITE_ID
, PARTNER_TYPE PARTNER_TYPE
, EMAIL EMAIL
, FAX FAX
, ENABLED_FLAG ENABLED_FLAG
, REFRESH_NUMBER REFRESH_NUMBER
, SR_INSTANCE_ID SR_INSTANCE_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
FROM "MSC"."MSC_PARTNER_CONTACTS"