how to do sql query Report Job ID(Report Job History)

Summary:

How to do sql query Report Job ID(Report Job History)

Content (please ensure you mask any confidential information):

Look like this Report Job ID is not Correct

(SELECT RP.VALUEFROM FUSION_ORA_ESS.REQUEST_PROPERTY_VIEW RPWHERE 1 = 1and RP.NAME = 'jobid'AND RP.REQUESTID = RH.REQUESTID)

Version (include the version you are using, if applicable):

select *
from (Select RH.REQUESTID,
RH.USERNAME,
RH.PRODUCT,
RH.PROCESSSTART + INTERVAL '8' HOUR as PROCESSSTART,
RH.PROCESSEND + INTERVAL '8' HOUR as PROCESSEND,
RH.SCHEDULED,
RH.COMPLETEDTIME + INTERVAL '8' HOUR as COMPLETEDTIME,
RH.EXECUTABLE_STATUS,
(SELECT RP.VALUE
FROM FUSION_ORA_ESS.REQUEST_PROPERTY_VIEW RP