delete来自wf define where id数据模型caozheng.pdfVIP

报告人隶属于运营人田立志

模..块名审核流程

表名

改动描述：

deletefromb2c_wf_definewherewf_idin

(,);

Insertintob2c_wf_define

(WF_ID,WF_NAME,WF_CODE,STATUS,CREATE_DATE,REMARKS,CHANN

EL_TYPE,BUS_ID,STEP)values(,争议处理审核流程

,077,1,to_timestamp(17-2月-1409.36.59.784000000上午,DD-MON-RR

HH.MI.SS.FFAM),null,1,BUS_WF_077,1);

Insertintob2c_wf_define

(WF_ID,WF_NAME,WF_CODE,STATUS,CREATE_DATE,REMARKS,CHANN

EL_TYPE,BUS_ID,STEP)values(,争议处理审核流程[免

审],077_0,1,to_timestamp(17-2月-1409.36.59.784000000上午

,DD-MON-RRHH.MI.SS.FFAM),null,1,BUS_WF_077,0);

commit;

deletefromB2C_WF_BUSINESSwhereBUSINESS_ID

in(BUS_WF_077,BUS_WF_077_0);

InsertintoB2C_WF_BUSINESS

(BUSINESS_ID,BUSINESS_NAME,CREATE_DATE,STATUS,REMARKS,BUS

_TYPE)values(BUS_WF_077,争议处理审核流程,to_timestamp(17-2月-14

09.36.59.784000000上午,DD-MON-RRHH.MI.SS.FFAM),1,争议处理审核

流程,1);

commit;

deletefromB2C_WF_BUS_USEwhereUSE_IDin(20140217001);

InsertintoB2C_WF_BUS_USE

(USE_ID,BUS_ID,WF_ID,UPDATE_DATE,REMARKS,vendorid)values

(20140217001,BUS_WF_077,,to_timestamp(17-2月

-1409.36.59.784000000上午,DD-MON-RRHH.MI.SS.FFAM),争议处理审核

流程,-1);

commit;