APPS.GMI_RESERVATION_UTIL dependencies on FND_LANGUAGES

Line 2362: from fnd_languages

2358: AND mtl.segment2 = tt.name
2359: AND mtl.segment3 = fnd_profile.value('ONT_SOURCE_CODE')
2360: -- AND tt.language = userenv('LANG') -- OPM bug 3770264
2361: AND tt.language = (select language_code -- OPM bug 3770264
2362: from fnd_languages
2363: where installed_flag = 'B')
2364: AND tt.transaction_type_id = soh.order_type_id
2365: AND soh.header_id = sol.header_id
2366: AND sol.line_id = so_line_id ;

Line 3790: from fnd_languages

3786: AND mtl.segment1 = to_char(soh.order_number)
3787: AND mtl.segment2 = tt.name
3788: -- AND tt.language = userenv('LANG') -- OPM bug 3770264
3789: AND tt.language = (select language_code -- OPM bug 3770264
3790: from fnd_languages
3791: where installed_flag = 'B')
3792: AND mtl.segment3 = fnd_profile.value('ONT_SOURCE_CODE')
3793: AND tt.transaction_type_id = soh.order_type_id
3794: AND sol.header_id = soh.header_id;

Line 3933: from fnd_languages

3929: AND mtl.segment2 = tt.name
3930: AND mtl.segment3 = fnd_profile.value('ONT_SOURCE_CODE')
3931: --AND tt.language = userenv('LANG') -- OPM bug 3770264
3932: AND tt.language = (select language_code -- OPM bug 3770264
3933: from fnd_languages
3934: where installed_flag = 'B')
3935: AND tt.transaction_type_id = soh.order_type_id
3936: AND sol.header_id = soh.header_id;
3937: Cursor get_uom IS