MSC_DIM_WORK_CENTER_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.DEPARTMENT_ID ID , MR.DEPARTMENT_CODE CODE , decode(MR.DEPARTMENT_NAME, NULL, MR.DEPARTMENT_CODE, MR.DEPARTMENT_NAME) NAME, MR.DEPARTMENT_DESCRIPTION DESCRIPTION, max(NVL(MR.WORK_AREA_ID,-1)) PARENT_ID , -1 REFRESH_NUMBER FROM MSC_DEPARTMENT_RESOURCES MR WHERE MR.PLAN_ID = -1 AND MR.DEPARTMENT_ID IS NOT NULL group by MR.DEPARTMENT_ID, MR.DEPARTMENT_CODE, MR.DEPARTMENT_NAME, MR.DEPARTMENT_DESCRIPTION, -1