View: JTF_FM_HIST_V

Product:	JTF - CRM Foundation
Description:	View to show detailed history of each fulfillment request
Implementation/DBA Data:	APPS.JTF_FM_HIST_V

View Text

SELECT CON.DOCUMENT_TYPE
, CON.MES_DOC_ID
, CON.CONTENT_NUMBER
, CON.CONTENT_TYPE
, CON.CONTENT_NAME
, CON.DESTINATION_ADDR
, CON.OUTPUT_ID
, CON.USER_NOTES
, CON.OUTCOME_CODE
, CON.OUTCOME_DESC
, CON.PARTY_ID
, CON.BATCH_NUMBER
, HIS.SOURCE_CODE_ID
, HIS.SOURCE_CODE
, HIS.OBJECT_TYPE
, HIS.OBJECT_ID
, HIS.ORDER_ID
, HIS.RESUBMIT_COUNT
, HIS.REQUEST
, HIS.SUBMIT_DT_TM
, HIS.SERVER_ID
, HIS.TEMPLATE_ID
, HIS.APP_INFO
, HIS.GROUP_ID
, HIS.HIST_REQ_ID
, HIS.USER_ID
, HIS.PRIORITY
, HIS.PROCESSED_DT_TM
, HIS.MESSAGE_ID
, HIS.ORG_ID
FROM JTF_FM_CONTENT_HISTORY CON
, JTF_FM_REQUEST_HISTORY_ALL HIS
WHERE HIS.HIST_REQ_ID = CON.HIST_REQ_ID
AND HIS.SUBMIT_DT_TM = CON.SUBMIT_DT_TM

Columns