Query to get GL Journal details in Fusion Cloud

on
Query to get GL Journal details in Fusion Cloud:

select   
  gjb.name BATCH_NAME,
  gjb.description BATCH_DESCRIPTION,
  to_char(gjh.ledger_id) "LEDGER_ID",
  gjh.period_name,
  gjs.user_je_source_name "USER_SOURCE_NAME",
  gjc.user_je_category_name "USER_CATEGORY_NAME",
  gjl.PERIOD_NAME,
  gjs.user_je_source_name,
  gjc.user_je_category_name,
  to_char(gcc.CHART_OF_ACCOUNTS_ID) CHART_OF_ACCOUNTS_ID,
 gjh.actual_flag "ACTUAL_FLAG",
  to_char(gcc.CODE_COMBINATION_ID) CODE_COMBINATION_ID,
  gcc.segment1,
  gcc.segment2 ,
  gcc.segment3 ,
  gcc.segment4 ,
  gcc.segment5 ,
  gcc.segment6,
  gcc.segment7,
gjl.currency_code,
  gjl.entered_dr ,
  gjl.entered_cr ,
  gjl.accounted_dr,
  gjl.accounted_cr,
  gjl.stat_amount,
  to_char(gjl.currency_conversion_date,'DD/MM/YYYY') currency_conversion_date,
  gjl.currency_conversion_type,
  gjl.currency_conversion_rate,
  gjl.status,
from gl_je_batches gjb,
  gl_je_headers gjh,
  gl_je_lines gjl ,
  gl_code_combinations gcc,
 gl_je_categories gjc,
 gl_je_sources gjs,
where 1=1
and gjb.je_batch_id       =gjh.je_batch_id
AND gjh.je_header_id        = gjl.je_header_id
AND gcc.code_combination_id = gjl.code_combination_id
and gjc.je_category_name=gjh.je_category
and gjs.je_source_name=gjh.je_source
and gjh.period_name=:PERIOD
order by gjh.je_header_id