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

TABLE: JTF.JTF_FM_INT_REQUEST_HEADER

Object Details
Object Name: JTF_FM_INT_REQUEST_HEADER
Object Type: TABLE
Owner: JTF
FND Design Data: TableJTF.JTF_FM_INT_REQUEST_HEADER
Subobject Name:
Status: VALID


Table to hold the data for request in progress. This table stores the header level details about the request.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
REQUEST_ID NUMBER
Yes Request Identifier
GROUP_ID NUMBER

User Group Identifier
SERVER_ID NUMBER
Yes Server Identifier
SUBMIT_DT_TM DATE

Request Submitted time
PROCESSED_DT_TM VARCHAR2 (240)
Request completed time
PRIORITY NUMBER

Request priority
SOURCE_CODE_ID NUMBER

Identifier for the request originator. Example: Marketing source code
SOURCE_CODE VARCHAR2 (30)
Identifier for the request originator. Example: Marketing source code
OBJECT_ID NUMBER

Identifier for the request originator. Example: Marketing source code
OBJECT_TYPE VARCHAR2 (30)
Identifier for the request originator. Example: Marketing source code
OUTCOME_DESC VARCHAR2 (2000)
Request Status
USER_ID NUMBER

Requester Identifier
TEMPLATE_ID NUMBER

Content Identifier
LAST_UPDATE_DATE DATE

Standard who column
LAST_UPDATED_BY NUMBER

Standard who column
CREATION_DATE DATE

Standard who column
CREATED_BY NUMBER

Standard who column
LAST_UPDATE_LOGIN NUMBER

Standard who column
OBJECT_VERSION_NUMBER NUMBER

Standard column, used for row locking
NO_OF_PARAMETERS NUMBER

Number of request merge fields
EMAIL_FROM_ADDRESS VARCHAR2 (100)
From header value for emails generated for the request
EMAIL_REPLY_TO_ADDRESS VARCHAR2 (100)
Reply-to header value for emails generated for the request
SENDER_DISPLAY_NAME VARCHAR2 (100)
Display Name header value for emails generated for the request
SUBJECT VARCHAR2 (2000)
Subject header value for emails generated for the request
USER_HISTORY VARCHAR2 (30)
Interaction History flag
EMAIL_FORMAT VARCHAR2 (100)
Email Format. TEXT, HTML or BOTH
REQUEST_STATUS VARCHAR2 (30)
Request Status
PARAMETER1 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER2 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER3 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER4 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER5 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER6 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER7 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER8 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER9 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER10 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER11 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER12 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER13 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER14 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER15 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER16 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER17 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER18 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER19 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER20 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER21 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER22 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER23 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER24 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER25 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER26 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER27 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER28 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER29 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER30 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER31 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER32 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER33 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER34 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER35 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER36 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER37 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER38 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER39 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER40 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER41 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER42 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER43 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER44 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER45 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER46 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER47 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER48 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER49 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER50 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER51 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER52 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER53 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER54 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER55 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER56 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER57 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER58 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER59 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER60 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER61 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER62 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER63 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER64 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER65 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER66 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER67 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER68 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER69 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER70 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER71 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER72 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER73 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER74 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER75 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER76 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER77 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER78 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER79 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER80 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER81 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER82 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER83 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER84 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER85 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER86 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER87 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER88 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER89 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER90 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER91 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER92 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER93 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER94 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER95 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER96 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER97 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER98 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER99 VARCHAR2 (100)
Generic column to capture merge field name
PARAMETER100 VARCHAR2 (100)
Generic column to capture merge field name
Query Text

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


SELECT REQUEST_ID
,      GROUP_ID
,      SERVER_ID
,      SUBMIT_DT_TM
,      PROCESSED_DT_TM
,      PRIORITY
,      SOURCE_CODE_ID
,      SOURCE_CODE
,      OBJECT_ID
,      OBJECT_TYPE
,      OUTCOME_DESC
,      USER_ID
,      TEMPLATE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      NO_OF_PARAMETERS
,      EMAIL_FROM_ADDRESS
,      EMAIL_REPLY_TO_ADDRESS
,      SENDER_DISPLAY_NAME
,      SUBJECT
,      USER_HISTORY
,      EMAIL_FORMAT
,      REQUEST_STATUS
,      PARAMETER1
,      PARAMETER2
,      PARAMETER3
,      PARAMETER4
,      PARAMETER5
,      PARAMETER6
,      PARAMETER7
,      PARAMETER8
,      PARAMETER9
,      PARAMETER10
,      PARAMETER11
,      PARAMETER12
,      PARAMETER13
,      PARAMETER14
,      PARAMETER15
,      PARAMETER16
,      PARAMETER17
,      PARAMETER18
,      PARAMETER19
,      PARAMETER20
,      PARAMETER21
,      PARAMETER22
,      PARAMETER23
,      PARAMETER24
,      PARAMETER25
,      PARAMETER26
,      PARAMETER27
,      PARAMETER28
,      PARAMETER29
,      PARAMETER30
,      PARAMETER31
,      PARAMETER32
,      PARAMETER33
,      PARAMETER34
,      PARAMETER35
,      PARAMETER36
,      PARAMETER37
,      PARAMETER38
,      PARAMETER39
,      PARAMETER40
,      PARAMETER41
,      PARAMETER42
,      PARAMETER43
,      PARAMETER44
,      PARAMETER45
,      PARAMETER46
,      PARAMETER47
,      PARAMETER48
,      PARAMETER49
,      PARAMETER50
,      PARAMETER51
,      PARAMETER52
,      PARAMETER53
,      PARAMETER54
,      PARAMETER55
,      PARAMETER56
,      PARAMETER57
,      PARAMETER58
,      PARAMETER59
,      PARAMETER60
,      PARAMETER61
,      PARAMETER62
,      PARAMETER63
,      PARAMETER64
,      PARAMETER65
,      PARAMETER66
,      PARAMETER67
,      PARAMETER68
,      PARAMETER69
,      PARAMETER70
,      PARAMETER71
,      PARAMETER72
,      PARAMETER73
,      PARAMETER74
,      PARAMETER75
,      PARAMETER76
,      PARAMETER77
,      PARAMETER78
,      PARAMETER79
,      PARAMETER80
,      PARAMETER81
,      PARAMETER82
,      PARAMETER83
,      PARAMETER84
,      PARAMETER85
,      PARAMETER86
,      PARAMETER87
,      PARAMETER88
,      PARAMETER89
,      PARAMETER90
,      PARAMETER91
,      PARAMETER92
,      PARAMETER93
,      PARAMETER94
,      PARAMETER95
,      PARAMETER96
,      PARAMETER97
,      PARAMETER98
,      PARAMETER99
,      PARAMETER100
FROM JTF.JTF_FM_INT_REQUEST_HEADER;

Dependencies

[top of page]

JTF.JTF_FM_INT_REQUEST_HEADER does not reference any database object

JTF.JTF_FM_INT_REQUEST_HEADER is referenced by following:

SchemaJTF
ViewJTF_FM_INT_REQUEST_HEADER#