MSC_CUSTOMER_SITES_MSC_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
PARTNER_SITE_ID PARTNER_ID TP_SITE_CODE LOCATION_ID PARTNER_TYPE LAST_UPDATE_DATE TIMEZONE_CODE

Query

SQL_Statement
SELECT site.PARTNER_SITE_ID, site.PARTNER_ID, site.TP_SITE_CODE, loc.LOCATION_ID, 2 PARTNER_TYPE,site.LAST_UPDATE_DATE ,site.timezone_code FROM MSC_CUSTOMER_SITES site, MSC_LOCATION_ASSOCIATIONS loc WHERE site.PARTNER_TYPE = 2 AND loc.SITE_ID = site.PARTNER_SITE_ID AND loc.SITE_TYPE = 2