DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.ECX_OAG_CBOD_V

Object Details
Object Name: ECX_OAG_CBOD_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewECX.ECX_OAG_CBOD_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


View for OAG confirmation BOD


[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.ECX_OAG_CBOD_V references the following:

SchemaAPPS
SynonymECX_DOCLOGS
APPS.ECX_OAG_CBOD_V is referenced by following:

SchemaAPPS
Package BodyOE_ORDER_IMPORT_WF - show dependent code