[Home] [Help]
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
224: WHERE p.plan_id = mst.plan_id
225: and mst.plan_id = p_plan_id
226: and mst.organization_id = nvl(p_org_id, mst.organization_id)
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
392: AND p.plan_id = msi.plan_id
393: AND msi.inventory_item_id = nvl(p_item_id, msi.inventory_item_id)
394: AND msi.organization_id = nvl(p_org_id, msi.organization_id)
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
530: AND p.plan_id = mgr.plan_id
531: AND msi.inventory_item_id = nvl(p_item_id, msi.inventory_item_id )
532: AND mgr.organization_id = nvl(p_org_id, mgr.organization_id)
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
679: AND p.plan_id = msi.plan_id
680: AND msi.inventory_item_id = nvl(p_item_id, msi.inventory_item_id)
681: AND msi.organization_id = nvl(p_org_id, msi.organization_id)
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
806: AND p.plan_id = mgr.plan_id
807: AND msi.inventory_item_id = nvl(p_item_id, msi.inventory_item_id )
808: AND mgr.organization_id = nvl(p_org_id, mgr.organization_id)
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
1633: t.sr_instance_id = t_sr_instance_id(j) and
1634: t.partner_type = 3 and
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
1716: m.map_type = 1 and
1747: s.company_site_name
1748: into t_supp_site_id(j),
1749: t_supp_site(j)
1750: from msc_company_sites s,
1751: msc_trading_partner_maps m,
1752: msc_item_suppliers mis
1753: where m.tp_key = mis.supplier_site_id and
1754: m.map_type = 3 and
1755: s.company_site_id = m.company_key and
1793: s.company_site_name
1794: into t_supp_site_id(j),
1795: t_supp_site(j)
1796: from msc_company_sites s,
1797: msc_trading_partner_maps m,
1798: msc_item_suppliers mis
1799: where m.map_type = 3 and
1800: s.company_site_id = m.company_key and
1801: s.company_id = t_supp_id(j) and
3324: sd.publisher_id = 1 and
3325: exists (select cs.company_site_id
3326: from msc_plan_organizations o,
3327: msc_company_sites cs,
3328: msc_trading_partner_maps m,
3329: msc_trading_partners p
3330: where o.plan_id = p_plan_id and
3331: p.sr_tp_id = nvl(p_org_id, o.organization_id) and
3332: p.sr_instance_id = nvl(p_sr_instance_id,
3354: sd.publisher_id = 1 and
3355: exists (select cs.company_site_id
3356: from msc_plan_organizations o,
3357: msc_company_sites cs,
3358: msc_trading_partner_maps m,
3359: msc_trading_partners p
3360: where o.plan_id = p_plan_id and
3361: p.sr_tp_id = nvl(p_org_id, o.organization_id) and
3362: p.sr_instance_id = nvl(p_sr_instance_id,