APPS.MSC_SNO_PKG dependencies on MSC_DEMANDS

Line 496: msc_demands_f: Merge SNO columns (net_demand, constrained_fcst, constrained_fcst_value, constrained_fcst_value2) in msc_demand_pkg.

492:
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

Line 497: msc_demands_cum_f: (new)

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 (

Line 499: --dbms_output.put_line('wei: msc_demands_f');

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 (
502: plan_id,
503: plan_run_id,

Line 500: -- msc_demands_f

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 (
502: plan_id,
503: plan_run_id,
504: sr_instance_id,

Line 501: insert into msc_demands_f (

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 (
502: plan_id,
503: plan_run_id,
504: sr_instance_id,
505: organization_id,

Line 567: msc_demands md,

563: - md.origination_type order_type,
564: sum(using_requirement_quantity) demand_qty,
565: sum(quantity_by_due_date) qty_by_due_date
566: from
567: msc_demands md,
568: msc_trading_partners mtp
569: where md.plan_id = p_plan_id
570: and md.origination_type = 81 -- wei: SNO
571: and md.sr_instance_id = mtp.sr_instance_id(+)

Line 602: --dbms_output.put_line('wei: msc_demands_cum_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,

Line 603: -- msc_demands_cum_f

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,

Line 604: insert into msc_demands_cum_f (

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,

Line 704: from msc_demands_f k1,

700: k1.customer_id,
701: k1.customer_site_id,
702: k1.demand_class,
703: k2.end_date
704: from msc_demands_f k1,
705: (select trunc(v.month_end_date) end_date
706: from msc_calendar_dtl v, msc_plans mp
707: where mp.plan_id=p_plan_id
708: and v.month_end_date between mp.curr_start_date and mp.curr_cutoff_date

Line 720: select order_date from msc_demands_f f

716: from msc_phub_fiscal_periods_mv v, msc_plans mp
717: where mp.plan_id=p_plan_id
718: and v.end_date between mp.curr_start_date and mp.curr_cutoff_date
719: union all
720: select order_date from msc_demands_f f
721: where f.plan_id=p_plan_id and f.plan_run_id=p_plan_run_id
722: ) k2
723: where k1.plan_id=p_plan_id and k1.plan_run_id=p_plan_run_id) k,
724: msc_demands_f f

Line 724: msc_demands_f f

720: select order_date from msc_demands_f f
721: where f.plan_id=p_plan_id and f.plan_run_id=p_plan_run_id
722: ) k2
723: where k1.plan_id=p_plan_id and k1.plan_run_id=p_plan_run_id) k,
724: msc_demands_f f
725: where k.plan_id = f.plan_id(+)
726: and k.plan_run_id = f.plan_run_id(+)
727: and k.sr_instance_id = f.sr_instance_id(+)
728: and k.organization_id = f.organization_id(+)