APPS.MSC_CL_SCE_COLLECTION dependencies on MSC_ITEM_ID_LID

Line 1946: msc_item_id_lid t1

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
1950: and nvl(mic.company_id, -1) = nvl(mtil.sr_company_id, -1)