Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - ECX Tables and Views

TABLE - ECX.ECX_ATTACHMENT_MAPS
TABLE - ECX.ECX_ATTRIBUTE_MAPPINGS
TABLE - ECX.ECX_DOCLOGS
TABLE - ECX.ECX_DTDS
TABLE - ECX.ECX_ERROR_MSGS
TABLE - ECX.ECX_EXTERNAL_LOGS
TABLE - ECX.ECX_EXTERNAL_RETRY
TABLE - ECX.ECX_EXT_PROCESSES
TABLE - ECX.ECX_FILES
TABLE - ECX.ECX_HUBS
TABLE - ECX.ECX_HUB_USERS
TABLE - ECX.ECX_INBOUND_LOGS
TABLE - ECX.ECX_LEVEL_MAPPINGS
TABLE - ECX.ECX_MAPPINGS
TABLE - ECX.ECX_MSG_LOGS
TABLE - ECX.ECX_OBJECTS
TABLE - ECX.ECX_OBJECT_ATTRIBUTES
TABLE - ECX.ECX_OBJECT_LEVELS
TABLE - ECX.ECX_OUTBOUND_LOGS
TABLE - ECX.ECX_OXTA_LOGMSG
TABLE - ECX.ECX_PROC_MAPPINGS
TABLE - ECX.ECX_STANDARDS_B
TABLE - ECX.ECX_STANDARDS_TL
TABLE - ECX.ECX_STANDARD_ATTRIBUTES
TABLE - ECX.ECX_TP_DETAILS
TABLE - ECX.ECX_TP_HEADERS
TABLE - ECX.ECX_TRANSACTIONS_B
TABLE - ECX.ECX_TRANSACTIONS_TL
TABLE - ECX.ECX_TRAN_STAGE_DATA
TABLE - ECX.ECX_XREF_DTL_B
TABLE - ECX.ECX_XREF_DTL_TL
TABLE - ECX.ECX_XREF_HDR_B
TABLE - ECX.ECX_XREF_HDR_TL
TABLE - ECX.ECX_XREF_STANDARDS_B
TABLE - ECX.ECX_XREF_STANDARDS_TL
VIEW - APPS.ECX_DUMMY1_V
VIEW - APPS.ECX_DUMMY2_V
VIEW - APPS.ECX_HEADER_V
VIEW - APPS.ECX_IN_PROCESS_VL
VIEW - APPS.ECX_LOOKUP_VALUES
VIEW - APPS.ECX_MSGNAME_V
VIEW - APPS.ECX_OAG_CBOD_V
VIEW - APPS.ECX_OAG_CONTROLAREA_TP_V
VIEW - APPS.ECX_OAG_CONTROLAREA_V
VIEW - APPS.ECX_OUT_PROCESS_VL
VIEW - APPS.ECX_PARTIES_V
VIEW - APPS.ECX_PARTY_SITES_V
VIEW - APPS.ECX_STANDARDS_VL
VIEW - APPS.ECX_TP_DETAILS_V
VIEW - APPS.ECX_TP_HEADERS_V
VIEW - APPS.ECX_TRANSACTIONS_VL
VIEW - APPS.ECX_XREF_DTL_VL
VIEW - APPS.ECX_XREF_HDR_MAPPED_V
VIEW - APPS.ECX_XREF_HDR_VL
VIEW - APPS.ECX_XREF_STANDARDS_VL

Table: ECX_ATTACHMENT_MAPS

Description: The table records correlation mappings between main business documents and their assciated attachments. It is used by the OTA and XML-Gateway engine.
Primary Key: ECX_ATTACHMENT_MAPS_PK
  1. MSGID
  2. CID
Comments

The table records correlation mappings between main business documents and their assciated attachments. It is used by the OTA and XML-Gateway engine.

Indexes
Index Type Tablespace Column
ECX_ATTACHMENT_MAPS_U1 UNIQUE APPS_TS_TX_IDX MSGID
CID
Columns
Name Datatype Length Mandatory Comments
MSGID RAW (16) Y This is the message id
CID VARCHAR2 (256) Y Content Id through whic user uniquely identifies the attachment
FID NUMBER
Y File Id of attachment
DATATYPE NUMBER
Y This type of attachment files
ORDERINDEX NUMBER

This is the order index of attachments
NESTPARENTINDEX NUMBER

This is nest parent index

[top of page]

ECX.ECX_ATTACHMENT_MAPS does not reference any database object

ECX.ECX_ATTACHMENT_MAPS is referenced by following:

ECX
VIEW - ECX_ATTACHMENT_MAPS#

[top of page]

Table: ECX_ATTRIBUTE_MAPPINGS

Description: This table contains the mapping information between the source and target attributes
Primary Key: ECX_ATTRIBUTE_MAPPINGS_PK
  1. MAP_ID
  2. ATTRIBUTE_MAP_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ECX_ATTRIBUTE_MAPPINGS.MAP_ID ECX_MAPPINGS
Comments

This table contains the mapping information between the source and target attributes

Indexes
Index Type Tablespace Column
ECX_ATTRIBUTE_MAPPINGS_U1 UNIQUE APPS_TS_SEED MAP_ID
ATTRIBUTE_MAP_ID
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
ATTRIBUTE_MAP_ID NUMBER
Y Attribute Mapping Identifier
LEVEL_MAPPING_ID NUMBER
Y Level Mapping Identifier
SOURCE_ATTRIBUTE_ID NUMBER
Y Source Attribute Identifier
TARGET_ATTRIBUTE_ID NUMBER
Y Target Attribute Identifier
MAP_ID NUMBER
Y Map Identifier
OCCURRENCE NUMBER

No longer used
COND_VALUE VARCHAR2 (10)
No longer used
COND_NODE VARCHAR2 (25)
No longer used
PARENT_ATTRIBUTE_MAP_ID NUMBER

No longer used
COND_NODE_TYPE VARCHAR2 (10)
No longer used
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

ECX.ECX_ATTRIBUTE_MAPPINGS does not reference any database object

ECX.ECX_ATTRIBUTE_MAPPINGS is referenced by following:

ECX
VIEW - ECX_ATTRIBUTE_MAPPINGS#

[top of page]

Table: ECX_DOCLOGS

Description: This table contains the document logs for Inbound, outbound and passthrough messages
Primary Key: ECX_DOCLOGS_PK
  1. MSGID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ECX_DOCLOGS.PARTYID HZ_PARTIES
ECX_DOCLOGS.PARTYID PO_VENDORS
Foreign Keys to this table:
Foreign Key Column Foreign Table
AR_DOCUMENT_TRANSFERS.CONFIRMATION_MSGID ECX_DOCLOGS
AR_DOCUMENT_TRANSFERS.DOCUMENT_MSGID ECX_DOCLOGS
ECX_EXTERNAL_LOGS.OUT_MSGID ECX_DOCLOGS
Comments

This table contains the document logs for Inbound, outbound and passthrough messages

Indexes
Index Type Tablespace Column
ECX_DOCLOGS_U1 UNIQUE APPS_TS_TX_IDX MSGID
SYS_IL0000165327C00019$$ UNIQUE APPS_TS_TX_DATA
ECX_DOCLOGS_N1 NONUNIQUE APPS_TS_TX_IDX INTERNAL_CONTROL_NUMBER
ECX_DOCLOGS_N2 NONUNIQUE APPS_TS_TX_IDX ITEM_TYPE
ITEM_KEY
ECX_DOCLOGS_N3 NONUNIQUE APPS_TS_TX_IDX TIME_STAMP
ECX_DOCLOGS_N4 NONUNIQUE APPS_TS_TX_IDX DOCUMENT_NUMBER
Columns
Name Datatype Length Mandatory Comments
MSGID RAW (16) Y Message Iedntifier in a Queue
MESSAGE_TYPE VARCHAR2 (100)
Payload Type
MESSAGE_STANDARD VARCHAR2 (100)
Payload Standard
TRANSACTION_TYPE VARCHAR2 (100)
External Transaction Type Code
TRANSACTION_SUBTYPE VARCHAR2 (100)
External Transaction Subtype Code
DOCUMENT_NUMBER VARCHAR2 (256)
Document Identifier
PARTYID VARCHAR2 (256)
No longer used
PARTY_SITE_ID VARCHAR2 (256)
Source Trading Partner Party Site Identifier
PARTY_TYPE VARCHAR2 (30)
No longer used
PROTOCOL_TYPE VARCHAR2 (500)
Protocol Type
PROTOCOL_ADDRESS VARCHAR2 (2000)
Protocol Address
USERNAME VARCHAR2 (500)
Receiving UserName
PASSWORD VARCHAR2 (500)
Receiving Password
ATTRIBUTE1 VARCHAR2 (500)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (500)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (500)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (500)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (500)
Descriptive flexfield segment
PAYLOAD CLOB (4000)
Message Payload
FIELD1 VARCHAR2 (2000)
Reserved for Inbound
FIELD2 VARCHAR2 (2000)
Reserved for Inbound
FIELD3 VARCHAR2 (2000)
Reserved for Inbound
FIELD4 VARCHAR2 (2000)
Reserved for Inbound
FIELD5 VARCHAR2 (2000)
Reserved for Inbound
FIELD6 VARCHAR2 (2000)
Reserved for Inbound
FIELD7 VARCHAR2 (2000)
Reserved for Inbound
FIELD8 VARCHAR2 (2000)
Reserved for Inbound
FIELD9 VARCHAR2 (2000)
Reserved for Inbound
FIELD10 VARCHAR2 (2000)
Reserved for Inbound
FIELD11 VARCHAR2 (2000)
Reserved for Inbound
FIELD12 VARCHAR2 (2000)
Reserved for Inbound
FIELD13 VARCHAR2 (2000)
Reserved for Inbound
FIELD14 VARCHAR2 (2000)
Reserved for Inbound
FIELD15 VARCHAR2 (2000)
Reserved for Inbound
FIELD16 VARCHAR2 (2000)
Reserved for Inbound
FIELD17 VARCHAR2 (2000)
Reserved for Inbound
FIELD18 VARCHAR2 (2000)
Reserved for Inbound
FIELD19 VARCHAR2 (2000)
Reserved for Inbound
FIELD20 VARCHAR2 (2000)
Reserved for Inbound
FIELD21 VARCHAR2 (2000)
Reserved for Inbound
FIELD22 VARCHAR2 (2000)
Reserved for Inbound
FIELD23 VARCHAR2 (2000)
Reserved for Inbound
FIELD24 VARCHAR2 (2000)
Reserved for Inbound
FIELD25 VARCHAR2 (2000)
Reserved for Inbound
FIELD26 VARCHAR2 (2000)
Reserved for Inbound
FIELD27 VARCHAR2 (2000)
Reserved for Inbound
FIELD28 VARCHAR2 (2000)
Reserved for Inbound
FIELD29 VARCHAR2 (2000)
Reserved for Inbound
FIELD30 VARCHAR2 (2000)
Reserved for Inbound
LOGFILE VARCHAR2 (80)
Transaction Logfile
INTERNAL_CONTROL_NUMBER NUMBER

