MSC_DIM_WORK_CENTER_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: MSC
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
ID CODE NAME DESCRIPTION PARENT_ID REFRESH_NUMBER |
問合せ
| 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 |