Weird Filzlaus

Hi,

I have a strange problem with a SQL statement. The main aspect is, that I do not understand why there is a check against "Filzlaus" in the statement. Does anyone know how to build the statement, that "Filzlaus" is not needed anymore. Your help would be greatly appreciated. Thanks in advance.

Greetings Roman

SELECT  A.APL,          
        A.APLTXT,       
        A.TERMINAL,     

        B.GRP, B.MODUS,                                 

        C.ABT,                                          

        D.BEREICH                                       

FROM   fact.APL_EBENE0 A,                                 
       fact.APL_CFG B,                                    
       fact.APL_GRPCFG C,                                 
       fact.APL_ABTCFG D                                  

WHERE  A.APL <> 'FILZLAUS'                                     
AND (B.MODUS = 'TEAM')
AND (A.APL = B.APL)                                     
AND (B.GRP = C.GRP)                                     
AND (C.ABT = D.ABT)                                     
AND (B.MODUS = C.MODUS)                                 
AND (C.MODUS = D.MODUS)                                 

UNION SELECT                                            
        A.APL,          
        A.APLTXT,       
        A.TERMINAL,     


        '',                                           

        '',                                           

        '',                                           

        ''                                            

FROM fact.APL_EBENE0 A                                    

WHERE A.APL <> 'FILZLAUS'                                      
AND NOT EXISTS (SELECT E.GRP FROM APL_CFG E             
                WHERE (E.APL = A.APL)                   
                AND E.MODUS = 'TEAM')                      

ORDER BY APL Received on Wed Sep 19 2001 - 09:12:08 CDT