FND_SEARCH_OPTIONS

Details

Schema: SEARCH
Object owner: FND
Object type: VIEW

Columns

Name
ROW_ID SEARCH_OPTION_ID SEARCH_OPTION_CODE PILLAR MODULE_ID OPTION_ENABLED_FLAG DEFAULT_OPTION_FLAG SEARCH_FIELD_CAT_ENA_FLAG SEARCH_FIELD_GRPS_ENA_FLAG SEARCH_FIELD_MIN_LEN SEARCH_FIELD_MAX_LEN SEARCH_FIELD_CLR_ON_SEARCH SEARCH_FIELD_SF_ENA_FLAG SUGGEST_ONLY_FLAG SEARCH_CATEGORY_APP_STRIPE SEARCH_CATEGORIES SAVED_SEARCHES_ENA_FLAG RECENT_SEARCHES_ENA_FLAG APPLIED_FILTERS_ENA_FLAG FILTER_SUBCAT_ENA_FLAG FILTER_FACETS_ENA_FLAG FILTER_FACET_CNT_ENA_FLAG FILTER_CLEAR_ALL_ENA_FLAG FILTER_LOV_STYLE LAST_UPDATE_DATE_FILTER RESULT_ICONS_ENA SUGGEST_GROUPS SUGGEST_TOP_SUGGESTIONS_ENA SUGGEST_GRP_HEADINGS_ENA SUGGEST_GRP_ICONS_ENA SUGGEST_MIN_CHARS_FOR_SUG SUGGEST_MAX_SUGGESTIONS SUGGEST_SYN_ENA_FLAG SUGGEST_SYN_CONTEXT_CODE SUGGEST_SYN_OBJECT_TYPE SEARCH_FACTORY_EXPRESSION CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN DISPLAY_NAME DESCRIPTION SEARCH_FIELD_PLACEHOLDER SEARCH_FIELD_LABEL SUGGEST_NO_MATCH_MSG

Name

ROW_ID

SEARCH_OPTION_ID

SEARCH_OPTION_CODE

PILLAR

MODULE_ID

OPTION_ENABLED_FLAG

DEFAULT_OPTION_FLAG

SEARCH_FIELD_CAT_ENA_FLAG

SEARCH_FIELD_GRPS_ENA_FLAG

SEARCH_FIELD_MIN_LEN

SEARCH_FIELD_MAX_LEN

SEARCH_FIELD_CLR_ON_SEARCH

SEARCH_FIELD_SF_ENA_FLAG

SUGGEST_ONLY_FLAG

SEARCH_CATEGORY_APP_STRIPE

SEARCH_CATEGORIES

SAVED_SEARCHES_ENA_FLAG

RECENT_SEARCHES_ENA_FLAG

APPLIED_FILTERS_ENA_FLAG

FILTER_SUBCAT_ENA_FLAG

FILTER_FACETS_ENA_FLAG

FILTER_FACET_CNT_ENA_FLAG

FILTER_CLEAR_ALL_ENA_FLAG

FILTER_LOV_STYLE

LAST_UPDATE_DATE_FILTER

RESULT_ICONS_ENA

SUGGEST_GROUPS

SUGGEST_TOP_SUGGESTIONS_ENA

SUGGEST_GRP_HEADINGS_ENA

SUGGEST_GRP_ICONS_ENA

SUGGEST_MIN_CHARS_FOR_SUG

SUGGEST_MAX_SUGGESTIONS

SUGGEST_SYN_ENA_FLAG

SUGGEST_SYN_CONTEXT_CODE

SUGGEST_SYN_OBJECT_TYPE

SEARCH_FACTORY_EXPRESSION

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

DISPLAY_NAME

DESCRIPTION

SEARCH_FIELD_PLACEHOLDER

SEARCH_FIELD_LABEL

SUGGEST_NO_MATCH_MSG

Query

