[Home] [Help]
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,
223: msc_plans p
383: msc_system_items msi,
384: msc_supplies rec,
385: msc_plan_buckets mpb,
386: msc_plan_organizations_v ov,
387: msc_companies c,
388: msc_company_sites s,
389: msc_trading_partners t,
390: msc_trading_partner_maps m
391: WHERE p.plan_id = p_plan_id
521: msc_system_items msi,
522: msc_demands mgr,
523: msc_plan_buckets mpb,
524: msc_plan_organizations_v ov,
525: msc_companies c,
526: msc_company_sites s,
527: msc_trading_partners t,
528: msc_trading_partner_maps m
529: WHERE p.plan_id = p_plan_id
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,
677: msc_trading_partner_maps m
678: WHERE p.plan_id = p_plan_id
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,
804: msc_trading_partner_maps m
805: WHERE p.plan_id = p_plan_id
1624: into t_pub_id(j),
1625: t_pub(j),
1626: t_pub_site_id(j),
1627: t_pub_site(j)
1628: from msc_companies c,
1629: msc_company_sites s,
1630: msc_trading_partner_maps m,
1631: msc_trading_partners t
1632: where t.sr_tp_id = t_org_id(j) and
1707: select distinct c.company_id,
1708: c.company_name
1709: into t_supp_id(j),
1710: t_supp(j)
1711: from msc_companies c,
1712: msc_trading_partner_maps m,
1713: msc_company_relationships r,
1714: msc_item_suppliers mis
1715: where m.tp_key = mis.supplier_id and