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

Data Dictionary for UniCharge : Provisioning

Objects:

Connectivity Mode Classifier
Onboarding Operation Classifier
Onboarding Vantiv Tandem Profile
Paymentech Provisioning File Batch
Paymentech Provisioning Transaction

Provisioning Additional Field
Provisioning Field Type Classifier
Provisioning Paymentech Profile
Provisioning Profile
Provisioning Transaction

Provisioning Transaction Response Detail
Provisioning Transaction Response Detail Status Classifier
Provisioning Verification Result