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,
1052: ) CUST_VIEW,
1053: ( select mtsil.sr_instance_id sr_instance_id,
1054: mtsil.tp_site_id tp_site_id,
1055: max(mtsil.sr_tp_site_id) sr_tp_site_id
1056: from msc_tp_site_id_lid mtsil
1057: where mtsil.partner_type = 2
1058: and mtsil.sr_company_id = -1
1059: group by mtsil.sr_instance_id, mtsil.tp_site_id
1060: ) CUST_SITE_VIEW,