DBA Data[Home] [Help]

APPS.OE_SCHEDULE_UTIL dependencies on OE_TRANSACTION_TYPES

Line 7824: FROM oe_transaction_types

7820:
7821: IF p_line_type_id IS NOT NULL THEN
7822: SELECT name, scheduling_level_code
7823: INTO l_line_type,l_scheduling_level_code
7824: FROM oe_transaction_types
7825: WHERE transaction_type_id = p_line_type_id AND
7826: transaction_type_code = 'LINE';
7827: END IF;
7828:

Line 11165: FROM OE_TRANSACTION_TYPES_TL

11161: ELSE
11162: BEGIN
11163: SELECT NAME
11164: INTO l_order_type_name
11165: FROM OE_TRANSACTION_TYPES_TL
11166: WHERE TRANSACTION_TYPE_ID = l_order_type_id
11167: AND language = (select language_code
11168: from fnd_languages
11169: where installed_flag = 'B');

Line 11269: FROM OE_TRANSACTION_TYPES_TL

11265: -- Fix for bug#1078323: the order type name should be selected in
11266: -- the base language
11267: SELECT NAME
11268: INTO l_order_type_name
11269: FROM OE_TRANSACTION_TYPES_TL
11270: WHERE TRANSACTION_TYPE_ID = p_header_rec.order_type_id
11271: AND language = (select language_code
11272: from fnd_languages
11273: where installed_flag = 'B');