ZCA_ES_SRCH_OPERATORS_VL
Details
-
Schema: FUSION
-
Object owner: ZCA
-
Object type: VIEW
Columns
Name |
---|
SEARCH_OPERATOR_UUID SEARCH_OPERATOR_TYPE_NAME NUMBER_OF_ARGUMENTS APPLIES_WHEN_FIELD_IS_REQ_FLAG APPLIES_WHEN_ALL_FIELD_FLAG APPLIES_WHEN_RECSET_FIELD_FLAG APPLIES_WHEN_CLOB_FIELD_FLAG APPLIES_WHEN_RESOURCE_FLAG ENABLED_FLAG 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 |
Query
SQL_Statement |
---|
SELECT ZCA_ES_SRCH_OPERATORS_B.SEARCH_OPERATOR_UUID, ZCA_ES_SRCH_OPERATORS_B.SEARCH_OPERATOR_TYPE_NAME, ZCA_ES_SRCH_OPERATORS_B.NUMBER_OF_ARGUMENTS, ZCA_ES_SRCH_OPERATORS_B.APPLIES_WHEN_FIELD_IS_REQ_FLAG, ZCA_ES_SRCH_OPERATORS_B.APPLIES_WHEN_ALL_FIELD_FLAG, ZCA_ES_SRCH_OPERATORS_B.APPLIES_WHEN_RECSET_FIELD_FLAG, ZCA_ES_SRCH_OPERATORS_B.APPLIES_WHEN_CLOB_FIELD_FLAG, ZCA_ES_SRCH_OPERATORS_B.APPLIES_WHEN_RESOURCE_FLAG, ZCA_ES_SRCH_OPERATORS_B.ENABLED_FLAG, ZCA_ES_SRCH_OPERATORS_B.DELETED_FLAG, ZCA_ES_SRCH_OPERATORS_B.CREATED_BY, ZCA_ES_SRCH_OPERATORS_B.CREATION_DATE, ZCA_ES_SRCH_OPERATORS_B.LAST_UPDATE_DATE, ZCA_ES_SRCH_OPERATORS_B.LAST_UPDATE_LOGIN, ZCA_ES_SRCH_OPERATORS_B.LAST_UPDATED_BY, ZCA_ES_SRCH_OPERATORS_B.OBJECT_VERSION_NUMBER, ZCA_ES_SRCH_OPERATORS_B.USER_LAST_UPDATE_DATE, ZCA_ES_SRCH_OPERATORS_TL.LOCALIZED_NAME, ZCA_ES_SRCH_OPERATORS_TL.LOCALIZED_DESCRIPTION FROM ZCA_ES_SRCH_OPERATORS_B, ZCA_ES_SRCH_OPERATORS_TL WHERE ZCA_ES_SRCH_OPERATORS_B.SEARCH_OPERATOR_UUID = ZCA_ES_SRCH_OPERATORS_TL.SEARCH_OPERATOR_UUID AND ZCA_ES_SRCH_OPERATORS_TL.LANGUAGE = USERENV('LANG') |