Update ESU and ASU  DV from  PD
in Planner (E1Local Oracle Database

delete from JDESY910.F9671 where SDSUDFUT2 in ('DV910');
COMMIT;

CREATE TABLE JDEsy910.F9671_BKP AS SELECT * FROM JDESY910.F9671 where SDSUDFUT2='PD910' and SDPKGNAME not in (select SDPKGNAME from JDEsy910.F9671 where SDSUDFUT2='DV910');

UPDATE JDEsy910.F9671_BKP set SDSUDFUT2='DV910';
COMMIT;

insert into JDEsy910.F9671 select * from JDEsy910.F9671_BKP;
COMMIT;
DROP TABLE JDESY910.F9671_BKP;

delete from JDESY910.F9672 where SUPATHCD in ('DV910');

CREATE TABLE JDEsy910.F9672_BKP AS SELECT * from JDEsy910.F9672 where SUPATHCD='PD910' and SUPKGNAME not in (select SUPKGNAME from JDEsy910.F9672 where SUPATHCD='DV910');

UPDATE JDEsy910.F9672_BKP set SUPATHCD='DV910';
COMMIT;

insert into JDEsy910.F9672 select * from JDEsy910.F9672_BKP;
COMMIT;
DROP TABLE JDESY910.F9672_BKP;