CN_ROLES_VL

Details

• Schema: FUSION

• Object owner: CN

• Object type: VIEW

Columns

Name

ROW_ID ROLE_ID ROLE_CODE ROLE_TYPE_CODE SEEDED_FLAG ACCESS_TYPE ACTIVE_FLAG OBJECT_VERSION_NUMBER ROLE_NAME ROLE_DESC ATTRIBUTE_CATEGORY ATTRIBUTE_CHAR1 ATTRIBUTE_CHAR2 ATTRIBUTE_CHAR3 ATTRIBUTE_CHAR4 ATTRIBUTE_CHAR5 ATTRIBUTE_CHAR6 ATTRIBUTE_CHAR7 ATTRIBUTE_CHAR8 ATTRIBUTE_CHAR9 ATTRIBUTE_CHAR10 ATTRIBUTE_CHAR11 ATTRIBUTE_CHAR12 ATTRIBUTE_CHAR13 ATTRIBUTE_CHAR14 ATTRIBUTE_CHAR15 CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT B.ROWID ROW_ID, B.ROLE_ID, B.ROLE_CODE, B.ROLE_TYPE_CODE, B.SEEDED_FLAG, B.ACCESS_TYPE, B.ACTIVE_FLAG, B.OBJECT_VERSION_NUMBER, T.ROLE_NAME, T.ROLE_DESC, B.ATTRIBUTE_CATEGORY, B.ATTRIBUTE_CHAR1, B.ATTRIBUTE_CHAR2, B.ATTRIBUTE_CHAR3, B.ATTRIBUTE_CHAR4, B.ATTRIBUTE_CHAR5, B.ATTRIBUTE_CHAR6, B.ATTRIBUTE_CHAR7, B.ATTRIBUTE_CHAR8, B.ATTRIBUTE_CHAR9, B.ATTRIBUTE_CHAR10, B.ATTRIBUTE_CHAR11, B.ATTRIBUTE_CHAR12, B.ATTRIBUTE_CHAR13, B.ATTRIBUTE_CHAR14, B.ATTRIBUTE_CHAR15, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN FROM CN_ROLES_TL T, CN_ROLES_B B WHERE B.ROLE_ID = T.ROLE_ID AND T.LANGUAGE = USERENV('LANG')