SELECT
            A.ACCOUNT_NUMBER,
            ACS.ACCOUNT_ID,
            ACS.ACCOUNTSERVICE_ID,
            CA.CONTRAGENT_NAME,
            S.SERVICE_NAME,
            TO_CHAR(SE.SERVICEENTRY_DEBT,'FM9999990D90', 'NLS_NUMERIC_CHARACTERS = '',.''') AS SERVICEENTRY_DEBT,
            TO_CHAR(SE.SERVICEENTRY_DEBTPAID,'FM9999990D90', 'NLS_NUMERIC_CHARACTERS = '',.''') AS SERVICEENTRY_DEBTPAID,
            (TO_CHAR(SE.SERVICEENTRY_VOLUME,'FM9999990D90', 'NLS_NUMERIC_CHARACTERS = '',.''') || ' ' || SE.SERVICEENTRY_EDIZM) SERVICEENTRY_VOLUME,
            TO_CHAR(SE.SERVICEENTRY_ADDITSUM,'FM9999990D90', 'NLS_NUMERIC_CHARACTERS = '',.''') AS SERVICEENTRY_ADDITSUM,
            TO_CHAR(SE.SERVICEENTRY_PAYABLE,'FM9999990D90', 'NLS_NUMERIC_CHARACTERS = '',.''')  AS SERVICEENTRY_PAYABLE,
            SE.ACCOUNTSERVICE_ID,
            SE.SERVICEENTRY_MONTH,
            SE.SERVICEENTRY_YEAR,
            TO_CHAR(SE.SERVICEENTRY_TARIF,'FM9999990D90', 'NLS_NUMERIC_CHARACTERS = '',.''')AS TARIF,
            SE.SERVICEENTRY_EDIZM,


            CASE
              WHEN A.workgroup_id IN (1,4,5,6) THEN 0
              WHEN A.workgroup_id IN (2)
                AND S.service_code IN ('4202','4203','4204')
                AND EXISTS(
                  select 1
                  from accountservice acs1
                  inner join v_serviceentrycurr se1 on se1.accountservice_id = acs1.accountservice_id
                  left outer join service s1 on s1.service_id = acs1.service_id
                  where acs1.account_id = acs.account_id
                    and acs1.contragent_id = acs.contragent_id
                    and acs1.owner_id = acs.owner_id
                    and acs1.provider_id = acs.provider_id
                    and s1.service_code in ('100','200')
                )
                THEN 0
              ELSE 1
            END payavailable

      FROM v_serviceentrycurr SE
      INNER JOIN accountservice ACS ON ACS.accountservice_id=SE.accountservice_id
      INNER JOIN proguseraccount PA ON PA.account_id=ACS.account_id
        AND PA.proguser_id=:user_id
      LEFT OUTER JOIN CONTRAGENT CA ON CA.CONTRAGENT_ID = ACS.CONTRAGENT_ID
      LEFT OUTER JOIN SERVICE S ON S.SERVICE_ID = ACS.SERVICE_ID
      LEFT OUTER JOIN ACCOUNT A ON A.ACCOUNT_ID = ACS.ACCOUNT_ID
      WHERE SE.SERVICEENTRY_ID = :acs