ESS Request History SQL - is it possible to extract Job Name?

Content

Hi,

Over time I've built up an SQL statement which has a DECODE statement to look up the definition value from the definition field of the request_history table.

This is a sample of the SQL:

select rh.requestid
, flv_state.meaning status
, to_char(rh.processstart, 'YYYY-MM-DD HH24:MI:SS') process_start
, to_char(rh.processend,   'YYYY-MM-DD HH24:MI:SS') process_end
, rh.definition full_definition
, decode(regexp_substr(rh.definition, '[^/]+', 1, length(regexp_replace(rh.definition, '[^/]', ''))), 'aaa','aaa'
                      , 'IBY_FD_FINAL_PMT_REGISTER',            'Payment File Register'
                      , 'IBY_FD_PAYMENT_FORMAT',                'Format Payment