UPDATE ARTICLE_NZOK SET IS_FULLY_PAID = 'F'
WHERE NZOK_CODE IN
('XF100', 'XF101', 'XF102', 'XF103', 'XF106',
'XF111', 'XF113', 'XF114', 'XF116', 'XF121',
'XF122', 'XF124', 'XF125', 'XF126', 'XF127',
'XF128', 'XF129', 'XF130', 'XF131', 'XF133',
'XF135', 'XF137');
/*
03.06.2020
1
Подменена актуализация НЗОК
*/
UPDATE ARTICLE_NZOK SET IS_FULLY_PAID = 'F'
WHERE NZOK_CODE IN
('XF100', 'XF101', 'XF102', 'XF103', 'XF106',
'XF111', 'XF113', 'XF114', 'XF116', 'XF121',
'XF122', 'XF124', 'XF125', 'XF126', 'XF127',
'XF128', 'XF129', 'XF130', 'XF131', 'XF133',
'XF135', 'XF137');
UPDATE NHIF_ART_NZOK_HIST SET IS_FULLY_PAID = 'F'
WHERE NZOK_CODE IN
('XF100', 'XF101', 'XF102', 'XF103', 'XF106',
'XF111', 'XF113', 'XF114', 'XF116', 'XF121',
'XF122', 'XF124', 'XF125', 'XF126', 'XF127',
'XF128', 'XF129', 'XF130', 'XF131', 'XF133',
'XF135', 'XF137')
AND (NHIF_PERIOD_ID IN (
SELECT ID FROM NHIF_PERIOD
WHERE (START_DATE = '01.06.2020') AND (END_DATE = '15.06.2020')
));