-- wace_plm public.comm_code 전체 시드 (733 rows)
-- objid 가 같은 행은 건너뜀(ON CONFLICT 처럼). 우리 comm_code.objid 는 PRIMARY KEY 가 아닐 수도 있으므로
-- NOT EXISTS 패턴으로 멱등 처리.
BEGIN;
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1857525443::numeric, '0000001', '', '제품구분', NULL, NULL, NULL, 'plm_admin', '2021-09-14 22:52:24.160445'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1857525443::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 707772523::numeric, '0000867', '0000211', '유압식코일러', NULL, NULL, 'HC', 'plm_admin', '2022-10-06 14:48:42.821182'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 707772523::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -262230619::numeric, '0000866', '0000211', '전기로', NULL, NULL, 'ELS', 'plm_admin', '2022-10-06 14:48:04.614803'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -262230619::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -528089026::numeric, '0000898', '0000286', '가변형용마루', NULL, NULL, 'VR', 'plm_admin', '2022-10-07 15:14:36.561706'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -528089026::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1891770398::numeric, '0000899', '0000286', '기와형용마루', NULL, NULL, 'RFR', 'plm_admin', '2022-10-07 15:15:00.959724'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1891770398::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -226353357::numeric, '0000904', '0000286', '엘보성형기', NULL, NULL, 'EF', 'plm_admin', '2022-10-07 15:17:37.048926'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -226353357::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1824072545::numeric, '0000906', '0000286', 'G/I U-BAR 성형기', NULL, NULL, 'GI', 'plm_admin', '2022-10-07 15:18:47.265367'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1824072545::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1310317843::numeric, '0000922', '0000921', '견적', NULL, NULL, '', 'plm_admin', '2022-11-08 17:08:41.285629'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1310317843::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -54399237::numeric, '0000923', '0000921', '계약완료', NULL, NULL, '', 'plm_admin', '2022-11-08 17:08:57.923946'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -54399237::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -636096691::numeric, '0000039', '', '생산여부', NULL, NULL, NULL, 'plm_admin', '2021-09-14 23:43:57.296616'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -636096691::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1024083923::numeric, '0000040', '0000039', '생산중', NULL, NULL, NULL, 'plm_admin', '2021-09-14 23:44:24.245691'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1024083923::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1954035611::numeric, '0000063', '0000062', '구매품', NULL, NULL, NULL, 'plm_admin', '2021-09-22 22:58:45.677252'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1954035611::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1309708239::numeric, '0000059', '', 'UNIT', NULL, NULL, NULL, 'plm_admin', '2021-09-22 22:53:37.918916'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1309708239::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1848810573::numeric, '0000060', '0000059', 'EA', NULL, NULL, NULL, 'plm_admin', '2021-09-22 22:53:56.914392'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1848810573::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1640776736::numeric, '0000061', '0000059', 'SET', NULL, NULL, NULL, 'plm_admin', '2021-09-22 22:54:08.52198'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1640776736::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1657129948::numeric, '0000062', '', 'PART TYPE', NULL, NULL, NULL, 'plm_admin', '2021-09-22 22:58:25.866346'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1657129948::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -578691653::numeric, '0001132', '0001071', '업체검사', NULL, NULL, '', 'plm_admin', '2023-02-06 13:14:34.527144'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -578691653::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -321685446::numeric, '0001133', '0001071', '검사성적서', NULL, NULL, '', 'plm_admin', '2023-02-06 13:14:51.9266'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -321685446::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1746459102::numeric, '0001204', '', '재고구분', NULL, NULL, '', 'plm_admin', '2023-02-15 11:21:20.922055'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1746459102::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1247937789::numeric, '0001222', '0000959', 'CW, CCW', NULL, NULL, '', 'plm_admin', '2023-03-02 13:49:10.207209'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1247937789::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 519567799::numeric, '0000041', '0000039', '중단(AS중)', NULL, NULL, NULL, 'plm_admin', '2021-09-14 23:44:33.613936'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 519567799::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -45728191::numeric, '0001398', '0000062', '사내제작품', NULL, NULL, '', 'plm_admin', '2023-03-22 17:14:01.206444'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -45728191::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1828754132::numeric, '0000099', '', '설변요청상태', NULL, NULL, NULL, 'plm_admin', '2021-11-08 22:44:28.630101'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1828754132::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -2071821134::numeric, '0000100', '0000099', '작성중', NULL, NULL, NULL, 'plm_admin', '2021-11-08 22:44:45.912747'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -2071821134::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 430440792::numeric, '0000101', '0000099', '결재중', NULL, NULL, NULL, 'plm_admin', '2021-11-08 22:45:01.778211'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 430440792::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1713079444::numeric, '0000130', '', '상태', NULL, NULL, NULL, 'plm_admin', '2021-11-22 05:54:16.879613'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1713079444::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1572197287::numeric, '0000087', '0000039', '단종(AS종료)', NULL, NULL, NULL, 'plm_admin', '2021-11-03 11:13:23.801494'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1572197287::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1694033122::numeric, '0000107', '0000099', '반려', NULL, NULL, NULL, 'plm_admin', '2021-11-13 04:00:08.124091'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1694033122::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1716783343::numeric, '0001527', '', '템플릿', NULL, NULL, '', 'plm_admin', '2023-05-10 13:51:28.014329'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1716783343::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1333820635::numeric, '0001556', '', '경비신청출장목적', NULL, NULL, '', 'plm_admin', '2023-11-13 13:33:40.725156'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1333820635::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1295551863::numeric, '0000065', '0000062', '사급품', NULL, NULL, NULL, 'plm_admin', '2021-09-22 22:59:22.851318'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1295551863::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -237318046::numeric, '0001536', '0001533', '위안(¥)', NULL, NULL, '', 'plm_admin', '2023-08-01 13:11:40.505271'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -237318046::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 991406908::numeric, '0001537', '0001533', '엔(¥)', NULL, NULL, '', 'plm_admin', '2023-08-01 13:11:44.922407'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 991406908::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1484059::numeric, '0001541', '', '경비신청구분', NULL, NULL, '', 'plm_admin', '2023-11-13 11:11:54.45644'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1484059::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -626962363::numeric, '0001599', '0000318', '자재수급', NULL, NULL, '', 'plm_admin', '2023-11-29 09:28:58.223918'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -626962363::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 744033284::numeric, '0001550', '', '경비신청지역', NULL, NULL, '', 'plm_admin', '2023-11-13 13:26:16.605131'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 744033284::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 2135803131::numeric, '0001554', '0001553', '경비신청이용차량1', NULL, NULL, '', 'plm_admin', '2023-11-13 13:33:19.701397'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 2135803131::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1880099719::numeric, '0001555', '0001553', '경비신청이용차량2', NULL, NULL, '', 'plm_admin', '2023-11-13 13:33:24.388941'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1880099719::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 978477144::numeric, 'EXPS6200', 'EXPS6000', '계정과목2', NULL, NULL, '', 'plm_admin', '2023-11-13 11:34:34.438598'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 978477144::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 362806729::numeric, '0000131', '0000130', '작성중', NULL, NULL, NULL, 'plm_admin', '2021-11-22 05:54:30.323804'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 362806729::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1662936142::numeric, '0000132', '0000130', '배포완료', NULL, NULL, NULL, 'plm_admin', '2021-11-22 05:54:50.467797'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1662936142::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1252581138::numeric, '0000133', '0000130', '결재중', NULL, NULL, NULL, 'plm_admin', '2021-11-22 05:55:05.729367'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1252581138::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 841845254::numeric, '0000134', '0000130', '결재완료', NULL, NULL, NULL, 'plm_admin', '2021-11-22 05:55:20.608171'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 841845254::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -2021201972::numeric, '0000135', '0000130', '반려', NULL, NULL, NULL, 'plm_admin', '2021-11-22 05:55:42.659423'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -2021201972::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1978598697::numeric, '0001592', '0000963', '진행중', NULL, NULL, '', 'plm_admin', '2023-11-23 15:00:49.157284'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1978598697::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1165287961::numeric, 'EXPS6100', 'EXPS6000', '계정과목1', NULL, NULL, '', 'plm_admin', '2023-11-13 11:34:27.960054'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1165287961::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -140277130::numeric, '0000140', '', 'AS접수유형', NULL, NULL, NULL, 'plm_admin', '2021-12-01 01:42:34.311683'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -140277130::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1141098308::numeric, '0000141', '0000140', '고장(작동오류/파손)', NULL, NULL, NULL, 'plm_admin', '2021-12-01 01:43:05.488995'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1141098308::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1082435690::numeric, '0000144', '0000140', '정기점검', NULL, NULL, NULL, 'plm_admin', '2021-12-01 02:19:17.581511'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1082435690::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1123372687::numeric, '0000145', '0000140', '사고', NULL, NULL, NULL, 'plm_admin', '2021-12-01 02:19:29.728915'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1123372687::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -397676461::numeric, '0000146', '0000140', '단순점검', NULL, NULL, NULL, 'plm_admin', '2021-12-01 02:19:43.890265'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -397676461::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1811394462::numeric, '0000147', '0000140', '추가작업', NULL, NULL, NULL, 'plm_admin', '2021-12-01 02:20:03.385472'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1811394462::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -332995738::numeric, '0000148', '', '요금지불방식', NULL, NULL, NULL, 'plm_admin', '2021-12-01 02:23:37.740771'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -332995738::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 723030133::numeric, '0000149', '0000148', '현금', NULL, NULL, NULL, 'plm_admin', '2021-12-01 02:23:52.264296'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 723030133::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1298034126::numeric, '0000150', '0000148', '카드', NULL, NULL, NULL, 'plm_admin', '2021-12-01 02:24:04.216198'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1298034126::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1669487202::numeric, '0000151', '0000148', '계좌이체', NULL, NULL, NULL, 'plm_admin', '2021-12-01 02:24:14.475845'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1669487202::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -946050220::numeric, '0000152', '0000148', '미수', NULL, NULL, NULL, 'plm_admin', '2021-12-01 02:24:27.406988'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -946050220::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1946993030::numeric, '0000153', '0000148', '세금계산서', NULL, NULL, NULL, 'plm_admin', '2021-12-01 02:24:38.725575'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1946993030::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1079260757::numeric, '0000157', '0000156', '유상', NULL, NULL, NULL, 'plm_admin', '2021-12-02 20:15:57.623077'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1079260757::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 809500980::numeric, '0000868', '0000211', '리와인더', NULL, NULL, 'RW', 'plm_admin', '2022-10-06 14:49:41.55956'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 809500980::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1791744401::numeric, '0000156', '', '유/무상', NULL, NULL, NULL, 'plm_admin', '2021-12-02 20:15:46.601467'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1791744401::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1852119859::numeric, '0000158', '0000156', '무상', NULL, NULL, NULL, 'plm_admin', '2021-12-02 20:16:15.531933'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1852119859::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1600124099::numeric, '0000930', '0000001', '이차전지', NULL, NULL, 'RSA1', 'plm_admin', '2022-12-07 07:07:09.501452'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1600124099::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1508357043::numeric, '0001600', '0000318', '제작불가', NULL, NULL, '', 'plm_admin', '2023-11-29 09:29:07.072719'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1508357043::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -468250804::numeric, '0001601', '0000318', '타부품변경', NULL, NULL, '', 'plm_admin', '2023-11-29 09:29:57.780491'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -468250804::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1457602057::numeric, '0001604', '0001603', '재발주', NULL, NULL, '', 'plm_admin', '2023-12-05 14:51:44.304175'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1457602057::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1273320718::numeric, '0001605', '0001603', '설계오류', NULL, NULL, '', 'plm_admin', '2023-12-05 14:52:04.06145'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1273320718::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1022866975::numeric, '0001606', '0001603', '업체요청', NULL, NULL, '', 'plm_admin', '2023-12-05 14:52:22.876274'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1022866975::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -509328014::numeric, '0001607', '0001603', '부품손실', NULL, NULL, '', 'plm_admin', '2023-12-05 14:52:40.744166'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -509328014::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1140799212::numeric, '0001608', '0001603', '추가구입', NULL, NULL, '', 'plm_admin', '2023-12-05 14:52:49.076727'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1140799212::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -60583969::numeric, '0001611', '', '이슈구분', NULL, NULL, '', 'plm_admin', '2023-12-15 12:10:13.234749'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -60583969::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 986910714::numeric, '0000912', '0000848', '레벨링기', NULL, NULL, 'LEV', 'plm_admin', '2022-10-07 15:21:26.180131'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 986910714::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -757105474::numeric, '0000280', '0000172', '경상북도', NULL, NULL, NULL, 'plm_admin', '2022-07-08 01:07:14.588687'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -757105474::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -356159934::numeric, '0001616', '0001615', '재고사용', NULL, NULL, '', 'plm_admin', '2023-12-15 12:14:54.514621'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -356159934::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -880874999::numeric, '0000085', '0000062', '표준품', NULL, NULL, NULL, 'plm_admin', '2021-10-22 11:04:40.5862'::timestamp, 'inActive
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -880874999::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1339968928::numeric, '0000913', '0000848', '자동적재장치', NULL, NULL, 'AS', 'plm_admin', '2022-10-07 15:21:48.979003'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1339968928::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1382001450::numeric, '0000161', '0000160', '크레인', NULL, NULL, NULL, 'plm_admin', '2021-12-07 19:14:55.618105'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1382001450::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1203559326::numeric, '0000162', '0000160', '기중기', NULL, NULL, NULL, 'plm_admin', '2021-12-07 19:15:39.584477'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1203559326::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -293841303::numeric, '0000163', '0000160', '특장차', NULL, NULL, NULL, 'plm_admin', '2021-12-07 19:15:54.556115'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -293841303::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -252310994::numeric, '0000164', '', '정비업체명', NULL, NULL, NULL, 'plm_admin', '2022-01-07 05:46:46.779072'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -252310994::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 162498854::numeric, '0000165', '0000164', '테스트업체01', NULL, NULL, NULL, 'plm_admin', '2022-01-07 05:46:58.248351'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 162498854::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1628435898::numeric, '0000166', '0000164', '테스트업체02', NULL, NULL, NULL, 'plm_admin', '2022-01-07 05:47:15.634765'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1628435898::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 977012385::numeric, '0000167', '', '계약구분', NULL, NULL, NULL, 'plm_admin', '2022-03-18 21:45:19.302673'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 977012385::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1916356499::numeric, '0000263', '0000262', 'SHSE_1F_A1', NULL, NULL, '', 'plm_admin', '2022-06-23 18:00:45.929987'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1916356499::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -2048586742::numeric, '0000172', '', '지역', NULL, NULL, NULL, 'plm_admin', '2022-03-18 23:53:08.630846'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -2048586742::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 2085053440::numeric, '0000173', '0000172', '서울특별시', NULL, NULL, NULL, 'plm_admin', '2022-03-19 01:15:06.214351'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 2085053440::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 356375361::numeric, '0000174', '0000172', '경기도', NULL, NULL, NULL, 'plm_admin', '2022-03-19 01:15:23.052453'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 356375361::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1831661413::numeric, '0000182', '', '계약제품구분', NULL, NULL, NULL, 'plm_admin', '2022-03-22 12:40:15.265562'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1831661413::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1076692609::numeric, '0000183', '0000182', '완제품', NULL, NULL, NULL, 'plm_admin', '2022-03-22 15:21:44.798267'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1076692609::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 542827729::numeric, '0000184', '0000182', '반제품', NULL, NULL, NULL, 'plm_admin', '2022-03-22 15:21:57.678567'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 542827729::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1559273415::numeric, '0000185', '', '보증기간', NULL, NULL, NULL, 'plm_admin', '2022-03-22 15:24:43.64301'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1559273415::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 2027969831::numeric, '0000186', '0000185', '1년', NULL, NULL, NULL, 'plm_admin', '2022-03-22 15:24:54.231261'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 2027969831::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1549651363::numeric, '0000187', '0000185', '2년', NULL, NULL, NULL, 'plm_admin', '2022-03-22 15:25:05.90886'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1549651363::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1174619802::numeric, '0000188', '0000185', '3년', NULL, NULL, NULL, 'plm_admin', '2022-03-22 15:28:51.816973'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1174619802::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1184934536::numeric, '0000189', '0000185', '5년', NULL, NULL, NULL, 'plm_admin', '2022-03-22 15:29:03.86664'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1184934536::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1585261401::numeric, '0000190', '0000185', '10년', NULL, NULL, NULL, 'plm_admin', '2022-03-22 15:29:15.122038'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1585261401::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1688722662::numeric, '0000914', '0000848', '샌드판넬절단기', NULL, NULL, 'SS', 'plm_admin', '2022-10-07 15:22:19.138536'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1688722662::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -562001191::numeric, '0000192', '', '자금관리 상태', NULL, NULL, NULL, 'plm_admin', '2022-03-27 16:11:03.541239'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -562001191::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 846703904::numeric, '0000193', '0000192', '미입금', NULL, NULL, NULL, 'plm_admin', '2022-03-27 16:11:24.8934'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 846703904::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1784735128::numeric, '0000194', '0000192', '계약금 입금', NULL, NULL, NULL, 'plm_admin', '2022-03-27 16:11:44.708147'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1784735128::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -357040226::numeric, '0000195', '0000192', '중도금(1차) 입금', NULL, NULL, NULL, 'plm_admin', '2022-03-27 16:12:09.517151'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -357040226::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -915575360::numeric, '0000196', '0000192', '중도금(2차) 입금', NULL, NULL, NULL, 'plm_admin', '2022-03-27 16:12:26.009159'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -915575360::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -624522927::numeric, '0000197', '0000192', '잔금입금', NULL, NULL, NULL, 'plm_admin', '2022-03-27 16:12:40.767429'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -624522927::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -452014780::numeric, '0000198', '0000192', '완불', NULL, NULL, NULL, 'plm_admin', '2022-03-27 16:13:00.378899'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -452014780::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 903898903::numeric, '0000199', '', '출고관리 상태', NULL, NULL, NULL, 'plm_admin', '2022-03-27 17:39:48.458074'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 903898903::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 963652142::numeric, '0000200', '0000199', '진행중', NULL, NULL, NULL, 'plm_admin', '2022-03-27 17:39:58.877267'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 963652142::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 311035666::numeric, '0000201', '0000199', '출고완료', NULL, NULL, NULL, 'plm_admin', '2022-03-27 17:40:13.92609'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 311035666::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 2086500874::numeric, '0000202', '', '계약상태', NULL, NULL, NULL, 'plm_admin', '2022-03-28 21:46:19.027286'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 2086500874::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1015289640::numeric, '0000231', '0000004', 'V-250 성형기', NULL, NULL, 'V2', 'plm_admin', '2022-04-01 11:35:51.102254'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1015289640::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1184117817::numeric, '0000232', '0000004', 'V-115 성형기', NULL, NULL, 'V1', 'plm_admin', '2022-04-01 11:36:12.168773'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1184117817::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 2139792931::numeric, '0000233', '0000004', 'V-115,250 복합성형기', NULL, NULL, 'DV', 'plm_admin', '2022-04-01 11:36:32.455864'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 2139792931::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1271223202::numeric, '0000234', '0000004', 'C-76 성형기', NULL, NULL, 'C76', 'plm_admin', '2022-04-01 11:36:49.995623'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1271223202::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -245946727::numeric, '0000235', '', '생산구분', NULL, NULL, NULL, 'plm_admin', '2022-05-11 21:49:10.642818'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -245946727::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1839036032::numeric, '0000236', '0000235', '계약생산', NULL, NULL, NULL, 'plm_admin', '2022-05-11 21:49:28.70486'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1839036032::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -321544004::numeric, '0000237', '0000235', '계획생산', NULL, NULL, NULL, 'plm_admin', '2022-05-11 21:49:42.117187'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -321544004::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1963537746::numeric, '0000883', '0000004', '미시성형기', NULL, NULL, 'M', 'plm_admin', '2022-10-06 15:03:07.940275'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1963537746::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 227610418::numeric, '0000243', '0000241', '외작', NULL, NULL, NULL, 'plm_admin', '2022-05-17 23:57:40.457017'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 227610418::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1361687167::numeric, '0000241', '', '구매 제품 구분', NULL, NULL, NULL, 'plm_admin', '2022-05-17 23:47:29.262767'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1361687167::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -33282031::numeric, '0000242', '0000241', '내작', NULL, NULL, NULL, 'plm_admin', '2022-05-17 23:56:07.331356'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -33282031::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1786850992::numeric, '0000873', '0000004', 'C-47 성형기', NULL, NULL, 'C47', 'plm_admin', '2022-10-06 14:58:28.396174'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1786850992::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 208734313::numeric, '0000245', '0000244', '생산의뢰서', NULL, NULL, NULL, 'plm_admin', '2022-05-23 13:39:55.223221'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 208734313::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1802427907::numeric, '0000247', '', '불량코드', NULL, NULL, NULL, 'plm_admin', '2022-05-31 19:42:29.412267'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1802427907::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -527444528::numeric, '0000248', '0000247', '조립불량', NULL, NULL, NULL, 'plm_admin', '2022-05-31 19:44:57.775721'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -527444528::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1022374167::numeric, '0000250', '0000249', '검사성적서', NULL, NULL, NULL, 'plm_admin', '2022-06-01 13:27:03.442991'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1022374167::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 393170155::numeric, '0000203', '0000202', '계약진행', NULL, NULL, NULL, 'plm_admin', '2022-03-28 21:46:40.323461'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 393170155::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 27960875::numeric, '0000204', '0000202', '계약완료', NULL, NULL, NULL, 'plm_admin', '2022-03-28 21:46:51.211133'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 27960875::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -598830289::numeric, '0000205', '0000202', '계약지연', NULL, NULL, NULL, 'plm_admin', '2022-03-28 21:47:04.493744'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -598830289::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1695284181::numeric, '0000254', '0000202', '계약대기', NULL, NULL, NULL, 'plm_admin', '2022-06-16 17:10:00.054013'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1695284181::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1529160928::numeric, '0001205', '0001204', '잉여', NULL, NULL, '', 'plm_admin', '2023-02-15 11:21:38.710336'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1529160928::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1187441648::numeric, '0000266', '0000262', 'SHSE_1F_A4', NULL, NULL, '', 'plm_admin', '2022-06-23 18:01:11.496283'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1187441648::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1670506926::numeric, '0000264', '0000262', 'SHSE_1F_A2', NULL, NULL, '', 'plm_admin', '2022-06-23 18:01:01.114054'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1670506926::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 2053500542::numeric, '0000265', '0000262', 'SHSE_1F_A3', NULL, NULL, '', 'plm_admin', '2022-06-23 18:01:46.522109'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 2053500542::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1001213427::numeric, '0000259', '', '접수 승인 여부', NULL, NULL, NULL, 'plm_admin', '2022-06-23 03:23:40.504211'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1001213427::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1998051364::numeric, '0000260', '0000259', '승인', NULL, NULL, NULL, 'plm_admin', '2022-06-23 03:23:51.975592'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1998051364::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -130620782::numeric, '0000261', '0000259', '기각', NULL, NULL, NULL, 'plm_admin', '2022-06-23 03:24:01.832752'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -130620782::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1334821736::numeric, '0000262', '', 'Location', NULL, NULL, NULL, 'plm_admin', '2022-06-23 18:00:33.051562'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1334821736::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 248429530::numeric, '0000881', '0000004', '기와,소골 성형기', NULL, NULL, 'RFT', 'plm_admin', '2022-10-06 15:02:37.480665'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 248429530::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -507553492::numeric, '0001140', '0000972', '부품파손', NULL, NULL, '', 'plm_admin', '2023-02-06 15:35:48.15391'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -507553492::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1744919090::numeric, '0000271', '0000172', '인천광역시', NULL, NULL, NULL, 'plm_admin', '2022-07-08 01:04:33.452076'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1744919090::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 912867468::numeric, '0000272', '0000172', '대전광역시', NULL, NULL, NULL, 'plm_admin', '2022-07-08 01:04:49.015121'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 912867468::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -182063070::numeric, '0000273', '0000172', '대구광역시', NULL, NULL, NULL, 'plm_admin', '2022-07-08 01:05:11.100478'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -182063070::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1242498140::numeric, '0000274', '0000172', '광주광역시', NULL, NULL, NULL, 'plm_admin', '2022-07-08 01:05:24.341947'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1242498140::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -791210630::numeric, '0000275', '0000172', '부산광역시', NULL, NULL, NULL, 'plm_admin', '2022-07-08 01:05:43.819002'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -791210630::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1391492564::numeric, '0000276', '0000172', '울산광역시', NULL, NULL, NULL, 'plm_admin', '2022-07-08 01:06:03.074129'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1391492564::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1072325744::numeric, '0000277', '0000172', '강원도', NULL, NULL, NULL, 'plm_admin', '2022-07-08 01:06:19.876714'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1072325744::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1942831984::numeric, '0000170', '0000167', '오버홀', NULL, NULL, '', 'plm_admin', '2022-03-18 21:46:19.549503'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1942831984::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 2028981346::numeric, '0000171', '0000167', '개조', NULL, NULL, '', 'plm_admin', '2022-03-18 21:46:29.677783'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 2028981346::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1234888758::numeric, '0001206', '0001204', '불용', NULL, NULL, '', 'plm_admin', '2023-02-15 11:21:45.944839'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1234888758::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -968499191::numeric, '0001207', '', '발생사유', NULL, NULL, '', 'plm_admin', '2023-02-15 11:22:18.083484'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -968499191::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1320463040::numeric, '0001208', '0001207', '구매오류', NULL, NULL, '', 'plm_admin', '2023-02-15 11:22:32.379305'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1320463040::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 650253293::numeric, '0001209', '0001207', '설계오류', NULL, NULL, '', 'plm_admin', '2023-02-15 11:22:39.294647'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 650253293::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -544415809::numeric, '0001210', '0001207', '가공오류', NULL, NULL, '', 'plm_admin', '2023-02-15 11:22:47.130609'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -544415809::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1175162871::numeric, '0000278', '0000172', '충청북도', NULL, NULL, NULL, 'plm_admin', '2022-07-08 01:06:44.857755'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1175162871::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -846046304::numeric, '0000279', '0000172', '충청남도', NULL, NULL, NULL, 'plm_admin', '2022-07-08 01:06:56.571837'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -846046304::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1085584382::numeric, '0000281', '0000172', '경상남도', NULL, NULL, NULL, 'plm_admin', '2022-07-08 01:07:31.086641'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1085584382::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 66529858::numeric, '0000282', '0000172', '전라남도', NULL, NULL, NULL, 'plm_admin', '2022-07-08 01:07:44.950513'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 66529858::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1547388396::numeric, '0000283', '0000172', '제주도', NULL, NULL, NULL, 'plm_admin', '2022-07-08 01:08:12.278945'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1547388396::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1927899977::numeric, '0000284', '0000172', '전라북도', NULL, NULL, NULL, 'plm_admin', '2022-07-08 01:08:28.68669'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1927899977::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -718865856::numeric, '0000887', '0000004', '각판넬 성형기(루버)', NULL, NULL, 'RV', 'plm_admin', '2022-10-06 15:04:06.569917'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -718865856::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -958603007::numeric, '0001141', '0000972', '사양미반영', NULL, NULL, '', 'plm_admin', '2023-02-06 15:37:08.093869'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -958603007::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 2099767321::numeric, '0000211', '0000918', '전기로', NULL, NULL, 'OV', 'plm_admin', '2022-03-30 14:39:37.400693'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 2099767321::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 175630711::numeric, '0000288', '0000286', '물받이성형기', NULL, NULL, 'WS', 'plm_admin', '2022-07-10 12:04:29.050259'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 175630711::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -631487476::numeric, '0000287', '0000286', 'L-BAR성형기', NULL, NULL, 'LB', 'plm_admin', '2022-07-10 12:04:02.196999'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -631487476::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1436244339::numeric, '0000915', '0000848', '간이형 쓰리팅라인 및 리와인더', NULL, NULL, 'SSRE', 'plm_admin', '2022-10-07 15:22:41.222212'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1436244339::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1964726942::numeric, '0000286', '0000918', '부자재성형기', NULL, NULL, 'SM', 'plm_admin', '2022-07-10 12:03:29.429225'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1964726942::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1842416039::numeric, '0000102', '0000099', '적용완료', NULL, NULL, NULL, 'plm_admin', '2021-11-08 22:45:14.578393'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1842416039::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1249714492::numeric, '0000295', '0000172', '세종특별자치시', NULL, NULL, NULL, 'plm_admin', '2022-07-15 21:15:21.448763'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1249714492::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -2032406105::numeric, '0000875', '0000004', 'V-333 성형기', NULL, NULL, 'V3', 'plm_admin', '2022-10-06 15:00:01.852309'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -2032406105::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1889374067::numeric, '0001211', '0001207', '사양변경', NULL, NULL, '', 'plm_admin', '2023-02-15 11:22:54.847973'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1889374067::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 542277393::numeric, '0001636', '0001399', 'BAG', NULL, NULL, '', 'plm_admin', '2024-02-08 10:47:33.392168'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 542277393::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -809610540::numeric, '0001399', '', '단위', NULL, NULL, '', 'plm_admin', '2023-03-24 13:10:26.00331'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -809610540::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1845753202::numeric, '0000318', '', '설변사유', NULL, NULL, '', 'plm_admin', '2022-07-26 13:36:42.500376'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1845753202::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 2103934203::numeric, '0000877', '0000004', 'C형강성형기', NULL, NULL, 'C', 'plm_admin', '2022-10-06 15:00:51.703166'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 2103934203::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -733108517::numeric, '0001637', '0000318', '파트삭제', NULL, NULL, '', 'plm_admin', '2023-12-18 17:12:03.16'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -733108517::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1703801146::numeric, '0900104', '', '지시사항 이행관리 분류', NULL, NULL, NULL, 'plm_admin', '2021-11-18 02:56:51.054'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1703801146::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1268937872::numeric, '0900206', '0900102', '경영진 이슈사항', NULL, NULL, NULL, 'plm_admin', '2022-05-30 13:43:38.17'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1268937872::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 503928516::numeric, '0001528', '0001527', '검사성적서', NULL, NULL, '', 'plm_admin', '2023-05-10 13:52:39.925469'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 503928516::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1635503604::numeric, '0001538', '0001068', '잡자재', NULL, NULL, '', 'plm_admin', '2023-08-31 14:18:56.676289'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1635503604::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1434579696::numeric, '0000879', '0000004', '사선판성형기', NULL, NULL, 'F', 'plm_admin', '2022-10-06 15:01:53.3287'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1434579696::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 852892908::numeric, '0000885', '0000004', '하우스패드성형기', NULL, NULL, 'H', 'plm_admin', '2022-10-06 15:03:36.373866'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 852892908::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 524355493::numeric, '0000916', '0000848', '크로샤 성형기', NULL, NULL, 'CF', 'plm_admin', '2022-10-07 15:23:02.597699'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 524355493::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 979147998::numeric, '0000297', '0000296', '내작', NULL, NULL, '', 'plm_admin', '2022-07-26 01:18:36.997881'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 979147998::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 716940760::numeric, '0001542', '0001541', 'Project', NULL, NULL, '', 'plm_admin', '2023-11-13 11:13:28.020421'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 716940760::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -415983332::numeric, '0001543', '0001541', 'Non-project', NULL, NULL, '', 'plm_admin', '2023-11-13 11:13:45.568879'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -415983332::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1004933408::numeric, '0001547', '', '경비신청단계', NULL, NULL, '', 'plm_admin', '2023-11-13 13:18:59.614955'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1004933408::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1422451717::numeric, '0001551', '0001550', '경비신청지역1', NULL, NULL, '', 'plm_admin', '2023-11-13 13:26:43.118405'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1422451717::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1567122560::numeric, '0001552', '0001550', '경비신청지역2', NULL, NULL, '', 'plm_admin', '2023-11-13 13:26:48.243545'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1567122560::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -258686306::numeric, '0001609', '0001059', '재고사용', NULL, NULL, '', 'plm_admin', '2023-12-06 11:48:27.717335'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -258686306::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -786373848::numeric, '0001612', '0001611', '설계', NULL, NULL, '', 'plm_admin', '2023-12-15 12:10:31.793668'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -786373848::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1756656703::numeric, '0001614', '0001611', '생산', NULL, NULL, '', 'plm_admin', '2023-12-15 12:10:54.443868'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1756656703::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -915619290::numeric, '0001615', '', '이슈조치내역', NULL, NULL, '', 'plm_admin', '2023-12-15 12:14:34.88922'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -915619290::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1752809365::numeric, '0001621', '0001613', '제작불량', NULL, NULL, '', 'plm_admin', '2023-12-15 12:17:37.627441'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1752809365::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 2080866761::numeric, '0001622', '0001613', '오사양', NULL, NULL, '', 'plm_admin', '2023-12-15 12:17:44.315418'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 2080866761::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1161066204::numeric, 'EXPS6101', 'EXPS6100', '경비신청적요1', NULL, 'EXPS7000', '', 'plm_admin', '2023-11-15 11:43:12.354052'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1161066204::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -357926719::numeric, 'EXPS6102', 'EXPS6100', '경비신청적요2', NULL, 'EXPS7000', '', 'plm_admin', '2023-11-15 11:43:20.870515'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -357926719::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -896198494::numeric, 'EXPS6201', 'EXPS6200', '경비신청적요3', NULL, 'EXPS7000', '', 'plm_admin', '2023-11-15 11:43:32.093341'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -896198494::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1767518813::numeric, 'EXPS6202', 'EXPS6200', '경비신청적요4', NULL, 'EXPS7000', '', 'plm_admin', '2023-11-15 11:43:36.892956'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1767518813::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 413806316::numeric, '0001623', '0001613', '품질불량', NULL, NULL, '', 'plm_admin', '2023-12-15 12:17:50.96929'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 413806316::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -108692116::numeric, '0001624', '0001614', '조립불량', NULL, NULL, '', 'plm_admin', '2023-12-15 12:18:04.814874'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -108692116::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1631550397::numeric, '0001625', '0001614', '작동오류', NULL, NULL, '', 'plm_admin', '2023-12-15 12:18:12.390247'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1631550397::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -330100816::numeric, '0001626', '0000318', '파트추가', NULL, NULL, '', 'plm_admin', '2023-12-18 17:31:07.927'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -330100816::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 798494564::numeric, '0001627', '0001055', '고객요청', NULL, NULL, '', 'plm_admin', '2023-12-27 16:28:47.224045'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 798494564::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -367728909::numeric, '0900205', '0900102', 'CEO 지시사항', NULL, NULL, NULL, 'plm_admin', '2022-05-30 13:43:06.158'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -367728909::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 576116830::numeric, '0001631', '0001547', 'CS', NULL, NULL, '', 'plm_admin', '2024-01-10 14:15:24.619766'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 576116830::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -276962767::numeric, '0001633', '0000172', 'China', NULL, NULL, '', 'plm_admin', '2024-02-07 13:25:01.849205'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -276962767::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1306877945::numeric, '0001635', '0001399', 'ROLL', NULL, NULL, '', 'plm_admin', '2024-02-08 10:25:07.367352'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1306877945::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -2070516182::numeric, '0000319', '0000318', '설계오류', NULL, NULL, '', 'plm_admin', '2022-07-26 13:36:59.021456'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -2070516182::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 82905928::numeric, '0000320', '0000318', '조립불가', NULL, NULL, '', 'plm_admin', '2022-07-26 13:37:15.544668'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 82905928::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1704297190::numeric, '0000321', '0000318', '사양오류', NULL, NULL, '', 'plm_admin', '2022-07-26 13:37:32.237428'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1704297190::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 310683315::numeric, '0900102', '', '지시사항 이행관리 구분', NULL, NULL, NULL, 'plm_admin', '2021-11-18 02:56:16.515'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 310683315::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 410064075::numeric, '0001146', '', '납품장소', NULL, NULL, '', 'plm_admin', '2023-02-06 16:42:40.486975'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 410064075::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -115121230::numeric, '0001147', '0001146', '우성', NULL, NULL, '', 'plm_admin', '2023-02-06 16:43:13.659503'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -115121230::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1573921974::numeric, '0001148', '0001146', '성하', NULL, NULL, '', 'plm_admin', '2023-02-06 16:43:19.658193'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1573921974::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1321093755::numeric, '0001149', '0001146', '고객사', NULL, NULL, '', 'plm_admin', '2023-02-06 16:43:25.172092'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1321093755::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1727080244::numeric, '0001214', '0000172', 'Japan', NULL, NULL, '', 'plm_admin', '2023-02-23 12:52:21.849734'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1727080244::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -20569977::numeric, '0001400', '0001399', 'EA', NULL, NULL, '', 'plm_admin', '2023-03-24 13:10:42.847074'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -20569977::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1274236416::numeric, '0001558', '0001556', '경비신청출장목적2', NULL, NULL, '', 'plm_admin', '2023-11-13 13:33:57.752551'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1274236416::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -126483181::numeric, '0001401', '0001399', 'Set', NULL, NULL, '', 'plm_admin', '2023-03-24 13:10:49.50453'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -126483181::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1886442513::numeric, '0001610', '0001059', '기각', NULL, NULL, '', 'plm_admin', '2023-12-07 16:48:09.477437'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1886442513::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -800669281::numeric, '0000579', '0000562', '종로구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:25:55.653348'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -800669281::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 839872850::numeric, '0000580', '0000562', '중구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:26:17.187253'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 839872850::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 657549887::numeric, '0000581', '0000562', '용산구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:28:44.198365'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 657549887::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1453690943::numeric, '0000582', '0000562', '성동구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:29:01.95288'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1453690943::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1409276525::numeric, '0000583', '0000562', '광진구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:29:24.12558'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1409276525::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 959526552::numeric, '0000584', '0000562', '동대문구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:29:40.281607'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 959526552::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 590678859::numeric, '0000585', '0000562', '중랑구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:30:13.334555'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 590678859::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1464872481::numeric, '0000586', '0000562', '성북구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:30:31.2204'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1464872481::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 35538772::numeric, '0000587', '0000562', '강북구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:30:45.105646'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 35538772::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -109432112::numeric, '0000588', '0000562', '도봉구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:31:08.007347'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -109432112::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 109331045::numeric, '0000589', '0000562', '노원구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:31:30.122155'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 109331045::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1355214230::numeric, '0000590', '0000562', '은평구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:31:48.530946'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1355214230::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1306963727::numeric, '0000591', '0000562', '서대문구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:32:01.925303'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1306963727::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1918509544::numeric, '0000592', '0000562', '마포구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:32:23.80686'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1918509544::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -636232439::numeric, '0000594', '0000562', '강서구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:33:05.169682'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -636232439::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -442406878::numeric, '0000600', '0000562', '서초구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:35:26.662287'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -442406878::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 278725837::numeric, '0000601', '0000562', '강남구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:35:39.942808'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 278725837::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1605667908::numeric, '0000602', '0000562', '송파구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:36:21.459948'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1605667908::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1233482505::numeric, '0000603', '0000562', '강동구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:36:49.58381'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1233482505::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 945766078::numeric, '0000604', '0000563', '중구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:37:53.909392'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 945766078::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1930795919::numeric, '0000605', '0000563', '동구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:38:11.366182'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1930795919::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1853217878::numeric, '0000606', '0000563', '미추홀구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:38:29.256562'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1853217878::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -370684275::numeric, '0000607', '0000563', '연수구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:38:40.856283'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -370684275::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1982911983::numeric, '0001529', '0001527', '생산의뢰서', NULL, NULL, '', 'plm_admin', '2023-05-10 13:53:07.037715'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1982911983::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1413613436::numeric, '0001553', '', '경비신청이용차량', NULL, NULL, '', 'plm_admin', '2023-11-13 13:33:07.799061'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1413613436::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 31064704::numeric, '0001402', '0001399', '식', NULL, NULL, '', 'plm_admin', '2023-03-24 13:10:53.719632'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 31064704::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1019923708::numeric, '0001557', '0001556', '경비신청출장목적1', NULL, NULL, '', 'plm_admin', '2023-11-13 13:33:53.70401'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1019923708::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1677918230::numeric, 'EXPS6000', '', '경비신청계정과목', NULL, NULL, '', 'plm_admin', '2023-11-13 11:28:29.710036'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1677918230::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 648662058::numeric, '0001566', '0001533', '원(₩)', NULL, NULL, '', 'plm_admin', '2023-11-16 14:09:28.111791'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 648662058::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -417845578::numeric, '0001579', '0000318', '수량변경', NULL, NULL, '', 'plm_admin', '2023-11-21 17:39:02.927353'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -417845578::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 827887895::numeric, '0001539', '0000001', '연료전지', NULL, NULL, 'RS1', 'plm_admin', '2023-09-01 15:38:15.270203'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 827887895::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1542850673::numeric, '0001603', '', '요청사유_구매의뢰서', NULL, NULL, '', 'plm_admin', '2023-12-05 14:51:02.024738'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1542850673::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -543427971::numeric, '0001620', '0001612', '설계오류', NULL, NULL, '', 'plm_admin', '2023-12-15 12:17:19.768886'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -543427971::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 720127008::numeric, '0001202', '0001200', '설변요청', NULL, NULL, '', 'plm_admin', '2023-02-15 03:09:58.249963'::timestamp, 'inActive
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 720127008::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1745663386::numeric, '0001628', '0001056', '현장요청', NULL, NULL, '', 'plm_admin', '2023-12-27 16:29:10.974615'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1745663386::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1779677619::numeric, '0001548', '0001547', '조립', NULL, NULL, '', 'plm_admin', '2023-11-13 13:20:49.883704'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1779677619::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1758980649::numeric, '0001549', '0001547', '셋업', NULL, NULL, '', 'plm_admin', '2023-11-13 13:20:56.030142'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1758980649::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1015934032::numeric, '0001632', '0000318', '내용추가', NULL, NULL, '', 'plm_admin', '2024-02-07 09:28:26.805309'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1015934032::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1225508678::numeric, '0001634', '0001399', 'BOX', NULL, NULL, '', 'plm_admin', '2024-02-08 10:24:55.728798'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1225508678::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 2145315069::numeric, '0000608', '0000563', '남동구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:39:16.758693'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 2145315069::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -524384779::numeric, '0000611', '0000563', '서구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:40:04.135211'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -524384779::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -561297268::numeric, '0000612', '0000563', '강화군', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:40:20.143743'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -561297268::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1581044517::numeric, '0000614', '0000564', '수원', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:41:32.088671'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1581044517::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1020721457::numeric, '0000615', '0000564', '성남', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:41:49.068982'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1020721457::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -980864007::numeric, '0000616', '0000564', '의정부', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:42:04.004357'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -980864007::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1249858464::numeric, '0000617', '0000564', '안양', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:42:17.320369'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1249858464::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1798459295::numeric, '0000618', '0000564', '부천', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:42:28.2762'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1798459295::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -939331992::numeric, '0000619', '0000564', '광명', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:42:40.500562'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -939331992::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 454122704::numeric, '0000621', '0000564', '동두천', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:43:03.976662'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 454122704::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 866063187::numeric, '0000630', '0000564', '의왕', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:44:50.986611'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 866063187::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 2087241415::numeric, '0000631', '0000564', '하남', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:45:06.880784'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 2087241415::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 58253146::numeric, '0000632', '0000564', '용인', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:45:24.027534'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 58253146::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 971623981::numeric, '0000634', '0000564', '이천', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:45:52.908184'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 971623981::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -588045669::numeric, '0000637', '0000564', '화성', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:46:36.489135'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -588045669::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1463305138::numeric, '0000638', '0000564', '광주', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:46:52.379352'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1463305138::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1645839521::numeric, '0000639', '0000564', '양주', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:47:06.408588'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1645839521::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 2008869297::numeric, '0000640', '0000564', '포천', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:47:21.843405'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 2008869297::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -729820493::numeric, '0000641', '0000564', '여주', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:47:36.416103'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -729820493::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1306637822::numeric, '0001617', '0001615', '현장조치', NULL, NULL, '', 'plm_admin', '2023-12-15 12:15:02.519845'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1306637822::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -172949027::numeric, '0001618', '0001615', '신규발주', NULL, NULL, '', 'plm_admin', '2023-12-15 12:15:10.126013'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -172949027::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 616517842::numeric, '0000642', '0000564', '연천', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:47:53.583866'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 616517842::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1262223088::numeric, '0000643', '0000564', '가평', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:48:04.46846'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1262223088::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 55628755::numeric, '0000644', '0000564', '양평', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:48:14.769541'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 55628755::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 383241516::numeric, '0000645', '0000565', '중구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:48:47.239403'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 383241516::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -706611734::numeric, '0000646', '0000565', '서구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:48:57.621109'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -706611734::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1430631304::numeric, '0000647', '0000565', '동구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:49:13.349955'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1430631304::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -840719531::numeric, '0000649', '0000565', '부산진구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:49:38.337087'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -840719531::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 752655286::numeric, '0000651', '0000565', '남구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:50:21.85092'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 752655286::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 304141365::numeric, '0000654', '0000565', '사하대구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:51:02.474735'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 304141365::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1005956683::numeric, '0000656', '0000565', '연제구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:51:29.171875'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1005956683::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1168468804::numeric, '0000657', '0000565', '수영구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:52:32.786439'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1168468804::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -494619744::numeric, '0000658', '0000565', '사상구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:52:48.995111'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -494619744::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1822840907::numeric, '0000659', '0000565', '기장군', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:53:12.320195'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1822840907::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -176434348::numeric, '0000593', '0000562', '양천구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:32:37.065216'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -176434348::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1910893135::numeric, '0000595', '0000562', '구로구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:33:21.200355'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1910893135::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -907826019::numeric, '0000596', '0000562', '금천구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:34:02.470971'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -907826019::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -2118895402::numeric, '0000597', '0000562', '영등포구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:34:20.339568'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -2118895402::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 668700969::numeric, '0000598', '0000562', '동작구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:34:33.599301'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 668700969::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 514763910::numeric, '0000599', '0000562', '관악구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:34:58.187925'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 514763910::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 835799067::numeric, '0000609', '0000563', '부평구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:39:32.577281'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 835799067::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 2033495219::numeric, '0000610', '0000563', '계양구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:39:49.225979'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 2033495219::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1885128804::numeric, '0000613', '0000563', '웅진군', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:40:42.845804'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1885128804::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1299411165::numeric, '0000620', '0000564', '평택', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:42:52.268329'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1299411165::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1915667359::numeric, '0000622', '0000564', '안산', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:43:16.206244'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1915667359::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1002229450::numeric, '0000623', '0000564', '고양', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:43:27.427884'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1002229450::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -2026979913::numeric, '0000625', '0000564', '구리', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:43:50.048633'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -2026979913::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -2100804126::numeric, '0000628', '0000564', '시흥', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:44:29.504524'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -2100804126::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -603682289::numeric, '0000629', '0000564', '군포', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:44:38.431072'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -603682289::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1291333468::numeric, '0000635', '0000564', '안성', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:46:04.148417'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1291333468::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -638354052::numeric, '0000636', '0000564', '김포', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:46:16.280637'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -638354052::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 140551689::numeric, '0000648', '0000565', '영도구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:49:25.269875'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 140551689::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -8782521::numeric, '0000650', '0000565', '동래구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:49:49.681839'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -8782521::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 536085922::numeric, '0000653', '0000565', '해운대구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:50:51.507559'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 536085922::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 69350608::numeric, '0000655', '0000565', '금정구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:51:15.494198'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 69350608::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -192238083::numeric, '0000660', '0000566', '중구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:53:40.421593'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -192238083::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -328334955::numeric, '0000661', '0000566', '동구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:53:57.805886'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -328334955::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 360310685::numeric, '0000662', '0000566', '서구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:54:12.653285'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 360310685::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1088507748::numeric, '0000663', '0000566', '남구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:54:27.974055'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1088507748::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -677828622::numeric, '0000665', '0000566', '수성구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:54:55.416009'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -677828622::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -963170028::numeric, '0000666', '0000566', '달서구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:55:09.492059'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -963170028::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1479426818::numeric, '0000667', '0000566', '달성군', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:55:20.584632'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1479426818::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 69313417::numeric, '0000668', '0000567', '동구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:55:56.657268'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 69313417::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1929096813::numeric, '0000669', '0000567', '서구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:56:05.63828'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1929096813::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -459375060::numeric, '0000670', '0000567', '남구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:56:19.040319'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -459375060::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 226497114::numeric, '0000671', '0000567', '북구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:56:29.590223'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 226497114::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1772925134::numeric, '0000672', '0000567', '광산구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:56:42.477526'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1772925134::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 575827512::numeric, '0000673', '0000568', '중구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:57:16.600216'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 575827512::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -2041567521::numeric, '0000674', '0000568', '남구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:57:25.876295'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -2041567521::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1417818285::numeric, '0000675', '0000568', '동구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:57:39.363116'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1417818285::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1744259524::numeric, '0000676', '0000568', '북구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:57:52.045705'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1744259524::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -386326120::numeric, '0000677', '0000568', '울주군', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:58:08.139179'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -386326120::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1692493488::numeric, '0000678', '0000570', '동구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:58:43.560793'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1692493488::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 2076070433::numeric, '0000679', '0000570', '중구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:59:02.43969'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 2076070433::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 53743669::numeric, '0000680', '0000570', '서구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:59:13.514997'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 53743669::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1486061298::numeric, '0000681', '0000570', '유성구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:59:24.131481'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1486061298::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -408132604::numeric, '0000682', '0000570', '대덕구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:59:37.473167'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -408132604::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1376179119::numeric, '0000683', '0000571', '전주', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:00:37.958619'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1376179119::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 2063598273::numeric, '0000684', '0000571', '군산', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:00:52.043629'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 2063598273::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 108212055::numeric, '0000685', '0000571', '익산', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:01:07.422399'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 108212055::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1534859619::numeric, '0000686', '0000571', '정읍', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:01:19.241937'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1534859619::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1484104579::numeric, '0000687', '0000571', '남원', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:01:35.516915'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1484104579::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -574003023::numeric, '0000688', '0000571', '김제', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:02:08.317997'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -574003023::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 2144233109::numeric, '0000689', '0000571', '완주', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:02:18.330802'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 2144233109::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1684112370::numeric, '0000690', '0000571', '진안', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:02:27.997137'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1684112370::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1808775365::numeric, '0000691', '0000571', '무주', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:02:41.042864'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1808775365::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1631513154::numeric, '0000692', '0000571', '장수', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:02:51.91669'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1631513154::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -204854829::numeric, '0000693', '0000571', '임실', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:03:10.264401'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -204854829::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1677280227::numeric, '0000694', '0000571', '순창', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:03:23.625544'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1677280227::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 906966872::numeric, '0000695', '0000571', '고창', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:03:34.960808'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 906966872::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 265142451::numeric, '0000696', '0000571', '부안', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:03:52.806438'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 265142451::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 2047904701::numeric, '0000697', '0000572', '목포', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:04:45.436518'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 2047904701::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -192324078::numeric, '0000698', '0000572', '여수', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:05:02.826081'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -192324078::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 2019192136::numeric, '0000699', '0000572', '순천', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:05:21.628716'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 2019192136::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1580083423::numeric, '0000700', '0000572', '나주', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:05:35.222154'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1580083423::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1650356733::numeric, '0000701', '0000572', '광양', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:05:47.238579'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1650356733::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 283125310::numeric, '0000702', '0000572', '담양', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:06:23.058905'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 283125310::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1312422270::numeric, '0000703', '0000572', '곡성', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:06:41.735987'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1312422270::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 212719230::numeric, '0000704', '0000572', '구례', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:06:59.896976'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 212719230::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -344429222::numeric, '0000705', '0000572', '고흥', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:07:10.694065'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -344429222::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -691979111::numeric, '0000706', '0000572', '보성', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:07:26.828148'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -691979111::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 844308805::numeric, '0000707', '0000572', '화순', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:07:42.067161'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 844308805::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -21247171::numeric, '0000708', '0000572', '장흥', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:07:52.957214'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -21247171::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 2029783656::numeric, '0000709', '0000572', '강진', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:08:05.796399'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 2029783656::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1014995655::numeric, '0000710', '0000572', '해남', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:08:28.115217'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1014995655::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1042805661::numeric, '0000711', '0000572', '영암', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:08:44.716306'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1042805661::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 142568848::numeric, '0000712', '0000572', ' 무안', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:09:43.807052'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 142568848::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 191302113::numeric, '0000713', '0000572', '함평', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:09:55.38918'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 191302113::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -774632510::numeric, '0000714', '0000572', '영광', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:10:15.530403'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -774632510::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1281154350::numeric, '0000715', '0000572', ' 장성', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:10:26.363921'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1281154350::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1357397125::numeric, '0000652', '0000565', '북구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:50:38.191253'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1357397125::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 646344277::numeric, '0000627', '0000564', '오산', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:44:17.994218'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 646344277::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 77268931::numeric, '0000633', '0000564', '파주', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:45:36.226233'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 77268931::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 175234185::numeric, '0000624', '0000564', '과천', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:43:39.386262'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 175234185::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1800554774::numeric, '0000716', '0000572', '완도', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:10:40.661366'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1800554774::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1031283918::numeric, '0000717', '0000572', '진도', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:10:54.582248'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1031283918::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1916211732::numeric, '0000719', '0000573', ' 창원', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:13:13.444522'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1916211732::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 503098244::numeric, '0000721', '0000573', '통영', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:13:55.480513'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 503098244::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -758599321::numeric, '0000723', '0000573', '김해', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:33:49.104463'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -758599321::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1793243170::numeric, '0000724', '0000573', '밀양', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:34:24.717546'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1793243170::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1645766695::numeric, '0000726', '0000573', '양산', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:34:48.731399'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1645766695::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 593517501::numeric, '0000727', '0000573', '의령', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:35:07.641736'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 593517501::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1976889484::numeric, '0000729', '0000573', '창녕', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:35:28.891396'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1976889484::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1364472983::numeric, '0000730', '0000573', '고성', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:35:42.038845'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1364472983::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 32365867::numeric, '0000731', '0000573', '남해', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:35:52.799406'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 32365867::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -907383488::numeric, '0000732', '0000573', '하동', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:36:06.301964'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -907383488::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 956453693::numeric, '0000734', '0000573', '함양', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:36:46.216998'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 956453693::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1406872269::numeric, '0000737', '0000574', '포항', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:38:35.826248'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1406872269::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 465041960::numeric, '0000739', '0000574', '김청', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:39:07.28601'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 465041960::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 254275171::numeric, '0000741', '0000574', '구미', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:39:36.527348'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 254275171::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1259352351::numeric, '0000745', '0000574', '문경', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:40:29.757399'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1259352351::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1224838039::numeric, '0000748', '0000574', '의성', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:41:22.419686'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1224838039::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1821148981::numeric, '0000749', '0000574', '청송', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:41:32.50769'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1821148981::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -655424596::numeric, '0000750', '0000574', '영양', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:41:52.901416'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -655424596::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1994147878::numeric, '0000751', '0000574', '영덕', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:42:04.469989'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1994147878::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1922315101::numeric, '0000752', '0000574', '청도', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:42:26.560868'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1922315101::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1097795543::numeric, '0000753', '0000574', '고령', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:42:37.751035'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1097795543::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 714671414::numeric, '0000754', '0000574', '성주', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:42:59.236614'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 714671414::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -548903877::numeric, '0000755', '0000574', '칠곡', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:43:10.649301'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -548903877::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1660095208::numeric, '0000756', '0000574', '예천', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:43:22.043981'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1660095208::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1155773240::numeric, '0000757', '0000574', '봉화', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:43:32.371465'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1155773240::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -900383910::numeric, '0000760', '0000575', ' 천안', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:45:05.675492'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -900383910::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1675678749::numeric, '0000761', '0000575', '공주', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:45:16.580854'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1675678749::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1226611509::numeric, '0000762', '0000575', '보령', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:45:25.679734'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1226611509::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1819022348::numeric, '0000764', '0000575', '서산', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:45:50.561745'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1819022348::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1895575951::numeric, '0000765', '0000575', '논산', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:46:06.084546'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1895575951::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1735255976::numeric, '0000766', '0000575', '계룡', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:46:17.873294'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1735255976::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1102127923::numeric, '0000768', '0000575', '금산', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:46:46.790259'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1102127923::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1436004929::numeric, '0000770', '0000575', '서천', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:47:21.099952'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1436004929::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 2135333633::numeric, '0000771', '0000575', '청양', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:47:35.511349'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 2135333633::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -791476680::numeric, '0000772', '0000575', '홍성', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:47:52.294727'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -791476680::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1792735963::numeric, '0000718', '0000572', '신안', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:11:08.968037'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1792735963::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1470952358::numeric, '0000720', '0000573', '진주', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:13:38.86471'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1470952358::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -447864164::numeric, '0000722', '0000573', '사천', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:33:32.615158'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -447864164::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1668688903::numeric, '0000725', '0000573', '거제', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:34:35.621955'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1668688903::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -2002147260::numeric, '0000728', '0000573', ' 함안', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:35:19.725866'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -2002147260::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1760767219::numeric, '0000733', '0000573', '산청', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:36:31.296601'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1760767219::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 772005764::numeric, '0000735', '0000573', '거창', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:37:00.426074'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 772005764::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -19601520::numeric, '0000736', '0000573', '합천', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:37:26.084236'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -19601520::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1791540697::numeric, '0000738', '0000574', '경주', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:38:50.811596'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1791540697::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -768771085::numeric, '0000740', '0000574', '안동', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:39:20.58588'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -768771085::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 935174274::numeric, '0000742', '0000574', '영주', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:39:58.974532'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 935174274::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1886295629::numeric, '0000743', '0000574', '영천', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:40:08.354271'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1886295629::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1688156711::numeric, '0000744', '0000574', '상주', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:40:18.397435'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1688156711::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1303263418::numeric, '0000746', '0000574', '경산', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:40:46.583641'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1303263418::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1252544609::numeric, '0000747', '0000574', '군위', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:41:07.660882'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1252544609::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1605952368::numeric, '0000758', '0000574', '울진', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:43:51.219594'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1605952368::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 176191734::numeric, '0000759', '0000574', '울릉', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:44:04.696646'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 176191734::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1357094155::numeric, '0000763', '0000575', '아산', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:45:36.066396'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1357094155::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 921593212::numeric, '0000767', '0000575', '당진', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:46:36.12276'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 921593212::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -2061687517::numeric, '0000769', '0000575', '부여', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:47:11.838614'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -2061687517::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1708685331::numeric, '0000773', '0000575', '예산', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:48:02.831512'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1708685331::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1695006720::numeric, '0000774', '0000575', '태안', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:48:12.792406'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1695006720::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 307520917::numeric, '0000775', '0000576', '청주', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:49:45.619841'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 307520917::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -864344296::numeric, '0000776', '0000576', '충주', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:50:12.575798'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -864344296::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1678895574::numeric, '0000777', '0000576', '제천', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:50:30.763441'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1678895574::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1534002205::numeric, '0000778', '0000576', '보은', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:50:44.236806'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1534002205::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1612670767::numeric, '0000779', '0000576', '옥천', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:51:00.618106'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1612670767::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 2011058021::numeric, '0000780', '0000576', '영동', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:51:28.37566'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 2011058021::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1441689774::numeric, '0000781', '0000576', '증평', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:51:42.861671'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1441689774::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 501670547::numeric, '0000782', '0000576', '진천', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:52:04.818683'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 501670547::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 345508108::numeric, '0000783', '0000576', '괴산', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:52:28.535116'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 345508108::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -561992690::numeric, '0000784', '0000576', '음성', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:52:42.814868'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -561992690::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -551835010::numeric, '0000785', '0000576', '단양', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:52:53.593947'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -551835010::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1827243884::numeric, '0000786', '0000577', '춘천', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:53:56.078035'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1827243884::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -617398058::numeric, '0000787', '0000577', '원주', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:54:10.099987'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -617398058::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1873119100::numeric, '0000788', '0000577', '강릉', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:54:22.117024'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1873119100::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 2002807354::numeric, '0000789', '0000577', '동해', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:54:33.406886'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 2002807354::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -656746113::numeric, '0000790', '0000577', '태백', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:54:45.091696'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -656746113::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -879645751::numeric, '0000791', '0000577', '속초', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:55:03.426038'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -879645751::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 707868778::numeric, '0000792', '0000577', '삼척', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:55:17.584818'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 707868778::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1245630799::numeric, '0000793', '0000577', '홍천', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:55:35.849041'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1245630799::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 749838495::numeric, '0000794', '0000577', '횡성', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:55:50.918864'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 749838495::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 440824403::numeric, '0000795', '0000577', '영월', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:56:05.646825'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 440824403::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 375453735::numeric, '0000796', '0000577', '평창', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:56:17.715403'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 375453735::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1912138891::numeric, '0000797', '0000577', '정선', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:56:28.806833'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1912138891::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -430189594::numeric, '0000798', '0000577', '철원', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:56:51.113775'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -430189594::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1329992665::numeric, '0000799', '0000577', '화천', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:57:16.954053'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1329992665::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1899072610::numeric, '0000800', '0000577', '양구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:57:30.724166'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1899072610::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 409315208::numeric, '0000801', '0000577', '인제', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:57:43.27303'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 409315208::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 264060926::numeric, '0000802', '0000577', '고성', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:58:02.824945'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 264060926::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -911128285::numeric, '0000803', '0000577', '양양', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:58:20.064568'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -911128285::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 674585113::numeric, '0000804', '0000564', '남양주', NULL, NULL, NULL, 'plm_admin', '2022-08-25 19:59:37.14208'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 674585113::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1206120719::numeric, '0000805', '0000578', '제주', NULL, NULL, NULL, 'plm_admin', '2022-08-25 20:00:16.43325'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1206120719::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1002122480::numeric, '0000806', '0000578', '서귀포', NULL, NULL, NULL, 'plm_admin', '2022-08-25 20:00:31.610026'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1002122480::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1185368295::numeric, '0000807', '0000569', '세종', NULL, NULL, NULL, 'plm_admin', '2022-08-25 20:00:43.818201'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1185368295::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1006030960::numeric, '0000664', '0000566', '북구', NULL, NULL, NULL, 'plm_admin', '2022-08-25 18:54:41.83728'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1006030960::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1171018593::numeric, '0000897', '0000286', '코너카바', NULL, NULL, 'CC', 'plm_admin', '2022-10-07 15:14:09.776276'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1171018593::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1826258362::numeric, '0000900', '0000286', '스팬드럴', NULL, NULL, 'SP', 'plm_admin', '2022-10-07 15:15:25.73991'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1826258362::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -655470671::numeric, '0000901', '0000286', '앤드캡 프레스', NULL, NULL, 'EC', 'plm_admin', '2022-10-07 15:15:56.070429'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -655470671::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -984739023::numeric, '0000902', '0000286', '쪼인트성형기', NULL, NULL, 'JF', 'plm_admin', '2022-10-07 15:16:44.436871'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -984739023::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 120305084::numeric, '0000903', '0000286', '사각선홍통성형기', NULL, NULL, 'REC', 'plm_admin', '2022-10-07 15:17:07.337274'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 120305084::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1642760400::numeric, '0000905', '0000286', 'C/S U-BAR 성형기', NULL, NULL, 'CS', 'plm_admin', '2022-10-07 15:18:06.749795'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1642760400::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 2045307174::numeric, '0000230', '0000004', '징크강판성형기', NULL, NULL, 'ZN', 'plm_admin', '2022-04-01 11:35:34.905621'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 2045307174::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 86947707::numeric, '0000296', '', '내외작', NULL, NULL, '', 'plm_admin', '2022-07-26 01:17:17.833292'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 86947707::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -136791436::numeric, '0000298', '0000296', '외작', NULL, NULL, '', 'plm_admin', '2022-07-26 01:18:54.901698'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -136791436::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1250249373::numeric, '0000907', '0000286', 'F/S 성형기', NULL, NULL, 'FS', 'plm_admin', '2022-10-07 15:19:10.119893'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1250249373::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1550216310::numeric, '0000849', '0000848', '롬버스 프레스', NULL, NULL, 'RPS', 'plm_admin', '2022-08-26 16:17:02.666595'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1550216310::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1399526262::numeric, '0000850', '0000848', '절곡기', NULL, NULL, 'BD', 'plm_admin', '2022-08-26 16:17:17.713931'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1399526262::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1687413855::numeric, '0000851', '0000848', '평판샤링기', NULL, NULL, 'RS', 'plm_admin', '2022-09-16 12:58:56.601433'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1687413855::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 768664439::numeric, '0000004', '0000918', 'ROLL FOAMING', NULL, NULL, 'RF', 'plm_admin', '2021-09-14 23:23:56.158679'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 768664439::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -188749483::numeric, '0000848', '0000918', '기타', NULL, NULL, 'ETC', 'plm_admin', '2022-08-26 16:16:42.573546'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -188749483::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1257980543::numeric, '0000921', '', '견적단계', NULL, NULL, '', 'plm_admin', '2022-11-08 17:07:06.951843'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1257980543::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 2009526844::numeric, '0000168', '0000167', '개발', NULL, NULL, '', 'plm_admin', '2022-03-18 21:45:50.411302'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 2009526844::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1993188846::numeric, '0000936', '0000932', '진행중', NULL, NULL, '', 'plm_admin', '2022-12-07 07:11:11.589954'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1993188846::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 963199394::numeric, '0000932', '', '계약진행상황', NULL, NULL, '', 'plm_admin', '2022-12-07 07:09:31.862215'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 963199394::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 2079978153::numeric, '0000937', '0000932', 'Drop', NULL, NULL, '', 'plm_admin', '2022-12-07 07:11:27.919525'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 2079978153::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -207352077::numeric, '0000938', '0000932', 'Hold', NULL, NULL, '', 'plm_admin', '2022-12-07 07:11:39.043613'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -207352077::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1041597778::numeric, '0000939', '0000932', 'Open', NULL, NULL, '', 'plm_admin', '2022-12-07 07:11:45.162101'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1041597778::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -2026018477::numeric, '0000940', '0000932', 'Close', NULL, NULL, '', 'plm_admin', '2022-12-07 07:11:54.736402'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -2026018477::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 698975038::numeric, '0000941', '0000932', '수주실패', NULL, NULL, '', 'plm_admin', '2022-12-07 07:12:01.161377'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 698975038::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -142968786::numeric, '0000942', '', '계약구분1', NULL, NULL, '', 'plm_admin', '2022-12-07 07:12:34.235353'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -142968786::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1999965975::numeric, '0000943', '0000942', '제안서', NULL, NULL, '', 'plm_admin', '2022-12-07 07:13:00.355991'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1999965975::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -124216272::numeric, '0000944', '0000942', '사양서', NULL, NULL, '', 'plm_admin', '2022-12-07 07:13:06.056586'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -124216272::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1372074924::numeric, '0000945', '0000942', '견적서', NULL, NULL, '', 'plm_admin', '2022-12-07 07:13:11.542267'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1372074924::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1799684036::numeric, '0001150', '0001146', '공급업체', NULL, NULL, '', 'plm_admin', '2023-02-06 16:43:30.691457'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1799684036::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1498403353::numeric, '0000928', '0000001', 'MLCC', NULL, NULL, 'RF4', 'plm_admin', '2022-12-07 07:04:31.570026'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1498403353::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -96233896::numeric, '0001533', '', '통화', NULL, NULL, '', 'plm_admin', '2023-08-01 13:10:58.808655'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -96233896::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 877706753::numeric, '0001525', '0000001', '연구설비', NULL, NULL, '', 'hjshin', '2023-04-12 10:05:14.625033'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 877706753::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -958720786::numeric, '0000955', '0000954', '설계', NULL, NULL, '', 'plm_admin', '2022-12-07 07:21:53.194034'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -958720786::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1650425273::numeric, '0000956', '0000954', '승인', NULL, NULL, '', 'plm_admin', '2022-12-07 07:21:59.793004'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1650425273::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1519967185::numeric, '0000957', '0000954', '구매', NULL, NULL, '', 'plm_admin', '2022-12-07 07:22:04.823338'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1519967185::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -306808839::numeric, '0000954', '', '계약구분2', NULL, NULL, '', 'plm_admin', '2022-12-07 07:21:33.1064'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -306808839::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1417808432::numeric, '0000959', '', '설비방향', NULL, NULL, '', 'plm_admin', '2022-12-07 07:22:37.745975'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1417808432::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 107971514::numeric, '0000960', '0000959', 'CW', NULL, NULL, '', 'plm_admin', '2022-12-07 07:22:56.993365'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 107971514::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -151063726::numeric, '0000961', '0000959', 'CCW', NULL, NULL, '', 'plm_admin', '2022-12-07 07:23:03.334661'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -151063726::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1906180721::numeric, '0000962', '0000959', '없음', NULL, NULL, '', 'plm_admin', '2022-12-07 07:23:09.743754'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1906180721::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 646152909::numeric, '0000963', '', '수주결과', NULL, NULL, '', 'plm_admin', '2022-12-07 07:24:12.940711'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 646152909::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1627797417::numeric, '0001165', '0000262', 'SHSE_1F_A6', NULL, NULL, '', 'plm_admin', '2023-02-07 13:43:26.39384'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1627797417::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -372144254::numeric, '0001164', '0000262', 'SHSE_1F_A5', NULL, NULL, '', 'plm_admin', '2023-02-07 13:43:20.616674'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -372144254::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -2101794885::numeric, '0001170', '0000262', 'SHSE_1F_B5', NULL, NULL, '', 'plm_admin', '2023-02-07 13:44:16.722709'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -2101794885::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 8862438::numeric, '0001166', '0000262', 'SHSE_1F_B1', NULL, NULL, '', 'plm_admin', '2023-02-07 13:43:31.854793'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 8862438::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 67918116::numeric, '0001167', '0000262', 'SHSE_1F_B2', NULL, NULL, '', 'plm_admin', '2023-02-07 13:43:37.207321'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 67918116::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1361428835::numeric, '0001168', '0000262', 'SHSE_1F_B3', NULL, NULL, '', 'plm_admin', '2023-02-07 13:43:49.191469'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1361428835::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1757463406::numeric, '0001169', '0000262', 'SHSE_1F_B4', NULL, NULL, '', 'plm_admin', '2023-02-07 13:43:55.302958'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1757463406::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1019786611::numeric, '0001171', '0000262', 'SHSE_1F_B6', NULL, NULL, '', 'plm_admin', '2023-02-07 13:44:21.9334'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1019786611::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1911538687::numeric, '0001172', '0000262', 'SHSE_1F_B7', NULL, NULL, '', 'plm_admin', '2023-02-07 13:44:26.644001'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1911538687::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1469402037::numeric, '0001173', '0000262', 'SHSE_2F_B1', NULL, NULL, '', 'plm_admin', '2023-02-07 13:44:33.511578'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1469402037::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1423921662::numeric, '0001174', '0000262', 'SHSE_2F_B2', NULL, NULL, '', 'plm_admin', '2023-02-07 13:44:39.511137'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1423921662::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 508113373::numeric, '0001175', '0000262', 'SHSE_2F_B3', NULL, NULL, '', 'plm_admin', '2023-02-07 13:44:45.536438'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 508113373::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1957378124::numeric, '0001219', '', '국내/해외', NULL, NULL, '', 'plm_admin', '2023-02-24 16:44:05.416482'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1957378124::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1656134317::numeric, '0001406', '', '발주구분', NULL, NULL, '', 'plm_admin', '2023-03-28 15:44:07.552657'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1656134317::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1327849873::numeric, '0000967', '', '영업구분', NULL, NULL, '', 'plm_admin', '2022-12-07 07:30:21.956549'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1327849873::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1811031215::numeric, '0001072', '0001071', '전수검사', NULL, NULL, '', 'plm_admin', '2023-01-10 21:06:36.781682'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1811031215::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1381389177::numeric, '0000969', '0000967', '오버홀', NULL, NULL, '', 'plm_admin', '2022-12-07 07:33:10.262292'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1381389177::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 153593810::numeric, '0000970', '', 'CS구분', NULL, NULL, '', 'plm_admin', '2022-12-13 17:36:43.06102'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 153593810::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -573668879::numeric, '0001200', '', '부적합_조치사항', NULL, NULL, '', 'plm_admin', '2023-02-15 03:09:32.526632'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -573668879::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1538780046::numeric, '0000972', '0000970', '문제발생', NULL, NULL, '', 'plm_admin', '2022-12-13 17:36:59.771759'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1538780046::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1332488825::numeric, '0000976', '0000975', '부품파손', NULL, NULL, '', 'plm_admin', '2022-12-13 17:39:20.98464'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1332488825::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1131579564::numeric, '0000977', '0000975', '가공오류', NULL, NULL, '', 'plm_admin', '2022-12-13 17:39:26.477821'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1131579564::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 2124655631::numeric, '0000978', '0000975', '설계오류', NULL, NULL, '', 'plm_admin', '2022-12-13 17:39:31.25876'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 2124655631::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1005212817::numeric, '0000979', '0000975', '조립실수', NULL, NULL, '', 'plm_admin', '2022-12-13 17:39:37.645969'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1005212817::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -662637732::numeric, '0000980', '0000975', '오사양적용', NULL, NULL, '', 'plm_admin', '2022-12-13 17:39:43.236988'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -662637732::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1409677454::numeric, '0000975', '', '조치내역서유형', NULL, NULL, '', 'plm_admin', '2022-12-13 17:38:03.250941'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1409677454::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -2099465434::numeric, '0000982', '0000976', '부품파손_중', NULL, NULL, '', 'plm_admin', '2022-12-13 17:41:06.759047'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -2099465434::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1446357373::numeric, '0000983', '0000982', '부품파손_소', NULL, NULL, '', 'plm_admin', '2022-12-13 17:41:31.077867'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1446357373::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1680920146::numeric, '0001201', '0001200', '공급업체 반환', NULL, NULL, '', 'plm_admin', '2023-02-15 03:09:49.810656'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1680920146::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -101480763::numeric, '0001073', '0001071', '샘플링검사', NULL, NULL, '', 'plm_admin', '2023-01-10 21:06:55.297604'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -101480763::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1494978196::numeric, '0000971', '0000970', '고객요청', NULL, NULL, '', 'plm_admin', '2022-12-13 17:36:56.20611'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1494978196::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1949538717::numeric, '0001061', '0001059', '재발주', NULL, NULL, '', 'plm_admin', '2023-01-01 16:42:20.513821'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1949538717::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 2129816155::numeric, '0001062', '', '구매관리_설계변경_조치결과', NULL, NULL, '', 'plm_admin', '2023-01-01 19:41:07.287386'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 2129816155::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1785689885::numeric, '0001055', '0001054', '고객요청', NULL, NULL, '', 'plm_admin', '2022-12-23 00:45:46.035649'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1785689885::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -238519667::numeric, '0001054', '', '설변구분', NULL, NULL, '', 'plm_admin', '2022-12-23 00:45:18.196976'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -238519667::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1713725133::numeric, '0001063', '0001062', '미접수', NULL, NULL, '', 'plm_admin', '2023-01-01 19:41:27.93236'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1713725133::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -240157948::numeric, '0001064', '0001062', '접수', NULL, NULL, '', 'plm_admin', '2023-01-01 19:41:39.706609'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -240157948::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1937115083::numeric, '0001059', '', '구매관리_조치내역', NULL, NULL, '', 'plm_admin', '2023-01-01 16:41:26.160564'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1937115083::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1286788069::numeric, '0001065', '0001062', '발주완료', NULL, NULL, '', 'plm_admin', '2023-01-01 19:41:52.027231'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1286788069::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -389761648::numeric, '0001060', '0001059', '발주', NULL, NULL, '', 'plm_admin', '2023-01-01 16:42:05.370423'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -389761648::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1828410149::numeric, '0000329', '', '공급업체 담당자구분', NULL, NULL, '', 'plm_admin', '2023-01-10 20:51:05.129524'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1828410149::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1265571129::numeric, '0001068', '', '발주관리-발주구분', NULL, NULL, '', 'plm_admin', '2023-01-10 21:04:47.914845'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1265571129::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1046343502::numeric, '0000330', '0000329', '발주담당', NULL, NULL, '', 'plm_admin', '2023-01-10 20:51:30.086895'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1046343502::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -280256118::numeric, '0001069', '0001068', '일반부품', NULL, NULL, '', 'plm_admin', '2023-01-10 21:05:03.502632'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -280256118::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 2097118173::numeric, '0001070', '0001068', '장납기품', NULL, NULL, '', 'plm_admin', '2023-01-10 21:05:17.839315'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 2097118173::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -453757694::numeric, '0001071', '', '발주관리-검수방법', NULL, NULL, '', 'plm_admin', '2023-01-10 21:06:23.341052'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -453757694::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1232537875::numeric, '0000964', '0000963', '수주', NULL, NULL, '', 'plm_admin', '2022-12-07 07:24:25.404574'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1232537875::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -480138889::numeric, '0000965', '0000963', '실패', NULL, NULL, '', 'plm_admin', '2022-12-07 07:24:34.042421'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -480138889::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -522011042::numeric, '0000966', '0000963', 'HOLD', NULL, NULL, '', 'plm_admin', '2022-12-07 07:24:41.015406'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -522011042::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1382583278::numeric, '0001056', '0001054', '자체설변', NULL, NULL, '', 'plm_admin', '2022-12-23 00:46:00.481777'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1382583278::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1074765676::numeric, '0001074', '', '발주관리-결제조건', NULL, NULL, '', 'plm_admin', '2023-01-10 21:07:22.595336'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1074765676::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 100390080::numeric, '0001077', '', '발주관리-부가세', NULL, NULL, '', 'plm_admin', '2023-01-10 21:22:14.913748'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 100390080::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 306194598::numeric, '0001078', '0001077', '포함', NULL, NULL, '', 'plm_admin', '2023-01-10 21:22:29.561919'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 306194598::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1380589404::numeric, '0001079', '0001077', '미포함', NULL, NULL, '', 'plm_admin', '2023-01-10 21:22:35.72789'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1380589404::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1603443311::numeric, '0001082', '0000967', '개발', NULL, NULL, '', 'plm_admin', '2023-01-30 22:49:20.961332'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1603443311::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1283584515::numeric, '0001083', '0000967', '개조', NULL, NULL, '', 'plm_admin', '2023-01-30 22:49:39.251341'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1283584515::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1855490374::numeric, '0001085', '0000954', '제작', NULL, NULL, '', 'plm_admin', '2023-01-30 22:56:09.930304'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1855490374::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -191161921::numeric, '0001086', '0000954', '시운전', NULL, NULL, '', 'plm_admin', '2023-01-30 22:56:22.215322'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -191161921::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1039097079::numeric, '0001087', '0000954', '자체검수', NULL, NULL, '', 'plm_admin', '2023-01-30 22:56:30.869883'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1039097079::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 960334021::numeric, '0001088', '0000954', '최종검수', NULL, NULL, '', 'plm_admin', '2023-01-30 22:56:40.161197'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 960334021::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -388607020::numeric, '0001089', '0000954', '포장', NULL, NULL, '', 'plm_admin', '2023-01-30 22:56:46.977061'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -388607020::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1884063852::numeric, '0001176', '0000262', 'SHSE_2F_B4', NULL, NULL, '', 'plm_admin', '2023-02-07 13:44:51.487597'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1884063852::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1549859245::numeric, '0001177', '0000262', 'SHSE_2F_B5', NULL, NULL, '', 'plm_admin', '2023-02-07 13:45:07.252184'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1549859245::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1177624675::numeric, '0001179', '0000262', 'WSE_C2 DRIVE', NULL, NULL, '', 'plm_admin', '2023-02-07 13:45:18.350985'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1177624675::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 268991118::numeric, '0001180', '0000262', 'WSE_C3 BEARING', NULL, NULL, '', 'plm_admin', '2023-02-07 13:45:22.623621'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 268991118::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 849004380::numeric, '0001181', '0000262', 'WSE_C4 MFC', NULL, NULL, '', 'plm_admin', '2023-02-07 13:45:29.053991'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 849004380::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1349180041::numeric, '0001182', '0000262', 'WSE_C5 FLOWMETER', NULL, NULL, '', 'plm_admin', '2023-02-07 13:45:33.39117'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1349180041::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -732014090::numeric, '0001183', '0000262', 'WSE_C6 BALL VALVE', NULL, NULL, '', 'plm_admin', '2023-02-07 13:45:39.591435'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -732014090::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -2123677922::numeric, '0001184', '0000262', 'WSE_C7 AIR', NULL, NULL, '', 'plm_admin', '2023-02-07 13:45:43.764413'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -2123677922::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 351299462::numeric, '0001185', '0000262', 'WSE_C8 AIR', NULL, NULL, '', 'plm_admin', '2023-02-07 13:45:51.255878'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 351299462::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1694703122::numeric, '0001178', '0000262', 'WSE_C1 DRIVE', NULL, NULL, '', 'plm_admin', '2023-02-07 13:45:11.79944'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1694703122::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1042221347::numeric, '0001186', '0000262', 'WSE_C9 TC', NULL, NULL, '', 'plm_admin', '2023-02-07 13:45:55.439057'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1042221347::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -117022467::numeric, '0001187', '0000262', 'WSE_C10 TC', NULL, NULL, '', 'plm_admin', '2023-02-07 13:46:01.175682'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -117022467::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 822766040::numeric, '0001188', '0000262', 'WSE_C11 SENSOR', NULL, NULL, '', 'plm_admin', '2023-02-07 13:46:05.355739'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 822766040::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1986069338::numeric, '0001189', '0000262', 'WSE_C12 SENSOR', NULL, NULL, '', 'plm_admin', '2023-02-07 13:46:11.935444'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1986069338::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -115737791::numeric, '0001190', '0000262', 'WSE_C13 SENSOR', NULL, NULL, '', 'plm_admin', '2023-02-07 13:46:15.887564'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -115737791::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1838973396::numeric, '0001191', '0000262', 'WSE_C14 SENSOR', NULL, NULL, '', 'plm_admin', '2023-02-07 13:46:22.696271'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1838973396::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -340769196::numeric, '0001192', '0000262', 'WSE_C15 OTHER', NULL, NULL, '', 'plm_admin', '2023-02-07 13:46:28.279415'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -340769196::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1135332251::numeric, '0001193', '0000262', 'WSE_C16 OTHER', NULL, NULL, '', 'plm_admin', '2023-02-07 13:46:34.023049'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1135332251::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 495292114::numeric, '0001194', '0000262', 'WSE_C17 OTHER', NULL, NULL, '', 'plm_admin', '2023-02-07 13:46:38.126652'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 495292114::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -499908285::numeric, '0001195', '0000262', 'WSE_D1', NULL, NULL, '', 'plm_admin', '2023-02-07 13:46:42.366956'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -499908285::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 727993334::numeric, '0001196', '0000262', 'WSE_D2', NULL, NULL, '', 'plm_admin', '2023-02-07 13:46:46.336389'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 727993334::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -630185014::numeric, '0001197', '0000262', 'WSE_D3', NULL, NULL, '', 'plm_admin', '2023-02-07 13:46:50.478954'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -630185014::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 858889002::numeric, '0001198', '0000262', 'WSE_D4', NULL, NULL, '', 'plm_admin', '2023-02-07 13:46:55.247583'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 858889002::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1657316367::numeric, '0001199', '0000262', 'WSE_D5', NULL, NULL, '', 'plm_admin', '2023-02-07 13:47:00.175915'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1657316367::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -46114678::numeric, '0001090', '0000954', '출하', NULL, NULL, '', 'plm_admin', '2023-01-30 22:56:53.28732'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -46114678::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 279867252::numeric, '0001091', '0000954', '선적', NULL, NULL, '', 'plm_admin', '2023-01-30 22:56:59.240111'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 279867252::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1721070206::numeric, '0001092', '0000954', '셋업', NULL, NULL, '', 'plm_admin', '2023-01-30 22:57:09.666146'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1721070206::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1126425887::numeric, '0001093', '', '고객구분', NULL, NULL, '', 'plm_admin', '2023-01-31 00:28:51.263529'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1126425887::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1364438682::numeric, '0001094', '0001093', '법인', NULL, NULL, '', 'plm_admin', '2023-01-31 00:29:08.868722'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1364438682::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -2023224319::numeric, '0001095', '0001093', '개인', NULL, NULL, '', 'plm_admin', '2023-01-31 00:29:14.262573'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -2023224319::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -755339602::numeric, '0001096', '0001093', '공공', NULL, NULL, '', 'plm_admin', '2023-01-31 00:29:19.211106'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -755339602::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 2036999445::numeric, '0001097', '0001093', '기타', NULL, NULL, '', 'plm_admin', '2023-01-31 00:29:23.741414'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 2036999445::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -353860635::numeric, '0001098', '', '수주회사', NULL, NULL, '', 'plm_admin', '2023-01-31 01:10:36.362755'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -353860635::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -729065573::numeric, '0001099', '0001098', '성하', NULL, NULL, '', 'plm_admin', '2023-01-31 01:10:51.161096'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -729065573::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 499170056::numeric, '0001100', '0001098', '우성', NULL, NULL, '', 'plm_admin', '2023-01-31 01:10:56.488598'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 499170056::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1636530852::numeric, '0001101', '', '제작공장', NULL, NULL, '', 'plm_admin', '2023-01-31 01:11:08.936064'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1636530852::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1323677820::numeric, '0001102', '0001101', '성하', NULL, NULL, '', 'plm_admin', '2023-01-31 01:11:20.223687'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1323677820::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 767601783::numeric, '0001103', '0001101', '우성', NULL, NULL, '', 'plm_admin', '2023-01-31 01:11:26.780291'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 767601783::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1358779027::numeric, '0001107', '', '검토결과', NULL, NULL, '', 'plm_admin', '2023-01-31 01:15:23.686069'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1358779027::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -5284884::numeric, '0001109', '0001107', 'HOLD', NULL, NULL, '', 'plm_admin', '2023-01-31 01:16:09.850094'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -5284884::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1550660986::numeric, '0001110', '0001107', 'OPEN', NULL, NULL, '', 'plm_admin', '2023-01-31 01:16:15.43922'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1550660986::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1714108590::numeric, '0001111', '0001107', 'CLOSE', NULL, NULL, '', 'plm_admin', '2023-01-31 01:16:21.116593'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1714108590::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1509491077::numeric, '0001113', '', '입고관리-불량사유', NULL, NULL, '', 'plm_admin', '2023-02-03 12:07:45.43493'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1509491077::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -2032162140::numeric, '0001117', '0001113', '오품반입', NULL, NULL, '', 'plm_admin', '2023-02-03 12:08:59.345624'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -2032162140::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -324678430::numeric, '0001534', '0001533', '달러($)', NULL, NULL, '', 'plm_admin', '2023-08-01 13:11:31.592297'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -324678430::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -481109281::numeric, '0001125', '0000318', '제작불량', NULL, NULL, '', 'plm_admin', '2023-02-03 16:11:50.560205'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -481109281::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1618265571::numeric, '0001126', '', '입고관리-귀책', NULL, NULL, '', 'plm_admin', '2023-02-05 19:38:13.559657'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1618265571::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 312415245::numeric, '0001127', '0001126', '공급업체', NULL, NULL, '', 'plm_admin', '2023-02-05 19:38:38.524863'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 312415245::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 2140734181::numeric, '0001128', '0001126', '당사(설계)', NULL, NULL, '', 'plm_admin', '2023-02-05 19:38:46.474618'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 2140734181::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -103068354::numeric, '0001129', '0001126', '당사(구매)', NULL, NULL, '', 'plm_admin', '2023-02-05 19:38:51.45028'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -103068354::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1074263498::numeric, '0001076', '0001074', '선지급', NULL, NULL, '', 'plm_admin', '2023-01-10 21:07:43.189723'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1074263498::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -491736118::numeric, '0001075', '0001074', '계산서발행월+1M', NULL, NULL, '', 'plm_admin', '2023-01-10 21:07:37.996377'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -491736118::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1521418323::numeric, '0001220', '0001219', '국내', NULL, NULL, '', 'plm_admin', '2023-02-24 16:44:17.394039'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1521418323::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1329859478::numeric, '0001221', '0001219', '해외', NULL, NULL, '', 'plm_admin', '2023-02-24 16:44:21.537898'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1329859478::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1507234863::numeric, '0001394', '0000971', '구조변경', NULL, NULL, '', 'plm_admin', '2023-03-15 00:40:31.796208'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1507234863::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1558924554::numeric, '0001407', '0001406', '신규', NULL, NULL, '', 'plm_admin', '2023-03-28 15:44:17.310131'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1558924554::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 295998405::numeric, '0001408', '0001406', '재발주', NULL, NULL, '', 'plm_admin', '2023-03-28 15:44:22.234369'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 295998405::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -142022267::numeric, '0001116', '0001113', '후처리(도금/도장)불량', NULL, NULL, '', 'plm_admin', '2023-02-03 12:08:34.327962'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -142022267::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1826343786::numeric, '0001115', '0001113', '외관불량', NULL, NULL, '', 'plm_admin', '2023-02-03 12:08:24.686507'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1826343786::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1327463778::numeric, '0001114', '0001113', 'Dim''s 불량', NULL, NULL, '', 'plm_admin', '2023-02-03 12:08:16.776735'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1327463778::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -27842736::numeric, '0001526', '0001200', '현장조치', NULL, NULL, '', 'hjshin', '2023-05-09 14:37:47.55442'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -27842736::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 78136845::numeric, '0001203', '0001200', '재발주', NULL, NULL, '', 'plm_admin', '2023-02-15 03:10:05.214442'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 78136845::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -2009746465::numeric, '0001535', '0001533', '유로(€)', NULL, NULL, '', 'plm_admin', '2023-08-01 13:11:36.127933'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -2009746465::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1235607670::numeric, '0001397', '0000062', '가공품', NULL, NULL, '', 'plm_admin', '2023-03-22 17:13:55.854029'::timestamp, 'inActive
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1235607670::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -745221563::numeric, '0001396', '0000062', '레이저품', NULL, NULL, '', 'plm_admin', '2023-03-22 17:13:50.543313'::timestamp, 'inActive
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -745221563::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1705035758::numeric, '0001540', '0000062', '용접품', NULL, NULL, '', 'hjshin', '2023-09-27 15:02:26.956116'::timestamp, 'inActive
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1705035758::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 2012122955::numeric, '0001619', '0001615', '문제없음', NULL, NULL, '', 'plm_admin', '2023-12-15 12:15:17.061915'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 2012122955::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -942073331::numeric, '0001641', '0001611', '고객사', NULL, NULL, '', 'plm_admin', '2024-05-03 11:31:57.036315'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -942073331::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1839494671::numeric, '0001642', '0001611', '공급업체', NULL, NULL, '', 'plm_admin', '2024-05-03 11:33:40.01941'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1839494671::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1593254136::numeric, '0001643', '0001611', '시스템', NULL, NULL, '', 'plm_admin', '2024-05-03 11:34:08.296193'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1593254136::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1728389633::numeric, '0001647', '0001615', 'REWORK', NULL, NULL, '', 'plm_admin', '2024-05-03 11:39:01.608571'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1728389633::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1701616692::numeric, '0001648', '0001615', '사급처리', NULL, NULL, '', 'plm_admin', '2024-05-03 11:43:33.700853'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1701616692::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1085386071::numeric, '0001613', '0001611', '구매', NULL, NULL, '', 'plm_admin', '2023-12-15 12:10:48.94372'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1085386071::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 499294014::numeric, '0001650', '0001612', '기존도면오류', NULL, NULL, '', 'plm_admin', '2024-05-03 11:53:55.272729'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 499294014::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1311496560::numeric, '0001651', '0001612', '기존품 개선', NULL, NULL, '', 'plm_admin', '2024-05-03 11:54:16.886043'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1311496560::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1967193578::numeric, '0001652', '0001613', '발주지연', NULL, NULL, '', 'plm_admin', '2024-05-03 11:57:49.363366'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1967193578::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1328062876::numeric, '0001639', '0000263', '1', NULL, NULL, '', 'plm_admin', '2024-03-27 18:05:14.643007'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1328062876::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -82701924::numeric, '0001653', '0001614', '관리소홀', NULL, NULL, '', 'plm_admin', '2024-05-03 11:59:00.022262'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -82701924::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -135174852::numeric, '0000064', '0000062', '제작품', NULL, NULL, '', 'plm_admin', '2021-09-22 22:59:03.578876'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -135174852::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1770899907::numeric, '0001774', '0001174', '2', NULL, NULL, '', 'plm_admin', '2024-08-28 19:34:39.099562'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1770899907::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 312990662::numeric, '0001654', '0001068', '사급품', NULL, NULL, '', 'plm_admin', '2024-05-27 13:05:28.866734'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 312990662::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 918498997::numeric, '0001655', '0001615', '사전조치', NULL, NULL, '', 'plm_admin', '2024-06-05 14:09:58.680789'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 918498997::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1626376715::numeric, '0001656', '0001642', '제작불량', NULL, NULL, '', 'plm_admin', '2024-06-13 11:00:45.705226'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1626376715::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1802172976::numeric, '0001658', '0900102', '세미나', NULL, NULL, '', 'plm_admin', '2024-06-26 18:31:04.141345'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1802172976::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -156030938::numeric, '0001659', '0900102', '교육과훈련', NULL, NULL, '', 'plm_admin', '2024-06-26 18:31:10.645075'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -156030938::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -247278211::numeric, '0001660', '0900102', '프로젝트회의', NULL, NULL, '', 'plm_admin', '2024-06-26 18:31:16.246922'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -247278211::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1144596817::numeric, '0001661', '0900102', '긴급회의', NULL, NULL, '', 'plm_admin', '2024-06-26 18:31:23.349191'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1144596817::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1363991754::numeric, '0001662', '0900102', '임시회의', NULL, NULL, '', 'plm_admin', '2024-06-26 18:31:27.514579'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1363991754::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 518712528::numeric, '0001663', '0900104', '전략회의', NULL, NULL, '', 'plm_admin', '2024-06-26 18:31:51.241789'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 518712528::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 639584903::numeric, '0001664', '0900104', '협의체회의', NULL, NULL, '', 'plm_admin', '2024-06-26 18:31:58.909947'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 639584903::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1115016582::numeric, '0001665', '0900104', '대표님지시사항', NULL, NULL, '', 'plm_admin', '2024-06-26 18:32:04.209581'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1115016582::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1428048008::numeric, '0001666', '0001399', 'm', NULL, NULL, '', 'plm_admin', '2024-08-06 08:14:48.911706'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1428048008::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -42383300::numeric, '0001667', '', '구매품표준관리_구분', NULL, NULL, '', 'plm_admin', '2024-08-20 16:37:04.959331'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -42383300::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 2136169066::numeric, '0001668', '0001667', '대분류(CODE1)', NULL, NULL, '', 'plm_admin', '2024-08-20 16:38:26.188731'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 2136169066::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1502144476::numeric, '0001669', '0001667', '중분류(CODE2)', NULL, NULL, '', 'plm_admin', '2024-08-20 16:39:08.602402'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1502144476::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1892151885::numeric, '0001670', '0001667', 'Maker(CODE3)', NULL, NULL, '', 'plm_admin', '2024-08-20 16:51:07.632486'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1892151885::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -845249159::numeric, '0001671', '0001667', '품명(CODE4)', NULL, NULL, '', 'plm_admin', '2024-08-20 16:51:26.172159'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -845249159::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1887003065::numeric, '0001672', '0001667', '규격(CODE5)', NULL, NULL, '', 'plm_admin', '2024-08-20 16:51:37.507198'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1887003065::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1490585944::numeric, '0001720', '0000262', 'WSE_D6', NULL, NULL, '', 'plm_admin', '2024-08-28 19:30:00.748094'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1490585944::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -932871364::numeric, '0001721', '0000262', 'WSE_D7', NULL, NULL, '', 'plm_admin', '2024-08-28 19:30:06.392026'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -932871364::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1076821382::numeric, '0001722', '0000262', 'WSE_D8', NULL, NULL, '', 'plm_admin', '2024-08-28 19:30:13.092437'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1076821382::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -587788058::numeric, '0001723', '0000262', 'WSE_D9', NULL, NULL, '', 'plm_admin', '2024-08-28 19:30:16.873342'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -587788058::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1013646335::numeric, '0001724', '0000262', 'WSE_D10', NULL, NULL, '', 'plm_admin', '2024-08-28 19:30:22.389725'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1013646335::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1428751167::numeric, '0001725', '0000262', 'WSE_D11', NULL, NULL, '', 'plm_admin', '2024-08-28 19:30:27.42984'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1428751167::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 2059832503::numeric, '0001726', '0000262', 'WSE_D12', NULL, NULL, '', 'plm_admin', '2024-08-28 19:30:34.237164'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 2059832503::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -35405024::numeric, '0001727', '0000262', 'WSE_D13', NULL, NULL, '', 'plm_admin', '2024-08-28 19:30:38.8223'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -35405024::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -993666356::numeric, '0001728', '0000262', 'WSE_D14', NULL, NULL, '', 'plm_admin', '2024-08-28 19:30:44.087091'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -993666356::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1082297886::numeric, '0001729', '0000262', 'WSE_D15', NULL, NULL, '', 'plm_admin', '2024-08-28 19:30:49.578498'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1082297886::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 67532985::numeric, '0001730', '0000262', 'WSE_D16', NULL, NULL, '', 'plm_admin', '2024-08-28 19:30:53.895704'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 67532985::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1001339719::numeric, '0001731', '0000262', 'WSE_D17', NULL, NULL, '', 'plm_admin', '2024-08-28 19:30:58.881938'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1001339719::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1388621351::numeric, '0001732', '0000263', '2', NULL, NULL, '', 'plm_admin', '2024-08-28 19:31:27.958104'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1388621351::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -667461375::numeric, '0001733', '0000263', '3', NULL, NULL, '', 'plm_admin', '2024-08-28 19:31:34.077461'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -667461375::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1161575183::numeric, '0001734', '0000264', '1', NULL, NULL, '', 'plm_admin', '2024-08-28 19:31:39.935476'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1161575183::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1389135393::numeric, '0001735', '0000264', '2', NULL, NULL, '', 'plm_admin', '2024-08-28 19:31:43.059683'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1389135393::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1161886607::numeric, '0001736', '0000264', '3', NULL, NULL, '', 'plm_admin', '2024-08-28 19:31:48.208843'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1161886607::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1806067148::numeric, '0001737', '0000265', '1', NULL, NULL, '', 'plm_admin', '2024-08-28 19:31:53.447973'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1806067148::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1659635783::numeric, '0001738', '0000265', '2', NULL, NULL, '', 'plm_admin', '2024-08-28 19:31:56.958821'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1659635783::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1029678290::numeric, '0001739', '0000265', '3', NULL, NULL, '', 'plm_admin', '2024-08-28 19:32:00.918064'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1029678290::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1690581771::numeric, '0001740', '0000266', '1', NULL, NULL, '', 'plm_admin', '2024-08-28 19:32:05.845317'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1690581771::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 642986521::numeric, '0001741', '0000266', '2', NULL, NULL, '', 'plm_admin', '2024-08-28 19:32:09.53104'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 642986521::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1167981181::numeric, '0001742', '0000266', '3', NULL, NULL, '', 'plm_admin', '2024-08-28 19:32:12.509557'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1167981181::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -492554250::numeric, '0001743', '0001164', '1', NULL, NULL, '', 'plm_admin', '2024-08-28 19:32:17.380537'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -492554250::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1031581137::numeric, '0001744', '0001164', '2', NULL, NULL, '', 'plm_admin', '2024-08-28 19:32:20.619768'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1031581137::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1537408425::numeric, '0001745', '0001164', '3', NULL, NULL, '', 'plm_admin', '2024-08-28 19:32:24.171348'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1537408425::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 613531074::numeric, '0001746', '0001165', '1', NULL, NULL, '', 'plm_admin', '2024-08-28 19:32:29.098966'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 613531074::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 162427171::numeric, '0001747', '0001165', '2', NULL, NULL, '', 'plm_admin', '2024-08-28 19:32:32.674356'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 162427171::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -943253638::numeric, '0001748', '0001165', '3', NULL, NULL, '', 'plm_admin', '2024-08-28 19:32:35.944541'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -943253638::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 2098480355::numeric, '0001749', '0001166', '1', NULL, NULL, '', 'plm_admin', '2024-08-28 19:32:46.110798'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 2098480355::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1293321376::numeric, '0001750', '0001166', '2', NULL, NULL, '', 'plm_admin', '2024-08-28 19:32:49.907383'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1293321376::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -2130120034::numeric, '0001751', '0001166', '3', NULL, NULL, '', 'plm_admin', '2024-08-28 19:32:54.906814'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -2130120034::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 229690172::numeric, '0001752', '0001167', '1', NULL, NULL, '', 'plm_admin', '2024-08-28 19:32:59.913145'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 229690172::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -458085768::numeric, '0001753', '0001167', '2', NULL, NULL, '', 'plm_admin', '2024-08-28 19:33:03.340161'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -458085768::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -568222930::numeric, '0001754', '0001167', '3', NULL, NULL, '', 'plm_admin', '2024-08-28 19:33:07.29564'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -568222930::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -790624063::numeric, '0001755', '0001168', '1', NULL, NULL, '', 'plm_admin', '2024-08-28 19:33:13.142264'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -790624063::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1635069929::numeric, '0001756', '0001168', '2', NULL, NULL, '', 'plm_admin', '2024-08-28 19:33:16.631147'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1635069929::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1704414740::numeric, '0001757', '0001168', '3', NULL, NULL, '', 'plm_admin', '2024-08-28 19:33:19.782595'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1704414740::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1868575934::numeric, '0001758', '0001169', '1', NULL, NULL, '', 'plm_admin', '2024-08-28 19:33:25.859082'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1868575934::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1783874152::numeric, '0001759', '0001169', '2', NULL, NULL, '', 'plm_admin', '2024-08-28 19:33:29.492956'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1783874152::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -691812910::numeric, '0001760', '0001169', '3', NULL, NULL, '', 'plm_admin', '2024-08-28 19:33:32.695401'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -691812910::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1908480416::numeric, '0001761', '0001170', '1', NULL, NULL, '', 'plm_admin', '2024-08-28 19:33:38.377057'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1908480416::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1664276344::numeric, '0001762', '0001170', '2', NULL, NULL, '', 'plm_admin', '2024-08-28 19:33:41.976969'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1664276344::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -75370596::numeric, '0001763', '0001170', '3', NULL, NULL, '', 'plm_admin', '2024-08-28 19:33:45.598747'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -75370596::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 2068356886::numeric, '0001764', '0001171', '1', NULL, NULL, '', 'plm_admin', '2024-08-28 19:33:51.938341'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 2068356886::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -300259462::numeric, '0001765', '0001171', '2', NULL, NULL, '', 'plm_admin', '2024-08-28 19:33:55.494833'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -300259462::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1322568114::numeric, '0001766', '0001171', '3', NULL, NULL, '', 'plm_admin', '2024-08-28 19:33:59.151919'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1322568114::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -12643029::numeric, '0001767', '0001172', '1', NULL, NULL, '', 'plm_admin', '2024-08-28 19:34:05.614964'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -12643029::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1066640077::numeric, '0001768', '0001172', '2', NULL, NULL, '', 'plm_admin', '2024-08-28 19:34:09.931792'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1066640077::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -58193824::numeric, '0001769', '0001172', '3', NULL, NULL, '', 'plm_admin', '2024-08-28 19:34:14.68754'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -58193824::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 671684779::numeric, '0001770', '0001173', '1', NULL, NULL, '', 'plm_admin', '2024-08-28 19:34:22.832721'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 671684779::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1036584007::numeric, '0001771', '0001173', '2', NULL, NULL, '', 'plm_admin', '2024-08-28 19:34:26.565483'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1036584007::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 388070013::numeric, '0001772', '0001173', '3', NULL, NULL, '', 'plm_admin', '2024-08-28 19:34:29.827924'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 388070013::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1881097166::numeric, '0001773', '0001174', '1', NULL, NULL, '', 'plm_admin', '2024-08-28 19:34:35.350001'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1881097166::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1717842368::numeric, '0001775', '0001174', '3', NULL, NULL, '', 'plm_admin', '2024-08-28 19:34:45.250582'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1717842368::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 884309049::numeric, '0001776', '0001175', '1', NULL, NULL, '', 'plm_admin', '2024-08-28 19:34:50.115269'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 884309049::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -897456304::numeric, '0001777', '0001175', '2', NULL, NULL, '', 'plm_admin', '2024-08-28 19:34:53.846392'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -897456304::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -937095252::numeric, '0001778', '0001175', '3', NULL, NULL, '', 'plm_admin', '2024-08-28 19:34:57.419305'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -937095252::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1991982592::numeric, '0001779', '0001176', '1', NULL, NULL, '', 'plm_admin', '2024-08-28 19:35:02.212383'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1991982592::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 728843242::numeric, '0001780', '0001176', '2', NULL, NULL, '', 'plm_admin', '2024-08-28 19:35:05.168076'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 728843242::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1370145498::numeric, '0001781', '0001176', '3', NULL, NULL, '', 'plm_admin', '2024-08-28 19:35:09.259725'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1370145498::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1433565510::numeric, '0001782', '0001177', '1', NULL, NULL, '', 'plm_admin', '2024-08-28 19:35:27.292456'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1433565510::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 183612982::numeric, '0001783', '0001177', '2', NULL, NULL, '', 'plm_admin', '2024-08-28 19:35:33.596194'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 183612982::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1481036241::numeric, '0001784', '0001177', '3', NULL, NULL, '', 'plm_admin', '2024-08-28 19:35:37.863328'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1481036241::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1046031134::numeric, '0001785', '0001068', '턴키', NULL, NULL, '', 'plm_admin', '2024-09-25 13:24:31.533176'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1046031134::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 1725607688::numeric, '0001788', '0000062', '구매품표준', NULL, NULL, '', 'plm_admin', '2024-10-09 16:14:09.218059'::timestamp, 'inActive
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 1725607688::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT -1629889157::numeric, '0001787', '0001068', '구매품표준', NULL, NULL, '', 'plm_admin', '2024-10-09 16:12:16.050444'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = -1629889157::numeric);
INSERT INTO comm_code (objid, code_id, parent_code_id, code_name, id, code_cd, ext_val, writer, regdate, status)
SELECT 962784264::numeric, '0001789', '0001399', 'kg', NULL, NULL, '', 'plm_admin', '2025-02-17 16:31:37.403229'::timestamp, 'active
'
WHERE NOT EXISTS (SELECT 1 FROM comm_code WHERE objid = 962784264::numeric);
COMMIT;