493: commit;
494:
495: /*
496: msc_demands_f: Merge SNO columns (net_demand, constrained_fcst, constrained_fcst_value, constrained_fcst_value2) in msc_demand_pkg.
497: msc_demands_cum_f: (new)
498: */
499: --dbms_output.put_line('wei: msc_demands_f');
500: -- msc_demands_f
501: insert into msc_demands_f (
598:
599: commit;
600:
601:
602: --dbms_output.put_line('wei: msc_demands_cum_f');
603: -- msc_demands_cum_f
604: insert into msc_demands_cum_f (
605: plan_id,
606: plan_run_id,
599: commit;
600:
601:
602: --dbms_output.put_line('wei: msc_demands_cum_f');
603: -- msc_demands_cum_f
604: insert into msc_demands_cum_f (
605: plan_id,
606: plan_run_id,
607: sr_instance_id,
600:
601:
602: --dbms_output.put_line('wei: msc_demands_cum_f');
603: -- msc_demands_cum_f
604: insert into msc_demands_cum_f (
605: plan_id,
606: plan_run_id,
607: sr_instance_id,
608: organization_id,