MSC_DIM_ORG_GEO_ORG_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
ID NAME DESCRIPTION PARENT_ID

Query

SQL_Statement

SELECT MP.ORGANIZATION_ID ID , MP.ORGANIZATION_CODE NAME , MP.ORGANIZATION_CODE||'-'|| MP.ORGANIZATION_NAME DESCRIPTION , MR.REGION_ID PARENT_ID FROM MSC_REGIONS_V MR, MSC_INT_LOCATIONS_V ML, MSC_LOCATION_ASSOCIATIONS LA, MSC_PARAMETERS MP 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 = MP.ORGANIZATION_ID AND LA.SITE_TYPE = 3