VIEW: ONT.OE_PROCESSING_MSGS#

Source

View Text - Preformatted

select TRANSACTION_ID TRANSACTION_ID, REQUEST_ID REQUEST_ID, ENTITY_CODE ENTITY_CODE, ENTITY_ID ENTITY_ID, HEADER_ID HEADER_ID, LINE_ID LINE_ID, ORIGINAL_SYS_DOCUMENT_REF ORIGINAL_SYS_DOCUMENT_REF, ORIGINAL_SYS_DOCUMENT_LINE_REF ORIGINAL_SYS_DOCUMENT_LINE_REF, SOURCE_DOCUMENT_ID SOURCE_DOCUMENT_ID, SOURCE_DOCUMENT_LINE_ID SOURCE_DOCUMENT_LINE_ID, ORDER_SOURCE_ID ORDER_SOURCE_ID, SOURCE_DOCUMENT_TYPE_ID SOURCE_DOCUMENT_TYPE_ID, ATTRIBUTE_CODE ATTRIBUTE_CODE, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, CONSTRAINT_ID CONSTRAINT_ID, PROCESS_ACTIVITY PROCESS_ACTIVITY, NOTIFICATION_FLAG NOTIFICATION_FLAG, ENTITY_REF ENTITY_REF, CHANGE_SEQUENCE CHANGE_SEQUENCE, ORIG_SYS_SHIPMENT_REF ORIG_SYS_SHIPMENT_REF, TYPE TYPE, MESSAGE_SOURCE_CODE MESSAGE_SOURCE_CODE, LANGUAGE LANGUAGE, MESSAGE_TEXT MESSAGE_TEXT, SOLD_TO_ORG_ID SOLD_TO_ORG_ID, MESSAGE_STATUS_CODE MESSAGE_STATUS_CODE, ORG_ID ORG_ID, INST_ID INST_ID from "ONT"."OE_PROCESSING_MSGS"

View Text - HTML Formatted

SELECT TRANSACTION_ID TRANSACTION_ID
, REQUEST_ID REQUEST_ID
, ENTITY_CODE ENTITY_CODE
, ENTITY_ID ENTITY_ID
, HEADER_ID HEADER_ID
, LINE_ID LINE_ID
, ORIGINAL_SYS_DOCUMENT_REF ORIGINAL_SYS_DOCUMENT_REF
, ORIGINAL_SYS_DOCUMENT_LINE_REF ORIGINAL_SYS_DOCUMENT_LINE_REF
, SOURCE_DOCUMENT_ID SOURCE_DOCUMENT_ID
, SOURCE_DOCUMENT_LINE_ID SOURCE_DOCUMENT_LINE_ID
, ORDER_SOURCE_ID ORDER_SOURCE_ID
, SOURCE_DOCUMENT_TYPE_ID SOURCE_DOCUMENT_TYPE_ID
, ATTRIBUTE_CODE ATTRIBUTE_CODE
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, CONSTRAINT_ID CONSTRAINT_ID
, PROCESS_ACTIVITY PROCESS_ACTIVITY
, NOTIFICATION_FLAG NOTIFICATION_FLAG
, ENTITY_REF ENTITY_REF
, CHANGE_SEQUENCE CHANGE_SEQUENCE
, ORIG_SYS_SHIPMENT_REF ORIG_SYS_SHIPMENT_REF
, TYPE TYPE
, MESSAGE_SOURCE_CODE MESSAGE_SOURCE_CODE
, LANGUAGE LANGUAGE
, MESSAGE_TEXT MESSAGE_TEXT
, SOLD_TO_ORG_ID SOLD_TO_ORG_ID
, MESSAGE_STATUS_CODE MESSAGE_STATUS_CODE
, ORG_ID ORG_ID
, INST_ID INST_ID
FROM "ONT"."OE_PROCESSING_MSGS"