ERC_20_SCHEDULE

 drop table ERC_20_SCHEDULE;
 create table ERC_20_SCHEDULE as
with a as
    (select max(sh.versionnumber)as versionnumber,sh.plannumber
    from dwh_tenderPlan_20_pos_opn_d sh
    group by sh.plannumber
    )
    select distinct
        sh.customer_fullname org_name,
        sh.customer_inn org_inn,
        sh.customer_regnum org_spz,
        org.id::int org_kgntv,
        sh.plannumber,
        sh.versionnumber,
        sh.publishdate
    from dwh_tenderPlan_20_pos_opn_d sh
    join acgz_organization_ais_gz org on sh.customer_regnum = org.spz
    join a on a.plannumber=sh.plannumber and a.versionnumber=sh.versionnumber
    where sh.planyear = 2020
    --and placingway_code <>all('ZK44') --выключить все бумажные
    --and placingway_code <>all('ZK504','ZP504','OK504','OKU504')
 and org.id not in (3039,2913,31344,2998,3020,2901,3024,2994,7817,3774,29714, /*проверять новые ГУПЫ перед генерацией*/ /*select distinct org.full_name, org.id from dwh_tenderPlan_20_pos_opn_d sh  join acgz_organization_ais_gz org on sh.customer_regnum = org.spz where lower(org.full_name) like '%гуп%' or lower(org.full_name) like '%унитар%';*/ -- Прошу исключить 4 УМВД у администраций Красносельского, Кронштадтского, Петроградского, Петродворцового районов. Исключить Автономное учреждение Поликлиника № 40.
3127,3128,3132,3133,2147,3011,1556 )