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

TABLE: EDR.EDR_REDLINE_TRANS_DATA

Object Details
Object Name: EDR_REDLINE_TRANS_DATA
Object Type: TABLE
Owner: EDR
FND Design Data: TableEDR.EDR_REDLINE_TRANS_DATA
Subobject Name:
Status: VALID

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

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

Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
SYS_IL0000396590C00002$$ LOB UNIQUE TablespaceAPPS_TS_INTERFACE
SYS_IL0000396590C00003$$ LOB UNIQUE TablespaceAPPS_TS_INTERFACE
SYS_IL0000396590C00006$$ LOB UNIQUE TablespaceAPPS_TS_INTERFACE
SYS_IL0000396590C00007$$ LOB UNIQUE TablespaceAPPS_TS_INTERFACE
Columns
Name Datatype Length Mandatory Comments
EVENT_ID NUMBER (22) Yes EVENT ID of the Current Transaction
PRE_XML_DATA CLOB (4000)
Pre Transaction XML Data
POST_XML_DATA CLOB (4000)
Current Transaction XML Data
ERR_CODE NUMBER (22)
Error Code generated during Ecx API Call
ERR_MSG VARCHAR2 (2000)
Error Message generated during Ecx API Call
DIFF_XML CLOB (4000)
Difference between Pre and post Current Transaction XML Data
APPENDIX_GEN_XML CLOB (4000)
Generic XML derived from DIFF_XML for Appendix Section in E Record pdf
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT EVENT_ID
,      PRE_XML_DATA
,      POST_XML_DATA
,      ERR_CODE
,      ERR_MSG
,      DIFF_XML
,      APPENDIX_GEN_XML
FROM EDR.EDR_REDLINE_TRANS_DATA;

Dependencies

[top of page]

EDR.EDR_REDLINE_TRANS_DATA does not reference any database object

EDR.EDR_REDLINE_TRANS_DATA is referenced by following:

SchemaEDR
ViewEDR_REDLINE_TRANS_DATA#