[Home] [Help]
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
Name |
CON_DOCUMENT_TYPE |
CON_PARTY_ID |
CON_BATCH_NUMBER |
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 |
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 |