|
|
| Legend: |
| Primary key columns |
| Columns with indexes |
| Implied relationships |
| Excluded column relationships |
| < n > number of related tables |
|
|
| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| DOC_ERR_ID |
number |
15 |
|
|
|
|
|
| XML_DOC_ID |
number |
0 |
|
|
|
|
|
| ERROR_ID |
number |
0 |
|
|
|
|
|
| CREATOR_ID |
varchar2 |
100 |
√ |
|
null |
|
|
| CREATOR_DATE |
date |
7 |
√ |
|
null |
|
|
| DOCNAME |
varchar2 |
80 |
√ |
|
null |
|
|
| STATUS_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| DOC_CATEGORY_CODE |
varchar2 |
3 |
√ |
|
null |
|
|
| SEVERITY |
varchar2 |
20 |
√ |
|
null |
|
|
| DESCRIPTION |
varchar2 |
255 |
√ |
|
null |
|
|
| DTL_ERROR_MSG |
varchar2 |
255 |
√ |
|
null |
|
|
| SQL_ERROR_MSG |
varchar2 |
255 |
√ |
|
null |
|
|
Analyzed at Mon Sep 20 21:05 MDT 2021
|
View Definition:
SELECT EX.DOC_ERR_ID DOC_ERR_ID
,EX.XML_DOC_ID XML_DOC_ID
,EX.ERROR_ID ERROR_ID
,EX.CREATOR_ID CREATOR_ID
,EX.CREATOR_DATE CREATOR_DATE
,EJ.DOCNAME DOCNAME
,EJ.STATUS_CODE STATUS_CODE
,EJ.DOC_CATEGORY_CODE DOC_CATEGORY_CODE
,EC.SEVERITY SEVERITY
,EC.DESCRIPTION DESCRIPTION
,EX.DTL_ERROR_MSG
,EX.SQL_ERROR_MSG
FROM EJS_XML_DOC_ERRORS EX
,ERROR_CODES EC
,EJSXML_DOCS EJ
WHERE EX.ERROR_ID = EC.ERROR_ID
AND EX.XML_DOC_ID = EJ.XML_DOC_ID(+)
Possibly Referenced Tables/Views:
