DELETE FROM gu_person
WHERE person_id IN (SELECT person_id FROM person WHERE vo_person_category_id = 101336);

DELETE FROM gu_vehicle
WHERE vehicle_id IN (SELECT vehicle_id FROM vehicle WHERE vo_vehicle_category_id IN (103107,103108,103109));

DELETE FROM gu_vehicle_owner
WHERE vo_person_category_id = 106628
OR vo_vehicle_category_id IN (103107,103108,103109);

UPDATE person
SET vehicle_owner_id = 101407
WHERE vo_person_category_id = 101336;

UPDATE vo_person_category
SET vehicle_owner_id = 101407
WHERE vo_person_category_id = 106628;

UPDATE vehicle
SET vehicle_owner_id = 101407
WHERE vo_vehicle_category_id IN (103107,103108,103109);

UPDATE vo_vehicle_category
SET vehicle_owner_id = 101407
WHERE vo_vehicle_category_id IN (103107,103108,103109);


INSERT INTO GU_PERSON (PERSON_ID, GUI_USER_ID, CREATION_DATE, LM_DATE) VALUES (224995,115472, SYSDATE, SYSDATE);
INSERT INTO GU_PERSON (PERSON_ID, GUI_USER_ID, CREATION_DATE, LM_DATE) VALUES (224996,115472, SYSDATE, SYSDATE);
INSERT INTO GU_PERSON (PERSON_ID, GUI_USER_ID, CREATION_DATE, LM_DATE) VALUES (224997,115472, SYSDATE, SYSDATE);
INSERT INTO GU_PERSON (PERSON_ID, GUI_USER_ID, CREATION_DATE, LM_DATE) VALUES (224998,115472, SYSDATE, SYSDATE);
INSERT INTO GU_PERSON (PERSON_ID, GUI_USER_ID, CREATION_DATE, LM_DATE) VALUES (225002,115472, SYSDATE, SYSDATE);
INSERT INTO GU_PERSON (PERSON_ID, GUI_USER_ID, CREATION_DATE, LM_DATE) VALUES (225003,115472, SYSDATE, SYSDATE);
INSERT INTO GU_PERSON (PERSON_ID, GUI_USER_ID, CREATION_DATE, LM_DATE) VALUES (225005,115472, SYSDATE, SYSDATE);
INSERT INTO GU_PERSON (PERSON_ID, GUI_USER_ID, CREATION_DATE, LM_DATE) VALUES (225006,115472, SYSDATE, SYSDATE);
INSERT INTO GU_PERSON (PERSON_ID, GUI_USER_ID, CREATION_DATE, LM_DATE) VALUES (225034,115472, SYSDATE, SYSDATE);
INSERT INTO GU_PERSON (PERSON_ID, GUI_USER_ID, CREATION_DATE, LM_DATE) VALUES (225035,115472, SYSDATE, SYSDATE);
INSERT INTO GU_PERSON (PERSON_ID, GUI_USER_ID, CREATION_DATE, LM_DATE) VALUES (225036,115472, SYSDATE, SYSDATE);
INSERT INTO GU_PERSON (PERSON_ID, GUI_USER_ID, CREATION_DATE, LM_DATE) VALUES (225037,115472, SYSDATE, SYSDATE);


INSERT INTO GU_VEHICLE VALUES (115472,123296, NULL);
INSERT INTO GU_VEHICLE VALUES (115472,120617, NULL);
INSERT INTO GU_VEHICLE VALUES (115472,121459, NULL);
INSERT INTO GU_VEHICLE VALUES (115472,169503, NULL);
INSERT INTO GU_VEHICLE VALUES (115472,169506, NULL);
INSERT INTO GU_VEHICLE VALUES (115472,169507, NULL);
INSERT INTO GU_VEHICLE VALUES (115472,169505, NULL);

INSERT INTO GU_VEHICLE_OWNER (GUI_USER_ID, VEHICLE_OWNER_ID, GU_VEHICLE_OWNER_ID,VO_VEHICLE_CATEGORY_ID) VALUES (115472,101407,SEQ_GU_VEHICLE_OWNER_ID.NEXTVAL,103109);
INSERT INTO GU_VEHICLE_OWNER (GUI_USER_ID, VEHICLE_OWNER_ID, GU_VEHICLE_OWNER_ID,VO_VEHICLE_CATEGORY_ID) VALUES (115472,101407,SEQ_GU_VEHICLE_OWNER_ID.NEXTVAL,103108);
INSERT INTO GU_VEHICLE_OWNER (GUI_USER_ID, VEHICLE_OWNER_ID, GU_VEHICLE_OWNER_ID,VO_VEHICLE_CATEGORY_ID) VALUES (115472,101407,SEQ_GU_VEHICLE_OWNER_ID.NEXTVAL,103107);
INSERT INTO GU_VEHICLE_OWNER (GUI_USER_ID, VEHICLE_OWNER_ID, GU_VEHICLE_OWNER_ID,VO_PERSON_CATEGORY_ID) VALUES (115472,101407,SEQ_GU_VEHICLE_OWNER_ID.NEXTVAL,106628);