MSC_DIM_ORG_GEO_ORG_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: MSC
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
ID NAME DESCRIPTION PARENT_ID |
問合せ
| 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 |