API tools faq
paste
Advertisement
psi_mmobile

Untitled

psi_mmobile
Jan 17th, 2024
1,533
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 73.41 KB | None | 0 0
raw download clone embed print report
  1. -- add missing units of measurement
  2. INSERT INTO unit_of_measurement
  3. VALUES (seq_unit_of_measurement_id.NEXTVAL,100718,'M2',NULL,'PSI',SYSDATE);
  4. INSERT INTO unit_of_measurement
  5. VALUES (seq_unit_of_measurement_id.NEXTVAL,100718,'M3',NULL,'PSI',SYSDATE);
  6. INSERT INTO unit_of_measurement
  7. VALUES (seq_unit_of_measurement_id.NEXTVAL,100718,'PIECE',NULL,'PSI',SYSDATE);
  8.  
  9. -- deactivate all present activities for VALENS
  10. UPDATE activity
  11. SET is_active = 'N'
  12. WHERE vehicle_owner_id = 100718;
  13.  
  14. -- update existing conflicting activities
  15. SELECT * FROM activity
  16. WHERE activity_id = 3689;--3691,3689 SET CODE TO PREVIOUS CODE + _XX
  17.  
  18. UPDATE activity
  19. SET activity_code = activity_code || '_XX'
  20. WHERE activity_id IN (3691,3689);
  21.  
  22. -- insert new activities
  23. INSERT INTO activity (activity_id,vehicle_owner_id,activity_code,activity_name,lm_name,lm_date,is_active,unit_of_measurement_id) VALUES (seq_activity_id.NEXTVAL,100718,'42704','PREFABRICATION BALCON','PSI',SYSDATE,'Y',192);
  24. INSERT INTO activity (activity_id,vehicle_owner_id,activity_code,activity_name,lm_name,lm_date,is_active,unit_of_measurement_id) VALUES (seq_activity_id.NEXTVAL,100718,'42705','PREFABRICATION - SOUS-TRAITANT BALCON','PSI',SYSDATE,'Y',192);
  25. INSERT INTO activity (activity_id,vehicle_owner_id,activity_code,activity_name,lm_name,lm_date,is_active,unit_of_measurement_id) VALUES (seq_activity_id.NEXTVAL,100718,'42104','BETONNAGE COLONNE','PSI',SYSDATE,'Y',191);
  26. INSERT INTO activity (activity_id,vehicle_owner_id,activity_code,activity_name,lm_name,lm_date,is_active,unit_of_measurement_id) VALUES (seq_activity_id.NEXTVAL,100718,'42105_ST','BETONNAGE - SOUS-TRAITANT COLONNE','PSI',SYSDATE,'Y',191);
  27. INSERT INTO activity (activity_id,vehicle_owner_id,activity_code,activity_name,lm_name,lm_date,is_active,unit_of_measurement_id) VALUES (seq_activity_id.NEXTVAL,100718,'44554','COFFRAGE COLONNE','PSI',SYSDATE,'Y',190);
  28. INSERT INTO activity (activity_id,vehicle_owner_id,activity_code,activity_name,lm_name,lm_date,is_active,unit_of_measurement_id) VALUES (seq_activity_id.NEXTVAL,100718,'10004','COFFRAGE - SOUS-TRAITANT COLONNE','PSI',SYSDATE,'Y',190);
  29. INSERT INTO activity (activity_id,vehicle_owner_id,activity_code,activity_name,lm_name,lm_date,is_active,unit_of_measurement_id) VALUES (seq_activity_id.NEXTVAL,100718,'42702','PREFABRICATION COLONNE','PSI',SYSDATE,'Y',192);
  30. INSERT INTO activity (activity_id,vehicle_owner_id,activity_code,activity_name,lm_name,lm_date,is_active,unit_of_measurement_id) VALUES (seq_activity_id.NEXTVAL,100718,'42703_ST','PREFABRICATION - SOUS-TRAITANT COLONNE','PSI',SYSDATE,'Y',192);
  31. INSERT INTO activity (activity_id,vehicle_owner_id,activity_code,activity_name,lm_name,lm_date,is_active,unit_of_measurement_id) VALUES (seq_activity_id.NEXTVAL,100718,'42102','BETONNAGE DALLE','PSI',SYSDATE,'Y',191);
  32. INSERT INTO activity (activity_id,vehicle_owner_id,activity_code,activity_name,lm_name,lm_date,is_active,unit_of_measurement_id) VALUES (seq_activity_id.NEXTVAL,100718,'42103_ST','BETONNAGE - SOUS-TRAITANT DALLE','PSI',SYSDATE,'Y',191);
  33. INSERT INTO activity (activity_id,vehicle_owner_id,activity_code,activity_name,lm_name,lm_date,is_active,unit_of_measurement_id) VALUES (seq_activity_id.NEXTVAL,100718,'44552','COFFRAGE DALLE','PSI',SYSDATE,'Y',190);
  34. INSERT INTO activity (activity_id,vehicle_owner_id,activity_code,activity_name,lm_name,lm_date,is_active,unit_of_measurement_id) VALUES (seq_activity_id.NEXTVAL,100718,'10002','COFFRAGE - SOUS-TRAITANT DALLE','PSI',SYSDATE,'Y',190);
  35. INSERT INTO activity (activity_id,vehicle_owner_id,activity_code,activity_name,lm_name,lm_date,is_active,unit_of_measurement_id) VALUES (seq_activity_id.NEXTVAL,100718,'42600','PREFABRICATION ESCALIER','PSI',SYSDATE,'Y',190);
  36. INSERT INTO activity (activity_id,vehicle_owner_id,activity_code,activity_name,lm_name,lm_date,is_active,unit_of_measurement_id) VALUES (seq_activity_id.NEXTVAL,100718,'42601','PREFABRICATION - SOUS-TRAITANT ESCALIER','PSI',SYSDATE,'Y',190);
  37. INSERT INTO activity (activity_id,vehicle_owner_id,activity_code,activity_name,lm_name,lm_date,is_active,unit_of_measurement_id) VALUES (seq_activity_id.NEXTVAL,100718,'42101','BETONNAGE FONDATION','PSI',SYSDATE,'Y',191);
  38. INSERT INTO activity (activity_id,vehicle_owner_id,activity_code,activity_name,lm_name,lm_date,is_active,unit_of_measurement_id) VALUES (seq_activity_id.NEXTVAL,100718,'30001','BETONNAGE - SOUS-TRAITANT FONDATION','PSI',SYSDATE,'Y',191);
  39. INSERT INTO activity (activity_id,vehicle_owner_id,activity_code,activity_name,lm_name,lm_date,is_active,unit_of_measurement_id) VALUES (seq_activity_id.NEXTVAL,100718,'44551','COFFRAGE FONDATION','PSI',SYSDATE,'Y',190);
  40. INSERT INTO activity (activity_id,vehicle_owner_id,activity_code,activity_name,lm_name,lm_date,is_active,unit_of_measurement_id) VALUES (seq_activity_id.NEXTVAL,100718,'10001','COFFRAGE - SOUS-TRAITANT FONDATION','PSI',SYSDATE,'Y',190);
  41. INSERT INTO activity (activity_id,vehicle_owner_id,activity_code,activity_name,lm_name,lm_date,is_active,unit_of_measurement_id) VALUES (seq_activity_id.NEXTVAL,100718,'42107','BETONNAGE HOURDIS','PSI',SYSDATE,'Y',191);
  42. INSERT INTO activity (activity_id,vehicle_owner_id,activity_code,activity_name,lm_name,lm_date,is_active,unit_of_measurement_id) VALUES (seq_activity_id.NEXTVAL,100718,'42108_ST','BETONNAGE - SOUS-TRAITANT HOURDIS','PSI',SYSDATE,'Y',191);
  43. INSERT INTO activity (activity_id,vehicle_owner_id,activity_code,activity_name,lm_name,lm_date,is_active,unit_of_measurement_id) VALUES (seq_activity_id.NEXTVAL,100718,'42400','PREFABRICATION HOURDIS','PSI',SYSDATE,'Y',190);
  44. INSERT INTO activity (activity_id,vehicle_owner_id,activity_code,activity_name,lm_name,lm_date,is_active,unit_of_measurement_id) VALUES (seq_activity_id.NEXTVAL,100718,'42401','PREFABRICATION - SOUS-TRAITANT HOURDIS','PSI',SYSDATE,'Y',190);
  45. INSERT INTO activity (activity_id,vehicle_owner_id,activity_code,activity_name,lm_name,lm_date,is_active,unit_of_measurement_id) VALUES (seq_activity_id.NEXTVAL,100718,'42105','BETONNAGE POUTRE','PSI',SYSDATE,'Y',191);
  46. INSERT INTO activity (activity_id,vehicle_owner_id,activity_code,activity_name,lm_name,lm_date,is_active,unit_of_measurement_id) VALUES (seq_activity_id.NEXTVAL,100718,'42106_ST','BETONNAGE - SOUS-TRAITANT POUTRE','PSI',SYSDATE,'Y',191);
  47. INSERT INTO activity (activity_id,vehicle_owner_id,activity_code,activity_name,lm_name,lm_date,is_active,unit_of_measurement_id) VALUES (seq_activity_id.NEXTVAL,100718,'44555','COFFRAGE POUTRE','PSI',SYSDATE,'Y',190);
  48. INSERT INTO activity (activity_id,vehicle_owner_id,activity_code,activity_name,lm_name,lm_date,is_active,unit_of_measurement_id) VALUES (seq_activity_id.NEXTVAL,100718,'10005','COFFRAGE - SOUS-TRAITANT POUTRE','PSI',SYSDATE,'Y',190);
  49. INSERT INTO activity (activity_id,vehicle_owner_id,activity_code,activity_name,lm_name,lm_date,is_active,unit_of_measurement_id) VALUES (seq_activity_id.NEXTVAL,100718,'42703','PREFABRICATION POUTRE','PSI',SYSDATE,'Y',192);
  50. INSERT INTO activity (activity_id,vehicle_owner_id,activity_code,activity_name,lm_name,lm_date,is_active,unit_of_measurement_id) VALUES (seq_activity_id.NEXTVAL,100718,'42704_ST','PREFABRICATION - SOUS-TRAITANT POUTRE','PSI',SYSDATE,'Y',192);
  51. INSERT INTO activity (activity_id,vehicle_owner_id,activity_code,activity_name,lm_name,lm_date,is_active,unit_of_measurement_id) VALUES (seq_activity_id.NEXTVAL,100718,'42106','BETONNAGE PREDALLE','PSI',SYSDATE,'Y',191);
  52. INSERT INTO activity (activity_id,vehicle_owner_id,activity_code,activity_name,lm_name,lm_date,is_active,unit_of_measurement_id) VALUES (seq_activity_id.NEXTVAL,100718,'42107_ST','BETONNAGE - SOUS-TRAITANT PREDALLE','PSI',SYSDATE,'Y',191);
  53. INSERT INTO activity (activity_id,vehicle_owner_id,activity_code,activity_name,lm_name,lm_date,is_active,unit_of_measurement_id) VALUES (seq_activity_id.NEXTVAL,100718,'42300','PREFABRICATION PREDALLE','PSI',SYSDATE,'Y',190);
  54. INSERT INTO activity (activity_id,vehicle_owner_id,activity_code,activity_name,lm_name,lm_date,is_active,unit_of_measurement_id) VALUES (seq_activity_id.NEXTVAL,100718,'20001','PREFABRICATION - SOUS-TRAITANT PREDALLE','PSI',SYSDATE,'Y',190);
  55. INSERT INTO activity (activity_id,vehicle_owner_id,activity_code,activity_name,lm_name,lm_date,is_active,unit_of_measurement_id) VALUES (seq_activity_id.NEXTVAL,100718,'42108','BETONNAGE PREMUR','PSI',SYSDATE,'Y',191);
  56. INSERT INTO activity (activity_id,vehicle_owner_id,activity_code,activity_name,lm_name,lm_date,is_active,unit_of_measurement_id) VALUES (seq_activity_id.NEXTVAL,100718,'42109','BETONNAGE - SOUS-TRAITANT PREMUR','PSI',SYSDATE,'Y',191);
  57. INSERT INTO activity (activity_id,vehicle_owner_id,activity_code,activity_name,lm_name,lm_date,is_active,unit_of_measurement_id) VALUES (seq_activity_id.NEXTVAL,100718,'42500','PREFABRICATION PREMUR','PSI',SYSDATE,'Y',190);
  58. INSERT INTO activity (activity_id,vehicle_owner_id,activity_code,activity_name,lm_name,lm_date,is_active,unit_of_measurement_id) VALUES (seq_activity_id.NEXTVAL,100718,'42501','PREFABRICATION - SOUS-TRAITANT PREMUR','PSI',SYSDATE,'Y',190);
  59. INSERT INTO activity (activity_id,vehicle_owner_id,activity_code,activity_name,lm_name,lm_date,is_active,unit_of_measurement_id) VALUES (seq_activity_id.NEXTVAL,100718,'42103','BETONNAGE VOILE','PSI',SYSDATE,'Y',191);
  60. INSERT INTO activity (activity_id,vehicle_owner_id,activity_code,activity_name,lm_name,lm_date,is_active,unit_of_measurement_id) VALUES (seq_activity_id.NEXTVAL,100718,'42104_ST','BETONNAGE - SOUS-TRAITANT VOILE','PSI',SYSDATE,'Y',191);
  61. INSERT INTO activity (activity_id,vehicle_owner_id,activity_code,activity_name,lm_name,lm_date,is_active,unit_of_measurement_id) VALUES (seq_activity_id.NEXTVAL,100718,'44553','COFFRAGE VOILE','PSI',SYSDATE,'Y',190);
  62. INSERT INTO activity (activity_id,vehicle_owner_id,activity_code,activity_name,lm_name,lm_date,is_active,unit_of_measurement_id) VALUES (seq_activity_id.NEXTVAL,100718,'10003','COFFRAGE - SOUS-TRAITANT VOILE','PSI',SYSDATE,'Y',190);
  63. INSERT INTO activity (activity_id,vehicle_owner_id,activity_code,activity_name,lm_name,lm_date,is_active,unit_of_measurement_id) VALUES (seq_activity_id.NEXTVAL,100718,'42701','PREFABRICATION VOILE','PSI',SYSDATE,'Y',190);
  64. INSERT INTO activity (activity_id,vehicle_owner_id,activity_code,activity_name,lm_name,lm_date,is_active,unit_of_measurement_id) VALUES (seq_activity_id.NEXTVAL,100718,'42702_ST','PREFABRICATION - SOUS-TRAITANT VOILE','PSI',SYSDATE,'Y',190);
  65.  
  66. -- statements for WBS
  67. -- WBS LVL0
  68. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name) VALUES (seq_wbs_id.NEXTVAL,101417,'TEST GREENWOOD 3',0,NULL,'GGW3',100718,0,'Y','Y',SYSDATE,'PSI');
  69. -- WBS LVL1
  70. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name) VALUES (seq_wbs_id.NEXTVAL,101417,'FOND-RADIER',1,(SELECT wbs_id FROM wbs WHERE name='TEST GREENWOOD 3' AND ref_number='GGW3' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'FR',100718,0,'Y',NULL,SYSDATE,'PSI');
  71. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name) VALUES (seq_wbs_id.NEXTVAL,101417,'FONDATION',1,(SELECT wbs_id FROM wbs WHERE name='TEST GREENWOOD 3' AND ref_number='GGW3' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'F',100718,0,'Y',NULL,SYSDATE,'PSI');
  72. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name) VALUES (seq_wbs_id.NEXTVAL,101417,'Rez 0',1,(SELECT wbs_id FROM wbs WHERE name='TEST GREENWOOD 3' AND ref_number='GGW3' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'R0',100718,0,'Y',NULL,SYSDATE,'PSI');
  73. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name) VALUES (seq_wbs_id.NEXTVAL,101417,'Rez 1',1,(SELECT wbs_id FROM wbs WHERE name='TEST GREENWOOD 3' AND ref_number='GGW3' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'R1',100718,0,'Y',NULL,SYSDATE,'PSI');
  74. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name) VALUES (seq_wbs_id.NEXTVAL,101417,'Sous-sol 1',1,(SELECT wbs_id FROM wbs WHERE name='TEST GREENWOOD 3' AND ref_number='GGW3' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'SS1',100718,0,'Y',NULL,SYSDATE,'PSI');
  75. -- WBS LVL2
  76. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name) VALUES (seq_wbs_id.NEXTVAL,101417,'Zone 2',2,(SELECT wbs_id FROM wbs WHERE name='FOND-RADIER' AND ref_number='FR' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'Z2',100718,0,'Y',NULL,SYSDATE,'PSI');
  77. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name) VALUES (seq_wbs_id.NEXTVAL,101417,'Zone 1',2,(SELECT wbs_id FROM wbs WHERE name='FONDATION' AND ref_number='F' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'Z1',100718,0,'Y',NULL,SYSDATE,'PSI');
  78. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name) VALUES (seq_wbs_id.NEXTVAL,101417,'Zone 2',2,(SELECT wbs_id FROM wbs WHERE name='FONDATION' AND ref_number='F' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'Z2',100718,0,'Y',NULL,SYSDATE,'PSI');
  79. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name) VALUES (seq_wbs_id.NEXTVAL,101417,'Zone 1',2,(SELECT wbs_id FROM wbs WHERE name='Rez 0' AND ref_number='R0' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'Z1',100718,0,'Y',NULL,SYSDATE,'PSI');
  80. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name) VALUES (seq_wbs_id.NEXTVAL,101417,'Zone 2',2,(SELECT wbs_id FROM wbs WHERE name='Rez 0' AND ref_number='R0' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'Z2',100718,0,'Y',NULL,SYSDATE,'PSI');
  81. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name) VALUES (seq_wbs_id.NEXTVAL,101417,'Zone 1',2,(SELECT wbs_id FROM wbs WHERE name='Rez 1' AND ref_number='R1' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'Z1',100718,0,'Y',NULL,SYSDATE,'PSI');
  82. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name) VALUES (seq_wbs_id.NEXTVAL,101417,'Zone 2',2,(SELECT wbs_id FROM wbs WHERE name='Rez 1' AND ref_number='R1' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'Z2',100718,0,'Y',NULL,SYSDATE,'PSI');
  83. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name) VALUES (seq_wbs_id.NEXTVAL,101417,'Zone 1',2,(SELECT wbs_id FROM wbs WHERE name='Sous-sol 1' AND ref_number='SS1' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'Z1',100718,0,'Y',NULL,SYSDATE,'PSI');
  84. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name) VALUES (seq_wbs_id.NEXTVAL,101417,'Zone 2',2,(SELECT wbs_id FROM wbs WHERE name='Sous-sol 1' AND ref_number='SS1' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'Z2',100718,0,'Y',NULL,SYSDATE,'PSI');
  85. -- WBS LVL3
  86. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name) VALUES (seq_wbs_id.NEXTVAL,101417,'Dalle',3,(SELECT wbs_id FROM wbs WHERE name='Zone 2' AND ref_number='Z2' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'D',100718,0,'Y',NULL,SYSDATE,'PSI');
  87. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name) VALUES (seq_wbs_id.NEXTVAL,101417,'Dalle',3,(SELECT wbs_id FROM wbs WHERE name='Zone 1' AND ref_number='Z1' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'D',100718,0,'Y',NULL,SYSDATE,'PSI');
  88. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name) VALUES (seq_wbs_id.NEXTVAL,101417,'Voile',3,(SELECT wbs_id FROM wbs WHERE name='Zone 1' AND ref_number='Z1' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'V',100718,0,'Y',NULL,SYSDATE,'PSI');
  89. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name) VALUES (seq_wbs_id.NEXTVAL,101417,'Voile',3,(SELECT wbs_id FROM wbs WHERE name='Zone 2' AND ref_number='Z2' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'V',100718,0,'Y',NULL,SYSDATE,'PSI');
  90. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name) VALUES (seq_wbs_id.NEXTVAL,101417,'Poutre',3,(SELECT wbs_id FROM wbs WHERE name='Zone 1' AND ref_number='Z1' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'P',100718,0,'Y',NULL,SYSDATE,'PSI');
  91. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name) VALUES (seq_wbs_id.NEXTVAL,101417,'Prédalle',3,(SELECT wbs_id FROM wbs WHERE name='Zone 1' AND ref_number='Z1' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'PD',100718,0,'Y',NULL,SYSDATE,'PSI');
  92. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name) VALUES (seq_wbs_id.NEXTVAL,101417,'Prémur',3,(SELECT wbs_id FROM wbs WHERE name='Zone 1' AND ref_number='Z1' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'PM',100718,0,'Y',NULL,SYSDATE,'PSI');
  93. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name) VALUES (seq_wbs_id.NEXTVAL,101417,'Prémur',3,(SELECT wbs_id FROM wbs WHERE name='Zone 2' AND ref_number='Z2' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'PM',100718,0,'Y',NULL,SYSDATE,'PSI');
  94. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name) VALUES (seq_wbs_id.NEXTVAL,101417,'Colonne',3,(SELECT wbs_id FROM wbs WHERE name='Zone 1' AND ref_number='Z1' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'C',100718,0,'Y',NULL,SYSDATE,'PSI');
  95. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name) VALUES (seq_wbs_id.NEXTVAL,101417,'Colonne',3,(SELECT wbs_id FROM wbs WHERE name='Zone 2' AND ref_number='Z2' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'C',100718,0,'Y',NULL,SYSDATE,'PSI');
  96. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name) VALUES (seq_wbs_id.NEXTVAL,101417,'Poutre',3,(SELECT wbs_id FROM wbs WHERE name='Zone 2' AND ref_number='Z2' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'P',100718,0,'Y',NULL,SYSDATE,'PSI');
  97. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name) VALUES (seq_wbs_id.NEXTVAL,101417,'Prédalle',3,(SELECT wbs_id FROM wbs WHERE name='Zone 2' AND ref_number='Z2' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'PD',100718,0,'Y',NULL,SYSDATE,'PSI');
  98. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name) VALUES (seq_wbs_id.NEXTVAL,101417,'Balcon',3,(SELECT wbs_id FROM wbs WHERE name='Zone 1' AND ref_number='Z1' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'B',100718,0,'Y',NULL,SYSDATE,'PSI');
  99. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name) VALUES (seq_wbs_id.NEXTVAL,101417,'Balcon',3,(SELECT wbs_id FROM wbs WHERE name='Zone 2' AND ref_number='Z2' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'B',100718,0,'Y',NULL,SYSDATE,'PSI');
  100. -- WBS LVL4
  101. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Betonnage',4,(SELECT wbs_id FROM wbs WHERE name='Dalle' AND ref_number='D' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'B',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_FR_Z2_D_B',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='42102'));
  102. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Betonnage',4,(SELECT wbs_id FROM wbs WHERE name='Dalle' AND ref_number='D' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'B',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_F_Z1_D_B',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='42102'));
  103. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Betonnage',4,(SELECT wbs_id FROM wbs WHERE name='Voile' AND ref_number='V' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'B',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_F_Z1_V_B',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='42103'));
  104. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Betonnage',4,(SELECT wbs_id FROM wbs WHERE name='Dalle' AND ref_number='D' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'B',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_F_Z2_D_B',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='42102'));
  105. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Betonnage',4,(SELECT wbs_id FROM wbs WHERE name='Voile' AND ref_number='V' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'B',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_F_Z2_V_B',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='42103'));
  106. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Betonnage',4,(SELECT wbs_id FROM wbs WHERE name='Poutre' AND ref_number='P' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'B',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_R0_Z1_P_B',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='42105'));
  107. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Betonnage',4,(SELECT wbs_id FROM wbs WHERE name='Prédalle' AND ref_number='PD' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'B',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_R0_Z1_PD_B',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='42106'));
  108. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Betonnage',4,(SELECT wbs_id FROM wbs WHERE name='Prémur' AND ref_number='PM' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'B',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_R0_Z1_PM_B',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='42108'));
  109. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Betonnage',4,(SELECT wbs_id FROM wbs WHERE name='Voile' AND ref_number='V' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'B',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_R0_Z1_V_B',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='42103'));
  110. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Betonnage',4,(SELECT wbs_id FROM wbs WHERE name='Prémur' AND ref_number='PM' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'B',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_R0_Z2_PM_B',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='42108'));
  111. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Betonnage',4,(SELECT wbs_id FROM wbs WHERE name='Voile' AND ref_number='V' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'B',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_R0_Z2_V_B',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='42103'));
  112. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Betonnage',4,(SELECT wbs_id FROM wbs WHERE name='Dalle' AND ref_number='D' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'B',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_R1_Z1_D_B',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='42102'));
  113. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Betonnage',4,(SELECT wbs_id FROM wbs WHERE name='Poutre' AND ref_number='P' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'B',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_R1_Z1_P_B',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='42105'));
  114. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Betonnage',4,(SELECT wbs_id FROM wbs WHERE name='Prédalle' AND ref_number='PD' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'B',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_R1_Z1_PD_B',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='42106'));
  115. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Betonnage',4,(SELECT wbs_id FROM wbs WHERE name='Prémur' AND ref_number='PM' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'B',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_R1_Z1_PM_B',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='42108'));
  116. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Betonnage',4,(SELECT wbs_id FROM wbs WHERE name='Voile' AND ref_number='V' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'B',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_R1_Z1_V_B',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='42103'));
  117. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Betonnage',4,(SELECT wbs_id FROM wbs WHERE name='Dalle' AND ref_number='D' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'B',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_R1_Z2_D_B',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='42102'));
  118. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Betonnage',4,(SELECT wbs_id FROM wbs WHERE name='Prémur' AND ref_number='PM' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'B',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_R1_Z2_PM_B',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='42108'));
  119. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Betonnage',4,(SELECT wbs_id FROM wbs WHERE name='Voile' AND ref_number='V' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'B',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_R1_Z2_V_B',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='42103'));
  120. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Betonnage',4,(SELECT wbs_id FROM wbs WHERE name='Colonne' AND ref_number='C' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'B',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_SS1_Z1_C_B',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='42104'));
  121. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Betonnage',4,(SELECT wbs_id FROM wbs WHERE name='Poutre' AND ref_number='P' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'B',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_SS1_Z1_P_B',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='42105'));
  122. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Betonnage',4,(SELECT wbs_id FROM wbs WHERE name='Prédalle' AND ref_number='PD' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'B',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_SS1_Z1_PD_B',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='42106'));
  123. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Betonnage',4,(SELECT wbs_id FROM wbs WHERE name='Prémur' AND ref_number='PM' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'B',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_SS1_Z1_PM_B',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='42108'));
  124. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Betonnage',4,(SELECT wbs_id FROM wbs WHERE name='Voile' AND ref_number='V' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'B',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_SS1_Z1_V_B',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='42103'));
  125. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Betonnage',4,(SELECT wbs_id FROM wbs WHERE name='Colonne' AND ref_number='C' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'B',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_SS1_Z2_C_B',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='42104'));
  126. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Betonnage',4,(SELECT wbs_id FROM wbs WHERE name='Poutre' AND ref_number='P' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'B',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_SS1_Z2_P_B',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='42105'));
  127. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Betonnage',4,(SELECT wbs_id FROM wbs WHERE name='Prédalle' AND ref_number='PD' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'B',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_SS1_Z2_PD_B',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='42106'));
  128. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Betonnage',4,(SELECT wbs_id FROM wbs WHERE name='Prémur' AND ref_number='PM' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'B',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_SS1_Z2_PM_B',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='42108'));
  129. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Betonnage',4,(SELECT wbs_id FROM wbs WHERE name='Voile' AND ref_number='V' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'B',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_SS1_Z2_V_B',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='42103'));
  130. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Coffrage',4,(SELECT wbs_id FROM wbs WHERE name='Voile' AND ref_number='V' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'C',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_F_Z1_V_C',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='44553'));
  131. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Coffrage',4,(SELECT wbs_id FROM wbs WHERE name='Voile' AND ref_number='V' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'C',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_F_Z2_V_C',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='44553'));
  132. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Coffrage',4,(SELECT wbs_id FROM wbs WHERE name='Poutre' AND ref_number='P' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'C',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_R0_Z1_P_C',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='44555'));
  133. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Coffrage',4,(SELECT wbs_id FROM wbs WHERE name='Voile' AND ref_number='V' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'C',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_R0_Z1_V_C',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='44553'));
  134. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Coffrage',4,(SELECT wbs_id FROM wbs WHERE name='Voile' AND ref_number='V' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'C',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_R0_Z2_V_C',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='44553'));
  135. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Coffrage',4,(SELECT wbs_id FROM wbs WHERE name='Dalle' AND ref_number='D' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'C',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_R1_Z1_D_C',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='44552'));
  136. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Coffrage',4,(SELECT wbs_id FROM wbs WHERE name='Poutre' AND ref_number='P' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'C',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_R1_Z1_P_C',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='44555'));
  137. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Coffrage',4,(SELECT wbs_id FROM wbs WHERE name='Voile' AND ref_number='V' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'C',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_R1_Z1_V_C',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='44553'));
  138. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Coffrage',4,(SELECT wbs_id FROM wbs WHERE name='Dalle' AND ref_number='D' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'C',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_R1_Z2_D_C',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='44552'));
  139. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Coffrage',4,(SELECT wbs_id FROM wbs WHERE name='Voile' AND ref_number='V' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'C',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_R1_Z2_V_C',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='44553'));
  140. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Coffrage',4,(SELECT wbs_id FROM wbs WHERE name='Colonne' AND ref_number='C' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'C',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_SS1_Z1_C_C',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='44554'));
  141. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Coffrage',4,(SELECT wbs_id FROM wbs WHERE name='Poutre' AND ref_number='P' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'C',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_SS1_Z1_P_C',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='44555'));
  142. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Coffrage',4,(SELECT wbs_id FROM wbs WHERE name='Voile' AND ref_number='V' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'C',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_SS1_Z1_V_C',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='44553'));
  143. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Coffrage',4,(SELECT wbs_id FROM wbs WHERE name='Colonne' AND ref_number='C' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'C',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_SS1_Z2_C_C',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='44554'));
  144. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Coffrage',4,(SELECT wbs_id FROM wbs WHERE name='Poutre' AND ref_number='P' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'C',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_SS1_Z2_P_C',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='44555'));
  145. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Coffrage',4,(SELECT wbs_id FROM wbs WHERE name='Voile' AND ref_number='V' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'C',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_SS1_Z2_V_C',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='44553'));
  146. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Préfabrication',4,(SELECT wbs_id FROM wbs WHERE name='Prédalle' AND ref_number='PD' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'PF',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_R0_Z1_PD_PF',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='42300'));
  147. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Préfabrication',4,(SELECT wbs_id FROM wbs WHERE name='Prémur' AND ref_number='PM' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'PF',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_R0_Z1_PM_PF',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='42500'));
  148. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Préfabrication',4,(SELECT wbs_id FROM wbs WHERE name='Voile' AND ref_number='V' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'PF',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_R0_Z1_V_PF',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='42701'));
  149. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Préfabrication',4,(SELECT wbs_id FROM wbs WHERE name='Prédalle' AND ref_number='PD' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'PF',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_R0_Z2_PD_PF',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='42300'));
  150. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Préfabrication',4,(SELECT wbs_id FROM wbs WHERE name='Prémur' AND ref_number='PM' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'PF',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_R0_Z2_PM_PF',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='42500'));
  151. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Préfabrication',4,(SELECT wbs_id FROM wbs WHERE name='Voile' AND ref_number='V' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'PF',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_R0_Z2_V_PF',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='42701'));
  152. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Préfabrication',4,(SELECT wbs_id FROM wbs WHERE name='Prédalle' AND ref_number='PD' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'PF',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_R1_Z1_PD_PF',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='42300'));
  153. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Préfabrication',4,(SELECT wbs_id FROM wbs WHERE name='Prémur' AND ref_number='PM' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'PF',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_R1_Z1_PM_PF',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='42500'));
  154. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Préfabrication',4,(SELECT wbs_id FROM wbs WHERE name='Voile' AND ref_number='V' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'PF',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_R1_Z1_V_PF',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='42701'));
  155. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Préfabrication',4,(SELECT wbs_id FROM wbs WHERE name='Prédalle' AND ref_number='PD' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'PF',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_R1_Z2_PD_PF',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='42300'));
  156. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Préfabrication',4,(SELECT wbs_id FROM wbs WHERE name='Prémur' AND ref_number='PM' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'PF',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_R1_Z2_PM_PF',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='42500'));
  157. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Préfabrication',4,(SELECT wbs_id FROM wbs WHERE name='Voile' AND ref_number='V' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'PF',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_R1_Z2_V_PF',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='42701'));
  158. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Préfabrication',4,(SELECT wbs_id FROM wbs WHERE name='Prédalle' AND ref_number='PD' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'PF',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_SS1_Z1_PD_PF',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='42300'));
  159. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Préfabrication',4,(SELECT wbs_id FROM wbs WHERE name='Prémur' AND ref_number='PM' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'PF',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_SS1_Z1_PM_PF',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='42500'));
  160. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Préfabrication',4,(SELECT wbs_id FROM wbs WHERE name='Prédalle' AND ref_number='PD' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'PF',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_SS1_Z2_PD_PF',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='42300'));
  161. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Préfabrication',4,(SELECT wbs_id FROM wbs WHERE name='Prémur' AND ref_number='PM' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'PF',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_SS1_Z2_PM_PF',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='42500'));
  162. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Préfabrication',4,(SELECT wbs_id FROM wbs WHERE name='Balcon' AND ref_number='B' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'PF',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_R0_Z1_B_PF',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='42704'));
  163. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Préfabrication',4,(SELECT wbs_id FROM wbs WHERE name='Balcon' AND ref_number='B' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'PF',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_R0_Z2_B_PF',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='42704'));
  164. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Préfabrication',4,(SELECT wbs_id FROM wbs WHERE name='Colonne' AND ref_number='C' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'PF',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_SS1_Z1_C_PF',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='42702'));
  165. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Préfabrication',4,(SELECT wbs_id FROM wbs WHERE name='Poutre' AND ref_number='P' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'PF',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_SS1_Z1_P_PF',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='42703'));
  166. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Préfabrication',4,(SELECT wbs_id FROM wbs WHERE name='Colonne' AND ref_number='C' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'PF',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_SS1_Z2_C_PF',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='42702'));
  167. INSERT INTO wbs (wbs_id,operation_center_id,name,wbs_level,parent_wbs_id,ref_number,vehicle_owner_id,wbs_status_id,is_project,can_assign_team,lm_date,lm_name,is_work_time_reported,short_name,activity_id) VALUES (seq_wbs_id.NEXTVAL,101417,'Préfabrication',4,(SELECT wbs_id FROM wbs WHERE name='Poutre' AND ref_number='P' AND operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI'),'PF',100718,0,'Y',NULL,SYSDATE,'PSI','Y','GGW3_SS1_Z2_P_PF',(SELECT activity_id FROM activity WHERE vehicle_owner_id=100718 AND lm_name='PSI' AND activity_code='42703'));
  168. -- SET PLANNED_QUANTITY OF WBS LVL4
  169. UPDATE wbs SET planned_quantity=9.01 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='B' AND short_name='GGW3_FR_Z2_D_B' AND name='Betonnage');
  170. UPDATE wbs SET planned_quantity=74.40 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='B' AND short_name='GGW3_F_Z1_D_B' AND name='Betonnage');
  171. UPDATE wbs SET planned_quantity=3.14 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='B' AND short_name='GGW3_F_Z1_V_B' AND name='Betonnage');
  172. UPDATE wbs SET planned_quantity=4.23 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='B' AND short_name='GGW3_F_Z2_D_B' AND name='Betonnage');
  173. UPDATE wbs SET planned_quantity=6.04 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='B' AND short_name='GGW3_F_Z2_V_B' AND name='Betonnage');
  174. UPDATE wbs SET planned_quantity=0.16 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='B' AND short_name='GGW3_R0_Z1_P_B' AND name='Betonnage');
  175. UPDATE wbs SET planned_quantity=35.79 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='B' AND short_name='GGW3_R0_Z1_PD_B' AND name='Betonnage');
  176. UPDATE wbs SET planned_quantity=2.20 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='B' AND short_name='GGW3_R0_Z1_PM_B' AND name='Betonnage');
  177. UPDATE wbs SET planned_quantity=18.98 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='B' AND short_name='GGW3_R0_Z1_V_B' AND name='Betonnage');
  178. UPDATE wbs SET planned_quantity=4.30 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='B' AND short_name='GGW3_R0_Z2_PM_B' AND name='Betonnage');
  179. UPDATE wbs SET planned_quantity=1.27 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='B' AND short_name='GGW3_R0_Z2_V_B' AND name='Betonnage');
  180. UPDATE wbs SET planned_quantity=1.09 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='B' AND short_name='GGW3_R1_Z1_D_B' AND name='Betonnage');
  181. UPDATE wbs SET planned_quantity=0.52 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='B' AND short_name='GGW3_R1_Z1_P_B' AND name='Betonnage');
  182. UPDATE wbs SET planned_quantity=36.12 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='B' AND short_name='GGW3_R1_Z1_PD_B' AND name='Betonnage');
  183. UPDATE wbs SET planned_quantity=0.58 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='B' AND short_name='GGW3_R1_Z1_PM_B' AND name='Betonnage');
  184. UPDATE wbs SET planned_quantity=16.05 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='B' AND short_name='GGW3_R1_Z1_V_B' AND name='Betonnage');
  185. UPDATE wbs SET planned_quantity=0.56 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='B' AND short_name='GGW3_R1_Z2_D_B' AND name='Betonnage');
  186. UPDATE wbs SET planned_quantity=0.96 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='B' AND short_name='GGW3_R1_Z2_PM_B' AND name='Betonnage');
  187. UPDATE wbs SET planned_quantity=2.26 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='B' AND short_name='GGW3_R1_Z2_V_B' AND name='Betonnage');
  188. UPDATE wbs SET planned_quantity=0.48 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='B' AND short_name='GGW3_SS1_Z1_C_B' AND name='Betonnage');
  189. UPDATE wbs SET planned_quantity=3.14 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='B' AND short_name='GGW3_SS1_Z1_P_B' AND name='Betonnage');
  190. UPDATE wbs SET planned_quantity=9.92 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='B' AND short_name='GGW3_SS1_Z1_PD_B' AND name='Betonnage');
  191. UPDATE wbs SET planned_quantity=0.95 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='B' AND short_name='GGW3_SS1_Z1_PM_B' AND name='Betonnage');
  192. UPDATE wbs SET planned_quantity=17.49 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='B' AND short_name='GGW3_SS1_Z1_V_B' AND name='Betonnage');
  193. UPDATE wbs SET planned_quantity=1.39 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='B' AND short_name='GGW3_SS1_Z2_C_B' AND name='Betonnage');
  194. UPDATE wbs SET planned_quantity=0.71 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='B' AND short_name='GGW3_SS1_Z2_P_B' AND name='Betonnage');
  195. UPDATE wbs SET planned_quantity=34.95 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='B' AND short_name='GGW3_SS1_Z2_PD_B' AND name='Betonnage');
  196. UPDATE wbs SET planned_quantity=0.83 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='B' AND short_name='GGW3_SS1_Z2_PM_B' AND name='Betonnage');
  197. UPDATE wbs SET planned_quantity=15.04 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='B' AND short_name='GGW3_SS1_Z2_V_B' AND name='Betonnage');
  198. UPDATE wbs SET planned_quantity=21.03 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='C' AND short_name='GGW3_F_Z1_V_C' AND name='Coffrage');
  199. UPDATE wbs SET planned_quantity=40.47 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='C' AND short_name='GGW3_F_Z2_V_C' AND name='Coffrage');
  200. UPDATE wbs SET planned_quantity=36.37 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='C' AND short_name='GGW3_R0_Z1_P_C' AND name='Coffrage');
  201. UPDATE wbs SET planned_quantity=213.74 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='C' AND short_name='GGW3_R0_Z1_V_C' AND name='Coffrage');
  202. UPDATE wbs SET planned_quantity=24.69 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='C' AND short_name='GGW3_R0_Z2_V_C' AND name='Coffrage');
  203. UPDATE wbs SET planned_quantity=7.28 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='C' AND short_name='GGW3_R1_Z1_D_C' AND name='Coffrage');
  204. UPDATE wbs SET planned_quantity=65.89 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='C' AND short_name='GGW3_R1_Z1_P_C' AND name='Coffrage');
  205. UPDATE wbs SET planned_quantity=165.37 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='C' AND short_name='GGW3_R1_Z1_V_C' AND name='Coffrage');
  206. UPDATE wbs SET planned_quantity=3.70 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='C' AND short_name='GGW3_R1_Z2_D_C' AND name='Coffrage');
  207. UPDATE wbs SET planned_quantity=24.37 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='C' AND short_name='GGW3_R1_Z2_V_C' AND name='Coffrage');
  208. UPDATE wbs SET planned_quantity=4.37 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='C' AND short_name='GGW3_SS1_Z1_C_C' AND name='Coffrage');
  209. UPDATE wbs SET planned_quantity=794.14 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='C' AND short_name='GGW3_SS1_Z1_P_C' AND name='Coffrage');
  210. UPDATE wbs SET planned_quantity=183.29 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='C' AND short_name='GGW3_SS1_Z1_V_C' AND name='Coffrage');
  211. UPDATE wbs SET planned_quantity=12.39 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='C' AND short_name='GGW3_SS1_Z2_C_C' AND name='Coffrage');
  212. UPDATE wbs SET planned_quantity=238.61 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='C' AND short_name='GGW3_SS1_Z2_P_C' AND name='Coffrage');
  213. UPDATE wbs SET planned_quantity=131.39 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='C' AND short_name='GGW3_SS1_Z2_V_C' AND name='Coffrage');
  214. UPDATE wbs SET planned_quantity=92.27 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='PF' AND short_name='GGW3_R0_Z1_PD_PF' AND name='Préfabrication');
  215. UPDATE wbs SET planned_quantity=18.28 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='PF' AND short_name='GGW3_R0_Z1_PM_PF' AND name='Préfabrication');
  216. UPDATE wbs SET planned_quantity=21.04 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='PF' AND short_name='GGW3_R0_Z1_V_PF' AND name='Préfabrication');
  217. UPDATE wbs SET planned_quantity=113.75 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='PF' AND short_name='GGW3_R0_Z2_PD_PF' AND name='Préfabrication');
  218. UPDATE wbs SET planned_quantity=32.77 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='PF' AND short_name='GGW3_R0_Z2_PM_PF' AND name='Préfabrication');
  219. UPDATE wbs SET planned_quantity=12.16 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='PF' AND short_name='GGW3_R0_Z2_V_PF' AND name='Préfabrication');
  220. UPDATE wbs SET planned_quantity=158.61 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='PF' AND short_name='GGW3_R1_Z1_PD_PF' AND name='Préfabrication');
  221. UPDATE wbs SET planned_quantity=4.84 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='PF' AND short_name='GGW3_R1_Z1_PM_PF' AND name='Préfabrication');
  222. UPDATE wbs SET planned_quantity=6.21 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='PF' AND short_name='GGW3_R1_Z1_V_PF' AND name='Préfabrication');
  223. UPDATE wbs SET planned_quantity=49.84 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='PF' AND short_name='GGW3_R1_Z2_PD_PF' AND name='Préfabrication');
  224. UPDATE wbs SET planned_quantity=7.98 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='PF' AND short_name='GGW3_R1_Z2_PM_PF' AND name='Préfabrication');
  225. UPDATE wbs SET planned_quantity=2.82 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='PF' AND short_name='GGW3_R1_Z2_V_PF' AND name='Préfabrication');
  226. UPDATE wbs SET planned_quantity=203.67 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='PF' AND short_name='GGW3_SS1_Z1_PD_PF' AND name='Préfabrication');
  227. UPDATE wbs SET planned_quantity=7.87 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='PF' AND short_name='GGW3_SS1_Z1_PM_PF' AND name='Préfabrication');
  228. UPDATE wbs SET planned_quantity=63.06 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='PF' AND short_name='GGW3_SS1_Z2_PD_PF' AND name='Préfabrication');
  229. UPDATE wbs SET planned_quantity=6.91 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='PF' AND short_name='GGW3_SS1_Z2_PM_PF' AND name='Préfabrication');
  230. UPDATE wbs SET planned_quantity=1 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='PF' AND short_name='GGW3_R0_Z1_B_PF' AND name='Préfabrication');
  231. UPDATE wbs SET planned_quantity=1 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='PF' AND short_name='GGW3_R0_Z2_B_PF' AND name='Préfabrication');
  232. UPDATE wbs SET planned_quantity=1 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='PF' AND short_name='GGW3_SS1_Z1_C_PF' AND name='Préfabrication');
  233. UPDATE wbs SET planned_quantity=1 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='PF' AND short_name='GGW3_SS1_Z1_P_PF' AND name='Préfabrication');
  234. UPDATE wbs SET planned_quantity=1 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='PF' AND short_name='GGW3_SS1_Z2_C_PF' AND name='Préfabrication');
  235. UPDATE wbs SET planned_quantity=1 WHERE wbs_id=(SELECT wbs_id FROM wbs WHERE operation_center_id=101417 AND vehicle_owner_id=100718 AND lm_name='PSI' AND ref_number='PF' AND short_name='GGW3_SS1_Z2_P_PF' AND name='Préfabrication');
  236.  
  237.  
  238.  
  239.  
  240.  
  241.  
  242.  
  243. SELECT * FROM wbs;
  244.  
  245. DESC wbs;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!