MSC_DIM_SCALED_ZONE_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
ID NAME PARENT_ID DESCRIPTION

Query

SQL_Statement
SELECT DISTINCT A.ID, A.NAME, A.PARENT_ID PARENT_ID, A.DESCRIPTION DESCRIPTION FROM (SELECT MZ.ZONE_ID ID , MZ.ZONE_NAME NAME , -1 PARENT_ID, MZ.ZONE_ID||'-'||MZ.ZONE_NAME||'-'||MZ.ZONE_TYPE DESCRIPTION FROM MSC_ZONES_V MZ WHERE MZ.ZONE_ID IS NOT NULL) A