zOs/SQL/WIESET

   SELECT TIS.TIS_UWI, tis.cif#, tis.ska#, d.customerno                 00107700
     from oa1a01.VPC003A1A TIS
     left join oa1a01.VPC003A1A t1
          on TIS.TIS_UWI = t1.tis_uwi
          and   exists (                                                00110900
       SELECT *                                                         00108500
          FROM     oa1a01.VPC401A1A d                                   00108900
          where (d.customerno  = T1.CIF# AND T1.TIS_LEVEL = '2')        00110900
            or (d.safekeeping_acc_no = T1.SKA# AND T1.TIS_LEVEL = '3')  00111000
            OR (d.prospectid = T1.PROSPECT# AND T1.TIS_LEVEL = '4')     00111100
          )
     where tis.cif# in ('054304995229', '088304445786' , '083501938427',
                         '077708757104', '006803403163', '077707977500'
                       );
   where d.customerno is not null;
     exists (
       SELECT *                                                         00108500
          FROM     oa1a01.VPC401A1A d                                   00108900
     ) or exists (
       SELECT *                                                         00109100
         FROM     oa1a01.VPC400A1A PF,                                  00109500
                oa1a01.VPC402A1A ACC                                    00109600
         WHERE    PF.PORTFOLIOID = ACC.PORTFOLIOID                      00109700
           and ((ACC.CUSTOMERNO = TIS.CIF# AND TIS.TIS_LEVEL = '2')
             or (PF.SAFEKEEPINGACCNO = TIS.SKA# AND TIS.TIS_LEVEL = '3')
             or (ACC.PROSPECTID = TIS.PROSPECT# AND TIS.TIS_LEVEL ='4'))
     ) or exists (                                                      00109800
       SELECT *                                                         00109100
         FROM     oa1a01.VPC400A1A PF,
                  oa1a01.VPC403A1A GM
         WHERE    PF.PORTFOLIOID = GM.PORTFOLIOID
           and (( GM.CUSTOMERNO = TIS.CIF# AND TIS.TIS_LEVEL = '2')
             or (PF.PORTFOLIOID = TIS.SKA# AND TIS.TIS_LEVEL = '3')
             or (GM.PROSPECTID = TIS.PROSPECT# AND TIS.TIS_LEVEL ='4'))
     ) then 'existiert' else 'fehlt'
     end
     from VPC003A1A TIS
     where TIS.TIS_UWI = :vpc003pa.tis_uwi                              00111200
     WITH UR;