VIEW: IEM.IEM_MIGRATION_STORE_TEMP#

Source

View Text - Preformatted

select MAIL_ID MAIL_ID, MESSAGE_ID MESSAGE_ID, MIGRATION_ID MIGRATION_ID, MESSAGE_TYPE MESSAGE_TYPE, EMAIL_ACCOUNT_ID EMAIL_ACCOUNT_ID, AGENT_ACCOUNT_ID AGENT_ACCOUNT_ID, RESOURCE_ID RESOURCE_ID, FOLDER_NAME FOLDER_NAME, RT_MEDIA_ITEM_ID RT_MEDIA_ITEM_ID, MSG_UID MSG_UID, RFC822_MESSAGE_ID RFC822_MESSAGE_ID, FROM_STR FROM_STR, TO_STR TO_STR, REPLY_TO_STR REPLY_TO_STR, CC_STR CC_STR, BCC_STR BCC_STR, SENT_DATE SENT_DATE, SUBJECT SUBJECT, IH_MEDIA_ITEM_ID IH_MEDIA_ITEM_ID, MESSAGE_SIZE MESSAGE_SIZE, DP_STATUS DP_STATUS, MIG_STATUS MIG_STATUS, ERROR_TEXT ERROR_TEXT, MESSAGE_TEXT MESSAGE_TEXT, MESSAGE_CONTENT MESSAGE_CONTENT, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "IEM"."IEM_MIGRATION_STORE_TEMP"

View Text - HTML Formatted

SELECT MAIL_ID MAIL_ID
, MESSAGE_ID MESSAGE_ID
, MIGRATION_ID MIGRATION_ID
, MESSAGE_TYPE MESSAGE_TYPE
, EMAIL_ACCOUNT_ID EMAIL_ACCOUNT_ID
, AGENT_ACCOUNT_ID AGENT_ACCOUNT_ID
, RESOURCE_ID RESOURCE_ID
, FOLDER_NAME FOLDER_NAME
, RT_MEDIA_ITEM_ID RT_MEDIA_ITEM_ID
, MSG_UID MSG_UID
, RFC822_MESSAGE_ID RFC822_MESSAGE_ID
, FROM_STR FROM_STR
, TO_STR TO_STR
, REPLY_TO_STR REPLY_TO_STR
, CC_STR CC_STR
, BCC_STR BCC_STR
, SENT_DATE SENT_DATE
, SUBJECT SUBJECT
, IH_MEDIA_ITEM_ID IH_MEDIA_ITEM_ID
, MESSAGE_SIZE MESSAGE_SIZE
, DP_STATUS DP_STATUS
, MIG_STATUS MIG_STATUS
, ERROR_TEXT ERROR_TEXT
, MESSAGE_TEXT MESSAGE_TEXT
, MESSAGE_CONTENT MESSAGE_CONTENT
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "IEM"."IEM_MIGRATION_STORE_TEMP"