VIEW: MSC.MSC_ST_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, DELETED_FLAG DELETED_FLAG, REFRESH_ID REFRESH_ID, 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, COMPANY_ID COMPANY_ID, COMPANY_NAME COMPANY_NAME, SR_INSTANCE_CODE SR_INSTANCE_CODE, TP_SITE_CODE TP_SITE_CODE, PARTNER_NAME PARTNER_NAME, MESSAGE_ID MESSAGE_ID, PROCESS_FLAG PROCESS_FLAG, DATA_SOURCE_TYPE DATA_SOURCE_TYPE, ST_TRANSACTION_ID ST_TRANSACTION_ID, BATCH_ID BATCH_ID, ERROR_TEXT ERROR_TEXT from "MSC"."MSC_ST_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
, DELETED_FLAG DELETED_FLAG
, REFRESH_ID REFRESH_ID
, 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
, COMPANY_ID COMPANY_ID
, COMPANY_NAME COMPANY_NAME
, SR_INSTANCE_CODE SR_INSTANCE_CODE
, TP_SITE_CODE TP_SITE_CODE
, PARTNER_NAME PARTNER_NAME
, MESSAGE_ID MESSAGE_ID
, PROCESS_FLAG PROCESS_FLAG
, DATA_SOURCE_TYPE DATA_SOURCE_TYPE
, ST_TRANSACTION_ID ST_TRANSACTION_ID
, BATCH_ID BATCH_ID
, ERROR_TEXT ERROR_TEXT
FROM "MSC"."MSC_ST_PARTNER_CONTACTS"