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
7553: ta.transaction_type_code = 'ORDER'