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_CL_SCE_COLLECTION dependencies on MSC_TP_SITE_ID_LID

Line 1751: msc_tp_site_id_lid mtsil

1747: select DISTINCT mtsil.tp_site_id,
1748: mcs.company_site_id
1749: from msc_company_sites mcs,
1750: msc_company_site_id_lid mcsil,
1751: msc_tp_site_id_lid mtsil
1752: where mcs.company_site_id = mcsil.company_site_id
1753: and mcsil.sr_instance_id = p_instance_id
1754: and mcsil.sr_instance_id = mtsil.sr_instance_id
1755: and mcsil.partner_type = mtsil.partner_type

Line 1945: msc_tp_site_id_lid mtsil,

1941: mic.planner_code,
1942: mic.refresh_number
1943: from msc_st_item_customers mic,
1944: msc_tp_id_lid mtil,
1945: msc_tp_site_id_lid mtsil,
1946: msc_item_id_lid t1
1947: where t1.SR_INVENTORY_ITEM_ID = mic.inventory_item_id
1948: AND t1.sr_instance_id= mic.sr_instance_id
1949: and mic.customer_id = mtil.sr_tp_id