FND_OBJECT_INSTANCE_SETS_VL

Details

• Schema: DATASECURITY

• Object owner: FND

• Object type: VIEW

Columns

Name
ROW_ID INSTANCE_SET_ID INSTANCE_SET_NAME OBJECT_ID PREDICATE FILTER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN DISPLAY_NAME DESCRIPTION DISPLAY_SHORT_NAME PROGRAM_NAME PROGRAM_TAG CHANGE_SINCE_LAST_REFRESH

Query

SQL_Statement

select B.ROWID ROW_ID, B.INSTANCE_SET_ID, B.INSTANCE_SET_NAME, B.OBJECT_ID, B.PREDICATE, B.FILTER, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, T.DISPLAY_NAME, T.DESCRIPTION, T.DISPLAY_SHORT_NAME, B.PROGRAM_NAME, B.PROGRAM_TAG, B.CHANGE_SINCE_LAST_REFRESH FROM FND_OBJECT_INSTANCE_SETS_TL T, FND_OBJECT_INSTANCE_SETS B WHERE B.INSTANCE_SET_ID = T.INSTANCE_SET_ID AND T.LANGUAGE = USERENV('LANG')