DBA Data[Home] [Help]

APPS.MSC_ATP_24X7 dependencies on MSC_TP_SITE_ID_LID

Line 765: from msc_tp_site_id_lid mtsil

761: ) CUST_VIEW,
762: ( select mtsil.sr_instance_id sr_instance_id,
763: mtsil.tp_site_id tp_site_id,
764: max(mtsil.sr_tp_site_id) sr_tp_site_id
765: from msc_tp_site_id_lid mtsil
766: where mtsil.partner_type = 2
767: and mtsil.sr_company_id = -1
768: group by mtsil.tp_site_id, mtsil.sr_instance_id
769: ) CUST_SITE_VIEW,

Line 1053: from msc_tp_site_id_lid mtsil

1049: ) CUST_VIEW,
1050: ( select mtsil.sr_instance_id sr_instance_id,
1051: mtsil.tp_site_id tp_site_id,
1052: max(mtsil.sr_tp_site_id) sr_tp_site_id
1053: from msc_tp_site_id_lid mtsil
1054: where mtsil.partner_type = 2
1055: and mtsil.sr_company_id = -1
1056: group by mtsil.sr_instance_id, mtsil.tp_site_id
1057: ) CUST_SITE_VIEW,