WIS_DATA_SECURITY_OBJECTS_VL
Details
-
Schema: FUSION
-
Object owner: WIS
-
Object type: VIEW
Columns
Name |
---|
DATA_SECURITY_OBJECT_ID OBJECT_VERSION_NUMBER DATA_SECURITY_OBJECT_CODE DATA_SECURITY_OBJECT_NAME DATA_SECURITY_ENABLED_FLAG CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN |
Query
SQL_Statement |
---|
SELECT DSOB.DATA_SECURITY_OBJECT_ID DATA_SECURITY_OBJECT_ID, DSOB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, DSOB.DATA_SECURITY_OBJECT_CODE DATA_SECURITY_OBJECT_CODE, DSOTL.DATA_SECURITY_OBJECT_NAME DATA_SECURITY_OBJECT_NAME, DSOB.DATA_SECURITY_ENABLED_FLAG DATA_SECURITY_ENABLED_FLAG, DSOB.CREATED_BY CREATED_BY, DSOB.CREATION_DATE CREATION_DATE, DSOB.LAST_UPDATED_BY LAST_UPDATED_BY, DSOB.LAST_UPDATE_DATE LAST_UPDATE_DATE, DSOB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM WIS_DATA_SECURITY_OBJECTS_B DSOB, WIS_DATA_SECURITY_OBJECTS_TL DSOTL WHERE DSOTL.DATA_SECURITY_OBJECT_ID = DSOB.DATA_SECURITY_OBJECT_ID AND DSOTL.LANGUAGE = USERENV('LANG') |