API tools faq
paste
Advertisement
faishholtria

Project

faishholtria
Jun 16th, 2020
1,429
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 16.46 KB | None | 0 0
raw download clone embed print report
  1. SET define off;
  2. -- project
  3. INSERT INTO projects (project_id, project_name, pm_id, bu_code, pm_leader_id, schedule_start, schedule_end, actual_start_date, actual_end_date) VALUES ('8802001','Daily Activities COS - Secretarial','S201009150','COS','S201009150',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'),TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  4. INSERT INTO projects (project_id, project_name, pm_id, bu_code, pm_leader_id, schedule_start, schedule_end, actual_start_date, actual_end_date) VALUES ('8802002','Daily Activities COS - Internal & External Communication Management','S201210155','COS','S201210155',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'),TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  5. INSERT INTO projects (project_id, project_name, pm_id, bu_code, pm_leader_id, schedule_start, schedule_end, actual_start_date, actual_end_date) VALUES ('8802003','Daily Activities COS - Office Management','S199701200','COS','S199701200',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'),TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  6. INSERT INTO projects (project_id, project_name, pm_id, bu_code, pm_leader_id, schedule_start, schedule_end, actual_start_date, actual_end_date) VALUES ('8802004','Daily Activities PUR - Outbund Purchasing','S199611051','PUR','S199611051',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'),TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  7. INSERT INTO projects (project_id, project_name, pm_id, bu_code, pm_leader_id, schedule_start, schedule_end, actual_start_date, actual_end_date) VALUES ('8802005','Daily Activities PUR - Asset Management','S2011120126','PUR','S2011120126',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'),TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  8. INSERT INTO projects (project_id, project_name, pm_id, bu_code, pm_leader_id, schedule_start, schedule_end, actual_start_date, actual_end_date) VALUES ('8802006','Daily Activities PUR - Inbound Purchasing and Supplier Management','S201410016','PUR','S201410016',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'),TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  9. INSERT INTO projects (project_id, project_name, pm_id, bu_code, pm_leader_id, schedule_start, schedule_end, actual_start_date, actual_end_date) VALUES ('8802007','Daily Activities FAT - Tax Management','S200709240','FAT','S200709240',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'),TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  10. INSERT INTO projects (project_id, project_name, pm_id, bu_code, pm_leader_id, schedule_start, schedule_end, actual_start_date, actual_end_date) VALUES ('8802008','Daily Activities FAT - Reporting and Consolidation','S201202154','FAT','S201202154',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'),TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  11. INSERT INTO projects (project_id, project_name, pm_id, bu_code, pm_leader_id, schedule_start, schedule_end, actual_start_date, actual_end_date) VALUES ('8802009','Daily Activities FAT - Accounting Management','S200907150','FAT','S200907150',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'),TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  12. INSERT INTO projects (project_id, project_name, pm_id, bu_code, pm_leader_id, schedule_start, schedule_end, actual_start_date, actual_end_date) VALUES ('8802010','Daily Activities FAT - Account Payable Management','S200908240','FAT','S200908240',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'),TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  13. INSERT INTO projects (project_id, project_name, pm_id, bu_code, pm_leader_id, schedule_start, schedule_end, actual_start_date, actual_end_date) VALUES ('8802011','Daily Activities FAT - Treasury Management','S200804020','FAT','S200804020',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'),TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  14. INSERT INTO projects (project_id, project_name, pm_id, bu_code, pm_leader_id, schedule_start, schedule_end, actual_start_date, actual_end_date) VALUES ('8802012','Daily Activities HCA - Talent and Competency Management','B200704010','HCA','B200704010',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'),TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  15. INSERT INTO projects (project_id, project_name, pm_id, bu_code, pm_leader_id, schedule_start, schedule_end, actual_start_date, actual_end_date) VALUES ('8802013','Daily Activities HCA - Strategic, Organization & Policy','S200703052','HCA','S200703052',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'),TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  16. INSERT INTO projects (project_id, project_name, pm_id, bu_code, pm_leader_id, schedule_start, schedule_end, actual_start_date, actual_end_date) VALUES ('8802014','Daily Activities HCA - Business Partner','S2018120120','HCA','S2018120120',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'),TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  17. INSERT INTO projects (project_id, project_name, pm_id, bu_code, pm_leader_id, schedule_start, schedule_end, actual_start_date, actual_end_date) VALUES ('8802015','Daily Activities HCA - Compensation, Benefit & Services','S200704011','HCA','S200704011',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'),TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  18. INSERT INTO projects (project_id, project_name, pm_id, bu_code, pm_leader_id, schedule_start, schedule_end, actual_start_date, actual_end_date) VALUES ('8802016','Daily Activities BIL - Billing Management','S201209014','BIL','S201209014',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'),TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  19. INSERT INTO projects (project_id, project_name, pm_id, bu_code, pm_leader_id, schedule_start, schedule_end, actual_start_date, actual_end_date) VALUES ('8802017','Daily Activities BIL - Collection Management','S201203012','BIL','S201203012',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'),TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  20. INSERT INTO projects (project_id, project_name, pm_id, bu_code, pm_leader_id, schedule_start, schedule_end, actual_start_date, actual_end_date) VALUES ('8802018','Daily Activities MAB - Budget Controll','B200909014','MAB','B200909014',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'),TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  21. INSERT INTO projects (project_id, project_name, pm_id, bu_code, pm_leader_id, schedule_start, schedule_end, actual_start_date, actual_end_date) VALUES ('8802019','Daily Activities MAB - Business Performance','S2012101511','MAB','S2012101511',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'),TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  22. INSERT INTO projects (project_id, project_name, pm_id, bu_code, pm_leader_id, schedule_start, schedule_end, actual_start_date, actual_end_date) VALUES ('8802020','Daily Activities MAB - Feasibility Analyst','C200406151','MAB','C200406151',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'),TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  23. INSERT INTO projects (project_id, project_name, pm_id, bu_code, pm_leader_id, schedule_start, schedule_end, actual_start_date, actual_end_date) VALUES ('8802021','Daily Activities MAB - Reporting and Performance Analysis','S2012101511','MAB','S2012101511',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'),TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  24. INSERT INTO projects (project_id, project_name, pm_id, bu_code, pm_leader_id, schedule_start, schedule_end, actual_start_date, actual_end_date) VALUES ('8802022','Daily Activities CIS - Business Intelligence and Data Warehouse','B200701150','CIS','B200701150',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'),TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  25. INSERT INTO projects (project_id, project_name, pm_id, bu_code, pm_leader_id, schedule_start, schedule_end, actual_start_date, actual_end_date) VALUES ('8802023','Daily Activities CIS - Database and System Administrator','S2012060114','CIS','S2012060114',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'),TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  26. INSERT INTO projects (project_id, project_name, pm_id, bu_code, pm_leader_id, schedule_start, schedule_end, actual_start_date, actual_end_date) VALUES ('8802024','Daily Activities CIS - Application Development','S201004056','CIS','S201004056',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'),TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  27. INSERT INTO projects (project_id, project_name, pm_id, bu_code, pm_leader_id, schedule_start, schedule_end, actual_start_date, actual_end_date) VALUES ('8802025','Daily Activities CIS - Operation and Service Management','N201204011','CIS','N201204011',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'),TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  28. INSERT INTO projects (project_id, project_name, pm_id, bu_code, pm_leader_id, schedule_start, schedule_end, actual_start_date, actual_end_date) VALUES ('8802026','Daily Activities CIS - Strategy and Interoperability','M8212452','CIS','M8212452',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'),TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  29. INSERT INTO projects (project_id, project_name, pm_id, bu_code, pm_leader_id, schedule_start, schedule_end, actual_start_date, actual_end_date) VALUES ('8802027','Daily Activities CEM - Audit Management and Certification','B200706180','CEM','B200706180',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'),TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  30. INSERT INTO projects (project_id, project_name, pm_id, bu_code, pm_leader_id, schedule_start, schedule_end, actual_start_date, actual_end_date) VALUES ('8802028','Daily Activities CEM - Business Process','K200407191','CEM','K200407191',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'),TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  31. INSERT INTO projects (project_id, project_name, pm_id, bu_code, pm_leader_id, schedule_start, schedule_end, actual_start_date, actual_end_date) VALUES ('8802029','Daily Activities CEM - Risk Management','S200805191','CEM','S200805191',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'),TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  32. INSERT INTO projects (project_id, project_name, pm_id, bu_code, pm_leader_id, schedule_start, schedule_end, actual_start_date, actual_end_date) VALUES ('8802030','Daily Activities LEG - Business & Partnership I','K200506010','LEG','K200506010',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'),TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  33. INSERT INTO projects (project_id, project_name, pm_id, bu_code, pm_leader_id, schedule_start, schedule_end, actual_start_date, actual_end_date) VALUES ('8802031','Daily Activities LEG - Business & Partnership II','S201202151','LEG','S201202151',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'),TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  34. INSERT INTO projects (project_id, project_name, pm_id, bu_code, pm_leader_id, schedule_start, schedule_end, actual_start_date, actual_end_date) VALUES ('8802032','Daily Activities LEG - Corporate Matters','S201209015','LEG','S201209015',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'),TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  35. INSERT INTO projects (project_id, project_name, pm_id, bu_code, pm_leader_id, schedule_start, schedule_end, actual_start_date, actual_end_date) VALUES ('8802033','Daily Activities LEG - Strategic Business & Purchasing Contract','S2018110101','LEG','S2018110101',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'),TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  36. INSERT INTO projects (project_id, project_name, pm_id, bu_code, pm_leader_id, schedule_start, schedule_end, actual_start_date, actual_end_date) VALUES ('8802034','Daily Activities PDA - Product Management','S2019101501','PDA','S2019101501',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'),TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  37. INSERT INTO projects (project_id, project_name, pm_id, bu_code, pm_leader_id, schedule_start, schedule_end, actual_start_date, actual_end_date) VALUES ('8802035','Daily Activities PDA - Partnership Management','S201212013','PDA','S201212013',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'),TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  38. INSERT INTO projects (project_id, project_name, pm_id, bu_code, pm_leader_id, schedule_start, schedule_end, actual_start_date, actual_end_date) VALUES ('8802036','Daily Activities CON - Business Strategy and Planning','S2016110115','CON','S2016110115',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'),TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  39. -- wbs
  40. INSERT INTO wbs (wbs_id, wbs_name, start_date, finish_date) VALUES ('8802001.0','Daily Activities COS - Secretarial',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  41. INSERT INTO wbs (wbs_id, wbs_name, start_date, finish_date) VALUES ('8802002.0','Daily Activities COS - Internal & External Communication Management',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  42. INSERT INTO wbs (wbs_id, wbs_name, start_date, finish_date) VALUES ('8802003.0','Daily Activities COS - Office Management',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  43. INSERT INTO wbs (wbs_id, wbs_name, start_date, finish_date) VALUES ('8802004.0','Daily Activities PUR - Outbund Purchasing',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  44. INSERT INTO wbs (wbs_id, wbs_name, start_date, finish_date) VALUES ('8802005.0','Daily Activities PUR - Asset Management',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  45. INSERT INTO wbs (wbs_id, wbs_name, start_date, finish_date) VALUES ('8802006.0','Daily Activities PUR - Inbound Purchasing and Supplier Management',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  46. INSERT INTO wbs (wbs_id, wbs_name, start_date, finish_date) VALUES ('8802007.0','Daily Activities FAT - Tax Management',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  47. INSERT INTO wbs (wbs_id, wbs_name, start_date, finish_date) VALUES ('8802008.0','Daily Activities FAT - Reporting and Consolidation',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  48. INSERT INTO wbs (wbs_id, wbs_name, start_date, finish_date) VALUES ('8802009.0','Daily Activities FAT - Accounting Management',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  49. INSERT INTO wbs (wbs_id, wbs_name, start_date, finish_date) VALUES ('8802010.0','Daily Activities FAT - Account Payable Management',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  50. INSERT INTO wbs (wbs_id, wbs_name, start_date, finish_date) VALUES ('8802011.0','Daily Activities FAT - Treasury Management',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  51. INSERT INTO wbs (wbs_id, wbs_name, start_date, finish_date) VALUES ('8802012.0','Daily Activities HCA - Talent and Competency Management',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  52. INSERT INTO wbs (wbs_id, wbs_name, start_date, finish_date) VALUES ('8802013.0','Daily Activities HCA - Strategic, Organization & Policy',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  53. INSERT INTO wbs (wbs_id, wbs_name, start_date, finish_date) VALUES ('8802014.0','Daily Activities HCA - Business Partner',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  54. INSERT INTO wbs (wbs_id, wbs_name, start_date, finish_date) VALUES ('8802015.0','Daily Activities HCA - Compensation, Benefit & Services',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  55. INSERT INTO wbs (wbs_id, wbs_name, start_date, finish_date) VALUES ('8802016.0','Daily Activities BIL - Billing Management',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  56. INSERT INTO wbs (wbs_id, wbs_name, start_date, finish_date) VALUES ('8802017.0','Daily Activities BIL - Collection Management',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  57. INSERT INTO wbs (wbs_id, wbs_name, start_date, finish_date) VALUES ('8802018.0','Daily Activities MAB - Budget Controll',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  58. INSERT INTO wbs (wbs_id, wbs_name, start_date, finish_date) VALUES ('8802019.0','Daily Activities MAB - Business Performance',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  59. INSERT INTO wbs (wbs_id, wbs_name, start_date, finish_date) VALUES ('8802020.0','Daily Activities MAB - Feasibility Analyst',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  60. INSERT INTO wbs (wbs_id, wbs_name, start_date, finish_date) VALUES ('8802021.0','Daily Activities MAB - Reporting and Performance Analysis',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  61. INSERT INTO wbs (wbs_id, wbs_name, start_date, finish_date) VALUES ('8802022.0','Daily Activities CIS - Business Intelligence and Data Warehouse',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  62. INSERT INTO wbs (wbs_id, wbs_name, start_date, finish_date) VALUES ('8802023.0','Daily Activities CIS - Database and System Administrator',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  63. INSERT INTO wbs (wbs_id, wbs_name, start_date, finish_date) VALUES ('8802024.0','Daily Activities CIS - Application Development',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  64. INSERT INTO wbs (wbs_id, wbs_name, start_date, finish_date) VALUES ('8802025.0','Daily Activities CIS - Operation and Service Management',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  65. INSERT INTO wbs (wbs_id, wbs_name, start_date, finish_date) VALUES ('8802026.0','Daily Activities CIS - Strategy and Interoperability',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  66. INSERT INTO wbs (wbs_id, wbs_name, start_date, finish_date) VALUES ('8802027.0','Daily Activities CEM - Audit Management and Certification',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  67. INSERT INTO wbs (wbs_id, wbs_name, start_date, finish_date) VALUES ('8802028.0','Daily Activities CEM - Business Process',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  68. INSERT INTO wbs (wbs_id, wbs_name, start_date, finish_date) VALUES ('8802029.0','Daily Activities CEM - Risk Management',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  69. INSERT INTO wbs (wbs_id, wbs_name, start_date, finish_date) VALUES ('8802030.0','Daily Activities LEG - Business & Partnership I',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  70. INSERT INTO wbs (wbs_id, wbs_name, start_date, finish_date) VALUES ('8802031.0','Daily Activities LEG - Business & Partnership II',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  71. INSERT INTO wbs (wbs_id, wbs_name, start_date, finish_date) VALUES ('8802032.0','Daily Activities LEG - Corporate Matters',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  72. INSERT INTO wbs (wbs_id, wbs_name, start_date, finish_date) VALUES ('8802033.0','Daily Activities LEG - Strategic Business & Purchasing Contract',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  73. INSERT INTO wbs (wbs_id, wbs_name, start_date, finish_date) VALUES ('8802034.0','Daily Activities PDA - Product Management',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  74. INSERT INTO wbs (wbs_id, wbs_name, start_date, finish_date) VALUES ('8802035.0','Daily Activities PDA - Partnership Management',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  75. INSERT INTO wbs (wbs_id, wbs_name, start_date, finish_date) VALUES ('8802036.0','Daily Activities CON - Business Strategy and Planning',TO_DATE('20200101','YYYYMMDD'), TO_DATE('20201231','YYYYMMDD'));
  76. COMMIT;
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!