APPS.OE_ORDER_SCH_UTIL dependencies on OE_TRANSACTION_TYPES

Line 2709: FROM oe_transaction_types

2705: END IF;
2706:
2707: SELECT name, scheduling_level_code
2708: INTO l_line_type,l_scheduling_level_code
2709: FROM oe_transaction_types
2710: WHERE transaction_type_id = p_line_type_id AND
2711: transaction_type_code = 'LINE';
2712:
2713: IF l_scheduling_level_code IS NOT NULL THEN

Line 8170: FROM OE_TRANSACTION_TYPES_TL

8166: -- Fix for bug#1078323: the order type name should be selected in
8167: -- the base language
8168: SELECT NAME
8169: INTO l_order_type_name
8170: FROM OE_TRANSACTION_TYPES_TL
8171: WHERE TRANSACTION_TYPE_ID = p_header_rec.order_type_id
8172: AND language = (select language_code
8173: from fnd_languages
8174: where installed_flag = 'B');