VIEW: APPS.JTF_FM_HIST_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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