eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_SCE_PUBLISH_PKG dependencies on MSC_COMPANIES

Line 1526: from msc_companies c,

1522: into t_pub_id(j),
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

Line 1558: from msc_companies c,

1554: select distinct c.company_id,
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

Line 5061: msc_companies c

5057: select c.company_id
5058: into l_supplier_id
5059: from msc_trading_partner_maps m,
5060: msc_company_relationships r,
5061: msc_companies c
5062: where m.tp_key = p_supplier_id and
5063: m.map_type = 1 and
5064: m.company_key = r.relationship_id and
5065: r.relationship_type = 2 and