VIEW: ONT.OE_EM_INFORMATION_ALL#

Source

View Text - Preformatted

select ORDER_SOURCE_ID ORDER_SOURCE_ID, ORIG_SYS_DOCUMENT_REF ORIG_SYS_DOCUMENT_REF, SOLD_TO_ORG_ID SOLD_TO_ORG_ID, EM_TRANSACTION_TYPE_CODE EM_TRANSACTION_TYPE_CODE, DOCUMENT_ID DOCUMENT_ID, PARENT_DOCUMENT_ID PARENT_DOCUMENT_ID, ORDER_NUMBER ORDER_NUMBER, ORDER_TYPE_ID ORDER_TYPE_ID, CHANGE_SEQUENCE CHANGE_SEQUENCE, ORG_ID ORG_ID, HEADER_ID HEADER_ID, EM_CONC_REQUEST_ID EM_CONC_REQUEST_ID, DOCUMENT_STATUS DOCUMENT_STATUS, DOCUMENT_DISPOSITION DOCUMENT_DISPOSITION, MESSAGE_TEXT MESSAGE_TEXT, ITEM_TYPE ITEM_TYPE, ITEM_KEY ITEM_KEY, 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, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REQUEST_ID REQUEST_ID, LAST_UPDATE_ITEMKEY LAST_UPDATE_ITEMKEY from "ONT"."OE_EM_INFORMATION_ALL"

View Text - HTML Formatted

SELECT ORDER_SOURCE_ID ORDER_SOURCE_ID
, ORIG_SYS_DOCUMENT_REF ORIG_SYS_DOCUMENT_REF
, SOLD_TO_ORG_ID SOLD_TO_ORG_ID
, EM_TRANSACTION_TYPE_CODE EM_TRANSACTION_TYPE_CODE
, DOCUMENT_ID DOCUMENT_ID
, PARENT_DOCUMENT_ID PARENT_DOCUMENT_ID
, ORDER_NUMBER ORDER_NUMBER
, ORDER_TYPE_ID ORDER_TYPE_ID
, CHANGE_SEQUENCE CHANGE_SEQUENCE
, ORG_ID ORG_ID
, HEADER_ID HEADER_ID
, EM_CONC_REQUEST_ID EM_CONC_REQUEST_ID
, DOCUMENT_STATUS DOCUMENT_STATUS
, DOCUMENT_DISPOSITION DOCUMENT_DISPOSITION
, MESSAGE_TEXT MESSAGE_TEXT
, ITEM_TYPE ITEM_TYPE
, ITEM_KEY ITEM_KEY
, 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
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REQUEST_ID REQUEST_ID
, LAST_UPDATE_ITEMKEY LAST_UPDATE_ITEMKEY
FROM "ONT"."OE_EM_INFORMATION_ALL"