1369: INTO l_order_type_name
1370: FROM oe_transaction_types_tl otl,
1371: oe_order_headers ooh
1372: WHERE otl.language = (select language_code
1373: from fnd_languages
1374: where installed_flag = 'B')
1375: AND otl.transaction_type_id = ooh.order_type_id
1376: AND ooh.header_id = p_header_id;
1377:
3788: INTO l_order_type_name
3789: FROM oe_transaction_types_tl otl,
3790: oe_order_headers ooh
3791: WHERE otl.language = (SELECT language_code
3792: FROM fnd_languages
3793: WHERE installed_flag = 'B')
3794: AND otl.transaction_type_id = ooh.order_type_id
3795: AND ooh.header_id = p_header_id;
3796: