APPS.MSC_CL_SCE_COLLECTION dependencies on MSC_ITEM_ID_LID

Line 1863: msc_item_id_lid t1

1859: mic.refresh_number
1860: from msc_st_item_customers mic,
1861: msc_tp_id_lid mtil,
1862: msc_tp_site_id_lid mtsil,
1863: msc_item_id_lid t1
1864: where t1.SR_INVENTORY_ITEM_ID = mic.inventory_item_id
1865: AND t1.sr_instance_id= mic.sr_instance_id
1866: and mic.customer_id = mtil.sr_tp_id
1867: and nvl(mic.company_id, -1) = nvl(mtil.sr_company_id, -1)