VIEW: SYS.EXU81OPRC

Source

View Text - Preformatted

SELECT  op."NAME",op."OBJID",op."OWNER",op."OWNERID",op."OLEVEL",op."SQLVER"
        FROM    sys.exu81opr op, sys.incexp i, sys.incvid v
        WHERE   op.name = i.name(+) AND
                op.ownerid = i.owner#(+) AND
                NVL(i.type#, 33) = 33 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 OP."NAME"
, OP."OBJID"
, OP."OWNER"
, OP."OWNERID"
, OP."OLEVEL"
, OP."SQLVER"
FROM SYS.EXU81OPR OP
, SYS.INCEXP I
, SYS.INCVID V
WHERE OP.NAME = I.NAME(+) AND OP.OWNERID = I.OWNER#(+) AND NVL(I.TYPE#
, 33) = 33 AND (NVL(I.CTIME
, TO_DATE('01-01-1900'
, 'DD-MM-YYYY')) < I.ITIME OR V.EXPID < NVL(I.EXPID
, 9999))