SQL_Statement
SELECT B.ROWID ROW_ID, B.SEARCH_OPTION_ID, B.SEARCH_OPTION_CODE, B.PILLAR, B.MODULE_ID, B.OPTION_ENABLED_FLAG, B.DEFAULT_OPTION_FLAG, B.SEARCH_FIELD_CAT_ENA_FLAG, B.SEARCH_FIELD_GRPS_ENA_FLAG, B.SEARCH_FIELD_MIN_LEN, B.SEARCH_FIELD_MAX_LEN, B.SEARCH_FIELD_CLR_ON_SEARCH, B.SEARCH_FIELD_SF_ENA_FLAG, B.SUGGEST_ONLY_FLAG, B.SEARCH_CATEGORY_APP_STRIPE, B.SEARCH_CATEGORIES, B.SAVED_SEARCHES_ENA_FLAG, B.RECENT_SEARCHES_ENA_FLAG, B.APPLIED_FILTERS_ENA_FLAG, B.FILTER_SUBCAT_ENA_FLAG, B.FILTER_FACETS_ENA_FLAG, B.FILTER_FACET_CNT_ENA_FLAG, B.FILTER_CLEAR_ALL_ENA_FLAG, B.FILTER_LOV_STYLE, B.LAST_UPDATE_DATE_FILTER, B.RESULT_ICONS_ENA, B.SUGGEST_GROUPS, B.SUGGEST_TOP_SUGGESTIONS_ENA, B.SUGGEST_GRP_HEADINGS_ENA, B.SUGGEST_GRP_ICONS_ENA, B.SUGGEST_MIN_CHARS_FOR_SUG, B.SUGGEST_MAX_SUGGESTIONS, B.SUGGEST_SYN_ENA_FLAG, B.SUGGEST_SYN_CONTEXT_CODE, B.SUGGEST_SYN_OBJECT_TYPE, B.SEARCH_FACTORY_EXPRESSION, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, T.DISPLAY_NAME, T.DESCRIPTION, T.SEARCH_FIELD_PLACEHOLDER, T.SEARCH_FIELD_LABEL, T.SUGGEST_NO_MATCH_MSG FROM FND_SEARCH_OPTIONS_TL T, FND_SEARCH_OPTIONS_B B WHERE B.SEARCH_OPTION_ID = T.SEARCH_OPTION_ID AND T.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

B.ROWID ROW_ID,

B.SEARCH_OPTION_ID,

B.SEARCH_OPTION_CODE,

B.PILLAR,

B.MODULE_ID,

B.OPTION_ENABLED_FLAG,

B.DEFAULT_OPTION_FLAG,

B.SEARCH_FIELD_CAT_ENA_FLAG,

B.SEARCH_FIELD_GRPS_ENA_FLAG,

B.SEARCH_FIELD_MIN_LEN,

B.SEARCH_FIELD_MAX_LEN,

B.SEARCH_FIELD_CLR_ON_SEARCH,

B.SEARCH_FIELD_SF_ENA_FLAG,

B.SUGGEST_ONLY_FLAG,

B.SEARCH_CATEGORY_APP_STRIPE,

B.SEARCH_CATEGORIES,

B.SAVED_SEARCHES_ENA_FLAG,

B.RECENT_SEARCHES_ENA_FLAG,

B.APPLIED_FILTERS_ENA_FLAG,

B.FILTER_SUBCAT_ENA_FLAG,

B.FILTER_FACETS_ENA_FLAG,

B.FILTER_FACET_CNT_ENA_FLAG,

B.FILTER_CLEAR_ALL_ENA_FLAG,

B.FILTER_LOV_STYLE,

B.LAST_UPDATE_DATE_FILTER,

B.RESULT_ICONS_ENA,

B.SUGGEST_GROUPS,

B.SUGGEST_TOP_SUGGESTIONS_ENA,

B.SUGGEST_GRP_HEADINGS_ENA,

B.SUGGEST_GRP_ICONS_ENA,

B.SUGGEST_MIN_CHARS_FOR_SUG,

B.SUGGEST_MAX_SUGGESTIONS,

B.SUGGEST_SYN_ENA_FLAG,

B.SUGGEST_SYN_CONTEXT_CODE,

B.SUGGEST_SYN_OBJECT_TYPE,

B.SEARCH_FACTORY_EXPRESSION,

B.CREATED_BY,

B.CREATION_DATE,

B.LAST_UPDATED_BY,

B.LAST_UPDATE_DATE,

B.LAST_UPDATE_LOGIN,

T.DISPLAY_NAME,

T.DESCRIPTION,

T.SEARCH_FIELD_PLACEHOLDER,

T.SEARCH_FIELD_LABEL,

T.SUGGEST_NO_MATCH_MSG

FROM

FND_SEARCH_OPTIONS_TL T,

FND_SEARCH_OPTIONS_B B

WHERE

B.SEARCH_OPTION_ID = T.SEARCH_OPTION_ID AND T.LANGUAGE = USERENV('LANG')