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')