[Home] [Help]
211: sum(mst.safety_stock_quantity)
212: FROM msc_safety_stocks mst,
213: msc_plan_buckets mpb,
214: msc_plan_organizations_v ov,
215: msc_system_items item,
216: msc_companies c,
217: msc_company_sites s,
218: msc_trading_partners t,
219: msc_trading_partner_maps m,
376: REP_SCHED_BY, -1, PLANNED_BY, -1,
377: FLOW_SCHED_BY, -1, 1))) new_quantity
378: FROM msc_plans p,
379: msc_trading_partners param,
380: msc_system_items msi,
381: msc_supplies rec,
382: msc_plan_buckets mpb,
383: msc_plan_organizations_v ov,
384: msc_companies c,
514: 29,nvl(mgr.probability,0),
515: null)) ,1) ,1)) new_quantity
516: FROM msc_plans p,
517: msc_trading_partners param,
518: msc_system_items msi,
519: msc_demands mgr,
520: msc_plan_buckets mpb,
521: msc_plan_organizations_v ov,
522: msc_companies c,
665: REP_SCHED_BY, -1, PLANNED_BY, -1,
666: FLOW_SCHED_BY, -1, 1))) new_quantity
667: FROM msc_plans p,
668: msc_trading_partners param,
669: msc_system_items msi,
670: msc_supplies rec,
671: msc_companies c,
672: msc_company_sites s,
673: msc_trading_partners t,
792: 29,nvl(mgr.probability,0),
793: null)) ,1) ,1)) new_quantity
794: FROM msc_plans p,
795: msc_trading_partners param,
796: msc_system_items msi,
797: msc_demands mgr,
798: msc_companies c,
799: msc_company_sites s,
800: msc_trading_partners t,
1642: ---------------------------------------------------------------------------------*/
1643: begin
1644: select item_name, description
1645: into t_item_name(j), t_item_desc(j)
1646: from msc_system_items
1647: where sr_instance_id = t_sr_instance_id(j)
1648: and organization_id = t_org_id(j)
1649: and inventory_item_id = t_item_id(j)
1650: and plan_id = -1;
1660: ---------------------------------------------------------------------------------*/
1661: begin
1662: select item_name
1663: into t_base_item_name(j)
1664: from msc_system_items
1665: where sr_instance_id = t_sr_instance_id(j)
1666: and organization_id = t_org_id(j)
1667: and inventory_item_id = t_base_item_id(j)
1668: and plan_id = -1;