参考文档:What to Do When a GL Period is Opened by Mistake (Doc ID 1609071.1)
--收款调整
--未传送到总帐数据:
select count(*) from ar_adjustments_all
where posting_control_id = -3
and gl_date between to_date('2014-02-01', 'YYYY-MM-DD') and
to_date('2014-02-28', 'YYYY-MM-DD');
--应收发票
--未传送到总帐数据:
select count(*)
from ra_cust_trx_line_gl_dist_all
where posting_control_id = -3
and gl_date between to_date('2014-02-01', 'YYYY-MM-DD') and
to_date('2014-02-28', 'YYYY-MM-DD');
--收款
--未传送到总帐数据:
select count(*)
from ar_cash_receipt_history_all
where posting_control_id = -3
and gl_date between to_date('2014-02-01', 'YYYY-MM-DD') and
to_date('2014-02-28', 'YYYY-MM-DD');
--核销
--未传送到总帐数据:8
select count(*)