GL Queries

 get the Events and their details-

select a.* , b.accounting_date,b.gl_transfer_date , b.PERIOD_NAME from apps.xla_events a, apps.xla_ae_headers b 

where  a.event_status_code='P'

--and event_Date like '%31-01-20%'

and a.event_id = b.event_id

and b.ledger_id in (2055,2115)

and b.PERIOD_NAME like 'FY2022-09'

order by event_Date desc;