[Home] [Help] [Dependency Information]
Object Name: | JTF_FM_INT_REQUEST_HEADER |
---|---|
Object Type: | TABLE |
Owner: | JTF |
FND Design Data: | JTF.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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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;
JTF.JTF_FM_INT_REQUEST_HEADER does not reference any database object
JTF.JTF_FM_INT_REQUEST_HEADER is referenced by following:
|
|
|