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
500: B.LAST_UPDATE_LOGIN,
501: B.DESCRIPTION,
502: L.LANGUAGE_CODE,
503: B.SOURCE_LANG
504: from FND_TERRITORIES_TL B, FND_LANGUAGES L
505: where L.INSTALLED_FLAG in ('I', 'B')
506: and B.LANGUAGE = userenv('LANG')
507: and not exists
508: (select NULL