Asset 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=140
and h.ae_header_id=l.ae_header_id
and c.code_combination_id=l.code_combination_id