1. Tables and Views for Sales and Fusion Service
  2. ZCA_SA_DICTIONARY_VL

ZCA_SA_DICTIONARY_VL

Details

  • Schema: FUSION

  • Object owner: ZCA

  • Object type: VIEW

Columns

Name

KEYWORD_TYPE

KEYWORD_ROOT

SA_CONTEXT_CODE

SA_CONTEXT_VALUE

TOKEN_CODE

CREATION_DATE

CREATED_BY

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

TOKEN_STRING

Query

SQL_Statement

SELECT

ZCA_SA_DICTIONARY_B.KEYWORD_TYPE KEYWORD_TYPE,

ZCA_SA_DICTIONARY_B.KEYWORD_ROOT KEYWORD_ROOT,

ZCA_SA_DICTIONARY_B.SA_CONTEXT_CODE SA_CONTEXT_CODE,

ZCA_SA_DICTIONARY_B.SA_CONTEXT_VALUE SA_CONTEXT_VALUE,

ZCA_SA_DICTIONARY_B.TOKEN_CODE TOKEN_CODE,

ZCA_SA_DICTIONARY_B.CREATION_DATE CREATION_DATE,

ZCA_SA_DICTIONARY_B.CREATED_BY CREATED_BY,

ZCA_SA_DICTIONARY_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

ZCA_SA_DICTIONARY_B.LAST_UPDATED_BY LAST_UPDATED_BY,

ZCA_SA_DICTIONARY_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

ZCA_SA_DICTIONARY_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

ZCA_SA_DICTIONARY_TL.TOKEN_STRING TOKEN_STRING

FROM

ZCA_SA_DICTIONARY_B,

ZCA_SA_DICTIONARY_TL

WHERE

ZCA_SA_DICTIONARY_B.KEYWORD_TYPE = ZCA_SA_DICTIONARY_TL.KEYWORD_TYPE AND ZCA_SA_DICTIONARY_B.KEYWORD_ROOT = ZCA_SA_DICTIONARY_TL.KEYWORD_ROOT AND ZCA_SA_DICTIONARY_B.SA_CONTEXT_CODE = ZCA_SA_DICTIONARY_TL.SA_CONTEXT_CODE AND ZCA_SA_DICTIONARY_B.SA_CONTEXT_VALUE = ZCA_SA_DICTIONARY_TL.SA_CONTEXT_VALUE AND ZCA_SA_DICTIONARY_B.TOKEN_CODE = ZCA_SA_DICTIONARY_TL.TOKEN_CODE

AND ( (ZCA_SA_DICTIONARY_TL.keyword_type = 'synonym' and instr(ZCA_SA_DICTIONARY_TL.token_string,';') > 0) or ZCA_SA_DICTIONARY_TL.keyword_type = 'typeAheadRootKeyWords')

AND ZCA_SA_DICTIONARY_TL.LANGUAGE = USERENV('LANG')