--
SELECT
STATE
, REQUESTID
, NAME
, EXECUTABLE_STATUS
, ERROR_WARNING_MESSAGE
, ERROR_WARNING_DETAIL
, cmdline
, workdirectoryroot
, logworkdirectory
, inputworkdirectory
, outputworkdirectory
, redirectedoutputfile
FROM
Fusion_ora_ess.request_history
WHERE
REQUESTID = 20780
ORDER BY
REQUESTID DESC