Tuesday, 7 July 2015

How to find OPM Batch Close Variance


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