DBA Data[Home] [Help]

APPS.MTL_ITEM_REVISIONS_UTIL dependencies on FND_LANGUAGES

Line 172: FROM FND_LANGUAGES L

168: P_Item_Revision_Rec.LAST_UPDATED_BY,
169: P_Item_Revision_Rec.LAST_UPDATE_LOGIN,
170: L.LANGUAGE_CODE,
171: USERENV('LANG')
172: FROM FND_LANGUAGES L
173: WHERE L.INSTALLED_FLAG in ('I', 'B')
174: AND NOT EXISTS (SELECT NULL
175: FROM MTL_ITEM_REVISIONS_TL T
176: WHERE T.INVENTORY_ITEM_ID = P_Item_Revision_Rec.INVENTORY_ITEM_ID

Line 471: FND_LANGUAGES L

467: B.LAST_UPDATE_LOGIN,
468: L.LANGUAGE_CODE,
469: B.SOURCE_LANG
470: FROM MTL_ITEM_REVISIONS_TL B,
471: FND_LANGUAGES L
472: WHERE L.INSTALLED_FLAG IN ('I', 'B')
473: AND B.LANGUAGE = USERENV('LANG')
474: AND NOT EXISTS (SELECT /*+ parallel(T) */ NULL
475: FROM MTL_ITEM_REVISIONS_TL T