VIEW: SYS.EXU81JAVC

Source

View Text - Preformatted

SELECT  j."OWNERID",j."UNAME",j."ID",j."SHORTNAME",j."TYPEID",j."TYPE"
        FROM    sys.exu81jav j, sys.incexp i, sys.incvid v
        WHERE   j.shortname = i.name(+) AND
                j.ownerid = i.owner#(+) AND
                NVL(i.type#, 28) IN (28, 29, 30, 31) AND
                (NVL(i.ctime, TO_DATE('01-01-1900', 'DD-MM-YYYY')) < i.itime OR
                 v.expid < NVL(i.expid, 9999))

View Text - HTML Formatted

SELECT J."OWNERID"
, J."UNAME"
, J."ID"
, J."SHORTNAME"
, J."TYPEID"
, J."TYPE"
FROM SYS.EXU81JAV J
, SYS.INCEXP I
, SYS.INCVID V
WHERE J.SHORTNAME = I.NAME(+) AND J.OWNERID = I.OWNER#(+) AND NVL(I.TYPE#
, 28) IN (28
, 29
, 30
, 31) AND (NVL(I.CTIME
, TO_DATE('01-01-1900'
, 'DD-MM-YYYY')) < I.ITIME OR V.EXPID < NVL(I.EXPID
, 9999))