MSC_DIM_RESOURCE_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.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