Task

use com_jur_calc
insert into objects_pointer
select objs.id_organization,objs.id_region, objs.id_city, objs.id_boiler,objs.id,objs.hot_water_from_central_heating,objs.point,null,null from (
select id_organization,id_region,id_city,id_boiler,hot_water_from_central_heating,id,row_number() over (partition by id_organization,id_boiler order by objs.name) as point from (
select id_organization,id_region,id_city,id_boiler,hot_water_from_central_heating,id,name from com_jur2021..uf_grom_objects(0,0,0,0,0,0)
union
select id_organization,id_region,id_city,id_boiler,hot_water_from_central_heating,id,name from com_jur2021..uf_grom_contract_objects(0,0,0,0,0,0)
union
Select org.id,org.id_region,0,0,0,'','-' from com_jur2021..uf_grom_organizations(0,0,0,0,0,0) org

Left Join (select id_organization,id_office,id_region
               from com_jur2021..uf_grom_contract_objects(0,0,0,0,0,0)
               union
               select id_organization,id_office,id_region
               from com_jur2021..uf_grom_objects(0,0,0,0,0,0)
               ) CO on org.id=co.id_organization and org.id_region=co.id_region 
               and co.id_office = org.id_office
              where co.id_region is null

) objs
group by id_organization,id_region,id_city,id_boiler,hot_water_from_central_heating,id,name) objs
left join com_jur_calc..objects_pointer objp on objp.id_organization = objs.id_organization and objp.id_city = objs.id_city and objp.id_boiler = objs.id_boiler and objp.id_object = objs.id
where objp.id_organization is null