SQL Query of Cash Management Accounting Details

select
h.je_category_name,
h.accounting_date,
h.accounting_entry_status_code,
h.description,
h.gl_transfer_status_code,
l.accounting_class_code,
l.description,
c.segment1||'-'||c.segment2||'-'||c.segment3||'-'||c.segment4||'-'||c.segment5||'-'||c.segment6||c.segment7 Account,
l.accounted_dr,
l.accounted_cr

from
xla_ae_headers h,
xla_ae_lines l,
gl_code_combinations c

where
h.application_id=260 and
h.ae_header_id=l.ae_header_id and
c.code_combination_id=l.code_combination_id