يوجد بطئ فى التقرير ماهى الاسباب
وخصوصا لما اضع فى ال select DISTINCT

SELECT DISTINCT 

JOURNALS_REFERRALS.CATEGORIES_ID CATEGORIES_ID, 
JOURNALS_REFERRALS.DOCUMENT_NUMBER  DOCUMENT_NUMBER, 
JOURNALS_REFERRALS.USER_SERIAL USER_SERIAL, 
JOURNALS_REFERRALS.JOURNALS_DATE  JOURNALS_DATE, 
JOURNALS_REFERRALS.FINANCIAL_PERIODS_ID FINANCIAL_PERIODS_ID, 
JOURNAL_ENTRIES_REFERRALS.REFERRALS_ID  REFERRALS_TRN_ID,
JOURNAL_ENTRIES_REFERRALS.REFERRAL_ROLL_TYPE  REFERRAL_ROLL_TYPE_TRN,
JOURNAL_ENTRIES_REFERRALS.REFERALS_SUB_ID  REFERALS_SUB_TRN ,
JOURNAL_ENTRIES_REFERRALS.ACTUAL_DEBIT DBT_TRN , 
JOURNAL_ENTRIES_REFERRALS.ACTUAL_CREDIT CRD_TRN ,JOURNAL_ENTRIES_REFERRALS.DESCRIPTION
FROM  JOURNALS_REFERRALS,JOURNAL_ENTRIES_REFERRALS


 WHERE( JOURNAL_ENTRIES_REFERRALS.JOURNALS_ID = JOURNALS_REFERRALS.JOURNALS_ID )

 AND (JOURNALS_REFERRALS.JOURNALS_DATE >= NVL (:FRM_DAT_TRN , JOURNALS_REFERRALS.JOURNALS_DATE) OR (:FRM_DAT_TRN  IS NULL)) 
      AND (JOURNALS_REFERRALS.JOURNALS_DATE  <= NVL (:TO_DAT_TRN , JOURNALS_REFERRALS.JOURNALS_DATE  ) OR (:TO_DAT_TRN IS NULL)) 

AND   JOURNAL_ENTRIES_REFERRALS.SUBSIDIARIES_ID  = NVL (:SBD , JOURNAL_ENTRIES_REFERRALS.SUBSIDIARIES_ID ) OR ( :SBD IS NULL )

 AND (JOURNALS_REFERRALS.JOURNALS_DATE >= NVL (:FRM_DAT , JOURNALS_REFERRALS.JOURNALS_DATE) OR (:FRM_DAT  IS NULL)) 
      AND (JOURNALS_REFERRALS.JOURNALS_DATE  <= NVL (:TO_DAT , JOURNALS_REFERRALS.JOURNALS_DATE  ) OR (:TO_DAT IS NULL)) 



    AND (JOURNALS_REFERRALS.CATEGORIES_ID    >=  NVL (:FRM_CTG , JOURNALS_REFERRALS.CATEGORIES_ID) OR (:FRM_CTG  IS NULL    )) 
    AND ( JOURNALS_REFERRALS.CATEGORIES_ID    <=  NVL (:TO_CTG    , JOURNALS_REFERRALS.CATEGORIES_ID ) OR (:TO_CTG IS NULL))

بس مالله الرحمن الرحيم

اخى الكريم اولا تاكد من انة يوجد indexes على الحقول التى تعمل عليها مقارنة وثانيا انت كرر بعض الامور والتى هى

AND (JOURNALS_REFERRALS.JOURNALS_DATE <= NVL (:TO_DAT , JOURNALS_REFERRALS.JOURNALS_DATE ) OR (:TO_DAT IS NULL
لماذا هذا الكود فبامكانك ان تستخدم هذه الجملة فقط لتقلل الجهد المطلوب

and JOURNALS_REFERRALS.JOURNALS_DATE <= nvl(:to_date,JOURNALS_REFERRALS.JOURNALS_DATE )

ايضا تجنب اخى الكريم المقارنة مع ال null لانة يسبب مشاكل كبير ة انا مجرب

وشكرا