Internal Message Control Number
STATUS VARCHAR2 (256)
Message Processing Status
DIRECTION VARCHAR2 (240)
Message Direction
TIME_STAMP DATE

Time Log was Last Updated
OUT_MSGID RAW (16)
Outbound Message Identifier
ITEM_TYPE VARCHAR2 (8)
Workflow Item Type
ITEM_KEY VARCHAR2 (240)
Workflow Item Key
ACTIVITY_ID NUMBER

Workflow activity id
EVENT_NAME VARCHAR2 (240)
Workflow event name
EVENT_KEY VARCHAR2 (240)
Workflow event key
ORIG_REFERENCE_ID VARCHAR2 (240)
Original Reference Id
CB_EVENT_NAME VARCHAR2 (240)
Message Callback event name
CB_EVENT_KEY VARCHAR2 (240)
Message Callback event key
BLOCK_MODE VARCHAR2 (1)
Message Callback Mode

[top of page]

ECX.ECX_DOCLOGS does not reference any database object

ECX.ECX_DOCLOGS is referenced by following:

ECX
VIEW - ECX_DOCLOGS#

[top of page]

Table: ECX_DTDS

Description: This table contains the DTD's used by XML Gateway
Primary Key: ECX_DTDS_PK
  1. DTD_ID
Comments

This table contains the DTD's used by XML Gateway

Indexes
Index Type Tablespace Column
ECX_DTDS_U1 UNIQUE APPS_TS_SEED FILENAME
ROOT_ELEMENT
VERSION
ZD_EDITION_NAME
ECX_DTDS_U2 UNIQUE APPS_TS_SEED DTD_ID
ZD_EDITION_NAME
SYS_IL0000165421C00006$$ UNIQUE APPS_TS_SEED
Columns
Name Datatype Length Mandatory Comments
DTD_ID NUMBER
Y DTD Identifier
DESCRIPTION VARCHAR2 (256)
DTD Description
FILENAME VARCHAR2 (256)
DTD FileName
ROOT_ELEMENT VARCHAR2 (256) Y DTD Root Element
VERSION VARCHAR2 (256)
User-defined DTD Version
PAYLOAD CLOB (4000)
Actual DTD
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

ECX.ECX_DTDS does not reference any database object

ECX.ECX_DTDS is referenced by following:

ECX
VIEW - ECX_DTDS#

[top of page]

Table: ECX_ERROR_MSGS

Description: This table contains the error messages that are generated during transaction processing.
Primary Key: ECX_ERROR_MSGS_PK
  1. ERROR_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
ECX_EXTERNAL_LOGS.ERROR_ID ECX_ERROR_MSGS
ECX_EXTERNAL_RETRY.ERROR_ID ECX_ERROR_MSGS
ECX_INBOUND_LOGS.ERROR_ID ECX_ERROR_MSGS
ECX_MSG_LOGS.ERROR_ID ECX_ERROR_MSGS
ECX_OUTBOUND_LOGS.ERROR_ID ECX_ERROR_MSGS
Comments

This table contains the error messages that are generated during transaction processing.

Indexes
Index Type Tablespace Column
ECX_ERROR_MSGS_U1 UNIQUE APPS_TS_TX_IDX ERROR_ID
Columns
Name Datatype Length Mandatory Comments
ERROR_ID NUMBER (15) Y Error Message Identifier
MESSAGE VARCHAR2 (2000)
Error Message
MESSAGE_PARAMETERS VARCHAR2 (4000)
Message Parameters

[top of page]

ECX.ECX_ERROR_MSGS does not reference any database object

ECX.ECX_ERROR_MSGS is referenced by following:

ECX
VIEW - ECX_ERROR_MSGS#

[top of page]

Table: ECX_EXTERNAL_LOGS

Description: This table contains the outbound message logs.
Primary Key: ECX_EXTERNAL_LOGS_PK
  1. EXTERNAL_PROCESS_ID
Primary Key: SYS_C00407837
  1. EXTERNAL_PROCESS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ECX_EXTERNAL_LOGS.ERROR_ID ECX_ERROR_MSGS
ECX_EXTERNAL_LOGS.OUT_MSGID ECX_DOCLOGS
Comments

This table contains the outbound message logs.

Indexes
Index Type Tablespace Column
ECX_EXTERNAL_LOGS_U1 UNIQUE APPS_TS_TX_IDX EXTERNAL_PROCESS_ID
ECX_EXTERNAL_LOGS_N1 NONUNIQUE APPS_TS_TX_IDX ERROR_ID
ECX_EXTERNAL_LOGS_N2 NONUNIQUE APPS_TS_TX_IDX OUT_MSGID
Columns
Name Datatype Length Mandatory Comments
EXTERNAL_PROCESS_ID NUMBER (15) Y External Process Identifier
OUT_MSGID RAW (16) Y Message Identifier
STATUS VARCHAR2 (240)
Document Status
ERROR_ID NUMBER (15)
Error Message Identifier
TIME_STAMP DATE

Last Update Time Stamp

[top of page]

ECX.ECX_EXTERNAL_LOGS does not reference any database object

ECX.ECX_EXTERNAL_LOGS is referenced by following:

ECX
VIEW - ECX_EXTERNAL_LOGS#

[top of page]

Table: ECX_EXTERNAL_RETRY

Description: This table contains the outbound logs for resent messages.
Primary Key: ECX_EXTERNAL_RETRY_PK
  1. RETRY_MSGID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ECX_EXTERNAL_RETRY.ERROR_ID ECX_ERROR_MSGS
Comments

This table contains the outbound logs for resent messages.

Indexes
Index Type Tablespace Column
ECX_EXTERNAL_RETRY_U1 UNIQUE APPS_TS_TX_IDX RETRY_MSGID
ECX_EXTERNAL_RETRY_N1 NONUNIQUE APPS_TS_TX_IDX ERROR_ID
Columns
Name Datatype Length Mandatory Comments
MSGID RAW (16) Y Original Message Identifier
RETRY_MSGID RAW (16) Y Retry Message Identifier
STATUS VARCHAR2 (240)
Retry Document Status
ERROR_ID NUMBER (15)
Error Message Identifier
TIME_STAMP DATE

Last Update Time Stamp

[top of page]

ECX.ECX_EXTERNAL_RETRY does not reference any database object

ECX.ECX_EXTERNAL_RETRY is referenced by following:

ECX
VIEW - ECX_EXTERNAL_RETRY#

[top of page]

Table: ECX_EXT_PROCESSES

Description: This table contains the external transaction definitions.
Primary Key: ECX_EXT_PROCESSES_PK
  1. EXT_PROCESS_ID
Primary Key: SYS_C00516354
  1. EXT_PROCESS_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
ECX_TP_DETAILS.EXT_PROCESS_ID ECX_EXT_PROCESSES
Comments

This table contains the external transaction definitions.

Indexes
Index Type Tablespace Column
ECX_ECX_PROCESSES_U2 UNIQUE APPS_TS_SEED EXT_PROCESS_ID
ZD_EDITION_NAME
ECX_EXT_PROCESSES_U1 UNIQUE APPS_TS_SEED TRANSACTION_ID
STANDARD_ID
DIRECTION
EXT_TYPE
EXT_SUBTYPE
ZD_EDITION_NAME
ECX_EXT_PROCESSES_N1 NONUNIQUE APPS_TS_SEED EXT_TYPE
EXT_SUBTYPE
STANDARD_ID
DIRECTION
Columns
Name Datatype Length Mandatory Comments
EXT_PROCESS_ID NUMBER
Y External Transaction Identifier
EXT_TYPE VARCHAR2 (80) Y External Transaction Type
EXT_SUBTYPE VARCHAR2 (80) Y External Transaction Subtype
TRANSACTION_ID NUMBER (15) Y Internal Transaction Identifier
STANDARD_ID NUMBER (15) Y Standard Identifier
QUEUE_NAME VARCHAR2 (256)
Queue Name
DIRECTION VARCHAR2 (20) Y Transaction Direction
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

ECX.ECX_EXT_PROCESSES does not reference any database object

ECX.ECX_EXT_PROCESSES is referenced by following:

ECX
VIEW - ECX_EXT_PROCESSES#

[top of page]

Table: ECX_FILES

Description: This table contains XSLT Files
Primary Key: ECX_FILES_PK
  1. ID
Comments

This table contains XSLT Files

Indexes
Index Type Tablespace Column
ECX_FILES_U1 UNIQUE APPS_TS_SEED ID
ZD_EDITION_NAME
SYS_IL0000194132C00003$$ UNIQUE APPS_TS_SEED
ECX_FILES_N1 NONUNIQUE APPS_TS_SEED TYPE
NAME
VERSION
APPLICATION_CODE
Columns
Name Datatype Length Mandatory Comments
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
PAYLOAD CLOB (4000)
actual content of the file
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
NAME VARCHAR2 (256) Y name of file
VERSION NUMBER (15)
Version of the File
APPLICATION_CODE VARCHAR2 (256) Y application code
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
TYPE VARCHAR2 (256) Y file type i.e. XML ,XSLT,DTD's
ID NUMBER (15) Y Unique identifier for the table
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

ECX.ECX_FILES does not reference any database object

ECX.ECX_FILES is referenced by following:

ECX
VIEW - ECX_FILES#

[top of page]

Table: ECX_HUBS

Description: This table contains the hub definitions
Primary Key: ECX_HUBS_PK
  1. HUB_ID
Primary Key: SYS_C00497450
  1. HUB_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
ECX_HUB_USERS.HUB_ID ECX_HUBS
Comments

This table contains the hub definitions

