VIEW: APPS.ECX_OAG_CBOD_V

Source

View Text - Preformatted

SELECT msgid msgid, message_type message_type, transaction_type ext_type, transaction_subtype ext_subtype, document_number document_number, partyid party_code, party_site_id party_site_code, party_type party_type, protocol_type, protocol_address, attribute1 exchange_name, attribute2, attribute3 routing_party_code, attribute4, orig_reference_id orig_reference_id, field1 verb, field2 noun, field3 revision, field4 logicalid, field5 component, field6 task, field7 referenceid, field8 confirmation, field9 language, field10 codepage, field11 authid, field12 year, field13 month, field14 day, field15 hour, field16 minute, field17 second, field18 subsecond, field19 timezone, field20, field21, field22, field23, field24, field25, field26, field27, field28, field29, field30, logfile, internal_control_number document_id from ecx_doclogs

View Text - HTML Formatted

SELECT MSGID MSGID
, MESSAGE_TYPE MESSAGE_TYPE
, TRANSACTION_TYPE EXT_TYPE
, TRANSACTION_SUBTYPE EXT_SUBTYPE
, DOCUMENT_NUMBER DOCUMENT_NUMBER
, PARTYID PARTY_CODE
, PARTY_SITE_ID PARTY_SITE_CODE
, PARTY_TYPE PARTY_TYPE
, PROTOCOL_TYPE
, PROTOCOL_ADDRESS
, ATTRIBUTE1 EXCHANGE_NAME
, ATTRIBUTE2
, ATTRIBUTE3 ROUTING_PARTY_CODE
, ATTRIBUTE4
, ORIG_REFERENCE_ID ORIG_REFERENCE_ID
, FIELD1 VERB
, FIELD2 NOUN
, FIELD3 REVISION
, FIELD4 LOGICALID
, FIELD5 COMPONENT
, FIELD6 TASK
, FIELD7 REFERENCEID
, FIELD8 CONFIRMATION
, FIELD9 LANGUAGE
, FIELD10 CODEPAGE
, FIELD11 AUTHID
, FIELD12 YEAR
, FIELD13 MONTH
, FIELD14 DAY
, FIELD15 HOUR
, FIELD16 MINUTE
, FIELD17 SECOND
, FIELD18 SUBSECOND
, FIELD19 TIMEZONE
, FIELD20
, FIELD21
, FIELD22
, FIELD23
, FIELD24
, FIELD25
, FIELD26
, FIELD27
, FIELD28
, FIELD29
, FIELD30
, LOGFILE
, INTERNAL_CONTROL_NUMBER DOCUMENT_ID
FROM ECX_DOCLOGS