SELECT vw."VOBJID",vw."VNAME",vw."VLEN",vw."VTEXT",vw."VOWNER",vw."VOWNERID",vw."VAUDIT",vw."VCOMMENT",vw."VCNAME",vw."VLEVEL" from exu7vew vw, incexp i, incvid v
WHERE vw.vname = i.name(+) AND vw.vownerid = i.owner#(+) AND
NVL(i.type#,4) = 4 AND
(NVL(i.ctime,TO_DATE('01-01-1900','DD-MM-YYYY')) < i.itime OR
v.expid < NVL(i.expid, 9999))
SELECT VW."VOBJID"
, VW."VNAME"
, VW."VLEN"
, VW."VTEXT"
, VW."VOWNER"
, VW."VOWNERID"
, VW."VAUDIT"
, VW."VCOMMENT"
, VW."VCNAME"
, VW."VLEVEL"
FROM EXU7VEW VW
, INCEXP I
, INCVID V
WHERE VW.VNAME = I.NAME(+)
AND VW.VOWNERID = I.OWNER#(+)
AND
NVL(I.TYPE#
, 4) = 4 AND
(NVL(I.CTIME
, TO_DATE('01-01-1900'
, 'DD-MM-YYYY')) < I.ITIME OR
V.EXPID < NVL(I.EXPID
, 9999))
|
|
|