您好,登錄后才能下訂單哦!
1.子分類帳期間關(guān)閉例外報(bào)表
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 = 2029
AND XE.EVENT_STATUS_CODE <>'P'
AND XE.EVENT_DATE > TO_DATE('2017-01-28','YYYY-MM-DD')
AND XE.EVENT_DATE <= TO_DATE('2017-02-28','YYYY-MM-DD');
2.未入帳事務(wù)處理報(bào)表
(1)未入帳的發(fā)票
select * from ap_invoice_distributions_all aid where aid.posted_flag <> 'Y';
或者是未驗(yàn)證的發(fā)票
select * from ap_invoices_all ai where ai.invoice_id not in (select aid.invoice_id from ap_invoice_distributions_all aid)
(2) 未入帳的預(yù)付款發(fā)票
select * from ap_prepay_history_all aph where pah.posted_flag <> 'Y'
(3)未入帳的付款
SELECT *
FROM AP_PAYMENT_HISTORY_ALL APH
WHERE APH.ACCOUNTING_DATE > TO_DATE('2017-01-28', 'YYYY-MM-DD')
AND APH.ACCOUNTING_DATE <= TO_DATE('2017-02-28', 'YYYY-MM-DD')
AND APH.POSTED_FLAG <> 'Y'
AND APH.ORG_ID IN (SELECT HOU.ORGANIZATION_ID
FROM HR_OPERATING_UNITS HOU
WHERE HOU.SET_OF_BOOKS_ID = 2029)
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。