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

Data Dictionary for UniCharge : Lexis Nexis

Objects:

• Ln Skip Tracing File Batch

• Ln Skip Tracing Transaction

• Skip Tracing Ln Profile