Так как у меня головная организация 1 и все остальные наполняться с АД. Сделал просто выборку по ID не заморачивался с запросом.
<class id="ServiceFamily">
<scopes>
<scope id="all">
<oql_view><![CDATA[SELECT ServiceFamily AS sf JOIN Service AS s ON s.servicefamily_id = sf.id JOIN lnkCustomerContractToService AS l1 ON l1.service_id=s.id JOIN CustomerContract AS cc ON l1.customercontract_id=cc.id WHERE cc.org_id = 1]]></oql_view>
<ignore_silos>true</ignore_silos>
</scope>
</scopes>
</class>
<class id="Service">
<scopes>
<scope id="all">
<oql_view><![CDATA[SELECT Service AS s JOIN lnkCustomerContractToService AS l1 ON l1.service_id=s.id JOIN CustomerContract AS cc ON l1.customercontract_id=cc.id WHERE cc.org_id = 1 AND s.status != 'obsolete']]></oql_view>
<ignore_silos>true</ignore_silos>
</scope>
</scopes>
</class>
<class id="ServiceSubcategory">
<scopes>
<scope id="all">
<oql_view><![CDATA[SELECT ServiceSubcategory AS ssc JOIN Service AS s ON ssc.service_id=s.id JOIN lnkCustomerContractToService AS l1 ON l1.service_id=s.id JOIN CustomerContract AS cc ON l1.customercontract_id=cc.id WHERE cc.org_id = 1 AND ssc.status != 'obsolete']]></oql_view>
<ignore_silos>true</ignore_silos>
</scope>
</scopes>
</class>