ZCA_ES_SAVED_SEARCHES_VL

Details

• Schema: FUSION

• Object owner: ZCA

• Object type: VIEW

Columns

Name

SAVED_SEARCH_UUID SAVED_SEARCH_NUMBER ENTITY_UUID USER_ID KEYWORDS KEYWORDS_FIELDS_LIST_JSON QUERY_JSON AGGREGATIONS_JSON SORT_JSON ENTITIES_JSON HIGHLIGHTS_JSON FIELDS_JSON EXCLUDE_JSON DELETED_FLAG CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATE_LOGIN LAST_UPDATED_BY OBJECT_VERSION_NUMBER USER_LAST_UPDATE_DATE LOCALIZED_NAME LOCALIZED_DESCRIPTION ACCESS_LEVEL_TYPE_NAME DEFAULT_LAYOUT_TYPE_NAME SHARED_FLAG

Query

SQL_Statement

SELECT ZCA_ES_SAVED_SEARCHES_B.SAVED_SEARCH_UUID, ZCA_ES_SAVED_SEARCHES_B.SAVED_SEARCH_NUMBER, ZCA_ES_SAVED_SEARCHES_B.ENTITY_UUID, ZCA_ES_SAVED_SEARCHES_B.USER_ID, ZCA_ES_SAVED_SEARCHES_B.KEYWORDS, ZCA_ES_SAVED_SEARCHES_B.KEYWORDS_FIELDS_LIST_JSON, ZCA_ES_SAVED_SEARCHES_B.QUERY_JSON, ZCA_ES_SAVED_SEARCHES_B.AGGREGATIONS_JSON, ZCA_ES_SAVED_SEARCHES_B.SORT_JSON, ZCA_ES_SAVED_SEARCHES_B.ENTITIES_JSON, ZCA_ES_SAVED_SEARCHES_B.HIGHLIGHTS_JSON, ZCA_ES_SAVED_SEARCHES_B.FIELDS_JSON, ZCA_ES_SAVED_SEARCHES_B.EXCLUDE_JSON, ZCA_ES_SAVED_SEARCHES_B.DELETED_FLAG, ZCA_ES_SAVED_SEARCHES_B.CREATED_BY, ZCA_ES_SAVED_SEARCHES_B.CREATION_DATE, ZCA_ES_SAVED_SEARCHES_B.LAST_UPDATE_DATE, ZCA_ES_SAVED_SEARCHES_B.LAST_UPDATE_LOGIN, ZCA_ES_SAVED_SEARCHES_B.LAST_UPDATED_BY, ZCA_ES_SAVED_SEARCHES_B.OBJECT_VERSION_NUMBER, ZCA_ES_SAVED_SEARCHES_B.USER_LAST_UPDATE_DATE, ZCA_ES_SAVED_SEARCHES_TL.LOCALIZED_NAME, ZCA_ES_SAVED_SEARCHES_TL.LOCALIZED_DESCRIPTION, ZCA_ES_SAVED_SEARCHES_B.ACCESS_LEVEL_TYPE_NAME, ZCA_ES_SAVED_SEARCHES_B.DEFAULT_LAYOUT_TYPE_NAME, ZCA_ES_SAVED_SEARCHES_B.SHARED_FLAG FROM ZCA_ES_SAVED_SEARCHES_B, ZCA_ES_SAVED_SEARCHES_TL WHERE ZCA_ES_SAVED_SEARCHES_B.SAVED_SEARCH_UUID = ZCA_ES_SAVED_SEARCHES_TL.SAVED_SEARCH_UUID AND ZCA_ES_SAVED_SEARCHES_TL.LANGUAGE = USERENV('LANG')