VIEW: XNP.XNP_MSGS#

Source

View Text - Preformatted

select MSG_ID MSG_ID, BODY_TEXT BODY_TEXT, MSG_CODE MSG_CODE, MSG_CREATION_DATE MSG_CREATION_DATE, DIRECTION_INDICATOR DIRECTION_INDICATOR, REFERENCE_ID REFERENCE_ID, OPP_REFERENCE_ID OPP_REFERENCE_ID, MSG_VERSION MSG_VERSION, SENDER_NAME SENDER_NAME, RECIPIENT_NAME RECIPIENT_NAME, SEND_RCV_DATE SEND_RCV_DATE, MSG_STATUS MSG_STATUS, DESCRIPTION DESCRIPTION, RETRIES RETRIES, ORDER_ID ORDER_ID, WI_INSTANCE_ID WI_INSTANCE_ID, FA_INSTANCE_ID FA_INSTANCE_ID, FE_NAME FE_NAME, ADAPTER_NAME ADAPTER_NAME, UPDATED_BY_USER UPDATED_BY_USER, 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 from "XNP"."XNP_MSGS"

View Text - HTML Formatted

SELECT MSG_ID MSG_ID
, BODY_TEXT BODY_TEXT
, MSG_CODE MSG_CODE
, MSG_CREATION_DATE MSG_CREATION_DATE
, DIRECTION_INDICATOR DIRECTION_INDICATOR
, REFERENCE_ID REFERENCE_ID
, OPP_REFERENCE_ID OPP_REFERENCE_ID
, MSG_VERSION MSG_VERSION
, SENDER_NAME SENDER_NAME
, RECIPIENT_NAME RECIPIENT_NAME
, SEND_RCV_DATE SEND_RCV_DATE
, MSG_STATUS MSG_STATUS
, DESCRIPTION DESCRIPTION
, RETRIES RETRIES
, ORDER_ID ORDER_ID
, WI_INSTANCE_ID WI_INSTANCE_ID
, FA_INSTANCE_ID FA_INSTANCE_ID
, FE_NAME FE_NAME
, ADAPTER_NAME ADAPTER_NAME
, UPDATED_BY_USER UPDATED_BY_USER
, 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
FROM "XNP"."XNP_MSGS"