SELECT   e 
FROM     businesspartner AS e 
WHERE    ( 
                  e.organization IN ('E443A31992CB4635AFCAEABE7183CE85', 
                                     '0', 
                                     '19404EAD144C49A0AF37D54377CF452D', 
                                     'B843C30461EA4501935CB1D125C9C25A') 
         AND      EXISTS 
                  ( 
                            SELECT    1 
                            FROM      rem_payment_v     AS e 
                            LEFT JOIN e.businesspartner AS i 
                            where     ( 
                                                e.organization IN ('E443A31992CB4635AFCAEABE7183CE85',
                                                                   '0', 
                                                                   '19404EAD144C49A0AF37D54377CF452D',
                                                                   'B843C30461EA4501935CB1D125C9C25A') )
                            AND       (( 
                                                          e.obselected = true 
                                                AND       e.remittance.id = :alias_1 ) 
                                      OR        ( 
                                                          e.obselected = false 
                                                AND       ( 
                                                                    e.currency.id = 
                                                                    ( 
                                                                           SELECT fa.currency.id
                                                                           FROM   fin_financial_account fa
                                                                           WHERE  fa.id=:alias_5 )
                                                          OR        rem_showalternativecurrency(:alias_2 , e.payment.id, NULL, NULL)='Y'))
                                      AND       ad_isorgincluded(e.organization.id , :alias_0 , e.client.id) <> -1
                                      AND       ( 
                                                          e.payment.receipt = 
                                                          CASE 
                                                                    WHEN 
                                                                              ( 
                                                                                     SELECT rt.paymentmethod.payinallow
                                                                                     FROM   rem_remittancetype rt
                                                                                     WHERE  rt.id = :alias_3 ) ='Y' THEN 'Y'
                                                                    ELSE 'P' 
                                                          END 
                                                OR        e.payment.receipt = 
                                                          CASE 
                                                                    WHEN 
                                                                              ( 
                                                                                     SELECT rt.paymentmethod.payoutallow
                                                                                     FROM   rem_remittancetype rt
                                                                                     WHERE  rt.id = :alias_4 ) ='Y' THEN 'N'
                                                                    ELSE 'P' 
                                                          END)) 
                            AND       i = e 
                            AND       e.organization.id IN ('E443A31992CB4635AFCAEABE7183CE85', 
                                                            '0', 
                                                            'DC206C91AA6A4897B44DA897936E0EC3', 
                                                            '7BABA5FF80494CAFA54DEBD22EC46F01', 
                                                            'BAE22373FEBE4CCCA24517E23F0C8A48', 
                                                            '19404EAD144C49A0AF37D54377CF452D', 
                                                            'B843C30461EA4501935CB1D125C9C25A', 
                                                            '2E60544D37534C0B89E765FE29BC0B43') 
                            AND       e.client.id IN ('23C59575B9CF467C9620760EB255B389', 
                                                      '0')) ) 
ORDER BY e.NAME