Indexes
Index Type Tablespace Column
ECX_HUBS_U1 UNIQUE APPS_TS_SEED NAME
PROTOCOL_TYPE
ECX_HUBS_U2 UNIQUE APPS_TS_SEED HUB_ID
Columns
Name Datatype Length Mandatory Comments
HUB_ID NUMBER
Y Hub Identifier
NAME VARCHAR2 (100) Y Hub Name
PROTOCOL_TYPE VARCHAR2 (30) Y Protocol Type
PROTOCOL_ADDRESS VARCHAR2 (512)
Protocol Address
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).

[top of page]

ECX.ECX_HUBS does not reference any database object

ECX.ECX_HUBS is referenced by following:

ECX
VIEW - ECX_HUBS#

[top of page]

Table: ECX_HUB_USERS

Description: This table contains the hub user definitions
Primary Key: ECX_HUB_USERS_PK
  1. HUB_USER_ID
Primary Key: SYS_C00497458
  1. HUB_USER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ECX_HUB_USERS.HUB_ID ECX_HUBS
Foreign Keys to this table:
Foreign Key Column Foreign Table
ECX_TP_DETAILS.HUB_USER_ID ECX_HUB_USERS
Comments

This table contains the hub user definitions

Indexes
Index Type Tablespace Column
ECX_HUB_USERS_U1 UNIQUE APPS_TS_SEED HUB_ID
HUB_ENTITY_CODE
USERNAME
ECX_HUB_USERS_U2 UNIQUE APPS_TS_SEED HUB_USER_ID
Columns
Name Datatype Length Mandatory Comments
HUB_USER_ID NUMBER
Y Hub User Identifier
HUB_ID NUMBER
Y Hub Identifier
HUB_ENTITY_CODE VARCHAR2 (100) Y Hub Location Code
USERNAME VARCHAR2 (512) Y Receiving UserName
PASSWORD VARCHAR2 (500)
Receiving Password
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).

[top of page]

ECX.ECX_HUB_USERS does not reference any database object

ECX.ECX_HUB_USERS is referenced by following:

ECX
VIEW - ECX_HUB_USERS#

[top of page]

Table: ECX_INBOUND_LOGS

Description: This table contains the inbound transaction logs.
Primary Key: ECX_INBOUND_LOGS_PK
  1. TRIGGER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ECX_INBOUND_LOGS.ERROR_ID ECX_ERROR_MSGS
Comments

This table contains the inbound transaction logs.

Indexes
Index Type Tablespace Column
ECX_INBOUND_LOGS_U1 UNIQUE APPS_TS_TX_IDX TRIGGER_ID
ECX_INBOUND_LOGS_N1 NONUNIQUE APPS_TS_TX_IDX MSGID
ECX_INBOUND_LOGS_N2 NONUNIQUE APPS_TS_TX_IDX PROCESS_ID
Columns
Name Datatype Length Mandatory Comments
TRIGGER_ID NUMBER (15) Y Triggerring Identifier
MSGID RAW (16)
Message Identifier
PROCESS_ID RAW (16)
Process Identifier
STATUS VARCHAR2 (256)
Processing Status
ERROR_ID NUMBER (15)
Error Message Identifier
LOGFILE VARCHAR2 (256)
Processing Logfile
TIME_STAMP DATE

Last Update Time Stamp

[top of page]

ECX.ECX_INBOUND_LOGS does not reference any database object

ECX.ECX_INBOUND_LOGS is referenced by following:

ECX
VIEW - ECX_INBOUND_LOGS#

[top of page]

Table: ECX_LEVEL_MAPPINGS

Description: This table contains the relationship between the source and target mappings
Primary Key: ECX_LEVEL_MAPPINGS_PK
  1. MAP_ID
  2. LEVEL_MAPPING_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ECX_LEVEL_MAPPINGS.MAP_ID ECX_MAPPINGS
Comments

This table contains the relationship between the source and target mappings

Indexes
Index Type Tablespace Column
ECX_LEVEL_MAPPINGS_U1 UNIQUE APPS_TS_SEED MAP_ID
LEVEL_MAPPING_ID
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
LEVEL_MAPPING_ID NUMBER
Y Level Mapping Identifier
SOURCE_LEVEL_ID NUMBER
Y Source Object Level Identifier
TARGET_LEVEL_ID NUMBER
Y Target Object Level Identifier
SOURCE_ELEMENT_ID NUMBER

First Source Attribute Identifier
MAP_ID NUMBER
Y Map Identifier
TARGET_ELEMENT_ID NUMBER

First Target Attribute Identifier
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

ECX.ECX_LEVEL_MAPPINGS does not reference any database object

ECX.ECX_LEVEL_MAPPINGS is referenced by following:

ECX
VIEW - ECX_LEVEL_MAPPINGS#

[top of page]

Table: ECX_MAPPINGS

Description: The table contains the definitions of the maps that are used by XML Gateway
Primary Key: ECX_MAPPINGS_PK
  1. MAP_ID
Primary Key: SYS_C00407833
  1. MAP_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
ECX_ATTRIBUTE_MAPPINGS.MAP_ID ECX_MAPPINGS
ECX_LEVEL_MAPPINGS.MAP_ID ECX_MAPPINGS
ECX_PROC_MAPPINGS.MAP_ID ECX_MAPPINGS
ECX_TP_DETAILS.MAP_ID ECX_MAPPINGS
ECX_OBJECTS.MAP_ID ECX_MAPPINGS
ECX_OBJECT_LEVELS.MAP_ID ECX_MAPPINGS
ECX_OBJECT_ATTRIBUTES.MAP_ID ECX_MAPPINGS
Comments

The table contains the definitions of the maps that are used by XML Gateway

Indexes
Index Type Tablespace Column
ECX_MAPPINGS_U1 UNIQUE APPS_TS_SEED MAP_CODE
ZD_EDITION_NAME
ECX_MAPPINGS_U2 UNIQUE APPS_TS_SEED MAP_ID
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
MAP_ID NUMBER
Y Map Identifier
MAP_CODE VARCHAR2 (30) Y Map Code
DESCRIPTION VARCHAR2 (4000)
Map Description
OBJECT_ID_SOURCE NUMBER
Y Source Object Identifier
OBJECT_ID_TARGET NUMBER
Y Target Object Identifier
ENABLED VARCHAR2 (1)
Maps Enabled Flag
ECX_MAJOR_VERSION NUMBER (15) Y ECX Major Version
ECX_MINOR_VERSION NUMBER (15) Y ECX Minor Version
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

ECX.ECX_MAPPINGS does not reference any database object

ECX.ECX_MAPPINGS is referenced by following:

ECX
VIEW - ECX_MAPPINGS#

[top of page]

Table: ECX_MSG_LOGS

Description: This table contains the inbound and outbound message logs.
Primary Key: ECX_MSG_LOGS_PK
  1. LOG_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ECX_MSG_LOGS.ERROR_ID ECX_ERROR_MSGS
Comments

This table contains the inbound and outbound message logs.

Indexes
Index Type Tablespace Column
ECX_MSG_LOGS_U1 UNIQUE APPS_TS_TX_IDX LOG_ID
ECX_MSG_LOGS_N1 NONUNIQUE APPS_TS_TX_IDX ERROR_ID
ECX_MSG_LOGS_N2 NONUNIQUE APPS_TS_TX_IDX TRIGGER_ID
Columns
Name Datatype Length Mandatory Comments
LOG_ID NUMBER (15) Y Message Log Identifier
TRIGGER_ID NUMBER (15) Y Trigger Identifier
ERROR_ID NUMBER (15) Y Error Message Identifier

[top of page]

ECX.ECX_MSG_LOGS does not reference any database object

ECX.ECX_MSG_LOGS is referenced by following:

ECX
VIEW - ECX_MSG_LOGS#

[top of page]

Table: ECX_OBJECTS

Description: This table contains the source and target objects for the maps.
Primary Key: ECX_OBJECTS_PK
  1. MAP_ID
  2. OBJECT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ECX_OBJECTS.MAP_ID ECX_MAPPINGS
Comments

This table contains the source and target objects for the maps.

Indexes
Index Type Tablespace Column
ECX_OBJECTS_U1 UNIQUE APPS_TS_SEED MAP_ID
OBJECT_ID
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
OBJECT_ID NUMBER
Y Object Identifier
OBJECT_NAME VARCHAR2 (255)
Object Name
OBJECT_TYPE VARCHAR2 (30)
Object Type
OBJECT_DESCRIPTION VARCHAR2 (255)
Object Description
OBJECT_STANDARD VARCHAR2 (30)
Object Standard
ROOT_ELEMENT VARCHAR2 (255)
Root Element
FULLPATH VARCHAR2 (255)
DTD Path and FileName
MAP_ID NUMBER
Y Map Identifier
RUNTIME_LOCATION VARCHAR2 (250)
Map version of the object
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

ECX.ECX_OBJECTS does not reference any database object

ECX.ECX_OBJECTS is referenced by following:

ECX
VIEW - ECX_OBJECTS#

[top of page]

Table: ECX_OBJECT_ATTRIBUTES

Description: This table contains the source and target object Attributes
Primary Key: ECX_OBJECT_ATTRIBUTES_PK
  1. MAP_ID
  2. ATTRIBUTE_ID
  3. OBJECTLEVEL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ECX_OBJECT_ATTRIBUTES.MAP_ID ECX_MAPPINGS
Comments

This table contains the source and target objectAttributes

Indexes
Index Type Tablespace Column
ECX_OBJECT_ATTRIBUTES_U1 UNIQUE APPS_TS_SEED MAP_ID
ATTRIBUTE_ID
OBJECTLEVEL_ID
ZD_EDITION_NAME
ECX_OBJECT_ATTRIBUTES_N1 NONUNIQUE APPS_TS_SEED XREF_CATEGORY_ID
Columns
Name Datatype Length Mandatory Comments
ATTRIBUTE_ID NUMBER
Y Attribute Identifier
OBJECTLEVEL_ID NUMBER
Y Object Level Identifier
ATTRIBUTE_NAME VARCHAR2 (255)
Attribute Name
OBJECT_COLUMN_FLAG VARCHAR2 (2)
Database Column Flag
DATA_TYPE NUMBER

Data Type
PARENT_ATTRIBUTE_ID NUMBER
Y Parent Attribute Identifier
POSITION NUMBER

No longer used
WIDTH NUMBER

No longer used
XREF_CATEGORY_ID NUMBER

