Batch Close Variance Checking Code
Select aa.ENTERED_AMOUNT,aa.* from gmf_xla_extract_lines aa
where journal_line_type ='CLS'
and event_id in(select event_id from gmf_xla_extract_headers
where transaction_date >='01-SEP-2014'
and transaction_date <='30-SEP-2015');
No comments:
Post a Comment