Shulou(Shulou.com)06/02 Report--

1. Close exception report during subledger period

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)

AND XE.EVENT_DATE TO_DATE ('2017-01-28,' YYYY-MM-DD')

AND APH.ACCOUNTING_DATE

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.