AR Accounting Lines SQL Query

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.concatenated_segments Account,
l.accounted_dr,
l.accounted_cr

from 
xla_ae_headers h,
xla_ae_lines l,
gl_code_combinations_kfv c

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

No comments:

Post a Comment