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 1543: from msc_companies c,

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

Line 1575: from msc_companies c,

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

Line 5078: msc_companies c

5074: select c.company_id
5075: into l_supplier_id
5076: from msc_trading_partner_maps m,
5077: msc_company_relationships r,
5078: msc_companies c
5079: where m.tp_key = p_supplier_id and
5080: m.map_type = 1 and
5081: m.company_key = r.relationship_id and
5082: r.relationship_type = 2 and