APPS.OE_HEADER_UTIL dependencies on OE_TRANSACTION_TYPES_TL

Line 7671: FROM OE_TRANSACTION_TYPES_TL

7667: -- Fix for bug#1078323: the order type name should be selected in
7668: -- the base language
7669: SELECT name
7670: INTO x_order_type
7671: FROM OE_TRANSACTION_TYPES_TL
7672: WHERE TRANSACTION_TYPE_ID = l_order_type_id
7673: AND language = (select language_code from
7674: fnd_languages
7675: where installed_flag = 'B');

Line 7700: from oe_transaction_types_tl tl,

7696: into l_header_id
7697: from oe_order_headers
7698: where order_number = p_order_number AND
7699: order_type_id = (select tl.transaction_type_id
7700: from oe_transaction_types_tl tl,
7701: oe_transaction_types_all ta
7702: where ta.transaction_type_id =
7703: tl.transaction_type_id and
7704: tl.name = p_order_type and

Line 8075: FROM OE_TRANSACTION_TYPES_TL

8071: END IF;
8072:
8073: SELECT NAME
8074: INTO l_order_type
8075: FROM OE_TRANSACTION_TYPES_TL
8076: WHERE TRANSACTION_TYPE_ID = p_order_type_id
8077: AND language = (select language_code
8078: from fnd_languages
8079: where installed_flag = 'B');