171: X_LAST_UPDATE_LOGIN,
172: X_DESCRIPTION,
173: L.LANGUAGE_CODE,
174: userenv('LANG')
175: from FND_LANGUAGES L
176: where L.INSTALLED_FLAG in ('I', 'B')
177: and not exists
178: (select NULL
179: from FND_TERRITORIES_TL T
512: B.LAST_UPDATE_LOGIN,
513: B.DESCRIPTION,
514: L.LANGUAGE_CODE,
515: B.SOURCE_LANG
516: from FND_TERRITORIES_TL B, FND_LANGUAGES L
517: where L.INSTALLED_FLAG in ('I', 'B')
518: and B.LANGUAGE = userenv('LANG')
519: and not exists
520: (select NULL