57: X_LOCATION_TYPE_NAME,
58: X_LOCATION_TYPE_DESCRIPTION,
59: L.LANGUAGE_CODE,
60: userenv('LANG')
61: from FND_LANGUAGES L
62: where L.INSTALLED_FLAG in ('I', 'B')
63: and not exists
64: (select NULL
65: from JTF_LOC_TYPES_TL T
170: B.LOCATION_TYPE_NAME,
171: B.LOCATION_TYPE_DESCRIPTION,
172: L.LANGUAGE_CODE,
173: B.SOURCE_LANG
174: from JTF_LOC_TYPES_TL B, FND_LANGUAGES L
175: where L.INSTALLED_FLAG in ('I', 'B')
176: and B.LANGUAGE = userenv('LANG')
177: and not exists
178: (select NULL