Code Conversion Category Identifier
STAGING_COLUMN VARCHAR2 (30)
No longer used
DEFAULT_VALUE VARCHAR2 (255)
Attribute Default Value
ATTRIBUTE_TYPE VARCHAR2 (20)
Attribute Type
HAS_ATTRIBUTES VARCHAR2 (20)
Number of Attributes
LEAF_NODE VARCHAR2 (1)
Attribute is a Leaf Node Indicator
REQUIRED_FLAG VARCHAR2 (1)
No longer used
MAP_ID NUMBER
Y Map Identifier
COND_NODE VARCHAR2 (50)
Condition Node Name
COND_VALUE VARCHAR2 (50)
Condition Node Value
COND_NODE_TYPE VARCHAR2 (25)
Condition Node Type
OCCURRENCE NUMBER (15)
No longer used
IS_MAPPED VARCHAR2 (20)
Attribute is Mapped Indicator
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

ECX.ECX_OBJECT_ATTRIBUTES does not reference any database object

ECX.ECX_OBJECT_ATTRIBUTES is referenced by following:

ECX
VIEW - ECX_OBJECT_ATTRIBUTES#

[top of page]

Table: ECX_OBJECT_LEVELS

Description: This table contains the source and target object Levels
Primary Key: ECX_OBJECT_LEVELS_PK
  1. MAP_ID
  2. OBJECTLEVEL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ECX_OBJECT_LEVELS.MAP_ID ECX_MAPPINGS
Comments

This table contains the source and target object Levels

Indexes
Index Type Tablespace Column
ECX_OBJECT_LEVELS_U1 UNIQUE APPS_TS_SEED MAP_ID
OBJECTLEVEL_ID
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
OBJECTLEVEL_ID NUMBER
Y Object Level Identifier
OBJECT_ID NUMBER
Y Object Identifier
OBJECT_LEVEL NUMBER

Logical Level
OBJECT_LEVEL_NAME VARCHAR2 (255)
Object Level Name
PARENT_LEVEL NUMBER

Parent Object Level
ENABLED VARCHAR2 (1)
No longer used
MAP_ID NUMBER
Y Map Identifier
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

ECX.ECX_OBJECT_LEVELS does not reference any database object

ECX.ECX_OBJECT_LEVELS is referenced by following:

ECX
VIEW - ECX_OBJECT_LEVELS#

[top of page]

Table: ECX_OUTBOUND_LOGS

Description: This table contains the outbound transaction logs
Primary Key: ECX_OUTBOUND_LOGS_PK
  1. TRIGGER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ECX_OUTBOUND_LOGS.ERROR_ID ECX_ERROR_MSGS
ECX_OUTBOUND_LOGS.PARTY_ID HZ_PARTIES
ECX_OUTBOUND_LOGS.PARTY_ID PO_VENDORS
Comments

This table contains the outbound transaction logs

Indexes
Index Type Tablespace Column
ECX_OUTBOUND_LOGS_U1 UNIQUE APPS_TS_TX_IDX TRIGGER_ID
ECX_OUTBOUND_LOGS_N1 NONUNIQUE APPS_TS_TX_IDX OUT_MSGID
ECX_OUTBOUND_LOGS_N2 NONUNIQUE APPS_TS_TX_IDX TIME_STAMP
Columns
Name Datatype Length Mandatory Comments
TRIGGER_ID NUMBER (15) Y Trigger Identifier
TRANSACTION_TYPE VARCHAR2 (100)
External Transaction Type
TRANSACTION_SUBTYPE VARCHAR2 (100)
External Transaction Subtype
PARTY_ID VARCHAR2 (256)
Party Identifier
PARTY_SITE_ID VARCHAR2 (256)
Party Site Identifier
DOCUMENT_NUMBER VARCHAR2 (256)
Document Number
PROCESS_ID RAW (16)
No longer used
STATUS VARCHAR2 (256)
Processing Status
ERROR_ID NUMBER (15)
Error Message Identifier
OUT_MSGID RAW (16)
Message Identifier
LOGFILE VARCHAR2 (256)
Processing Logfile
TIME_STAMP DATE

Last Update Time Stamp
PARTY_TYPE VARCHAR2 (30)
The Party Type

[top of page]

ECX.ECX_OUTBOUND_LOGS does not reference any database object

ECX.ECX_OUTBOUND_LOGS is referenced by following:

ECX
VIEW - ECX_OUTBOUND_LOGS#

[top of page]

Table: ECX_OXTA_LOGMSG

Description: This table contains the Oracle Transport Agent message logs
Primary Key: ECX_OXTA_LOGMSG_PK
  1. BEGIN_DATE
  2. SENDER_MESSAGE_ID
  3. DIRECTION
Primary Key: PK_ECX_OXTA_LOGMSG
  1. BEGIN_DATE
  2. SENDER_MESSAGE_ID
  3. USERNAME
Comments

This table contains the Oracle Transport Agent message logs

Indexes
Index Type Tablespace Column
ECX_OXTA_LOGMSG_N1 NONUNIQUE APPS_TS_TX_IDX DIRECTION
STATUS
RESULT_CODE
ECX_OXTA_LOGMSG_N2 NONUNIQUE APPS_TS_TX_IDX SENDER_MESSAGE_ID
ECX_OXTA_LOGMSG_N3 NONUNIQUE APPS_TS_TX_IDX RECEIPT_MESSAGE_ID
Columns
Name Datatype Length Mandatory Comments
SENDER_MESSAGE_ID VARCHAR2 (50) Y Sender Message Identifier
DIRECTION VARCHAR2 (3) Y Message Direction
STATUS VARCHAR2 (15) Y Message Status
BEGIN_DATE DATE
Y Message Start Date
REQUEST_TYPE VARCHAR2 (15) Y Request Type
CONTENT_LENGTH NUMBER

Message length
TRANSACTION_TYPE VARCHAR2 (30)
Transaction Type
USERNAME VARCHAR2 (500)
UserName
IP_ADDRESS VARCHAR2 (15)
IP Address
PROTOCOL_TYPE VARCHAR2 (80)
Protocol Type
PROTOCOL_ADDRESS VARCHAR2 (500)
Protocol Address
RESULT_CODE VARCHAR2 (4)
Result Status Code
RESULT_TEXT VARCHAR2 (2000)
Result Message
RECEIPT_MESSAGE_ID VARCHAR2 (50)
Receipt Message Identifier
COMPLETED_DATE DATE

Message Processing Date
EXCEPTION_TEXT VARCHAR2 (2000)
Exception Message

[top of page]

ECX.ECX_OXTA_LOGMSG does not reference any database object

ECX.ECX_OXTA_LOGMSG is referenced by following:

ECX
VIEW - ECX_OXTA_LOGMSG#

[top of page]

Table: ECX_PROC_MAPPINGS

Description: This table contains the procedure mappings
Primary Key: ECX_PROC_MAPPINGS_PK
  1. MAP_ID
  2. PROCMAP_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ECX_PROC_MAPPINGS.MAP_ID ECX_MAPPINGS
ECX_PROC_MAPPINGS.TRANSTAGE_ID ECX_TRAN_STAGE_DATA
Comments

This table contains the procedure mappings

Indexes
Index Type Tablespace Column
ECX_PROC_MAPPINGS_U1 UNIQUE APPS_TS_SEED MAP_ID
PROCMAP_ID
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
PROCMAP_ID NUMBER
Y Procedure map Identifier
TRANSTAGE_ID NUMBER
Y Transaction stage Identifier
PARAMETER_NAME VARCHAR2 (250)
Parameter Name
ACTION_TYPE NUMBER

IN or OUT parameter
VARIABLE_LEVEL NUMBER

Direction variable Level
VARIABLE_NAME VARCHAR2 (255)
Variable Name
DATA_TYPE NUMBER

Datatype as specified in Oracle server
VARIABLE_POS NUMBER

