165: X_LAST_UPDATE_LOGIN,
166: X_COMMENTS,
167: L.LANGUAGE_CODE,
168: userenv('LANG')
169: from FND_LANGUAGES L
170: where L.INSTALLED_FLAG in ('I', 'B')
171: and not exists
172: (select NULL
173: from AHL_PRD_DISPOSITIONS_TL_H T
560: B.LAST_UPDATE_LOGIN,
561: B.COMMENTS,
562: L.LANGUAGE_CODE,
563: B.SOURCE_LANG
564: from AHL_PRD_DISPOSITIONS_TL_H B, FND_LANGUAGES L
565: where L.INSTALLED_FLAG in ('I', 'B')
566: and B.LANGUAGE = userenv('LANG')
567: and not exists
568: (select NULL