157: X_TRANSACTION_TYPE_ID,
158: X_NAME,
159: L.LANGUAGE_CODE,
160: userenv('LANG')
161: from FND_LANGUAGES L
162: where L.INSTALLED_FLAG in ('I', 'B')
163: and not exists
164: (select NULL
165: from CS_TRANSACTION_TYPES_TL T
543: B.TRANSACTION_TYPE_ID,
544: B.NAME,
545: L.LANGUAGE_CODE,
546: B.SOURCE_LANG
547: from CS_TRANSACTION_TYPES_TL B, FND_LANGUAGES L
548: where L.INSTALLED_FLAG in ('I', 'B')
549: and B.LANGUAGE = userenv('LANG')
550: and not exists
551: (select NULL