Variable Position
MAP_ID NUMBER
Y Map Identifier
VARIABLE_DIRECTION VARCHAR2 (1)
Variable direction (Direction or Global or Literal
VARIABLE_CONSTANT VARCHAR2 (2000)
Stores Literal Value
VARIABLE_VALUE VARCHAR2 (200)
Variable Value
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

ECX.ECX_PROC_MAPPINGS does not reference any database object

ECX.ECX_PROC_MAPPINGS is referenced by following:

ECX
VIEW - ECX_PROC_MAPPINGS#

[top of page]

Table: ECX_STANDARDS_B

Description: This table contains the standards definitions
Primary Key: ECX_STANDARDS_B_PK
  1. STANDARD_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
ECX_XREF_DTL_B.STANDARD_ID ECX_STANDARDS_B
Comments

This table contains the standards definitions

Indexes
Index Type Tablespace Column
ECX_STANDARDS_B_U1 UNIQUE APPS_TS_SEED STANDARD_CODE
STANDARD_TYPE
ZD_EDITION_NAME
ECX_STANDARDS_B_U2 UNIQUE APPS_TS_SEED STANDARD_ID
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
STANDARD_ID NUMBER
Y Standard Identifier
STANDARD_CODE VARCHAR2 (30) Y Standard Code
STANDARD_TYPE VARCHAR2 (30) Y Standard Type
STANDARD_DESC VARCHAR2 (80)
DATA_SEEDED VARCHAR2 (1)
Seeded Data Flag
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
APPLICATION_ID NUMBER

Application Id
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

ECX.ECX_STANDARDS_B does not reference any database object

ECX.ECX_STANDARDS_B is referenced by following:

ECX
VIEW - ECX_STANDARDS_B#

[top of page]

Table: ECX_STANDARDS_TL

Description: This table contains the translated standards definition
Primary Key: ECX_STANDARDS_TL_PK
  1. STANDARD_ID
  2. LANGUAGE
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
ECX_STANDARDS_TL_U1 UNIQUE APPS_TS_SEED STANDARD_ID
LANGUAGE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
STANDARD_ID NUMBER
Y
STANDARD_DESC VARCHAR2 (80)
Standard Code Description
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
LANGUAGE VARCHAR2 (4) Y Translated Language
SOURCE_LANG VARCHAR2 (4) Y Seeded language
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

ECX.ECX_STANDARDS_TL does not reference any database object

ECX.ECX_STANDARDS_TL is referenced by following:

ECX
VIEW - ECX_STANDARDS_TL#

[top of page]

Table: ECX_STANDARD_ATTRIBUTES

Description: This table contains the attributes for a given standard
Primary Key: ECX_STANDARD_ATTRIBUTES_PK
  1. STANDARD_ATTRIBUTE_ID
Primary Key: SYS_C00407836
  1. STANDARD_ATTRIBUTE_ID
Comments

This table contains the attributes for a given standard

Indexes
Index Type Tablespace Column
ECX_STANDARD_ATTRIBUTES_U1 UNIQUE APPS_TS_SEED STANDARD_ID
ATTRIBUTE_NAME
ZD_EDITION_NAME
ECX_STANDARD_ATTRIBUTES_U2 UNIQUE APPS_TS_SEED STANDARD_ATTRIBUTE_ID
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
STANDARD_ATTRIBUTE_ID NUMBER
Y Standard Attribute Identifier
STANDARD_ID NUMBER
Y Standard identifier
ATTRIBUTE_NAME VARCHAR2 (30) Y Standard Attribute name
ELEMENT_TAG_NAME VARCHAR2 (30)
Standard Element Name
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

ECX.ECX_STANDARD_ATTRIBUTES does not reference any database object

ECX.ECX_STANDARD_ATTRIBUTES is referenced by following:

ECX
VIEW - ECX_STANDARD_ATTRIBUTES#

[top of page]

Table: ECX_TP_DETAILS

Description: This table contains the trading partner detail information
Primary Key: ECX_TP_DETAILS_PK
  1. TP_DETAIL_ID
Primary Key: SYS_C00497498
  1. TP_DETAIL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ECX_TP_DETAILS.EXT_PROCESS_ID ECX_EXT_PROCESSES
ECX_TP_DETAILS.HUB_USER_ID ECX_HUB_USERS
ECX_TP_DETAILS.MAP_ID ECX_MAPPINGS
ECX_TP_DETAILS.ROUTING_ID ECX_TP_DETAILS
ECX_TP_DETAILS.TP_HEADER_ID ECX_TP_HEADERS
Foreign Keys to this table:
Foreign Key Column Foreign Table
ECX_TP_DETAILS.ROUTING_ID ECX_TP_DETAILS
Comments

This table contains the trading partner detail information

Indexes
Index Type Tablespace Column
ECX_TP_DETAILS_U2 UNIQUE APPS_TS_TX_IDX TP_DETAIL_ID
ECX_TP_DETAILS_N1 NONUNIQUE APPS_TS_TX_IDX EXT_PROCESS_ID
SOURCE_TP_LOCATION_CODE
ECX_TP_DETAILS_N2 NONUNIQUE APPS_TS_TX_IDX TP_HEADER_ID
EXT_PROCESS_ID
Columns
Name Datatype Length Mandatory Comments
TP_HEADER_ID NUMBER
Y Trading partner Header Identifier
TP_DETAIL_ID NUMBER
Y Trading partner Detail Identifier
MAP_ID NUMBER
Y Map Identifier
EXT_PROCESS_ID NUMBER
Y External transaction Identifier
CONNECTION_TYPE VARCHAR2 (30)
Connection Type
HUB_USER_ID NUMBER

Hub User Identifier
PROTOCOL_TYPE VARCHAR2 (30)
Protocol Type
PROTOCOL_ADDRESS VARCHAR2 (512)
Protocol Address
USERNAME VARCHAR2 (512)
Username
PASSWORD VARCHAR2 (500)
Password
ROUTING_ID NUMBER

Routing id for passthrough transaction
SOURCE_TP_LOCATION_CODE VARCHAR2 (200)
Source trading partner Location Code
EXTERNAL_TP_LOCATION_CODE VARCHAR2 (200)
Target trading partner Location Code
OMB_SYNC VARCHAR2 (1)
No longer Used
CONFIRMATION NUMBER (2)
Confirmation Indicator
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
HUB_ID NUMBER

Hub ID

[top of page]

ECX.ECX_TP_DETAILS does not reference any database object

ECX.ECX_TP_DETAILS is referenced by following:

ECX
VIEW - ECX_TP_DETAILS#

[top of page]

Table: ECX_TP_HEADERS

Description: This table contains Trading Partner header information
Primary Key: ECX_TP_HEADERS_PK
  1. TP_HEADER_ID
Primary Key: SYS_C00497489
  1. TP_HEADER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ECX_TP_HEADERS.PARTY_ID HZ_PARTIES
ECX_TP_HEADERS.PARTY_ID PO_VENDORS
ECX_TP_HEADERS.PARTY_ID HZ_PARTIES
Foreign Keys to this table:
Foreign Key Column Foreign Table
ECX_XREF_DTL_B.TP_HEADER_ID ECX_TP_HEADERS
ECX_XREF_DTL.TP_HEADER_ID ECX_TP_HEADERS
ECX_TP_DETAILS.TP_HEADER_ID ECX_TP_HEADERS
Comments

This table contains Trading Partner header information

Indexes
Index Type Tablespace Column
ECX_TP_HEADERS_U1 UNIQUE APPS_TS_SEED PARTY_ID
PARTY_SITE_ID
PARTY_TYPE
ECX_TP_HEADERS_U2 UNIQUE APPS_TS_SEED TP_HEADER_ID
Columns
Name Datatype Length Mandatory Comments
TP_HEADER_ID NUMBER
Y Trading Partner Header Identifier
PARTY_TYPE VARCHAR2 (30) Y Party type
PARTY_ID NUMBER
Y Party Identifier
PARTY_SITE_ID NUMBER
Y Party Site identifier
COMPANY_ADMIN_EMAIL VARCHAR2 (256) Y Trading Partner Administrator Email Address
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).

[top of page]

ECX.ECX_TP_HEADERS does not reference any database object

ECX.ECX_TP_HEADERS is referenced by following:

ECX
VIEW - ECX_TP_HEADERS#

[top of page]

Table: ECX_TRANSACTIONS_B

Description: This table contains internal transaction definitions
Primary Key: ECX_TRANSACTIONS_B_PK
  1. TRANSACTION_ID
Comments

This table contains internal transaction definitions

Indexes
Index Type Tablespace Column
ECX_TRANSACTIONS_B_U1 UNIQUE APPS_TS_SEED TRANSACTION_TYPE
TRANSACTION_SUBTYPE
PARTY_TYPE
ZD_EDITION_NAME
ECX_TRANSACTIONS_B_U2 UNIQUE APPS_TS_SEED TRANSACTION_ID
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID NUMBER
Y Internal Transaction identifier
TRANSACTION_DESCRIPTION VARCHAR2 (256)
TRANSACTION_TYPE VARCHAR2 (100) Y Internal Transaction Type
TRANSACTION_SUBTYPE VARCHAR2 (100) Y Internal Transaction subtype
PARTY_TYPE VARCHAR2 (30) Y Party type
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ENABLED VARCHAR2 (240)
Enabled
APPLICATION_ID NUMBER

Application Id
ADMIN_USER VARCHAR2 (240)
Admin User
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

ECX.ECX_TRANSACTIONS_B does not reference any database object

ECX.ECX_TRANSACTIONS_B is referenced by following:

ECX
VIEW - ECX_TRANSACTIONS_B#

[top of page]

Table: ECX_TRANSACTIONS_TL

Description: This table contains translated internal transaction definitions
Primary Key: ECX_TRANSACTIONS_TL_PK
  1. TRANSACTION_ID
  2. LANGUAGE
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
ECX_TRANSACTIONS_TL_U1 UNIQUE APPS_TS_SEED TRANSACTION_ID
LANGUAGE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID NUMBER
Y
TRANSACTION_DESCRIPTION VARCHAR2 (256)
Internal Transaction Description
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
LANGUAGE VARCHAR2 (4) Y Translated Language
SOURCE_LANG VARCHAR2 (4) Y Seeded Language
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

ECX.ECX_TRANSACTIONS_TL does not reference any database object

ECX.ECX_TRANSACTIONS_TL is referenced by following:

ECX
VIEW - ECX_TRANSACTIONS_TL#

[top of page]

Table: ECX_TRAN_STAGE_DATA

Description: This table contains the action definitions
Primary Key: ECX_TRAN_STAGE_DATA_PK
  1. TRANSTAGE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
ECX_PROC_MAPPINGS.TRANSTAGE_ID ECX_TRAN_STAGE_DATA
Comments

This table contains the action definitions

Indexes
Index Type Tablespace Column
ECX_TRAN_STAGE_DATA_U1 UNIQUE APPS_TS_SEED MAP_ID
TRANSTAGE_ID
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
TRANSTAGE_ID NUMBER
Y Transaction Stage Identifier
SOURCE_LEVEL_ID NUMBER

Source Object Level Identifier
STAGE NUMBER

Processing Stage
SEQ_NUMBER NUMBER

Action Sequence Number
ACTION_TYPE NUMBER

Action Type
VARIABLE_LEVEL NUMBER

Result Variable Level
VARIABLE_NAME VARCHAR2 (255)
Result Variable Name
VARIABLE_VALUE VARCHAR2 (2000)
Result Variable Value
DEFAULT_VALUE VARCHAR2 (2000)
Result Default Value
SEQUENCE_NAME VARCHAR2 (255)
Sequence Name
CUSTOM_PROCEDURE_NAME VARCHAR2 (255)
Database Procedure Name
DATA_TYPE NUMBER (15)
Datatype
FUNCTION_NAME VARCHAR2 (255)
Database Function Name
WHERE_CLAUSE VARCHAR2 (2000)
Where Clause
VARIABLE_POS NUMBER

Result Variable Postion
MAP_ID NUMBER
Y Map Identifier
OBJECTLEVEL_ID NUMBER
Y Object Level Identifier
OBJECT_DIRECTION VARCHAR2 (1)
Object Direction
VARIABLE_DIRECTION VARCHAR2 (1)
Result Direction
ACTION_POS NUMBER

