[Home] [Help]
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,
220: msc_plans p
380: msc_system_items msi,
381: msc_supplies rec,
382: msc_plan_buckets mpb,
383: msc_plan_organizations_v ov,
384: msc_companies c,
385: msc_company_sites s,
386: msc_trading_partners t,
387: msc_trading_partner_maps m
388: WHERE p.plan_id = p_plan_id
518: msc_system_items msi,
519: msc_demands mgr,
520: msc_plan_buckets mpb,
521: msc_plan_organizations_v ov,
522: msc_companies c,
523: msc_company_sites s,
524: msc_trading_partners t,
525: msc_trading_partner_maps m
526: WHERE p.plan_id = p_plan_id
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,
674: msc_trading_partner_maps m
675: WHERE p.plan_id = p_plan_id
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,
801: msc_trading_partner_maps m
802: WHERE p.plan_id = p_plan_id
1608: into t_pub_id(j),
1609: t_pub(j),
1610: t_pub_site_id(j),
1611: t_pub_site(j)
1612: from msc_companies c,
1613: msc_company_sites s,
1614: msc_trading_partner_maps m,
1615: msc_trading_partners t
1616: where t.sr_tp_id = t_org_id(j) and
1691: select distinct c.company_id,
1692: c.company_name
1693: into t_supp_id(j),
1694: t_supp(j)
1695: from msc_companies c,
1696: msc_trading_partner_maps m,
1697: msc_company_relationships r,
1698: msc_item_suppliers mis
1699: where m.tp_key = mis.supplier_id and