機械翻訳について

MSC_DIM_GEO_V

詳細

• スキーマ: FUSION

• オブジェクト所有者: MSC

• オブジェクト・タイプ: VIEW

列

名前
ID NAME DESCRIPTION PARENT_ID HIERARCHY_ID LEVEL_ID

問合せ

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)