[Home] [Help] [Dependency Information]
Object Name: | ECX_OAG_CBOD_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ECX.ECX_OAG_CBOD_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
View for OAG confirmation BOD
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MSGID | RAW | (16) | Yes | Message Identifier |
MESSAGE_TYPE | VARCHAR2 | (100) | Payload type | |
EXT_TYPE | VARCHAR2 | (100) | External Transaction Type | |
EXT_SUBTYPE | VARCHAR2 | (100) | External Transaction subtype | |
DOCUMENT_NUMBER | VARCHAR2 | (256) | Document Number | |
PARTY_CODE | VARCHAR2 | (256) | Party Name | |
PARTY_SITE_CODE | VARCHAR2 | (256) | Party Site Name | |
PARTY_TYPE | VARCHAR2 | (30) | Party Type | |
PROTOCOL_TYPE | VARCHAR2 | (500) | Protocol Type | |
PROTOCOL_ADDRESS | VARCHAR2 | (2000) | Protocol Address | |
EXCHANGE_NAME | VARCHAR2 | (500) | Exchange Name | |
ATTRIBUTE2 | VARCHAR2 | (500) | Descriptive flexfield segment | |
ROUTING_PARTY_CODE | VARCHAR2 | (500) | Routing Party Identifier | |
ATTRIBUTE4 | VARCHAR2 | (500) | Descriptive flexfield segment | |
ORIG_REFERENCE_ID | VARCHAR2 | (240) | Original Document's ID | |
VERB | VARCHAR2 | (2000) | Verb | |
NOUN | VARCHAR2 | (2000) | Noun | |
REVISION | VARCHAR2 | (2000) | Revision | |
LOGICALID | VARCHAR2 | (2000) | Logical Identifier | |
COMPONENT | VARCHAR2 | (2000) | Component | |
TASK | VARCHAR2 | (2000) | Task | |
REFERENCEID | VARCHAR2 | (2000) | Reference Identifier | |
CONFIRMATION | VARCHAR2 | (2000) | Confirmation Code | |
LANGUAGE | VARCHAR2 | (2000) | Language | |
CODEPAGE | VARCHAR2 | (2000) | Code Page | |
AUTHID | VARCHAR2 | (2000) | Authorization Identifier | |
YEAR | VARCHAR2 | (2000) | Datetime - Year Qualifier | |
MONTH | VARCHAR2 | (2000) | Datetime - Month Qualifier | |
DAY | VARCHAR2 | (2000) | Datetime - Day Qualifier | |
HOUR | VARCHAR2 | (2000) | Datetime - Hour Qualifier | |
MINUTE | VARCHAR2 | (2000) | Datetime - Minute Qualifier | |
SECOND | VARCHAR2 | (2000) | Datetime -Second Qualifier | |
SUBSECOND | VARCHAR2 | (2000) | Datetime -Subsecond Qualifier | |
TIMEZONE | VARCHAR2 | (2000) | Time Zone | |
FIELD20 | VARCHAR2 | (2000) | Reserved Field | |
FIELD21 | VARCHAR2 | (2000) | Reserved Field | |
FIELD22 | VARCHAR2 | (2000) | Reserved Field | |
FIELD23 | VARCHAR2 | (2000) | Reserved Field | |
FIELD24 | VARCHAR2 | (2000) | Reserved Field | |
FIELD25 | VARCHAR2 | (2000) | Reserved Field | |
FIELD26 | VARCHAR2 | (2000) | Reserved Field | |
FIELD27 | VARCHAR2 | (2000) | Reserved Field | |
FIELD28 | VARCHAR2 | (2000) | Reserved Field | |
FIELD29 | VARCHAR2 | (2000) | Reserved Field | |
FIELD30 | VARCHAR2 | (2000) | Reserved Field | |
LOGFILE | VARCHAR2 | (80) | Transaction Logfile | |
DOCUMENT_ID | NUMBER | Document Identifier |
Cut, paste (and edit) the following text to query this object:
SELECT MSGID
, MESSAGE_TYPE
, EXT_TYPE
, EXT_SUBTYPE
, DOCUMENT_NUMBER
, PARTY_CODE
, PARTY_SITE_CODE
, PARTY_TYPE
, PROTOCOL_TYPE
, PROTOCOL_ADDRESS
, EXCHANGE_NAME
, ATTRIBUTE2
, ROUTING_PARTY_CODE
, ATTRIBUTE4
, ORIG_REFERENCE_ID
, VERB
, NOUN
, REVISION
, LOGICALID
, COMPONENT
, TASK
, REFERENCEID
, CONFIRMATION
, LANGUAGE
, CODEPAGE
, AUTHID
, YEAR
, MONTH
, DAY
, HOUR
, MINUTE
, SECOND
, SUBSECOND
, TIMEZONE
, FIELD20
, FIELD21
, FIELD22
, FIELD23
, FIELD24
, FIELD25
, FIELD26
, FIELD27
, FIELD28
, FIELD29
, FIELD30
, LOGFILE
, DOCUMENT_ID
FROM APPS.ECX_OAG_CBOD_V;
|
|
|