Oracle Fusion Custom ESS Job Details Query

by admin

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

Comments |0|

Legend *) Required fields are marked
**) You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>
Category: OracleSaaS