APPS.OE_HEADER_UTIL dependencies on OE_TRANSACTION_TYPES_TL

Line 7519: FROM OE_TRANSACTION_TYPES_TL

7515: -- Fix for bug#1078323: the order type name should be selected in
7516: -- the base language
7517: SELECT name
7518: INTO x_order_type
7519: FROM OE_TRANSACTION_TYPES_TL
7520: WHERE TRANSACTION_TYPE_ID = l_order_type_id
7521: AND language = (select language_code from
7522: fnd_languages
7523: where installed_flag = 'B');

Line 7548: from oe_transaction_types_tl tl,

7544: into l_header_id
7545: from oe_order_headers
7546: where order_number = p_order_number AND
7547: order_type_id = (select tl.transaction_type_id
7548: from oe_transaction_types_tl tl,
7549: oe_transaction_types_all ta
7550: where ta.transaction_type_id =
7551: tl.transaction_type_id and
7552: tl.name = p_order_type and

Line 7923: FROM OE_TRANSACTION_TYPES_TL

7919: END IF;
7920:
7921: SELECT NAME
7922: INTO l_order_type
7923: FROM OE_TRANSACTION_TYPES_TL
7924: WHERE TRANSACTION_TYPE_ID = p_order_type_id
7925: AND language = (select language_code
7926: from fnd_languages
7927: where installed_flag = 'B');