/* 05.11.2020 1 Подменена актуализация от НЗОК */ UPDATE ARTICLE_NZOK AN SET AN.MEDICAL_ARTICLE_TYPE_ID = 5 WHERE AN.NZOK_CODE = 'WF110'; UPDATE MEASURE M SET M.MEASURE_NAME_ID = (SELECT FIRST 1 MN.ID FROM MEASURE_NAME MN WHERE MN.NAME LIKE '%ИНФУЗИОНЕН СЕТ%') WHERE (M.ARTICLE_ID = (SELECT FIRST 1 AN.ID FROM ARTICLE_NZOK AN WHERE (AN.NZOK_CODE = 'WF110'))) AND (M.IS_ATOMIC = 'T'); UPDATE NHIF_ART_NZOK_HIST NANH SET NANH.MEDICAL_ARTICLE_TYPE_ID = 5 WHERE (NANH.NZOK_CODE = 'WF110') AND (NANH.NHIF_PERIOD_ID IN (SELECT SP.PERIOD_ID FROM SP_GET_NHIF_PERIOD('01.11.2020') SP));