216: X_LAST_UPDATED_BY,
217: X_LAST_UPDATE_LOGIN,
218: L.LANGUAGE_CODE,
219: userenv('LANG')
220: from FND_LANGUAGES L
221: where L.INSTALLED_FLAG in ('I', 'B')
222: and not exists
223: (select NULL
224: from CS_KB_HISTORIES_TL T
515: B.LAST_UPDATED_BY,
516: B.LAST_UPDATE_LOGIN,
517: L.LANGUAGE_CODE,
518: B.SOURCE_LANG
519: from CS_KB_HISTORIES_TL B, FND_LANGUAGES L
520: where L.INSTALLED_FLAG in ('I', 'B')
521: and B.LANGUAGE = userenv('LANG')
522: and not exists
523: (select NULL