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 390: FROM FND_LANGUAGES

386: -- Get current language installation status (B or I)
387: -- to see if it is base language
388: --
389: SELECT INSTALLED_FLAG INTO l_Lang_Flag
390: FROM FND_LANGUAGES
391: WHERE LANGUAGE_CODE = userenv('LANG');
392:
393: --------------------------------------------
394: -- Open item query and fetch a first row. --

Line 4273: FROM FND_LANGUAGES L

4269: P_Item_Rec.LAST_UPDATED_BY,
4270: P_Item_Rec.CREATION_DATE,
4271: P_Item_Rec.CREATED_BY,
4272: P_Item_Rec.LAST_UPDATE_LOGIN
4273: FROM FND_LANGUAGES L
4274: WHERE L.INSTALLED_FLAG in ('I', 'B')
4275: AND NOT EXISTS
4276: ( SELECT NULL
4277: FROM MTL_SYSTEM_ITEMS_TL T

Line 6363: FND_LANGUAGES L

6359: ,B.LAST_UPDATE_LOGIN
6360: ,L.LANGUAGE_CODE
6361: ,B.SOURCE_LANG
6362: FROM MTL_SYSTEM_ITEMS_TL B ,
6363: FND_LANGUAGES L
6364: WHERE L.INSTALLED_FLAG IN ( 'I','B' )
6365: AND B.LANGUAGE = USERENV ( 'LANG' )
6366: AND NOT EXISTS( SELECT /*+ parallel(t) */ NULL
6367: FROM MTL_SYSTEM_ITEMS_TL T

Line 6414: FND_LANGUAGES L

6410: SYSDATE ,
6411: MSIK.LAST_UPDATED_BY,
6412: MSIK.LAST_UPDATE_LOGIN
6413: FROM MTL_SYSTEM_ITEMS_B_KFV MSIK,
6414: FND_LANGUAGES L
6415: WHERE L.INSTALLED_FLAG in ('I', 'B')
6416: AND MSIK.CONCATENATED_SEGMENTS IS NOT NULL
6417: AND MSIK.INVENTORY_ITEM_ID IS NOT NULL
6418: AND MSIK.ORGANIZATION_ID IS NOT NULL