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_X_VMI_UTIL_NEW dependencies on MSC_COMPANIES

Line 272: msc_companies cp,

268: msc_sr_source_org src_org,
269: msc_trading_partner_maps map1,
270: msc_trading_partner_maps map2,
271: msc_company_sites site,
272: msc_companies cp,
273: msc_company_relationships rel
274: where plan_id = -1
275: and a.publisher_order_type = UNALLOCATED_ONHAND
276: and a.customer_id = p_customer_id

Line 293: and rel.object_id = cp.company_id --supplier company id in MSC_COMPANIES

289: and src_org.source_partner_id = map1.tp_key
290: and map1.map_type = 1
291: and map1.company_key = rel.relationship_id
292: and rel.relationship_type = 2
293: and rel.object_id = cp.company_id --supplier company id in MSC_COMPANIES
294: and cp.company_id = p_supplier_id
295: and src_org.source_partner_site_id = map2.tp_key
296: and map2.map_type = 3
297: and map2.company_key = site.company_site_id