SELECT Id, Name FROM object p WHERE p.Status='A' AND ((COALESCE(p.Branch, '')='') OR (p.`Branch`='Operative' and not exists (select 1 from `object` p2 where p2.`NameJava`=p.`NameJava` and COALESCE(p2.Branch, '')='' and p2.`Status`='A'))) AND p.GroupId=44 AND p.ApplicationId in ('C') ORDER BY p.Name

Data Dictionary for UniCharge : First Data Rapid Connect

Objects:

First Data Rapid Connect Auth Retail Item
First Data Rapid Connect Auth Retail Transaction

First Data Rapid Connect Capture Retail Transaction
First Data Rapid Connect Retail File Batch

Retail First Data Rapid Connect Profile