Action Postion
COND_LOGICAL_OPERATOR VARCHAR2 (10)
Not Used
COND_OPERATOR1 VARCHAR2 (20)
First Condition Operator
COND_VAR1_LEVEL NUMBER (15)
First Condition Variable Level
COND_VAR1_NAME VARCHAR2 (240)
First Condition Variable Name
COND_VAR1_POS NUMBER (15)
First Condition Variable Position
COND_VAR1_DIRECTION VARCHAR2 (20)
First Condition Variable Direction
COND_VAR1_CONSTANT VARCHAR2 (2000)
First Condition Variable Constant
COND_OPERATOR2 VARCHAR2 (240)
Not Used
COND_VAR2_LEVEL NUMBER (15)
Not Used
COND_VAR2_NAME VARCHAR2 (240)
Not Used
COND_VAR2_POS NUMBER (15)
Not Used
COND_VAR2_DIRECTION VARCHAR2 (20)
Not Used
COND_VAR2_CONSTANT VARCHAR2 (2000)
Not Used
COND_VAL1_LEVEL NUMBER (15)
First Condition Value Level
COND_VAL1_NAME VARCHAR2 (240)
First Condition Value Name
COND_VAL1_POS NUMBER (15)
First Condition Value Position
COND_VAL1_DIRECTION VARCHAR2 (20)
First Condition Value Direction
COND_VAL1_CONSTANT VARCHAR2 (2000)
First Condition Value Constant
COND_VAL2_LEVEL NUMBER (15)
Not Used
COND_VAL2_NAME VARCHAR2 (240)
Not Used
COND_VAL2_POS NUMBER (15)
Not Used
COND_VAL2_DIRECTION VARCHAR2 (20)
Not Used
COND_VAL2_CONSTANT VARCHAR2 (2000)
Not Used
OPERAND1_LEVEL NUMBER (15)
First Operand Level
OPERAND1_NAME VARCHAR2 (240)
First Operand Name
OPERAND1_POS NUMBER (15)
First Operand Position
OPERAND1_DIRECTION VARCHAR2 (20)
First Operand Direction
OPERAND1_CONSTANT VARCHAR2 (2000)
First Operand Constant
OPERAND1_START_POS NUMBER (15)
Not Used
OPERAND1_LEN NUMBER (15)
Not Used
OPERAND2_NAME VARCHAR2 (240)
Second Operand Name
OPERAND2_LEVEL NUMBER (15)
Second Operand Level
OPERAND2_POS NUMBER (15)
Second Operand Position
OPERAND2_DIRECTION VARCHAR2 (20)
Second Operand Direction
OPERAND2_CONSTANT VARCHAR2 (2000)
Second Operand Constant
OPERAND3_LEVEL NUMBER (15)
Third Operand Level
OPERAND3_NAME VARCHAR2 (240)
Third Operand Name
OPERAND3_POS NUMBER (15)
Third Operand Position
OPERAND3_DIRECTION VARCHAR2 (20)
Third Operand Direction
OPERAND3_CONSTANT VARCHAR2 (2000)
Third Operand Constant
OPERAND4_LEVEL NUMBER (15)
Fourth Operand Level
OPERAND4_NAME VARCHAR2 (240)
Fourth Operand Name
OPERAND4_POS NUMBER (15)
Fourth Operand Position
OPERAND4_DIRECTION VARCHAR2 (20)
Fourth Operand Direction
OPERAND4_CONSTANT VARCHAR2 (2000)
Fourth Operand Constant
OPERAND5_LEVEL NUMBER (15)
Fifth Operand Level
OPERAND5_NAME VARCHAR2 (240)
Fifth Operand Name
OPERAND5_POS NUMBER (15)
Fifth Operand Position
OPERAND5_DIRECTION VARCHAR2 (20)
Fifth Operand Direction
OPERAND5_CONSTANT VARCHAR2 (2000)
Fifth Operand Constant
OPERAND6_LEVEL NUMBER (15)
Sixth Operand Level
OPERAND6_NAME VARCHAR2 (240)
Sixth Operand Name
OPERAND6_POS NUMBER (15)
Sixth Operand Position
OPERAND6_DIRECTION VARCHAR2 (20)
Sixth Operand Direction
OPERAND6_CONSTANT VARCHAR2 (2000)
Sixth Operand Constant
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

ECX.ECX_TRAN_STAGE_DATA does not reference any database object

ECX.ECX_TRAN_STAGE_DATA is referenced by following:

ECX
VIEW - ECX_TRAN_STAGE_DATA#

[top of page]

Table: ECX_XREF_DTL_B

Description: This table contains the trading partners code conversion values.
Primary Key: ECX_XREF_DTL_B_PK
  1. XREF_DTL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ECX_XREF_DTL_B.TP_HEADER_ID ECX_TP_HEADERS
ECX_XREF_DTL_B.XREF_CATEGORY_ID ECX_XREF_HDR_B
ECX_XREF_DTL_B.STANDARD_ID ECX_STANDARDS_B
Comments

This table contains the trading partners code conversion values.

Indexes
Index Type Tablespace Column
ECX_XREF_DTL_B_U1 UNIQUE APPS_TS_TX_IDX XREF_CATEGORY_ID
STANDARD_ID
XREF_INT_VALUE
XREF_EXT_VALUE
DIRECTION
TP_HEADER_ID
ECX_XREF_DTL_B_U2 UNIQUE APPS_TS_TX_IDX XREF_DTL_ID
ECX_XREF_DTL_B_N1 NONUNIQUE APPS_TS_TX_IDX XREF_CATEGORY_ID
TP_HEADER_ID
Columns
Name Datatype Length Mandatory Comments
XREF_DTL_ID NUMBER
Y Conversion Category Value Identifier
XREF_CATEGORY_ID NUMBER
Y Code Conversion Category Identifier
STANDARD_ID NUMBER
Y Standard Identifier
XREF_STANDARD_CODE VARCHAR2 (80)
Not Used
TP_HEADER_ID NUMBER
Y Trading Partner Header Identifier
XREF_EXT_VALUE VARCHAR2 (240) Y Code Conversion External Category Value
XREF_INT_VALUE VARCHAR2 (240) Y Code Conversion Internal Category Value
DESCRIPTION VARCHAR2 (240)
DIRECTION VARCHAR2 (10) Y Direction
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
APPLICATION_ID NUMBER

Application Id

[top of page]

ECX.ECX_XREF_DTL_B does not reference any database object

ECX.ECX_XREF_DTL_B is referenced by following:

ECX
VIEW - ECX_XREF_DTL_B#

[top of page]

Table: ECX_XREF_DTL_TL

Description:
Primary Key: ECX_XREF_DTL_TL_PK
  1. XREF_DTL_ID
  2. LANGUAGE
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
ECX_XREF_DTL_TL_U1 UNIQUE APPS_TS_TX_IDX XREF_DTL_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
XREF_DTL_ID NUMBER
Y
DESCRIPTION VARCHAR2 (240)
LANGUAGE VARCHAR2 (4) Y
SOURCE_LANG VARCHAR2 (4) Y
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).

[top of page]

ECX.ECX_XREF_DTL_TL does not reference any database object

ECX.ECX_XREF_DTL_TL is referenced by following:

ECX
VIEW - ECX_XREF_DTL_TL#

[top of page]

Table: ECX_XREF_HDR_B

Description: This table contains the code conversion categories.
Primary Key: ECX_XREF_HDR_B_PK
  1. XREF_CATEGORY_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
ECX_XREF_DTL_B.XREF_CATEGORY_ID ECX_XREF_HDR_B
Comments

This table contains the code conversion categories.

Indexes
Index Type Tablespace Column
ECX_XREF_HDR_B_U1 UNIQUE APPS_TS_SEED XREF_CATEGORY_CODE
ZD_EDITION_NAME
ECX_XREF_HDR_B_U2 UNIQUE APPS_TS_SEED XREF_CATEGORY_ID
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
XREF_CATEGORY_ID NUMBER
Y Code Conversion Category unique identifier
XREF_CATEGORY_CODE VARCHAR2 (30) Y Code Conversion Category Code
DESCRIPTION VARCHAR2 (256)
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
APPLICATION_ID NUMBER

Application Id
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

ECX.ECX_XREF_HDR_B does not reference any database object

ECX.ECX_XREF_HDR_B is referenced by following:

ECX
VIEW - ECX_XREF_HDR_B#

[top of page]

Table: ECX_XREF_HDR_TL

Description: This table contains the translated code conversion categories.
Primary Key: ECX_XREF_HDR_TL_PK
  1. XREF_CATEGORY_ID
  2. LANGUAGE
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
ECX_XREF_HDR_TL_U1 UNIQUE APPS_TS_SEED XREF_CATEGORY_ID
LANGUAGE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
XREF_CATEGORY_ID NUMBER
Y
DESCRIPTION VARCHAR2 (256)
Code Conversion Category Description
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
LANGUAGE VARCHAR2 (4) Y Translated Language
SOURCE_LANG VARCHAR2 (4) Y Seeded Language
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

ECX.ECX_XREF_HDR_TL does not reference any database object

ECX.ECX_XREF_HDR_TL is referenced by following:

ECX
VIEW - ECX_XREF_HDR_TL#

[top of page]

Table: ECX_XREF_STANDARDS_B

Description: This table contains the code conversion category values.
Primary Key: ECX_XREF_STANDARDS_B_PK
  1. XREF_STANDARD_ID
Comments

This table contains the code conversion category values.

Indexes
Index Type Tablespace Column
ECX_XREF_STANDARDS_B_U1 UNIQUE APPS_TS_SEED XREF_CATEGORY_ID
STANDARD_ID
XREF_INT_VALUE
ZD_EDITION_NAME
ECX_XREF_STANDARDS_B_U2 UNIQUE APPS_TS_SEED XREF_STANDARD_ID
ZD_EDITION_NAME
ECX_XREF_STANDARDS_B_U3 UNIQUE APPS_TS_SEED XREF_CATEGORY_ID
STANDARD_ID
XREF_STD_VALUE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
XREF_STANDARD_ID NUMBER
Y Code Conversion Category Value Identifier
XREF_CATEGORY_ID NUMBER
Y Category Id
STANDARD_ID NUMBER
Y Standard Id
XREF_STANDARD_CODE VARCHAR2 (240)
Standard Code
XREF_STD_VALUE VARCHAR2 (240) Y Code Conversion Standard Value
XREF_INT_VALUE VARCHAR2 (240) Y Code Conversion Internal Value
DESCRIPTION VARCHAR2 (240)
DATA_SEEDED VARCHAR2 (1)
Seeded Data Indicator
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
APPLICATION_ID NUMBER

Application Id
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

ECX.ECX_XREF_STANDARDS_B does not reference any database object

ECX.ECX_XREF_STANDARDS_B is referenced by following:

ECX
VIEW - ECX_XREF_STANDARDS_B#

[top of page]

Table: ECX_XREF_STANDARDS_TL

