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