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,
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,