View: JTF_FM_REQUEST_HISTORY

Product:	JTF - CRM Foundation
Description:	Stores request history information
Implementation/DBA Data:	APPS.JTF_FM_REQUEST_HISTORY

View Text

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

Columns