WIS_DATA_SECURITY_OBJECTS_VL
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: WIS
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
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 |
問合せ
| 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') |