SELECT UNIQUE
    sr.SERV_NAME AS SERV_NAME,
    TRUNC(ssh.CRE_DATE) AS CRE_DATE,
    tp.TRPL_NAME AS TRPL_NAME,
    ph.MSISDN AS MSISDN,
    ssh.SUBS_ID AS SUBS_ID,
    ssh.SSTAT_ID AS SSTAT_ID,
    sst.SSTAT_NAME AS SSTAT_NAME
FROM
    SUBS_SERV_HISTORY ssh,
    SUBS_HISTORY sh,
    TARIFF_PLAN tp,
    SERVICE sr,
    SERV_STATUS sst,
    PHONE ph
WHERE
    ssh.SERV_ID IN (557)
    AND ssh.SSTAT_ID = 1
    AND sh.SUBS_ID = ssh.SUBS_ID
    AND sh.TRPL_ID = tp.TRPL_ID
    AND tp.TRPL_ID IN (207,208,209,210)
    AND sh.PHONE_ID = ph.PHONE_ID
    AND sr.SERV_ID = ssh.SERV_ID
    AND ssh.SSTAT_ID = sst.SSTAT_ID
    AND sh.STAT_ID = 1
    AND TRUNC(:REP_DATE) BETWEEN sh.STIME AND sh.ETIME - 1 / 86400
    AND TRUNC(:REP_DATE) BETWEEN ssh.STIME AND ssh.ETIME - 1 / 86400
--ORDER BY ssh.CRE_DATE, ph.MSISDN

SELECT beg_date + LEVEL - 1 AS DAY_MONTH
FROM   (SELECT TO_DATE('01.08.2020', 'dd.mm.yyyy') beg_date,
               TO_DATE('31.08.2020', 'dd.mm.yyyy') end_date
        FROM   dual)
CONNECT BY LEVEL <= end_date - beg_date + 1

SELECT * FROM
(SELECT UNIQUE
    --sr.SERV_NAME AS SERV_NAME,
    TRUNC(ssh.CRE_DATE) AS CRE_DATE,
    --tp.TRPL_NAME AS TRPL_NAME,
    ph.MSISDN AS MSISDN,
    ssh.SUBS_ID AS SUBS_ID,
    ssh.SSTAT_ID AS SSTAT_ID,
    sst.SSTAT_NAME AS SSTAT_NAME
FROM
    SUBS_SERV_HISTORY ssh,
    SUBS_HISTORY sh,
    TARIFF_PLAN tp,
    SERVICE sr,
    SERV_STATUS sst,
    PHONE ph
WHERE
    ssh.SERV_ID IN (557)
    AND ssh.SSTAT_ID = 1
    AND sh.SUBS_ID = ssh.SUBS_ID
    AND sh.TRPL_ID = tp.TRPL_ID
    AND tp.TRPL_ID IN (207,208,209,210)
    AND sh.PHONE_ID = ph.PHONE_ID
    AND ph.MSISDN = '7257840'
    AND sr.SERV_ID = ssh.SERV_ID
    AND ssh.SSTAT_ID = sst.SSTAT_ID
    AND sh.STAT_ID = 1
    AND ssh.CRE_DATE BETWEEN sh.STIME AND sh.ETIME - 1 / 86400
    --AND TRUNC(:REP_DATE) BETWEEN ssh.STIME AND ssh.ETIME - 1 / 86400
    ) r1
join
(select trunc(:rep_date +level) as dat from dual connect by level < 10) r2
on r2.dat = r1.CRE_DATE
ORDER BY r2.dat

SELECT
    ssh.CRE_DATE AS CRE_DATE,
    TRUNC(ssh.STIME) AS SSH_STIME,
    TRUNC(ssh.ETIME) AS SSH_ETIME,
    DECODE(TRUNC(ssh.ETIME),TO_DATE('31.12.2999','DD.MM.YYYY'),TRUNC(SYSDATE)-TRUNC(ssh.STIME),TRUNC(ssh.ETIME)-TRUNC(ssh.STIME)) AS KOL_DAYS,
    sr.SERV_NAME AS SERV_NAME,
    tp.TRPL_NAME AS TRPL_NAME,
    ssh.SUBS_ID AS SUBS_ID,
    ssh.SSTAT_ID AS SSTAT_ID,
    sst.SSTAT_NAME AS SSTAT_NAME
FROM
    SUBS_SERV_HISTORY ssh,
    SUBS_HISTORY sh,
    TARIFF_PLAN tp,
    SERVICE sr,
    SERV_STATUS sst,
    PHONE ph
WHERE
    ssh.SERV_ID IN (557)
    AND ssh.SSTAT_ID = 1
    AND sh.SUBS_ID = ssh.SUBS_ID
    AND sh.TRPL_ID = tp.TRPL_ID
    AND tp.TRPL_ID IN (207,208,209,210)
    AND sh.PHONE_ID = ph.PHONE_ID
    AND sr.SERV_ID = ssh.SERV_ID
    AND ssh.SSTAT_ID = sst.SSTAT_ID
    AND sh.STAT_ID = 1
    AND ssh.CRE_DATE BETWEEN sh.STIME AND sh.ETIME - 1 / 86400
    AND ssh.CRE_DATE >= TRUNC(:DATE1)
    AND ssh.CRE_DATE <= TRUNC(:DATE2) + 1 - 1 / 86400
ORDER BY ph.MSISDN, ssh.CRE_DATE