FND_SAVED_SEARCH_VL

Details

• Schema: SEARCH

• Object owner: FND

• Object type: VIEW

Columns

Name
ROW_ID SAVED_SEARCH_ID SAVED_SEARCH_CODE SEARCH_TYPE VERSION CONTEXT_CODE OBJECT_TYPE APPLIED_TYPE APPLIED_NAME OWNER_TYPE OWNER_NAME ENABLED_FLAG DEFAULT_FLAG VISIBLE_FLAG AUTO_RUN_FLAG SAVED_SEARCH OBJECT_VERSION_NUMBER USER_DATA MODULE_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN SEED_DATA_SOURCE DISPLAY_NAME DESCRIPTION

Query

SQL_Statement

SELECT B.ROWID ROW_ID, B.SAVED_SEARCH_ID SAVED_SEARCH_ID, B.SAVED_SEARCH_CODE SAVED_SEARCH_CODE, B.SEARCH_TYPE SEARCH_TYPE, B.VERSION VERSION, B.CONTEXT_CODE CONTEXT_CODE, B.OBJECT_TYPE OBJECT_TYPE, B.APPLIED_TYPE APPLIED_TYPE, B.APPLIED_NAME APPLIED_NAME, B.OWNER_TYPE OWNER_TYPE, B.OWNER_NAME OWNER_NAME, B.ENABLED_FLAG ENABLED_FLAG, B.DEFAULT_FLAG DEFAULT_FLAG, B.VISIBLE_FLAG VISIBLE_FLAG, B.AUTO_RUN_FLAG AUTO_RUN_FLAG, B.SAVED_SEARCH SAVED_SEARCH, B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, B.USER_DATA USER_DATA, B.MODULE_ID MODULE_ID, B.CREATED_BY CREATED_BY, B.CREATION_DATE CREATION_DATE, B.LAST_UPDATED_BY LAST_UPDATED_BY, B.LAST_UPDATE_DATE LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, B.SEED_DATA_SOURCE SEED_DATA_SOURCE, TL.DISPLAY_NAME DISPLAY_NAME, TL.DESCRIPTION DESCRIPTION FROM FND_SAVED_SEARCH_B B, FND_SAVED_SEARCH_TL TL WHERE B.SAVED_SEARCH_ID = TL.SAVED_SEARCH_ID AND TL.LANGUAGE = USERENV('LANG')