Oracle Discoverer报表使用情况查询

SELECT AA.*,
       BB.*,
       CUX_TEST_PLAY.GET_DOC_USER(P_DOC_NAME => AA.DOC_NAME) 发起人
  FROM (SELECT DISTINCT L.DOC_NAME
          FROM (SELECT CASE
                         WHEN TRUNC(SYSDATE) BETWEEN FU.START_DATE AND
                              NVL(FU.END_DATE, TRUNC(SYSDATE)) THEN
                          FU.USER_NAME
                         ELSE
                          EEU.EU_USERNAME
                       END USER_NAME,
                       FU.DESCRIPTION,
                       ED.DOC_NAME
                  FROM EUL10.EUL5_EUL_USERS    EEU,
                       EUL10.EUL5_ACCESS_PRIVS EAP,
                       EUL10.EUL5_DOCUMENTS    ED,
                       FND_USER                FU
                 WHERE EAP.GD_DOC_ID = ED.DOC_ID
                   AND EAP.AP_EU_ID = EEU.EU_ID
                      --AND EEU.EU_ROLE_FLAG = 0 --用户
                   AND TO_CHAR(FU.USER_ID) = SUBSTR(EEU.EU_USERNAME, 2)
                UNION ALL
                SELECT CASE
                         WHEN TRUNC(SYSDATE) BETWEEN R.START_DATE AND
                              NVL(R.END_DATE, TRUNC(SYSDATE)) THEN
                          R.RESPONSIBILITY_NAME
                         ELSE
                          EEU.EU_USERNAME
                       END USER_NAME,
                       NULL DESCRIPTION,
                       ED.DOC_NAME
                  FROM EUL10.EUL5_EUL_USERS    EEU,
                       EUL10.EUL5_ACCESS_PRIVS EAP,
                       EUL10.EUL5_DOCUMENTS    ED,
                       FND_RESPONSIBILITY_VL   R
                 WHERE EAP.GD_DOC_ID = ED.DOC_ID
                   AND EAP.AP_EU_ID = EEU.EU_ID
                      --AND EEU.EU_ROLE_FLAG = 1 --职责
                   AND TO_CHAR(R.RESPONSIBILITY_ID) =
                       SUBSTR(EEU.EU_USERNAME,
                              2,
                              INSTR(EEU.EU_USERNAME, '#', 1, 2) - 2)
                   AND TO_CHAR(R.APPLICATION_ID) =
                       SUBSTR(EEU.EU_USERNAME,
                              INSTR(EEU.EU_USERNAME, '#', 1, 2) + 1)) L) AA,
       (SELECT QS_DOC_NAME, COUNT(1) 发起次数
          FROM EUL10.EUL5_QPP_STATS A
         WHERE 1 = 1
           AND A.QS_CREATED_DATE > SYSDATE - 180
           AND QS_DOC_NAME IS NOT NULL
           AND A.QS_DOC_OWNER = 'EUL_ADMIN'
         GROUP BY QS_DOC_NAME) BB
 WHERE 1 = 1
   AND AA.DOC_NAME LIKE '%账龄%'
   AND AA.DOC_NAME = BB.QS_DOC_NAME(+)