[Home] [Help]
266: X_LAST_UPDATE_LOGIN,
267: X_TITLE,
268: L.LANGUAGE_CODE,
269: userenv('LANG')
270: from FND_LANGUAGES L
271: where L.INSTALLED_FLAG in ('I', 'B')
272: and not exists
273: (select NULL
274: from AHL_ROUTES_TL T
847: B.LAST_UPDATE_LOGIN,
848: B.TITLE,
849: L.LANGUAGE_CODE,
850: B.SOURCE_LANG
851: from AHL_ROUTES_TL B, FND_LANGUAGES L
852: where L.INSTALLED_FLAG in ('I', 'B')
853: and B.LANGUAGE = userenv('LANG')
854: and not exists
855: (select NULL