----UPDATE------------1
CREATE TABLE AP_INVOICE_DISTRIBUTIONS_BAC
AS SELECT * FROM AP_INVOICE_DISTRIBUTIONS_ALL
WHERE INVOICE_ID IN (215563,215564)
AND ACCOUNTING_DATE=TO_DATE('2010-12-01','YYYY-MM-DD')
UPDATE AP_INVOICE_DISTRIBUTIONS_ALL
SET ACCOUNTING_DATE=TO_DATE('2009-12-01','YYYY-MM-DD')
,PERIOD_NAME='Dec-09'
WHERE INVOICE_ID IN (215563,215564)
AND ACCOUNTING_DATE=TO_DATE('2010-12-01','YYYY-MM-DD')
----UPDATE-------------2
create table accounting_event_backup as select * from ap_accounting_events_all
where org_id=102
and accounting_date=to_date('2010-12-01','yyyy-mm-dd')
order by creation_date desc
update ap_accounting_events_all
set ACCOUNTING_DATE=TO_DATE('2009-12-01','YYYY-MM-DD')
where org_id=102
and accounting_date=to_date('2010-12-01','yyyy-mm-dd')
----UPDATE------------3
create table ap_ae_headers_all_back as
select * from ap_ae_headers_all
where accounting_event_id in (258937,258936)
update ap_ae_headers_all
set ACCOUNTING_DATE=TO_DATE('2009-12-01','YYYY-MM-DD')
, PERIOD_NAME='Dec-09'
where accounting_event_id in (258937,258936)
-------------------传递GL,测试OK