|
|
| 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 |
| CODE |
varchar2 |
10 |
|
|
|
|
|
| AGNCY_CD_AGENCY_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| AGENCY_DESC |
varchar2 |
40 |
√ |
|
null |
|
|
| NEXT_START_DATE |
date |
7 |
√ |
|
null |
|
|
| FTP_ID |
number |
0 |
√ |
|
null |
|
| EJS_FTP.FTP_ID
|
Implied Constraint R |
|
| ENCRYPTION_PW |
varchar2 |
30 |
√ |
|
null |
|
|
| DESCRIPTION |
varchar2 |
80 |
√ |
|
null |
|
|
| PROCEDURE_NAME |
varchar2 |
80 |
√ |
|
null |
|
|
| EXSYS_DOC_CATEGORY_CODE |
varchar2 |
3 |
√ |
|
null |
|
|
| XML_DESCRIPTION |
varchar2 |
80 |
√ |
|
null |
|
|
| CAD_INTERFACE |
char |
1 |
√ |
|
null |
|
|
| DISPATCH_COUNT |
number |
0 |
√ |
|
null |
|
|
Analyzed at Mon Sep 20 21:05 MDT 2021
|
View Definition:
SELECT CODE,
AGNCY_CD_AGENCY_CODE,
AGENCY_DESC,
NEXT_START_DATE,
ESA.FTP_ID,
ENCRYPTION_PW,
ESC.DESCRIPTION,
PROCEDURE_NAME,
EXSYS_DOC_CATEGORY_CODE,
XDC.DESCRIPTION,
CASE UPPER(XDC.UPLOAD_PROCEDURE) WHEN 'XMLUPLOAD_CAD.UPLOAD_CAD'
THEN 'Y' ELSE 'N' END "CAD_INTERFACE",
CASE UPPER(XDC.UPLOAD_PROCEDURE) WHEN 'XMLUPLOAD_CAD.UPLOAD_CAD'
THEN EJS_INTERFACE_MAINT_PK.COUNT_DISPATCH_EVENTS(XDC.DOC_CATEGORY_CODE)
ELSE 0 END "DISPATCH_COUNT"
FROM EXTERNAL_SYSTEM_AGENCIES ESA, EXTERNAL_SYSTEM_CODES ESC,
AGENCY_CODES AC, XML_DOCUMENT_CATEGORY_CODES XDC
WHERE ESA.EXSYS_CODE(+) = ESC.CODE
AND AC.AGENCY_CODE(+) = ESA.AGNCY_CD_AGENCY_CODE
AND ESC.EXSYS_DOC_CATEGORY_CODE = XDC.DOC_CATEGORY_CODE(+)
Possibly Referenced Tables/Views:
