VIEW: APPS.JTF_FM_REQUEST_HISTORY

Source

View Text - Preformatted

SELECT OUTCOME_CODE, SOURCE_CODE_ID, SOURCE_CODE , OBJECT_TYPE, OBJECT_ID, ORDER_ID, RESUBMIT_COUNT, OUTCOME_DESC, REQUEST, SUBMIT_DT_TM, SERVER_ID, TEMPLATE_ID, APP_INFO, GROUP_ID, HIST_REQ_ID, USER_ID, PRIORITY, DECODE(PROCESS_DT_TM, NULL, PROCESSED_DT_TM, TO_CHAR(PROCESS_DT_TM, 'YYYY-MM-DD HH24:MI:SS')) PROCESSED_DT_TM, MESSAGE_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, ORG_ID, F_DELETEDFLAG, OBJECT_VERSION_NUMBER, REQUEST_TYPE, PARENT_REQ_ID, TOTAL_JOBS, MEDIA_TYPE FROM JTF_FM_REQUEST_HISTORY_ALL

View Text - HTML Formatted

SELECT OUTCOME_CODE
, SOURCE_CODE_ID
, SOURCE_CODE
, OBJECT_TYPE
, OBJECT_ID
, ORDER_ID
, RESUBMIT_COUNT
, OUTCOME_DESC
, REQUEST
, SUBMIT_DT_TM
, SERVER_ID
, TEMPLATE_ID
, APP_INFO
, GROUP_ID
, HIST_REQ_ID
, USER_ID
, PRIORITY
, DECODE(PROCESS_DT_TM
, NULL
, PROCESSED_DT_TM
, TO_CHAR(PROCESS_DT_TM
, 'YYYY-MM-DD HH24:MI:SS')) PROCESSED_DT_TM
, MESSAGE_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, ORG_ID
, F_DELETEDFLAG
, OBJECT_VERSION_NUMBER
, REQUEST_TYPE
, PARENT_REQ_ID
, TOTAL_JOBS
, MEDIA_TYPE
FROM JTF_FM_REQUEST_HISTORY_ALL