MSC_DIM_CUS_GEO_CUS_SITE_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
ID NAME DESCRIPTION PARENT_ID

Query

SQL_Statement

SELECT DISTINCT CSV.PARTNER_SITE_ID ID , CSV.TP_SITE_CODE NAME , CSV.PARTNER_SITE_ID||'-'|| CSV.TP_SITE_CODE DESCRIPTION , MR.REGION_ID PARENT_ID FROM MSC_REGIONS_V MR, MSC_LOCATIONS_V ML, MSC_LOC_ASSOCIATIONS_V LA, MSC_CUSTOMER_SITES_V CSV WHERE MR.REGION_LEVEL = (SELECT MAX(REGION_LEVEL) FROM MSC_REGIONS_V WHERE COUNTRY_CODE = MR.COUNTRY_CODE ) AND MR.REGION_ID = ML.REGION_ID AND ML.LOCATION_ID = LA.LOCATION_ID AND LA.SITE_ID = CSV.PARTNER_SITE_ID AND LA.SITE_TYPE = 2