DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.JTF_FM_REQUEST_HISTORY

Object Details
Object Name: JTF_FM_REQUEST_HISTORY
Object Type: VIEW
Owner: APPS
FND Design Data: ViewJTF.JTF_FM_REQUEST_HISTORY
Subobject Name:
Status: VALID

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.


Stores request history information


[View Source]

Columns
Name Datatype Length Mandatory Comments
OUTCOME_CODE VARCHAR2 (20)
Outcome code for the fulfillment request
SOURCE_CODE_ID NUMBER

Campaign field
SOURCE_CODE VARCHAR2 (100)
Campaign field
OBJECT_TYPE VARCHAR2 (30)
Campaign field
OBJECT_ID NUMBER

Campaign field
ORDER_ID NUMBER

Order Capture field
RESUBMIT_COUNT NUMBER

Number of times the request has been resubmitted
OUTCOME_DESC VARCHAR2 (2000)
Brief description of fulfillment request outcome
REQUEST CLOB (4000)
Actual Request Submitted to the Engine in XML format
SUBMIT_DT_TM DATE
Yes Request DateTimestamp
SERVER_ID NUMBER

Uniqie ID for the Server
TEMPLATE_ID NUMBER

Fulfillment template used in request
APP_INFO VARCHAR2 (240)
Requesting Application Information
GROUP_ID NUMBER

Group to which the requesting agent currently belongs
HIST_REQ_ID NUMBER
Yes Unique Fulfillment Request ID
USER_ID NUMBER (15)
Agent who generated the fulfillment request
PRIORITY NUMBER

The priority of the request
PROCESSED_DT_TM VARCHAR2 (240)
The date on which the request was handled
MESSAGE_ID RAW (16)
Unque Message ID of the request in AQ
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ORG_ID NUMBER (15)
Organization identifier
F_DELETEDFLAG VARCHAR2 (1)
Flag to indicate HTML components that the record has been deleted
OBJECT_VERSION_NUMBER NUMBER

Sequential number used for database locking control when using HTML as a user interface
REQUEST_TYPE VARCHAR2 (1)
Defines the type of Request. Introduced in 11.5.9 release. Records 'S' for Single, 'M' for mass, 'B' for batch and 'P' for physical.
PARENT_REQ_ID NUMBER

Parent Request Id. If this is a resubmitted request, this field holds the original request's request id.
TOTAL_JOBS NUMBER

Number of jobs (number of recipients)
MEDIA_TYPE VARCHAR2 (30)
Media Type for the request. Email, Fax, Printer, Physical.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OUTCOME_CODE
,      SOURCE_CODE_ID
,      SOURCE_CODE
,      OBJECT_TYPE
,      OBJECT_ID
,      ORDER_ID
,      RESUBMIT_COUNT
,      OUTCOME_DESC
,      REQUEST
,      SUBMIT_DT_TM
,      SERVER_ID
,      TEMPLATE_ID
,      APP_INFO
,      GROUP_ID
,      HIST_REQ_ID
,      USER_ID
,      PRIORITY
,      PROCESSED_DT_TM
,      MESSAGE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ORG_ID
,      F_DELETEDFLAG
,      OBJECT_VERSION_NUMBER
,      REQUEST_TYPE
,      PARENT_REQ_ID
,      TOTAL_JOBS
,      MEDIA_TYPE
FROM APPS.JTF_FM_REQUEST_HISTORY;

Dependencies

[top of page]

APPS.JTF_FM_REQUEST_HISTORY references the following:

SchemaAPPS
SynonymJTF_FM_REQUEST_HISTORY_ALL
APPS.JTF_FM_REQUEST_HISTORY is referenced by following:

SchemaAPPS
ViewAST_COLLTRL_HISTORY_V
ViewCS_SR_FULFIL_STATUS_V
ViewIEX_DUNNINGS_ACCT_BALI_V
ViewIEX_DUNNINGS_BALI_V
ViewIEX_DUNNINGS_PARTY_BALI_V
ViewIEX_PAYING_DUNNINGS_BALI_V
ViewIEX_TRX_DUNNINGS_BALI_V
ViewJTF_FM_CONTENT_HISTORY_V
Package BodyJTF_FM_HISTORY_UTIL_PVT - show dependent code
Package BodyJTF_FM_UTL_V - show dependent code
Package BodyJTF_REQUEST_HISTORY_PVT - show dependent code