110: X_STORE_NAME,
111: X_STORE_DESCRIPTION,
112: L.LANGUAGE_CODE,
113: userenv('LANG')
114: from FND_LANGUAGES L
115: where L.INSTALLED_FLAG in ('I', 'B')
116: and not exists
117: (select NULL
118: from JTF_STORES_TL T
515: B.STORE_NAME,
516: B.STORE_DESCRIPTION,
517: L.LANGUAGE_CODE,
518: B.SOURCE_LANG
519: from JTF_STORES_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