Oracle Fusion Custom ESS Job Details Query

select  DISTINCT
erh.application, erh.product, erh.type,
erh.definition , erh.jobtype , frp.name PROPERTY_TYPE, frp.value PROPERTY_VALUE
from fusion.ESS_REQUEST_HISTORY erh , fusion.REQUEST_PROPERTY frp   
where 1=1
AND erh.definition like '%oracle/apps/ess/custom/%'
and erh.requestid = frp.requestid