CREATE OR REPLACE FUNCTION public.fn_admin_list_promotion_reasons()
 RETURNS TABLE(reason_id integer, label text, lang character varying, active boolean, sort_order integer)
 LANGUAGE sql
 STABLE
AS $function$
    SELECT reason_id, label, lang, active, sort_order
    FROM public.promotion_reasons
    ORDER BY lang, sort_order, reason_id;
$function$
;