DBA Data[Home] [Help]

APPS.MSC_CL_SCE_COLLECTION dependencies on MSC_TP_SITE_ID_LID

Line 1668: msc_tp_site_id_lid mtsil

1664: select DISTINCT mtsil.tp_site_id,
1665: mcs.company_site_id
1666: from msc_company_sites mcs,
1667: msc_company_site_id_lid mcsil,
1668: msc_tp_site_id_lid mtsil
1669: where mcs.company_site_id = mcsil.company_site_id
1670: and mcsil.sr_instance_id = p_instance_id
1671: and mcsil.sr_instance_id = mtsil.sr_instance_id
1672: and mcsil.partner_type = mtsil.partner_type

Line 1862: msc_tp_site_id_lid mtsil,

1858: mic.planner_code,
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