1. Tables and Views for SCM
  2. MSC_DIM_GEO_V

MSC_DIM_GEO_V

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: VIEW

Columns

Name

ID

NAME

DESCRIPTION

PARENT_ID

HIERARCHY_ID

LEVEL_ID

Query

SQL_Statement

SELECT MR.REGION_ID ID ,

MR.REGION_NAME NAME ,

MR.REGION_ID||'-'||MR.REGION_NAME||'-'||MR.REGION_TYPE DESCRIPTION ,

NVL(MR.IMMEDIATE_PARENT_REGION_ID,-1) PARENT_ID ,

MLM.HIERARCHY_ID HIERARCHY_ID,

MLM.LEVEL_ID LEVEL_ID

FROM MSC_REGIONS MR,

MSC_LEVEL_MEMBERS MLM,

MSC_HIERARCHIES_B MHB

WHERE MLM.HIERARCHY_ID = MHB.HIERARCHY_ID

AND MHB.HIERARCHY_CODE IN ('ORG_GEO', 'CUS_GEO')

AND MHB.DIMENSION_ID IN (2, 3)

AND MR.REGION_ID = MLM.LEVEL_MEMBER_ID

AND MR.REGION_ZONE_FLAG = 'R'

AND MR.IMMEDIATE_PARENT_REGION_ID = NVL(MLM.PARENT_LEVEL_MEMBER_ID, MR.IMMEDIATE_PARENT_REGION_ID)