942: --Get the order type desc. Takes care of order type renaming.
943: BEGIN
944: select meaning
945: into l_order_type_desc 946: from mfg_lookups 947: where lookup_type = p_lookup_type
948: and lookup_code = p_order_type_code;
949:
950: return l_order_type_desc;