АЦК. Проставить РО в БО

/* Скрипт для отбора */

SELECT b.id, 

   b.documentclass_ID, 

   b.dispstatus_id, 

   b.doc_date, 

   b.doc_number, 

   b.amount,

   'UPDATE BUDGORDER B SET B.DIRECTION_ID ='||B.DIRECTION_ID||

   ', B.DIRECTION_CODE_BUDGLEVEL = '||'"'||B.DIRECTION_CODE_BUDGLEVEL||'"'||

   --', B.DIRECTION_DIRECT_GROUP_NAME = '||B.DIRECTION_DIRECT_GROUP_NAME||

   ', B.DIRECTION_CODE_NUMBER = '||'"'||B.DIRECTION_CODE_NUMBER||'"'||

   ', B.DIRECTION_CAPTION = '||'"'||B.DIRECTION_CAPTION||'"'||

   ' where B.ID ='||B.ID||' AND B.direction_id is null;' AS FIX

  FROM BUDGORDER B

 WHERE B.budget_id IN (SELECT b2.id FROM budget b2 WHERE b2.finyear = 2020)

   AND B.documentclass_id IN (10)

   AND B.direction_id IS NOT NULL;