VIEW: SYS.EXU8REFIC

Source

View Text - Preformatted

SELECT  "OBJID","OWNER","OWNERID","TNAME","ROWNER","RTNAME","CNAME","CNO","RCNO","ACTION","ENABLED","DEFER","PROPERTY","ROBJID","ROWNERID","REFTYPE","REFCONSTR","TYPE"
        FROM    sys.exu8ref
        WHERE   (ownerid, tname) IN (
                    SELECT  i.owner#, i.name
                    FROM    sys.incexp i, sys.incvid v
                    WHERE   i.expid > v.expid AND
                            i.type# = 2)

View Text - HTML Formatted

SELECT "OBJID"
, "OWNER"
, "OWNERID"
, "TNAME"
, "ROWNER"
, "RTNAME"
, "CNAME"
, "CNO"
, "RCNO"
, "ACTION"
, "ENABLED"
, "DEFER"
, "PROPERTY"
, "ROBJID"
, "ROWNERID"
, "REFTYPE"
, "REFCONSTR"
, "TYPE"
FROM SYS.EXU8REF
WHERE (OWNERID
, TNAME) IN ( SELECT I.OWNER#
, I.NAME
FROM SYS.INCEXP I
, SYS.INCVID V
WHERE I.EXPID > V.EXPID AND I.TYPE# = 2)