View: JTF_FM_STATUS

Product:	JTF - CRM Foundation
Description:	stores information about the fulfillment status for requests
Implementation/DBA Data:	APPS.JTF_FM_STATUS

View Text

SELECT A.ORDER_ID
, A. SOURCE_CODE_ID
, A.SOURCE_CODE
, A. OBJECT_TYPE
, A. OBJECT_ID
, A. REQUEST_ID
, A.REQUEST_STATUS
, A.REQUEST_MODE
, A. REQUEUE_COUNT
, A. SUBMIT_DT_TM
, A. SERVER_ID
, A. TEMPLATE_ID
, A. USER_ID
, A. GROUP_ID
, A.PRIORITY
, A.MESSAGE_ID
, A. LAST_UPDATE_DATE
, A. LAST_UPDATED_BY
, A.CREATION_DATE
, A. CREATED_BY
, A.LAST_UPDATE_LOGIN
, A.ORG_ID
, A. ATTRIBUTE1
, A.ATTRIBUTE2
, A.ATTRIBUTE3
, A.ATTRIBUTE4
, A.ATTRIBUTE5
, A. ATTRIBUTE6
, A. ATTRIBUTE7
, A.ATTRIBUTE8
, A.ATTRIBUTE9
, A. ATTRIBUTE10
, A.ATTRIBUTE11
, A.ATTRIBUTE12
, A.ATTRIBUTE13
, A. ATTRIBUTE14
, A. ATTRIBUTE15
, A. F_DELETEDFLAG
, A.OBJECT_VERSION_NUMBER
, B.TOTAL_JOBS
, A. JOBS_PROCESSED
, B.PARENT_REQ_ID
, B.REQUEST_TYPE
, B.MEDIA_TYPE
FROM JTF_FM_STATUS_ALL A
, JTF_FM_REQUEST_HISTORY_ALL B
WHERE A.REQUEST_ID = B.HIST_REQ_ID

Columns