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


VIEW: JTF.JTF_FM_INT_REQUEST_HEADER#

Object Details
Object Name: JTF_FM_INT_REQUEST_HEADER#
Object Type: VIEW
Owner: JTF
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
REQUEST_ID NUMBER
Yes
GROUP_ID NUMBER

SERVER_ID NUMBER
Yes
SUBMIT_DT_TM DATE

PROCESSED_DT_TM VARCHAR2 (240)
PRIORITY NUMBER

SOURCE_CODE_ID NUMBER

SOURCE_CODE VARCHAR2 (30)
OBJECT_ID NUMBER

OBJECT_TYPE VARCHAR2 (30)
OUTCOME_DESC VARCHAR2 (2000)
USER_ID NUMBER

TEMPLATE_ID NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

OBJECT_VERSION_NUMBER NUMBER

NO_OF_PARAMETERS NUMBER

EMAIL_FROM_ADDRESS VARCHAR2 (100)
EMAIL_REPLY_TO_ADDRESS VARCHAR2 (100)
SENDER_DISPLAY_NAME VARCHAR2 (100)
SUBJECT VARCHAR2 (2000)
USER_HISTORY VARCHAR2 (30)
EMAIL_FORMAT VARCHAR2 (100)
REQUEST_STATUS VARCHAR2 (30)
PARAMETER1 VARCHAR2 (100)
PARAMETER2 VARCHAR2 (100)
PARAMETER3 VARCHAR2 (100)
PARAMETER4 VARCHAR2 (100)
PARAMETER5 VARCHAR2 (100)
PARAMETER6 VARCHAR2 (100)
PARAMETER7 VARCHAR2 (100)
PARAMETER8 VARCHAR2 (100)
PARAMETER9 VARCHAR2 (100)
PARAMETER10 VARCHAR2 (100)
PARAMETER11 VARCHAR2 (100)
PARAMETER12 VARCHAR2 (100)
PARAMETER13 VARCHAR2 (100)
PARAMETER14 VARCHAR2 (100)
PARAMETER15 VARCHAR2 (100)
PARAMETER16 VARCHAR2 (100)
PARAMETER17 VARCHAR2 (100)
PARAMETER18 VARCHAR2 (100)
PARAMETER19 VARCHAR2 (100)
PARAMETER20 VARCHAR2 (100)
PARAMETER21 VARCHAR2 (100)
PARAMETER22 VARCHAR2 (100)
PARAMETER23 VARCHAR2 (100)
PARAMETER24 VARCHAR2 (100)
PARAMETER25 VARCHAR2 (100)
PARAMETER26 VARCHAR2 (100)
PARAMETER27 VARCHAR2 (100)
PARAMETER28 VARCHAR2 (100)
PARAMETER29 VARCHAR2 (100)
PARAMETER30 VARCHAR2 (100)
PARAMETER31 VARCHAR2 (100)
PARAMETER32 VARCHAR2 (100)
PARAMETER33 VARCHAR2 (100)
PARAMETER34 VARCHAR2 (100)
PARAMETER35 VARCHAR2 (100)
PARAMETER36 VARCHAR2 (100)
PARAMETER37 VARCHAR2 (100)
PARAMETER38 VARCHAR2 (100)
PARAMETER39 VARCHAR2 (100)
PARAMETER40 VARCHAR2 (100)
PARAMETER41 VARCHAR2 (100)
PARAMETER42 VARCHAR2 (100)
PARAMETER43 VARCHAR2 (100)
PARAMETER44 VARCHAR2 (100)
PARAMETER45 VARCHAR2 (100)
PARAMETER46 VARCHAR2 (100)
PARAMETER47 VARCHAR2 (100)
PARAMETER48 VARCHAR2 (100)
PARAMETER49 VARCHAR2 (100)
PARAMETER50 VARCHAR2 (100)
PARAMETER51 VARCHAR2 (100)
PARAMETER52 VARCHAR2 (100)
PARAMETER53 VARCHAR2 (100)
PARAMETER54 VARCHAR2 (100)
PARAMETER55 VARCHAR2 (100)
PARAMETER56 VARCHAR2 (100)
PARAMETER57 VARCHAR2 (100)
PARAMETER58 VARCHAR2 (100)
PARAMETER59 VARCHAR2 (100)
PARAMETER60 VARCHAR2 (100)
PARAMETER61 VARCHAR2 (100)
PARAMETER62 VARCHAR2 (100)
PARAMETER63 VARCHAR2 (100)
PARAMETER64 VARCHAR2 (100)
PARAMETER65 VARCHAR2 (100)
PARAMETER66 VARCHAR2 (100)
PARAMETER67 VARCHAR2 (100)
PARAMETER68 VARCHAR2 (100)
PARAMETER69 VARCHAR2 (100)
PARAMETER70 VARCHAR2 (100)
PARAMETER71 VARCHAR2 (100)
PARAMETER72 VARCHAR2 (100)
PARAMETER73 VARCHAR2 (100)
PARAMETER74 VARCHAR2 (100)
PARAMETER75 VARCHAR2 (100)
PARAMETER76 VARCHAR2 (100)
PARAMETER77 VARCHAR2 (100)
PARAMETER78 VARCHAR2 (100)
PARAMETER79 VARCHAR2 (100)
PARAMETER80 VARCHAR2 (100)
PARAMETER81 VARCHAR2 (100)
PARAMETER82 VARCHAR2 (100)
PARAMETER83 VARCHAR2 (100)
PARAMETER84 VARCHAR2 (100)
PARAMETER85 VARCHAR2 (100)
PARAMETER86 VARCHAR2 (100)
PARAMETER87 VARCHAR2 (100)
PARAMETER88 VARCHAR2 (100)
PARAMETER89 VARCHAR2 (100)
PARAMETER90 VARCHAR2 (100)
PARAMETER91 VARCHAR2 (100)
PARAMETER92 VARCHAR2 (100)
PARAMETER93 VARCHAR2 (100)
PARAMETER94 VARCHAR2 (100)
PARAMETER95 VARCHAR2 (100)
PARAMETER96 VARCHAR2 (100)
PARAMETER97 VARCHAR2 (100)
PARAMETER98 VARCHAR2 (100)
PARAMETER99 VARCHAR2 (100)
PARAMETER100 VARCHAR2 (100)
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# references the following:

SchemaJTF
TableJTF_FM_INT_REQUEST_HEADER
JTF.JTF_FM_INT_REQUEST_HEADER# is referenced by following:

SchemaAPPS
SynonymJTF_FM_INT_REQUEST_HEADER