Description:
Primary Key: ECX_XREF_STANDARDS_TL_PK
  1. XREF_STANDARD_ID
  2. LANGUAGE
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
ECX_XREF_STANDARDS_TL_U1 UNIQUE APPS_TS_SEED XREF_STANDARD_ID
LANGUAGE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
XREF_STANDARD_ID NUMBER
Y
DESCRIPTION VARCHAR2 (240)
LANGUAGE VARCHAR2 (4) Y
SOURCE_LANG VARCHAR2 (4) Y
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

ECX.ECX_XREF_STANDARDS_TL does not reference any database object

ECX.ECX_XREF_STANDARDS_TL is referenced by following:

ECX
VIEW - ECX_XREF_STANDARDS_TL#

[top of page]

View: ECX_DUMMY1_V

Comments
View Type

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

Dummy View for OAG Level

Columns
Name Datatype Length Mandatory Comments
DUMMY VARCHAR2 (1)
Dummy Column

[top of page]

APPS.ECX_DUMMY1_V references the following:

PUBLIC
SYNONYM - DUAL
- DUAL

APPS.ECX_DUMMY1_V is not referenced by any database object

[top of page]

View: ECX_DUMMY2_V

Comments
View Type

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

Dummy View for OAG Level

Columns
Name Datatype Length Mandatory Comments
DUMMY VARCHAR2 (1)
Dummy Column

[top of page]

APPS.ECX_DUMMY2_V references the following:

PUBLIC
SYNONYM - DUAL
- DUAL

APPS.ECX_DUMMY2_V is not referenced by any database object

[top of page]

View: ECX_HEADER_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

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

Columns
Name Datatype Length Mandatory Comments
DUMMY VARCHAR2 (1)

[top of page]

APPS.ECX_HEADER_V references the following:

PUBLIC
SYNONYM - DUAL
- DUAL

APPS.ECX_HEADER_V is not referenced by any database object

[top of page]

View: ECX_IN_PROCESS_VL

Comments
View Type

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

Status for Inbound Messages

Columns
Name Datatype Length Mandatory Comments
TRIGGER_ID NUMBER (15)
Triggerring Identifier
DOCUMENT_ID VARCHAR2 (256)
Document Identifier
TRANSACTION_TYPE VARCHAR2 (100)
Internal Transaction Type
TRANSACTION_SUBTYPE VARCHAR2 (100)
Internal Transaction Subtype
PARTY_ID NUMBER

Party Identifier
PARTY_SITE_ID NUMBER

Party Site Identifier
PARTY_TYPE VARCHAR2 (30)
Party Type
SOURCE_TP_LOCATION_CODE VARCHAR2 (200)
INTERNAL_CONTROL_NUMBER NUMBER

Internal Message Control Number
PROCESSING_STATUS VARCHAR2 (256)
Processing Status
PROCESSING_MESSAGE VARCHAR2 (4000)
Processing Message
PROCESSING_TIMESTAMP DATE

Processing Timestamp
PROCESSING_LOGFILE VARCHAR2 (256)
Processing Logfile
OUT_MSGID RAW (16)
Message Identifier
MSGID RAW (16) Y Message Identifier

[top of page]

APPS.ECX_IN_PROCESS_VL references the following:

APPS
PACKAGE - ECX_DEBUG
SYNONYM - ECX_DOCLOGS
SYNONYM - ECX_ERROR_MSGS
SYNONYM - ECX_EXT_PROCESSES
SYNONYM - ECX_INBOUND_LOGS
SYNONYM - ECX_STANDARDS
SYNONYM - ECX_TP_DETAILS
SYNONYM - ECX_TP_HEADERS

APPS.ECX_IN_PROCESS_VL is not referenced by any database object

[top of page]

View: ECX_LOOKUP_VALUES

Comments
View Type

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

Stores XML Lookup Values

Columns
Name Datatype Length Mandatory Comments
LOOKUP_TYPE VARCHAR2 (30) Y Lookup Type
LOOKUP_CODE VARCHAR2 (30) Y Lookup Code
MEANING VARCHAR2 (80) Y Lookup Code meaning
DESCRIPTION VARCHAR2 (240)
Description
ENABLED_FLAG VARCHAR2 (1) Y Enabled Flag
START_DATE_ACTIVE DATE

Active Start Date
END_DATE_ACTIVE DATE

Active End Date

[top of page]

APPS.ECX_LOOKUP_VALUES references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - FND_LOOKUP_VALUES
APPS.ECX_LOOKUP_VALUES is referenced by following:

APPS
VIEW - ECX_TP_HEADERS_V

[top of page]

View: ECX_MSGNAME_V

Comments
View Type

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

Dummy View for OAG level

Columns
Name Datatype Length Mandatory Comments
DUMMY VARCHAR2 (1)
Dummy Column

[top of page]

APPS.ECX_MSGNAME_V references the following:

PUBLIC
SYNONYM - DUAL
- DUAL

APPS.ECX_MSGNAME_V is not referenced by any database object

[top of page]

View: ECX_OAG_CBOD_V

Comments
View Type

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

View for OAG confirmation BOD

Columns
Name Datatype Length Mandatory Comments
MSGID RAW (16) Y 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

[top of page]

APPS.ECX_OAG_CBOD_V references the following:

APPS
SYNONYM - ECX_DOCLOGS

APPS.ECX_OAG_CBOD_V is not referenced by any database object

[top of page]

View: ECX_OAG_CONTROLAREA_TP_V

Comments
View Type

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

View for the Open Applications Group (OAG) Control Area.

Columns
Name Datatype Length Mandatory Comments
VERB_VALUE VARCHAR2 (80) Y Verb Value
VERB_ATTVALUE VARCHAR2 (80) Y Verb Attribute Value
NOUN_VALUE VARCHAR2 (80) Y Noun Value
NOUN_ATTVALUE VARCHAR2 (80) Y Noun Attribute Value
COMPONENT VARCHAR2 (100) Y Component
TASK VARCHAR2 (100) Y Task
LOGICAL_ID VARCHAR2 (4000)
Logical Identifier
REFERENCE_ID VARCHAR2 (4000)
Reference Identifier
AUTHID VARCHAR2 (30)
Authorization Identifier
DATETIME DATE

Datetime
DATE_ATTVALUE CHAR (8)
Datetime Attribute Value
LANGUAGE VARCHAR2 (52)
Language
CONFIRMATION NUMBER (2)
Confirmation Code
REVISION_VALUE VARCHAR2 (0)
Revision Value
REVISION_ATTVALUE VARCHAR2 (0)
Revision Attribute Value
CODEPAGE VARCHAR2 (64)
Code Page
TRANSACTION_TYPE VARCHAR2 (100) Y Internal Transaction Type
TRANSACTION_SUBTYPE VARCHAR2 (100) Y Internal Transaction Subtype
USERNAME VARCHAR2 (512)
username
SOURCE_TP_LOCATION_CODE VARCHAR2 (200)
Source trading partner location code
PARTY_ID NUMBER
Y Party Identifier
PARTY_SITE_ID NUMBER
Y Party Site Identifier
PARTY_TYPE VARCHAR2 (30) Y Party Type

[top of page]

APPS.ECX_OAG_CONTROLAREA_TP_V references the following:

APPS
SYNONYM - ECX_EXT_PROCESSES
PACKAGE - ECX_STANDARD
SYNONYM - ECX_STANDARDS_B
SYNONYM - ECX_TP_DETAILS
SYNONYM - ECX_TP_HEADERS
PACKAGE - ECX_TRADING_PARTNER_PVT
SYNONYM - ECX_TRANSACTIONS_B
PUBLIC
SYNONYM - V$NLS_PARAMETERS
- V$NLS_PARAMETERS

APPS.ECX_OAG_CONTROLAREA_TP_V is not referenced by any database object

[top of page]

View: ECX_OAG_CONTROLAREA_V

Comments
View Type

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

View for the Open Applications Group (OAG) Control Area.

Columns
Name Datatype Length Mandatory Comments
VERB_VALUE VARCHAR2 (80) Y Verb Value
VERB_ATTVALUE VARCHAR2 (80) Y Verb Attribute Value
NOUN_VALUE VARCHAR2 (80) Y Noun Value
NOUN_ATTVALUE VARCHAR2 (80) Y Noun Attribute Value
COMPONENT VARCHAR2 (80) Y Component
TASK VARCHAR2 (80) Y Task
LOGICAL_ID VARCHAR2 (4000)
Logical Identifier
REFERENCE_ID CHAR (1)
Reference Identifier
AUTHID VARCHAR2 (30)
Authorization Identifier
DATETIME DATE

Datetime
DATE_ATTVALUE CHAR (8)
Datetime Attribute Value
LANGUAGE VARCHAR2 (52)
Language
CONFIRMATION NUMBER

Confirmation Code
REVISION_VALUE VARCHAR2 (0)
Revision Value
REVISION_ATTVALUE VARCHAR2 (0)
Revision Attribute Value
CODEPAGE VARCHAR2 (64)
Code Page
TRANSACTION_TYPE VARCHAR2 (100) Y Internal Transaction Type
TRANSACTION_SUBTYPE VARCHAR2 (100) Y Internal Transaction Subtype

[top of page]

APPS.ECX_OAG_CONTROLAREA_V references the following:

APPS
SYNONYM - ECX_EXT_PROCESSES
SYNONYM - ECX_STANDARDS_B
SYNONYM - ECX_TRANSACTIONS_B
PACKAGE - FND_PROFILE
PUBLIC
SYNONYM - V$NLS_PARAMETERS
- V$NLS_PARAMETERS

APPS.ECX_OAG_CONTROLAREA_V is not referenced by any database object

[top of page]

View: ECX_OUT_PROCESS_VL

Comments
View Type

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

Status for Outbound Messages

Columns
Name Datatype Length Mandatory Comments
TRIGGER_ID NUMBER (15)
Triggerring Identifier
DOCUMENT_ID VARCHAR2 (256)
Document Identifier
TRANSACTION_TYPE VARCHAR2 (100)
Internal Transaction Type
TRANSACTION_SUBTYPE VARCHAR2 (100)
Internal Transaction Subtype
PARTY_TYPE VARCHAR2 (30)
Party Type
PARTY_ID NUMBER

Party Identifier
PARTY_SITE_ID VARCHAR2 (256)
Party Site Identifier
GENERATION_STATUS VARCHAR2 (256)
Message Generation Status
GENERATION_MESSAGE VARCHAR2 (4000)
Generating Message
GENERATION_TIMESTAMP DATE

