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
v.expid < NVL(i.expid, 9999)
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
V.EXPID < NVL(I.EXPID
, 9999)
|
|
|