APPS.INV_ITEM_PVT dependencies on FND_LANGUAGES

Line 244: l_Lang_Flag FND_LANGUAGES.INSTALLED_FLAG%TYPE;

240:
241: l_Attribute_Code Attribute_Code_type;
242: l_update_Item_TL BOOLEAN;
243: -- l_Lang_Flag VARCHAR2(1);
244: l_Lang_Flag FND_LANGUAGES.INSTALLED_FLAG%TYPE;
245:
246: l_return_status VARCHAR2(1);
247: --Added for 11.5.10
248: l_vmiorconsign_enabled NUMBER;

Line 363: FROM FND_LANGUAGES

359: -- Get current language installation status (B or I)
360: -- to see if it is base language
361: --
362: SELECT INSTALLED_FLAG INTO l_Lang_Flag
363: FROM FND_LANGUAGES
364: WHERE LANGUAGE_CODE = userenv('LANG');
365:
366: --------------------------------------------
367: -- Open item query and fetch a first row. --

Line 4008: FROM FND_LANGUAGES L

4004: P_Item_Rec.LAST_UPDATED_BY,
4005: P_Item_Rec.CREATION_DATE,
4006: P_Item_Rec.CREATED_BY,
4007: P_Item_Rec.LAST_UPDATE_LOGIN
4008: FROM FND_LANGUAGES L
4009: WHERE L.INSTALLED_FLAG in ('I', 'B')
4010: AND NOT EXISTS
4011: ( SELECT NULL
4012: FROM MTL_SYSTEM_ITEMS_TL T

Line 5951: FND_LANGUAGES L

5947: B.LAST_UPDATE_LOGIN,
5948: L.LANGUAGE_CODE,
5949: B.SOURCE_LANG
5950: FROM MTL_SYSTEM_ITEMS_TL B,
5951: FND_LANGUAGES L
5952: WHERE L.INSTALLED_FLAG in ('I', 'B')
5953: AND B.LANGUAGE = userenv('LANG')
5954: AND NOT EXISTS( SELECT NULL
5955: FROM MTL_SYSTEM_ITEMS_TL T