APPS.GMI_RESERVATION_UTIL dependencies on FND_LANGUAGES

Line 2350: from fnd_languages

2346: AND mtl.segment2 = tt.name
2347: AND mtl.segment3 = fnd_profile.value('ONT_SOURCE_CODE')
2348: -- AND tt.language = userenv('LANG') -- OPM bug 3770264
2349: AND tt.language = (select language_code -- OPM bug 3770264
2350: from fnd_languages
2351: where installed_flag = 'B')
2352: AND tt.transaction_type_id = soh.order_type_id
2353: AND soh.header_id = sol.header_id
2354: AND sol.line_id = so_line_id ;

Line 3778: from fnd_languages

3774: AND mtl.segment1 = to_char(soh.order_number)
3775: AND mtl.segment2 = tt.name
3776: -- AND tt.language = userenv('LANG') -- OPM bug 3770264
3777: AND tt.language = (select language_code -- OPM bug 3770264
3778: from fnd_languages
3779: where installed_flag = 'B')
3780: AND mtl.segment3 = fnd_profile.value('ONT_SOURCE_CODE')
3781: AND tt.transaction_type_id = soh.order_type_id
3782: AND sol.header_id = soh.header_id;

Line 3921: from fnd_languages

3917: AND mtl.segment2 = tt.name
3918: AND mtl.segment3 = fnd_profile.value('ONT_SOURCE_CODE')
3919: --AND tt.language = userenv('LANG') -- OPM bug 3770264
3920: AND tt.language = (select language_code -- OPM bug 3770264
3921: from fnd_languages
3922: where installed_flag = 'B')
3923: AND tt.transaction_type_id = soh.order_type_id
3924: AND sol.header_id = soh.header_id;
3925: Cursor get_uom IS