Script-reativa-declaracoes_omissao.sql 744 Bytes
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12
begin;
update par.omissodeclarado set odestatus = 'A' where prpid in(
  '11910', '12174', '13292', '21729', '1394', '7881', '22931', '13871', '6508', '11917', '24169',
  '4484', '14192', '13852', '18797', '1289', '23614', '2685', '6466', '11378', '22801', '10607',
  '23068', '23629', '2213', '4056', '5435', '3777', '9447', '963', '8375', '2680', '3817', '6047',
  '3201', '8638', '4301', '10488', '21730', '23385', '5130', '12935', '19040', '2661', '13799',
  '17779', '5363', '7125', '4394', '2244', '6388', '2240', '21682', '21240', '9909', '16744',
  '19516', '4204', '8924', '22248', '21723', '2541', '15439', '23254', '23609', '12219', '12131',
  '5427', '9431', '22156', '21796', '1468', '18118', '13975'
) and odestatus = 'I';

commit;