1.子分类帐期间关闭例外报表
SELECT *
FROM XLA_EVENTS XE
JOIN XLA.XLA_TRANSACTION_ENTITIES XTE
ON XE.ENTITY_ID = XTE.ENTITY_ID
WHERE XE.APPLICATION_ID = 200
AND XTE.LEDGER_ID = 2025
AND XE.EVENT_STATUS_CODE <>'P'
AND XE.EVENT_DATE >= TO_DATE('2021-09-01','YYYY-MM-DD')
AND XE.EVENT_DATE <= TO_DATE('2021-09-30','YYYY-MM-DD');
2.未入帐事务处理报表
(1)未入帐的发票
select * from ap_invoice_distributions_all aid where aid.posted_flag <> 'Y';
或者是未验证的发票
select * from ap_invoices_all ai where ai.invoice_id not in (select aid.invoice_id from ap_invoice_distributions_all aid)
(2) 未入帐的预付款发票
select * from ap_prepay_history_all aph where pah.posted_flag <> 'Y'<