select t1.code from locations as t1 left join  case_category_code as t2 on t1.code=t2.location_code where t2.location_code is NULL;
select t1.code from locations as t1 left join  party_type_codes as t2 on t1.code=t2.location_code where t2.location_code is NULL;
select t1.code from locations as t1 left join  party_type_codes as t2 on t1.code=t2.location_code where t2.location_code is NULL;
select t1.code from locations as t1 left join  case_type_codes as t2 on t1.code=t2.location_code where t2.location_code is NULL;
select t1.code from locations as t1 left join  document_type_codes as t2 on t1.code=t2.location_code where t2.location_code is NULL;
select t1.code from locations as t1 left join  file_type_codes as t2 on t1.code=t2.location_code where t2.location_code is NULL;
select t1.code from locations as t1 left join  filing_component_codes as t2 on t1.code=t2.location_code where t2.location_code is NULL;
select t1.code from locations as t1 left join  filer_type_codes as t2 on t1.code=t2.location_code where t2.location_code is NULL;
select t1.code from locations as t1 left join  filing_codes as t2 on t1.code=t2.location_code where t2.location_code is NULL;
