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')
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