MSC_DIM_RESOURCE_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: MSC
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
ID CODE NAME DESCRIPTION PARENT_ID REFRESH_NUMBER |
問合せ
| SQL_Statement |
|---|
|
SELECT MR.RESOURCE_ID ID , MR.RESOURCE_CODE CODE , decode(MR.RESOURCE_NAME,NULL,MR.RESOURCE_CODE,MR.RESOURCE_NAME) NAME , MR.RESOURCE_DESCRIPTION DESCRIPTION, MR.DEPARTMENT_ID PARENT_ID , MR.REFRESH_NUMBER REFRESH_NUMBER FROM MSC_DEPARTMENT_RESOURCES MR WHERE PLAN_ID = -1 AND MR.RESOURCE_ID IS NOT NULL |