View slot9.WORLD.TSTA.ZZV1_DS_ICR_FILE_REFERENCES
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 Comments
AUDIT_TIMESTAMP date 7  √  null
AUDIT_TRANSACTION_TYPE varchar2 1  √  null
AUDIT_USER_NAME varchar2 100  √  null
AUDIT_TRUE_NULLS varchar2 250  √  null
DATASETID number 38  √  null
ATT_ID number 0  √  null
KEYWORD varchar2 80  √  null
DATE_OF_INFO date 7  √  null
FILE_DESC varchar2 2000  √  null
FILE_CODE varchar2 30  √  null
FILE_CODE_TYPE varchar2 30  √  null
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
REC_ID number 0  √  null
EXTSYS_CODE varchar2 10  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

View Definition:
SELECT ZZ1.AUDIT_TIMESTAMP AUDIT_TIMESTAMP, ZZ1.AUDIT_TRANSACTION_TYPE AUDIT_TRANSACTION_TYPE, ZZ1.AUDIT_USER_NAME AUDIT_USER_NAME, ZZ1.AUDIT_TRUE_NULLS AUDIT_TRUE_NULLS, ZZ1.DATASETID DATASETID, ZZ1.ATT_ID ATT_ID, ZZ1.KEYWORD KEYWORD, ZZ1.DATE_OF_INFO DATE_OF_INFO, ZZ1.FILE_DESC FILE_DESC, ZZ1.FILE_CODE FILE_CODE, ZZ1.FILE_CODE_TYPE FILE_CODE_TYPE, ZZ1.CREATOR_ID CREATOR_ID, ZZ1.CREATOR_DATE CREATOR_DATE, ZZ1.UPDATOR_ID UPDATOR_ID, ZZ1.UPDATOR_DATE UPDATOR_DATE, ZZ1.REC_ID REC_ID, ZZ1.EXTSYS_CODE EXTSYS_CODE FROM ZZ_DS_ICR_FILE_REFERENCES ZZ1 union all select sysdate, 'C', null, null, ZZ2.DATASETID, ZZ2.ATT_ID, ZZ2.KEYWORD, ZZ2.DATE_OF_INFO, ZZ2.FILE_DESC, ZZ2.FILE_CODE, ZZ2.FILE_CODE_TYPE, ZZ2.CREATOR_ID, ZZ2.CREATOR_DATE, ZZ2.UPDATOR_ID, ZZ2.UPDATOR_DATE, ZZ2.REC_ID, ZZ2.EXTSYS_CODE FROM DS_ICR_FILE_REFERENCES ZZ2 where exists ( select * from ZZ_DS_ICR_FILE_REFERENCES where DATASETID= ZZ2.DATASETID AND ATT_ID= ZZ2.ATT_ID )
 
Possibly Referenced Tables/Views:
DS_ICR_FILE_REFERENCES ZZ_DS_ICR_FILE_REFERENCES