143: X_STATUS_ID,
144: X_LAST_UPDATED_BY,
145: L.LANGUAGE_CODE,
146: userenv('LANG')
147: from FND_LANGUAGES L
148: where L.INSTALLED_FLAG in ('I', 'B')
149: and not exists
150: (select NULL
151: from MTL_MATERIAL_STATUSES_TL T
198: X_STATUS_ID,
199: X_LAST_UPDATED_BY,
200: L.LANGUAGE_CODE,
201: userenv('LANG')
202: from FND_LANGUAGES L
203: where L.INSTALLED_FLAG in ('I', 'B')
204: and not exists
205: (select NULL
206: from MTL_MATERIAL_STATUSES_TL T
777: B.STATUS_ID,
778: B.LAST_UPDATED_BY,
779: L.LANGUAGE_CODE,
780: B.SOURCE_LANG
781: from MTL_MATERIAL_STATUSES_TL B, FND_LANGUAGES L
782: where L.INSTALLED_FLAG in ('I', 'B')
783: and B.LANGUAGE = userenv('LANG')
784: and not exists
785: (select NULL