MSC_DIM_WORK_AREA_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
ID CODE NAME DESCRIPTION PARENT_ID REFRESH_NUMBER

Query

SQL_Statement

SELECT MR.WORK_AREA_ID ID , MR.WORK_AREA_CODE CODE , DECODE(MR.WORK_AREA_NAME,NULL,MR.WORK_AREA_CODE,MR.WORK_AREA_NAME) NAME , MR.WORK_AREA_DESCRIPTION DESCRIPTION, max(nvl(MR.ORGANIZATION_ID,-1)) PARENT_ID , -1 REFRESH_NUMBER FROM MSC_DEPARTMENT_RESOURCES MR WHERE MR.PLAN_ID = -1 AND MR.WORK_AREA_ID IS NOT NULL group by MR.WORK_AREA_ID, MR.WORK_AREA_CODE, MR.WORK_AREA_NAME, MR.WORK_AREA_DESCRIPTION, -1