VIEW: SYS.EXU7SPRC

Source

View Text - Preformatted

SELECT s."OWNERID",s."UNAME",s."ID",s."NAME",s."TIME",s."TYPEID",s."TYPE",s."AUDT" from exu7spr s,incexp i, incvid v
       WHERE s.name  = i.name(+) AND s.ownerid = i.owner#(+) AND
             NVL(i.type#,7) = 7 AND
(NVL(i.ctime,TO_DATE('01-01-1900','DD-MM-YYYY')) < i.itime OR
               NVL(i.expid,9999) > v.expid)

View Text - HTML Formatted

SELECT S."OWNERID"
, S."UNAME"
, S."ID"
, S."NAME"
, S."TIME"
, S."TYPEID"
, S."TYPE"
, S."AUDT"
FROM EXU7SPR S
, INCEXP I
, INCVID V
WHERE S.NAME = I.NAME(+)
AND S.OWNERID = I.OWNER#(+) AND NVL(I.TYPE#
, 7) = 7 AND (NVL(I.CTIME
, TO_DATE('01-01-1900'
, 'DD-MM-YYYY')) < I.ITIME OR NVL(I.EXPID
, 9999) > V.EXPID)