Generating Timestamp
GENERATION_LOGFILE VARCHAR2 (256)
Message Generated Logfile
OUT_MSGID RAW (16)
Message Identifier
DELIVERY_STATUS VARCHAR2 (240)
Delivery Status
DELIVERY_MESSAGE VARCHAR2 (4000)
Delivery Message
DELIVERY_TIMESTAMP DATE

Delivery Timestamp
RETRY_STATUS VARCHAR2 (240)
Retry Status
RETRY_MESSAGE VARCHAR2 (4000)
Retry Message
RETRY_TIMESTAMP DATE

Retry Timestamp
PROTOCOL_TYPE VARCHAR2 (500)
Protocol Type
PROTOCOL_ADDRESS VARCHAR2 (2000)
Protocol Address
RETRY_MSGID RAW (16)
Retry Message Identifier

[top of page]

APPS.ECX_OUT_PROCESS_VL references the following:

APPS
PACKAGE - ECX_DEBUG
SYNONYM - ECX_DOCLOGS
SYNONYM - ECX_ERROR_MSGS
SYNONYM - ECX_EXTERNAL_LOGS
SYNONYM - ECX_EXTERNAL_RETRY
SYNONYM - ECX_OUTBOUND_LOGS
SYNONYM - ECX_TP_HEADERS

APPS.ECX_OUT_PROCESS_VL is not referenced by any database object

[top of page]

View: ECX_PARTIES_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
DUMMY VARCHAR2 (0)
Party Number

[top of page]

APPS.ECX_PARTIES_V references the following:

PUBLIC
SYNONYM - DUAL
- DUAL

APPS.ECX_PARTIES_V is not referenced by any database object

[top of page]

View: ECX_PARTY_SITES_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
DUMMY VARCHAR2 (0)
Dummy

[top of page]

APPS.ECX_PARTY_SITES_V references the following:

PUBLIC
SYNONYM - DUAL
- DUAL

APPS.ECX_PARTY_SITES_V is not referenced by any database object

[top of page]

View: ECX_STANDARDS_VL

Comments
View Type

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

ECX Standards

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row ID
STANDARD_ID NUMBER
Y Standard Id
STANDARD_CODE VARCHAR2 (30) Y Standard Code
STANDARD_TYPE VARCHAR2 (30) Y Standard Type
DATA_SEEDED VARCHAR2 (1)
Data Seeded
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
STANDARD_DESC VARCHAR2 (80)
Standard Description

[top of page]

APPS.ECX_STANDARDS_VL references the following:

APPS
SYNONYM - ECX_STANDARDS_B
SYNONYM - ECX_STANDARDS_TL

APPS.ECX_STANDARDS_VL is not referenced by any database object

[top of page]

View: ECX_TP_DETAILS_V

Comments
View Type

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

This view contains the trading partner detail information.

Columns
Name Datatype Length Mandatory Comments
TP_HEADER_ID NUMBER
Y Trading Partner Header Identifier
TP_DETAIL_ID NUMBER
Y Trading Partner Detail Identifier
MAP_ID NUMBER
Y Map Identifier
EXT_PROCESS_ID NUMBER
Y External Transaction Identifier
TRANSACTION_TYPE VARCHAR2 (100) Y Internal Transaction Type
TRANSACTION_SUBTYPE VARCHAR2 (100) Y Internal Transaction Subtype
STANDARD_CODE VARCHAR2 (30) Y Standard Code
EXT_TYPE VARCHAR2 (80) Y External Transaction Type
EXT_SUBTYPE VARCHAR2 (80) Y External Transaction Subtype
TRANSACTION_DIRECTION VARCHAR2 (20) Y Transaction Direction
CONNECTION_TYPE VARCHAR2 (30)
Connection Type
HUB_USER_ID NUMBER

Hub User Identifier
PROTOCOL_TYPE VARCHAR2 (30)
Protocol Type
PROTOCOL_ADDRESS VARCHAR2 (512)
Protocol Address
USERNAME VARCHAR2 (512)
Username
PASSWORD VARCHAR2 (500)
Password
ROUTING_ID NUMBER

Routing ID for Passthrough Transaction
CONFIRMATION NUMBER (2)
Confirmation Code
SOURCE_TP_LOCATION_CODE VARCHAR2 (200)
Source Trading Partner Location Code
EXTERNAL_TP_LOCATION_CODE VARCHAR2 (200)
Destination Trading Partner Location Code
OMB_SYNC VARCHAR2 (1)
No Longer Used
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
HUB_ID NUMBER

Hub ID

[top of page]

APPS.ECX_TP_DETAILS_V references the following:

APPS
SYNONYM - ECX_EXT_PROCESSES
SYNONYM - ECX_HUBS
SYNONYM - ECX_HUB_USERS
SYNONYM - ECX_STANDARDS_B
SYNONYM - ECX_TP_DETAILS
SYNONYM - ECX_TRANSACTIONS_B

APPS.ECX_TP_DETAILS_V is not referenced by any database object

[top of page]

View: ECX_TP_HEADERS_V

Comments
View Type

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

This table contains the trading partner header information

Columns
Name Datatype Length Mandatory Comments
TP_HEADER_ID NUMBER

Trading Partner Header Identifier
PARTY_TYPE VARCHAR2 (240)
Party Type
PARTY_ID NUMBER

Party Identifier
PARTY_SITE_ID NUMBER

Party Site Identifier
PARTY_NAME VARCHAR2 (360)
Party Name
PARTY_SITE_NAME VARCHAR2 (1146)
Party Site identifier
COMPANY_ADMIN_EMAIL VARCHAR2 (256)
Trading Partner Administration Email Address
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER

Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ORG_ID NUMBER

Organization identifier

[top of page]

APPS.ECX_TP_HEADERS_V references the following:

APPS
VIEW - CE_BANK_BRANCHES_V
VIEW - ECX_LOOKUP_VALUES
SYNONYM - ECX_TP_HEADERS
PACKAGE - FND_GLOBAL
PACKAGE - HR_GENERAL
SYNONYM - HZ_CUST_ACCT_SITES
SYNONYM - HZ_LOCATIONS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_PARTY_SITES
VIEW - PO_VENDORS
- HR_LOCATIONS
- PO_VENDOR_SITES

APPS.ECX_TP_HEADERS_V is not referenced by any database object

[top of page]

View: ECX_TRANSACTIONS_VL

Comments
View Type

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

ECX Transactions

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row Id
TRANSACTION_ID NUMBER
Y Transaction ID
TRANSACTION_TYPE VARCHAR2 (100) Y Transaction Type
TRANSACTION_SUBTYPE VARCHAR2 (100) Y Transaction Subtype
PARTY_TYPE VARCHAR2 (30) Y Party Type
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
TRANSACTION_DESCRIPTION VARCHAR2 (256)
Transaction Description
ADMIN_USER VARCHAR2 (240)
Administrative User for the Transaction

[top of page]

APPS.ECX_TRANSACTIONS_VL references the following:

APPS
SYNONYM - ECX_TRANSACTIONS_B
SYNONYM - ECX_TRANSACTIONS_TL

APPS.ECX_TRANSACTIONS_VL is not referenced by any database object

[top of page]

View: ECX_XREF_DTL_VL

Comments
View Type

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

Code conversion Trading Partner detail

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row ID
XREF_DTL_ID NUMBER
Y Detail Id
XREF_CATEGORY_ID NUMBER
Y Category ID
STANDARD_ID NUMBER
Y Standard ID
XREF_STANDARD_CODE VARCHAR2 (80)
Standard Code
TP_HEADER_ID NUMBER
Y Header ID
XREF_EXT_VALUE VARCHAR2 (240) Y External Value
XREF_INT_VALUE VARCHAR2 (240) Y Interrnal Value
DIRECTION VARCHAR2 (10) Y Direction
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
DESCRIPTION VARCHAR2 (240)
Description

[top of page]

APPS.ECX_XREF_DTL_VL references the following:

APPS
SYNONYM - ECX_XREF_DTL_B
SYNONYM - ECX_XREF_DTL_TL

APPS.ECX_XREF_DTL_VL is not referenced by any database object

[top of page]

View: ECX_XREF_HDR_MAPPED_V

Comments
View Type

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

View showing code categories for maps

Columns
Name Datatype Length Mandatory Comments
XREF_CATEGORY_ID NUMBER
Y Code Conversion Category unique identifier
XREF_CATEGORY_CODE VARCHAR2 (30) Y Code Conversion Category Code
DESCRIPTION VARCHAR2 (256)
Category Code Description
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).

[top of page]

APPS.ECX_XREF_HDR_MAPPED_V references the following:

APPS
SYNONYM - ECX_OBJECT_ATTRIBUTES
- ECX_XREF_HDR_VL

APPS.ECX_XREF_HDR_MAPPED_V is not referenced by any database object

[top of page]

View: ECX_XREF_HDR_VL

Comments
View Type

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

Code Category

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row ID
XREF_CATEGORY_ID NUMBER
Y Category ID
XREF_CATEGORY_CODE VARCHAR2 (30) Y Category Code
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
DESCRIPTION VARCHAR2 (256)
Description

[top of page]

APPS.ECX_XREF_HDR_VL references the following:

APPS
SYNONYM - ECX_XREF_HDR_B
SYNONYM - ECX_XREF_HDR_TL

APPS.ECX_XREF_HDR_VL is not referenced by any database object

[top of page]

View: ECX_XREF_STANDARDS_VL

Comments
View Type

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

Code conversion standard detail

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row ID
XREF_STANDARD_ID NUMBER
Y Standard ID
XREF_CATEGORY_ID NUMBER
Y Category ID
STANDARD_ID NUMBER
Y Standard ID
XREF_STANDARD_CODE VARCHAR2 (240)
Standard Code
XREF_STD_VALUE VARCHAR2 (240) Y Standard Value
XREF_INT_VALUE VARCHAR2 (240) Y Internal Value
DATA_SEEDED VARCHAR2 (1)
Data Seeded Flag
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
DESCRIPTION VARCHAR2 (240)
Description

[top of page]

APPS.ECX_XREF_STANDARDS_VL references the following:

APPS
SYNONYM - ECX_XREF_STANDARDS_B
SYNONYM - ECX_XREF_STANDARDS_TL

APPS.ECX_XREF_STANDARDS_VL is not referenced by any database object

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract