Скрипт миграции

    INSERT INTO CONSENT_OPERATION (ID, CONSENT_ID, ACTION_TYPE, STATUS, PACK_NUMBER, UPDATE_TIME, TB_CODE)
    SELECT CONSENT_OPERATION_SEQ.NEXTVAL AS ID, C.ID AS CONSENT_ID,
           (CASE
               WHEN C.STATUS = 1 OR (C.STATUS = 0 AND ACTION_TYPE = 'REVOKE')
               THEN 'CONSENT'
               ELSE 'REVOKE'
           END) AS ACTION_TYPE,
           'Wait' AS STATUS,
           CONSENT_OPERATION_SEQ.NEXTVAL AS PACK_NUMBER,
           SYSDATE AS UPDATE_TIME,
           TBIDENTCODE AS TB_CODE
    FROM CONSENT C
             join CONSENT_OPERATION cp ON C.ID = cp.CONSENT_ID
             join USERINFO UI ON C.USERINFO_ID = UI.USERINFOID
             join OFFICE OFF ON UI.OFFICEID = OFF.ID
             join BRANCH B ON OFF.OWNEROFFICEID = B.ID
    WHERE C.ID NOT IN (SELECT c.ID FROM CONSENT c
    join CONSENT_OPERATION co ON c.ID = CO.CONSENT_ID)
    AND C.PPRB_USK_ID IS NULL;