select SSS.*
  from (SELECT
               case
                 when A.N_MARKGTSTATE in (2, 5, 6) and :V_CLIENT_FLAG = 1 then
                  1
                 when :V_CLIENT_FLAG = 0 then
                  1
                 when A.N_MARKGTSTATE not in (2, 5, 6) and :V_CLIENT_FLAG = 1 then
                  0
                 when A.N_TEST = 1 and :V_CLIENT_FLAG = 1 then
                  0
               end IS_VIVIBLE,
               A.ID,
               A.D_DATEVISIT,
               TO_CHAR(A.D_DATEVISIT, 'DD.MM.YYYY') AS S_DATEVISIT,
               A.S_CITY,
               A.S_AREA,
               A.S_TL,
               .......
               A.S_WEEK,
               A.S_MONTH,
               A.N_YEAR,
               a.n_ttid
          FROM V_KIOSK_ANKETS A) SSS
 where sss.IS_VIVIBLE = 1
 order by SSS.D_DATEVISIT, SSS.S_CITY