31: X_CUSTOM_LEVEL,
32: X_DESCRIPTION,
33: L.CODE,
34: userenv('LANG')
35: from WF_LANGUAGES L
36: where L.INSTALLED_FLAG = 'Y'
37: and not exists
38: (select NULL
39: from WF_LOOKUP_TYPES_TL T
199: B.CUSTOM_LEVEL,
200: B.DESCRIPTION,
201: L.CODE,
202: B.SOURCE_LANG
203: from WF_LOOKUP_TYPES_TL B, WF_LANGUAGES L
204: where L.INSTALLED_FLAG = 'Y'
205: and B.LANGUAGE = userenv('LANG')
206: and (B.LOOKUP_TYPE , L.CODE ) NOT IN
207: (select /*+ hash_aj index_ffs(T,WF_LOOKUP_TYPES_TL_PK ) */