[Home] [Help]
214: sum(mst.safety_stock_quantity)
215: FROM msc_safety_stocks mst,
216: msc_plan_buckets mpb,
217: msc_plan_organizations_v ov,
218: msc_system_items item,
219: msc_companies c,
220: msc_company_sites s,
221: msc_trading_partners t,
222: msc_trading_partner_maps m,
379: REP_SCHED_BY, -1, PLANNED_BY, -1,
380: FLOW_SCHED_BY, -1, 1))) new_quantity
381: FROM msc_plans p,
382: msc_trading_partners param,
383: msc_system_items msi,
384: msc_supplies rec,
385: msc_plan_buckets mpb,
386: msc_plan_organizations_v ov,
387: msc_companies c,
517: 29,nvl(mgr.probability,0),
518: null)) ,1) ,1)) new_quantity
519: FROM msc_plans p,
520: msc_trading_partners param,
521: msc_system_items msi,
522: msc_demands mgr,
523: msc_plan_buckets mpb,
524: msc_plan_organizations_v ov,
525: msc_companies c,
668: REP_SCHED_BY, -1, PLANNED_BY, -1,
669: FLOW_SCHED_BY, -1, 1))) new_quantity
670: FROM msc_plans p,
671: msc_trading_partners param,
672: msc_system_items msi,
673: msc_supplies rec,
674: msc_companies c,
675: msc_company_sites s,
676: msc_trading_partners t,
795: 29,nvl(mgr.probability,0),
796: null)) ,1) ,1)) new_quantity
797: FROM msc_plans p,
798: msc_trading_partners param,
799: msc_system_items msi,
800: msc_demands mgr,
801: msc_companies c,
802: msc_company_sites s,
803: msc_trading_partners t,
1658: ---------------------------------------------------------------------------------*/
1659: begin
1660: select item_name, description
1661: into t_item_name(j), t_item_desc(j)
1662: from msc_system_items
1663: where sr_instance_id = t_sr_instance_id(j)
1664: and organization_id = t_org_id(j)
1665: and inventory_item_id = t_item_id(j)
1666: and plan_id = -1;
1676: ---------------------------------------------------------------------------------*/
1677: begin
1678: select item_name
1679: into t_base_item_name(j)
1680: from msc_system_items
1681: where sr_instance_id = t_sr_instance_id(j)
1682: and organization_id = t_org_id(j)
1683: and inventory_item_id = t_base_item_id(j)
1684: and plan_id = -1;