INSERT INTO BO_CRM_CLIENT_SERDPT
(ID,
ORGNO,
BINDID,
CREATEDATE,
CREATEUSER,
UPDATEDATE,
UPDATEUSER,
WORKFLOWID,
WORKFLOWSTEPID,
ISEND,
GSID,
GSDM,
GSMC,
BMID,
BMMC,
KHBMMC,
DKHZJZH,
DKHZJXM,
SSGSDM,
SSGSMC,
KHBMBH,
KHJLZH,
KHJLXM,
KHBH)
SELECT BO_CRM_CLIENT_SERDPT_SEQ.NEXTVAL,
ORGNO,
BINDID,
CREATEDATE,
CREATEUSER,
UPDATEDATE,
UPDATEUSER,
WORKFLOWID,
WORKFLOWSTEPID,
ISEND,
GSID,
GSDM,
GSMC,
BMID,
(SELECT DEPARTMENTNAME FROM ORGDEPARTMENT WHERE ID = BMID) BMMC,
KHBMMC,
DKHZJZH,
DKHZJXM,
SSGSDM,
SSGSMC,
KHBMBH,
KHJLZH,
KHJLXM,
KHBH
FROM (SELECT ORGNO,
BINDID,
SYSDATE CREATEDATE,
'admin' CREATEUSER,
SYSDATE UPDATEDATE,
'admin' UPDATEUSER,
WORKFLOWID,
WORKFLOWSTEPID,
ISEND,
GSID,
GSDM,
GSMC,
(CASE BMID
WHEN CAST('7880' AS NVARCHAR2(100)) THEN
CAST('51876' AS NVARCHAR2(100))
WHEN CAST('7882' AS NVARCHAR2(100)) THEN
CAST('51889' AS NVARCHAR2(100))
WHEN CAST('7879' AS NVARCHAR2(100)) THEN
CAST('51893' AS NVARCHAR2(100))
WHEN CAST('7881' AS NVARCHAR2(100)) THEN
CAST('51903' AS NVARCHAR2(100))
WHEN CAST('45807' AS NVARCHAR2(100)) THEN
CAST('51907' AS NVARCHAR2(100))
WHEN CAST('32809' AS NVARCHAR2(100)) THEN
CAST('51937' AS NVARCHAR2(100))
WHEN CAST('46837' AS NVARCHAR2(100)) THEN
CAST('51942' AS NVARCHAR2(100))
WHEN CAST('45790' AS NVARCHAR2(100)) THEN
CAST('51950' AS NVARCHAR2(100))
WHEN CAST('45762' AS NVARCHAR2(100)) THEN
CAST('51963' AS NVARCHAR2(100))
WHEN CAST('45764' AS NVARCHAR2(100)) THEN
CAST('51970' AS NVARCHAR2(100))
WHEN CAST('45760' AS NVARCHAR2(100)) THEN
CAST('51979' AS NVARCHAR2(100))
WHEN CAST('45768' AS NVARCHAR2(100)) THEN
CAST('51995' AS NVARCHAR2(100))
WHEN CAST('45784' AS NVARCHAR2(100)) THEN
CAST('52002' AS NVARCHAR2(100))
WHEN CAST('45786' AS NVARCHAR2(100)) THEN
CAST('52014' AS NVARCHAR2(100))
WHEN CAST('45782' AS NVARCHAR2(100)) THEN
CAST('52022' AS NVARCHAR2(100))
WHEN CAST('7896' AS NVARCHAR2(100)) THEN
CAST('52004' AS NVARCHAR2(100))
WHEN CAST('7895' AS NVARCHAR2(100)) THEN
CAST('52016' AS NVARCHAR2(100))
WHEN CAST('45772' AS NVARCHAR2(100)) THEN
CAST('51904' AS NVARCHAR2(100))
WHEN CAST('45774' AS NVARCHAR2(100)) THEN
CAST('51911' AS NVARCHAR2(100))
WHEN CAST('45776' AS NVARCHAR2(100)) THEN
CAST('51917' AS NVARCHAR2(100))
WHEN CAST('45778' AS NVARCHAR2(100)) THEN
CAST('51921' AS NVARCHAR2(100))
WHEN CAST('45770' AS NVARCHAR2(100)) THEN
CAST('51931' AS NVARCHAR2(100))
WHEN CAST('45788' AS NVARCHAR2(100)) THEN
CAST('51936' AS NVARCHAR2(100))
WHEN CAST('7911' AS NVARCHAR2(100)) THEN
CAST('51877' AS NVARCHAR2(100))
WHEN CAST('32811' AS NVARCHAR2(100)) THEN
CAST('51879' AS NVARCHAR2(100))
WHEN CAST('32810' AS NVARCHAR2(100)) THEN
CAST('51880' AS NVARCHAR2(100))
WHEN CAST('45780' AS NVARCHAR2(100)) THEN
CAST('51882' AS NVARCHAR2(100))
WHEN CAST('46601' AS NVARCHAR2(100)) THEN
CAST('52032' AS NVARCHAR2(100))
END) BMID,
KHBMMC,
DKHZJZH,
DKHZJXM,
SSGSDM,
SSGSMC,
KHBMBH,
KHJLZH,
KHJLXM,
KHBH
FROM BO_CRM_CLIENT_SERDPT
WHERE BMID IN (7880,
7882,
7879,
7881,
45807,
32809,
46837,
45790,
45762,
45764,
45760,
45768,
45784,
45786,
45782,
7896,
7895,
45772,
45774,
45776,
45778,
45770,
45788,
7911,
32811,
32810,
45780,
46601));