src: |
  SELECT DISTINCT 'DT'::text || t_ghm_cout_patient_shs.ghm5_id::text AS oid,
      (t_ghm_cout_patient_shs.ghm5_code::text || ' '::text) || t_ghm_cout_patient_shs.ghm5_texte::text AS texte,
      t_ghm_cout_patient_shs.ghm5_code,
      '1'::text AS level,
      '9'::text || t_ghm_cout_patient_shs.ghm5_code::text AS tri
     FROM compta.t_ghm_cout_patient_shs
    WHERE (t_ghm_cout_patient_shs.oid IN ( SELECT p_oids.oid
             FROM compta.p_oids
            WHERE p_oids.code_table::text = 'ghm_cout_patient_shs'::text))
    ORDER BY '9'::text || t_ghm_cout_patient_shs.ghm5_code::text, 'DT'::text || t_ghm_cout_patient_shs.ghm5_id::text, (t_ghm_cout_patient_shs.ghm5_code::text || ' '::text) || t_ghm_cout_patient_shs.ghm5_texte::text, t_ghm_cout_patient_shs.ghm5_code, '1'::text;