PO, OPM and INventory Period closure dates queries

1.  OPM -

SELECT LEGAL_ENTITY_ID, ps.PERIOD_code "Period Name" ,

  ps.START_DATE "Period Start Date" ,

  ps.END_DATE "Period End Date" ,ps.period_status,

   DECODE(ps.period_status,'C',(to_char(last_update_date ,'DD-MON-YYYY HH24:mm:ss')),null) "Period Close Date",

  DECODE(ps.period_status, 'O','O - Open' ,

                            'N','N - Never Opened' ,

                            'F','F - Future Enterable' ,

                            'C','C - Closed' ,'Unknown') "Period Status"

FROM apps.gmf_period_statuses ps

where (TRUNC(to_date('15-OCT-21'))  

  BETWEEN TRUNC(ps.start_date) AND TRUNC (ps.end_date));

2. Inventory -

SELECT ood.organization_id "Organization ID" ,

  ood.organization_code "Organization Code" ,

  ood.organization_name "Organization Name" ,

  oap.period_name "Period Name" ,

  oap.period_start_date "Start Date" ,

  to_char(oap.period_close_date,'DD-MON-YYYY hh24:mm:ss') "Closed Date" ,

  oap.schedule_close_date "Scheduled Close" ,

  DECODE(oap.open_flag, 'P','P - Period Close is processing' ,

                        'N','N - Period Close process is completed' ,

                        'Y','Y - Period is open if Closed Date is NULL' ,'Unknown') "Period Status"

FROM org_acct_periods oap ,

  org_organization_definitions ood

WHERE oap.organization_id = ood.organization_id

AND (TRUNC(to_date('01-SEP-21')) 

  BETWEEN TRUNC(oap.period_start_date) AND TRUNC (oap.schedule_close_date))

ORDER BY ood.organization_id,

  oap.period_start_date;