AR-11i Receivables Exchange Gain or Loss Query

SELECT DISTINCT gl_je_journal_lines_v.period_name,gl_je_journal_lines_v.je_category,
gl_je_journal_lines_v.line_reference_1,
       gl_je_journal_lines_v.line_reference_2,
       TO_CHAR (NULL) third_party_name, TO_CHAR (NULL) third_party_number,
       je_source "Source", gl_je_journal_lines_v.SET_OF_BOOKS_ID "set_of_books_id" ,
          segment1
       || '-'
       || segment2
       || '-'
       || segment3
       || '-'
       || segment4
       || '-'
       || segment5
       || '-'
       || segment6
       || '-'
       || segment7
       || '-'
       || segment8 SEGMENT,
    
       gl_je_journal_lines_v.currency_code, line_entered_dr, line_entered_cr,
       line_accounted_dr ,line_accounted_cr
  ,gl_je_journal_lines_v.JE_HEADER_ID,--TO_NUMBER (NULL) je_header_id,
       LINE_JE_LINE_NUM,--TO_NUMBER (NULL) je_line_num,
    line_code_combination_id,
     gl_je_journal_lines_v.DOC_SEQUENCE_VALUE,
    HEADER_EFFECTIVE_DATE,--TO_DATE (NULL) gl_date,
       LINE_ATTRIBUTE1,--TO_CHAR (NULL) attribute1,
    LINE_ATTRIBUTE2,--TO_CHAR (NULL) attribute2,
       LINE_ATTRIBUTE3,--TO_CHAR (NULL) attribute3,
    LINE_DESCRIPTION description--TO_CHAR (NULL) description 
 
 FROM gl_je_journal_lines_v , gl_summary_combinations_v, gl_sets_of_books
WHERE gl_summary_combinations_v.code_combination_id = gl_je_journal_lines_v.line_code_combination_id
   AND actual_flag = 'A'
   AND batch_status || '' = 'P'
   AND gl_je_journal_lines_v.currency_code != 'STAT'
   AND gl_je_journal_lines_v.set_of_books_id =gl_sets_of_books.set_of_books_id
   AND gl_sets_of_books.mrc_sob_type_code = 'P'
   AND (    NVL (effective_period_num, 0) >= :cf_period_from
        AND (NVL (effective_period_num, 0) <= :cf_period_to)
       )
   AND (    NVL (segment1, 0) >= :p_org_from
        AND (NVL (segment1, 0) <= :p_org_to)
       )
   AND (    NVL (segment5, 0) >= :p_account_from
        AND (NVL (segment5, 0) <= :p_account_to)
       )
and gl_je_journal_lines_v.SET_OF_BOOKS_ID not in ( 1014,1015,1016 )
AND je_source='Receivables'