APPS.MSC_SCE_PUBLISH_PKG dependencies on MSC_COMPANY_SITES

Line 1544: msc_company_sites s,

1540: t_pub(j),
1541: t_pub_site_id(j),
1542: t_pub_site(j)
1543: from msc_companies c,
1544: msc_company_sites s,
1545: msc_trading_partner_maps m,
1546: msc_trading_partners t
1547: where t.sr_tp_id = t_org_id(j) and
1548: t.sr_instance_id = t_sr_instance_id(j) and

Line 1576: msc_company_sites s,

1572: c.company_name
1573: into t_supp_id(j),
1574: t_supp(j)
1575: from msc_companies c,
1576: msc_company_sites s,
1577: msc_trading_partner_maps m,
1578: msc_company_relationships r
1579: where m.tp_key = t_source_supp_id(j) and
1580: m.map_type = 1 and

Line 1602: from msc_company_sites s,

1598: select s.company_site_id,
1599: s.company_site_name
1600: into t_supp_site_id(j),
1601: t_supp_site(j)
1602: from msc_company_sites s,
1603: msc_trading_partner_maps m
1604: where m.tp_key = t_source_supp_site_id(j) and
1605: m.map_type = 3 and
1606: s.company_site_id = m.company_key and

Line 5102: msc_company_sites cs

5098: BEGIN
5099: select cs.company_site_id
5100: into l_supplier_site_id
5101: from msc_trading_partner_maps m,
5102: msc_company_sites cs
5103: where m.tp_key = p_supplier_site_id and
5104: m.map_type = 3 and
5105: cs.company_site_id = m.company_key;
5106: EXCEPTION

Line 5128: msc_company_sites cs,

5124: sd.plan_id = -1 and
5125: sd.publisher_id = 1 and
5126: exists (select cs.company_site_id
5127: from msc_plan_organizations o,
5128: msc_company_sites cs,
5129: msc_trading_partner_maps m,
5130: msc_trading_partners p
5131: where o.plan_id = p_plan_id
5132: AND O.ORGANIZATION_ID = NVL(p_org_id , O.ORGANIZATION_ID)

Line 5174: msc_company_sites cs,

5170: sd.plan_id = -1 and
5171: sd.publisher_id = 1 and
5172: exists (select cs.company_site_id
5173: from msc_plan_organizations o,
5174: msc_company_sites cs,
5175: msc_trading_partner_maps m,
5176: msc_trading_partners p
5177: where o.plan_id = p_plan_id and
5178: p.sr_tp_id = nvl(p_org_id, o.organization_id) and