CREATE SYNONYM OQCUSR.CCS_HOLD_CONSUMALBE_SN FOR MESMGR.CCS_HOLD_CONSUMALBE_SN;

CREATE SYNONYM MESUSR.CCS_HOLD_CONSUMALBE_SN FOR MESMGR.CCS_HOLD_CONSUMALBE_SN;

CREATE SYNONYM SIFUSR.CCS_HOLD_CONSUMALBE_SN FOR MESMGR.CCS_HOLD_CONSUMALBE_SN;

GRANT DELETE, INSERT, SELECT, UPDATE ON MESMGR.CCS_HOLD_CONSUMALBE_SN TO DCMGR;

GRANT DELETE, INSERT, SELECT, UPDATE ON MESMGR.CCS_HOLD_CONSUMALBE_SN TO RL_MES_RW;

GRANT DELETE, INSERT, SELECT, UPDATE ON MESMGR.CCS_HOLD_CONSUMALBE_SN TO SIFMGR;

GRANT DELETE, INSERT, SELECT, UPDATE ON MESMGR.CCS_HOLD_CONSUMALBE_SN TO MESUSR;

select *
from node
where PROCESSFLOWNAME = 'TNFM31';

INSERT INTO PROCESSFLOW (
FACTORYNAME, PROCESSFLOWNAME, PROCESSFLOWVERSION,
DESCRIPTION, CHECKSTATE, ACTIVESTATE,
CREATETIME, CREATEUSER, CHECKOUTTIME,
CHECKOUTUSER, PROCESSFLOWTYPE, SAJETID,
FINISHTYPE, FLOWCATEGORY)
SELECT FACTORYNAME, PROCESSFLOWNAME, PROCESSFLOWVERSION,
DESCRIPTION, CHECKSTATE, ACTIVESTATE,
CREATETIME, CREATEUSER, CHECKOUTTIME,
CHECKOUTUSER, PROCESSFLOWTYPE, SAJETID,
FINISHTYPE, FLOWCATEGORY
FROM PKGMGR.PROCESSFLOW@DEV_MES
where PROCESSFLOWNAME = 'TNFM31';

INSERT INTO NODE (
NODEID, NODETYPE, NODEATTRIBUTE1,
NODEATTRIBUTE2, XCOORDINATE, YCOORDINATE,
FACTORYNAME, PROCESSFLOWNAME, PROCESSFLOWVERSION)
SELECT NODEID, NODETYPE, NODEATTRIBUTE1,
NODEATTRIBUTE2, XCOORDINATE, YCOORDINATE,
FACTORYNAME, 'TNFM31', PROCESSFLOWVERSION
FROM PKGMGR.node@DEV_MES
where PROCESSFLOWNAME = 'TNFM31';

INSERT INTO PKGMGR.ARC (
FROMNODEID, TONODEID, ARCTYPE,
ARCATTRIBUTE, FACTORYNAME, PROCESSFLOWNAME,
PROCESSFLOWVERSION)
SELECT FROMNODEID, TONODEID, ARCTYPE,
ARCATTRIBUTE, FACTORYNAME, 'TNFM31',
PROCESSFLOWVERSION
FROM PKGMGR.ARC@DEV_MES
where PROCESSFLOWNAME = 'TNFM31';