SQL Query to find Report Job History in ERP Cloud

/********************************************************* 
 *PURPOSE: SQL Query to find Report Job History          *
 *AUTHOR: Shailender Thallam 				 *
 *********************************************************/
 SELECT
         rh.requestid
       , rh.name
       , rh.definition
       , rh.processend
       , rh.processstart
       , rh.parentrequestid
       , rh.elapsedtime
       , rh.executable_status
       , rh.submitter
       , rh.jobtype
FROM
         fusion_ora_ess.request_history_view rh
WHERE
         rh.executable_status        = 'SUCCEEDED'
         AND rh.processend IS NOT NULL
         AND EXISTS
         (
                SELECT
                       1
                FROM
                       fusion_ora_ess.request_property_view rpw
                WHERE
                       rpw.requestid = rh.requestid
                       AND name      = 'report_url'
                       AND VALUE  LIKE '%DR AR Customer Master Site Report.xdo%'
         )
         AND EXISTS
         (
                SELECT
                       1
                FROM
                       fusion_ora_ess.request_property_view rpw
                WHERE
                       rpw.requestid = rh.requestid
                       AND name      = 'report_params'
                       AND VALUE  LIKE '%'
         )
ORDER BY
         requestid DESC
SQL Query to find Report Job History in ERP Cloud

For Further Reading
