VIEW: APPS.JTF_FM_STATUS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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