FSG Last Used PLSQL Query - Oracle EBS R12

https://generalledger-gl.blogspot.com/2017/11/fsg-last-used.html

Query to Get FSG Last Used in Oracle EBS R12

select max(a.REQUEST_DATE) Last_Request_Date, c.REPORT_TITLE
  from FND_CONCURRENT_PROGRAMS_VL b,
       fnd_concurrent_requests    a,
       RG_REPORTS_V               c,
       fnd_user                   d --67156

 where a.CONCURRENT_PROGRAM_ID = b.CONCURRENT_PROGRAM_ID
     
   and a.PROGRAM_APPLICATION_ID = b.APPLICATION_ID
     
   and c.REPORT_ID = a.ARGUMENT7
     
   and d.USER_ID = a.REQUESTED_BY
     
      --and c.APPLICATION_ID=b.APPLICATION_ID
     
   and b.USER_CONCURRENT_PROGRAM_NAME like '%Program%Publish%FSG%'

 group by c.REPORT_TITLE

--order by a.REQUEST_DATE