delete from NOM_LIST_ITEM li
where  li.ID_LIST_GROUP = (select g.ID_LIST_GROUP
                           from   NOM_LIST_GROUP g
                           where  g.LIST_GROUP = 'REPORT_CATEGORY')
        and li.KEY_VALUE = 'SUBTOTAL';

delete from SETTING_PROFILE_PRINTER spp
where  spp.REPORT_CATEGORY = 'SUBTOTAL';

delete from RIGHT_DEFINE r
where  r.RIGHT_CODE = 'COPY_BILL_OPEN';

delete from RIGHT_GROUP_LINE r
where  r.RIGHT_CODE = 'COPY_BILL_OPEN';

update EAI_P2F_TRANSFER_LOG l
set    l.GROUP_NAME = l.STOCK_GROUP;

commit work;
