MSC_REGIONS_MSC_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name

REGION_ID REGION_NAME REGION_TYPE REGION_LEVEL COUNTRY_CODE IMMEDIATE_PARENT_REGION_ID PARENT_REGION_NAME_1 PARENT_REGION_NAME_2 PARENT_REGION_NAME_3 PARENT_REGION_NAME_4 PARENT_REGION_NAME_5 PARENT_REGION_NAME_6 PARENT_REGION_NAME_7 PARENT_REGION_NAME_8 PARENT_REGION_TYPE_1 PARENT_REGION_TYPE_2 PARENT_REGION_TYPE_3 PARENT_REGION_TYPE_4 PARENT_REGION_TYPE_5 PARENT_REGION_TYPE_6 PARENT_REGION_TYPE_7 PARENT_REGION_TYPE_8 PARENT_REGION_NAME_LIST DELETED_FLAG

Query

SQL_Statement

SELECT REGION_ID, REGION_NAME, REGION_TYPE, REGION_LEVEL, COUNTRY_CODE, IMMEDIATE_PARENT_REGION_ID, PARENT_REGION_NAME_1, PARENT_REGION_NAME_2, PARENT_REGION_NAME_3, PARENT_REGION_NAME_4, PARENT_REGION_NAME_5, PARENT_REGION_NAME_6, PARENT_REGION_NAME_7, PARENT_REGION_NAME_8, PARENT_REGION_TYPE_1, PARENT_REGION_TYPE_2, PARENT_REGION_TYPE_3, PARENT_REGION_TYPE_4, PARENT_REGION_TYPE_5, PARENT_REGION_TYPE_6, PARENT_REGION_TYPE_7, PARENT_REGION_TYPE_8, (COUNTRY_CODE||NVL2(PARENT_REGION_NAME_1,(','||PARENT_REGION_NAME_1||NVL2(PARENT_REGION_NAME_2,(','||PARENT_REGION_NAME_2||NVL2(PARENT_REGION_NAME_3,(','||PARENT_REGION_NAME_3||NVL2(PARENT_REGION_NAME_4,(','||PARENT_REGION_NAME_4||NVL2(PARENT_REGION_NAME_5,(','||PARENT_REGION_NAME_5||NVL2(PARENT_REGION_NAME_6,(','||PARENT_REGION_NAME_6||NVL2(PARENT_REGION_NAME_7,(','||PARENT_REGION_NAME_7 ||NVL2(PARENT_REGION_NAME_8,(','||PARENT_REGION_NAME_8),NULL)),NULL)),NULL)),NULL)),NULL)),NULL)),NULL)),NULL)) PARENT_REGION_NAME_LIST, DELETED_FLAG FROM MSC_REGIONS WHERE REGION_ZONE_FLAG = 'R'