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=77 AND p.ApplicationId in ('C') ORDER BY p.Name

Data Dictionary for UniCharge : Wells Fargo

Objects:

Account Verification Wells Fargo Profile
Provisioning Wells Fargo Profile
Transaction Channel Classifier

Wells Fargo Account Verification Api Classifier
Wells Fargo Onboarding Owner
Wells Fargo Provisioning File Batch

Wells Fargo Provisioning Transaction
Wells Fargo Provisioning Transaction Response Detail