AP Accounting Entries Not Transfered to GL SQL Query

select
head.accounting_date,
head.accounting_entry_status_code,
head.creation_date,
head.period_name,
head.doc_sequence_value,
head.doc_category_code,
line.accounting_class_code,
gcc.concatenated_segments

from 

xla_ae_headers head,
xla_ae_lines line,
fnd_application app,
gl_code_combinations_kfv gcc

where

head.ae_header_id=line.ae_header_id and
app.application_id=head.application_id and
gcc.code_combination_id=line.code_combination_id and
head.application_id=200 and
head.gl_transfer_status_code=nvl(:gl_transfer_status_code,'N')

No comments:

Post a Comment