zOs/SQL/KE54806

with a as
(
                                      SELECT DISTINCT V833.PARTNER_KEY
FROM
oa1p.VKS833A1V V833, oa1p.VKS835A1V V835
WHERE V833.PARTNER_KEY >= ' ' AND
V833.PARTNER_TYPE = 3
and V835.PARTNER_KEY = V833.PARTNER_KEY AND V835.PARTNER_TYPE = 3 AND
V835.CONTRACT_KEY = V833.CONTRACT_KEY
AND (  V833.LAST_UPDATE_TIME > current timestamp - 7 days
    or V835.LAST_UPDATE_TIME > current timestamp - 7 days
 )
 )
select count(*) from a
    with ur