DBA Data[Home] [Help]

APPS.OE_SCHEDULE_UTIL dependencies on OE_TRANSACTION_TYPES

Line 9166: FROM oe_transaction_types

9162:
9163: IF p_line_type_id IS NOT NULL THEN
9164: SELECT name, scheduling_level_code
9165: INTO l_line_type,l_scheduling_level_code
9166: FROM oe_transaction_types
9167: WHERE transaction_type_id = p_line_type_id AND
9168: transaction_type_code = 'LINE';
9169: END IF;
9170:

Line 12772: FROM OE_TRANSACTION_TYPES_TL

12768: ELSE
12769: BEGIN
12770: SELECT NAME
12771: INTO l_order_type_name
12772: FROM OE_TRANSACTION_TYPES_TL
12773: WHERE TRANSACTION_TYPE_ID = l_order_type_id
12774: AND language = (select language_code
12775: from fnd_languages
12776: where installed_flag = 'B');

Line 12876: FROM OE_TRANSACTION_TYPES_TL

12872: -- Fix for bug#1078323: the order type name should be selected in
12873: -- the base language
12874: SELECT NAME
12875: INTO l_order_type_name
12876: FROM OE_TRANSACTION_TYPES_TL
12877: WHERE TRANSACTION_TYPE_ID = p_header_rec.order_type_id
12878: AND language = (select language_code
12879: from fnd_languages
12880: where installed_flag = 'B');