73: X_LAST_UPDATE_LOGIN,
74: X_DISPLAY_NAME,
75: L.LANGUAGE_CODE,
76: userenv('LANG')
77: from FND_LANGUAGES L
78: where L.INSTALLED_FLAG in ('I', 'B')
79: and not exists
80: (select NULL
81: from AMS_LIST_QUERIES_PARAM_TL T
285: B.LAST_UPDATE_LOGIN,
286: B.DISPLAY_NAME,
287: L.LANGUAGE_CODE,
288: B.SOURCE_LANG
289: from AMS_LIST_QUERIES_PARAM_TL B, FND_LANGUAGES L
290: where L.INSTALLED_FLAG in ('I', 'B')
291: and B.LANGUAGE = userenv('LANG')
292: and not exists
293: (select NULL
366: X_LAST_UPDATE_LOGIN,
367: X_DISPLAY_NAME,
368: L.LANGUAGE_CODE,
369: userenv('LANG')
370: from FND_LANGUAGES L
371: where L.INSTALLED_FLAG in ('I', 'B')
372: and not exists
373: (select NULL
374: from AMS_LIST_QUERIES_PARAM_TL T