DBA Data[Home] [Help]

APPS.OE_RETROBILL_PVT dependencies on FND_LANGUAGES

Line 641: and b.language = (select language_code from fnd_languages where installed_flag = 'B');

637: and INTERFACE_LINE_ATTRIBUTE6=to_char(p_line_id) --bug5138249
638: and INTERFACE_LINE_ATTRIBUTE11 = '0'
639: and a.org_id = (select org_id from oe_order_lines_all where line_id = p_line_id) --bug# 8448816
640: and b.transaction_type_id = p_order_type_id
641: and b.language = (select language_code from fnd_languages where installed_flag = 'B');
642:
643: --CONTEXT,ATTRIBUTE1,ATTRIBUTE2 and ATTRIBUTE6 will hit a concatenate index in AR table
644: l_ci_id NUMBER;
645: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 4266: and ott.language = (select language_code from fnd_languages

4262: rctl.INTERFACE_LINE_ATTRIBUTE2=ott.name and
4263: rctl. INTERFACE_LINE_ATTRIBUTE6= to_char(l_line_id) and -- Added to_char for bug 9323027
4264: rctl.customer_trx_id = rct.customer_trx_id and
4265: ott.transaction_type_id=l_order_type_id
4266: and ott.language = (select language_code from fnd_languages
4267: where installed_flag = 'B') ;
4268:
4269: BEGIN
4270: --GSCC Not initializing during declaration