SELECT A.OwnerType, A.Owner_ID, A.SubType, FO.Parent_ID FROM SYS$CCTexts A LEFT JOIN FirmOffices FO on (FO.ID=A.Owner_ID and A.OwnerType=2) WHERE A.Text LIKE '%'||:Name||'%'
Generated by ABRA Software a.s. 27.10.2021 16:35:09