zOs/SQL/KE54808

with a as
(
                                      SELECT DISTINCT V833.PARTNER_KEY
    ,V833.PARTNER_TYPE, V833.CONTRACT_KEY, V833.LAST_UPDATE_TIME
     ,V835.PRODUCT_ID, V835.LAST_UPDATE_TIME V835LAST
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
)
SELECT DISTINCT a.PARTNER_KEY,
V831.PARTNER_ID, V858.IDENT_ID, V843.TAB_TEXT3, V858.VALID_TO_DATE,
V859.VALID_TO_DATE v859valid, V859.APPLICATION_TYPE
FROM oa1p.VKS831A1V V831,
   a
 , oa1p.VKS843A1V V843, oa1p.VKS843A1V V843B,
   oa1p.VKS858A1V V858, oa1p.VKS859A1V V859
WHERE

      V831.PARTNER_KEY = a.PARTNER_KEY
   AND V858.PARTNER_KEY =
   a.PARTNER_KEY AND V859.IDENT_ID = V858.IDENT_ID AND V843.TAB_ART =
'PRODUCT_ID' AND V843.TAB_CODE = a.PRODUCT_ID AND V843.TAB_TYPE2 =
V858.IDENT_TYPE AND V843B.TAB_ART = 'APPLICATION_IDENT' AND
V843B.TAB_TEXT3 = V843.TAB_TEXT3 AND V859.APPLICATION_TYPE =
V843B.TAB_TYPE1
AND (  a.LAST_UPDATE_TIME > current timestamp - 7 days
    or a.V835LAST  >        current timestamp - 7 days
    OR V858.VALID_TO_DATE BETWEEN current date - 7 days
                              and current date + 7 days
    or V859.VALID_TO_DATE BETWEEN current date - 7 days
                              and current date + 7 days
    OR V859.VALID_FROM_DATE >= current date - 7 days
 )
                   WITH UR