APPS.MSC_SCE_PUBLISH_PKG dependencies on MSC_COMPANY_SITES

Line 1527: msc_company_sites s,

1523: t_pub(j),
1524: t_pub_site_id(j),
1525: t_pub_site(j)
1526: from msc_companies c,
1527: msc_company_sites s,
1528: msc_trading_partner_maps m,
1529: msc_trading_partners t
1530: where t.sr_tp_id = t_org_id(j) and
1531: t.sr_instance_id = t_sr_instance_id(j) and

Line 1559: msc_company_sites s,

1555: c.company_name
1556: into t_supp_id(j),
1557: t_supp(j)
1558: from msc_companies c,
1559: msc_company_sites s,
1560: msc_trading_partner_maps m,
1561: msc_company_relationships r
1562: where m.tp_key = t_source_supp_id(j) and
1563: m.map_type = 1 and

Line 1585: from msc_company_sites s,

1581: select s.company_site_id,
1582: s.company_site_name
1583: into t_supp_site_id(j),
1584: t_supp_site(j)
1585: from msc_company_sites s,
1586: msc_trading_partner_maps m
1587: where m.tp_key = t_source_supp_site_id(j) and
1588: m.map_type = 3 and
1589: s.company_site_id = m.company_key and

Line 5085: msc_company_sites cs

5081: BEGIN
5082: select cs.company_site_id
5083: into l_supplier_site_id
5084: from msc_trading_partner_maps m,
5085: msc_company_sites cs
5086: where m.tp_key = p_supplier_site_id and
5087: m.map_type = 3 and
5088: cs.company_site_id = m.company_key;
5089: EXCEPTION

Line 5111: msc_company_sites cs,

5107: sd.plan_id = -1 and
5108: sd.publisher_id = 1 and
5109: exists (select cs.company_site_id
5110: from msc_plan_organizations o,
5111: msc_company_sites cs,
5112: msc_trading_partner_maps m,
5113: msc_trading_partners p
5114: where o.plan_id = p_plan_id
5115: AND O.ORGANIZATION_ID = NVL(p_org_id , O.ORGANIZATION_ID)

Line 5157: msc_company_sites cs,

5153: sd.plan_id = -1 and
5154: sd.publisher_id = 1 and
5155: exists (select cs.company_site_id
5156: from msc_plan_organizations o,
5157: msc_company_sites cs,
5158: msc_trading_partner_maps m,
5159: msc_trading_partners p
5160: where o.plan_id = p_plan_id and
5161: p.sr_tp_id = nvl(p_org_id, o.organization_id) and