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

TABLE: JTF.JTF_FM_PROCESSED

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


Table that stores information all the requests that have been processed


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
SYS_IL0000243055C00009$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
JTF_FM_PROCESSED_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARTY_ID
JTF_FM_PROCESSED_U1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQUEST_ID
ColumnJOB
Columns
Name Datatype Length Mandatory Comments
REQUEST_ID NUMBER
Yes Unique request Identifier
JOB NUMBER
Yes Job Number or Batch
PARTY_ID NUMBER

Party Id is the recipient's party Id
PARTY_NAME VARCHAR2 (240)
Recipient party's name
EMAIL_ADDRESS VARCHAR2 (400)
Email address of the recipient
FAX_ADDRESS VARCHAR2 (400)
Fax address of th recipient
PRINT_ADDRESS VARCHAR2 (400)
Print Address of the recipient
OUTCOME_CODE VARCHAR2 (30) Yes Request outcome code
MERGE_XML BLOB (4000)
Request is stored as an XML blob
CREATED_BY NUMBER
Yes Created by
CREATION_DATE DATE
Yes Creation Date
LAST_UPDATED_BY NUMBER
Yes Last Updated by
LAST_UPDATE_DATE DATE
Yes Last Updated Date
LAST_UPDATE_LOGIN NUMBER

Last updated user's login Id
EMAIL_STATUS VARCHAR2 (15)
Status of the Email
COL1 VARCHAR2 (2000)
Generic column to capture merge field name
COL2 VARCHAR2 (2000)
Generic column to capture merge field name
COL3 VARCHAR2 (2000)
Generic column to capture merge field name
COL4 VARCHAR2 (2000)
Generic column to capture merge field name
COL5 VARCHAR2 (2000)
Generic column to capture merge field name
COL6 VARCHAR2 (2000)
Generic column to capture merge field name
COL7 VARCHAR2 (2000)
Generic column to capture merge field name
COL8 VARCHAR2 (2000)
Generic column to capture merge field name
COL9 VARCHAR2 (2000)
Generic column to capture merge field name
COL10 VARCHAR2 (2000)
Generic column to capture merge field name
COL11 VARCHAR2 (2000)
Generic column to capture merge field name
COL12 VARCHAR2 (2000)
Generic column to capture merge field name
COL13 VARCHAR2 (2000)
Generic column to capture merge field name
COL14 VARCHAR2 (2000)
Generic column to capture merge field name
COL15 VARCHAR2 (2000)
Generic column to capture merge field name
COL16 VARCHAR2 (2000)
Generic column to capture merge field name
COL17 VARCHAR2 (2000)
Generic column to capture merge field name
COL18 VARCHAR2 (2000)
Generic column to capture merge field name
COL19 VARCHAR2 (2000)
Generic column to capture merge field name
COL20 VARCHAR2 (2000)
Generic column to capture merge field name
COL21 VARCHAR2 (2000)
Generic column to capture merge field name
COL22 VARCHAR2 (2000)
Generic column to capture merge field name
COL23 VARCHAR2 (2000)
Generic column to capture merge field name
COL24 VARCHAR2 (2000)
Generic column to capture merge field name
COL25 VARCHAR2 (2000)
Generic column to capture merge field name
COL26 VARCHAR2 (2000)
Generic column to capture merge field name
COL27 VARCHAR2 (2000)
Generic column to capture merge field name
COL28 VARCHAR2 (2000)
Generic column to capture merge field name
COL29 VARCHAR2 (2000)
Generic column to capture merge field name
COL30 VARCHAR2 (2000)
Generic column to capture merge field name
COL31 VARCHAR2 (2000)
Generic column to capture merge field name
COL32 VARCHAR2 (2000)
Generic column to capture merge field name
COL33 VARCHAR2 (2000)
Generic column to capture merge field name
COL34 VARCHAR2 (2000)
Generic column to capture merge field name
COL35 VARCHAR2 (2000)
Generic column to capture merge field name
COL36 VARCHAR2 (2000)
Generic column to capture merge field name
COL37 VARCHAR2 (2000)
Generic column to capture merge field name
COL38 VARCHAR2 (2000)
Generic column to capture merge field name
COL39 VARCHAR2 (2000)
Generic column to capture merge field name
COL40 VARCHAR2 (2000)
Generic column to capture merge field name
COL41 VARCHAR2 (2000)
Generic column to capture merge field name
COL42 VARCHAR2 (2000)
Generic column to capture merge field name
COL43 VARCHAR2 (2000)
Generic column to capture merge field name
COL44 VARCHAR2 (2000)
Generic column to capture merge field name
COL45 VARCHAR2 (2000)
Generic column to capture merge field name
COL46 VARCHAR2 (2000)
Generic column to capture merge field name
COL47 VARCHAR2 (2000)
Generic column to capture merge field name
COL48 VARCHAR2 (2000)
Generic column to capture merge field name
COL49 VARCHAR2 (2000)
Generic column to capture merge field name
COL50 VARCHAR2 (2000)
Generic column to capture merge field name
COL51 VARCHAR2 (2000)
Generic column to capture merge field name
COL52 VARCHAR2 (2000)
Generic column to capture merge field name
COL53 VARCHAR2 (2000)
Generic column to capture merge field name
COL54 VARCHAR2 (2000)
Generic column to capture merge field name
COL55 VARCHAR2 (2000)
Generic column to capture merge field name
COL56 VARCHAR2 (2000)
Generic column to capture merge field name
COL57 VARCHAR2 (2000)
Generic column to capture merge field name
COL58 VARCHAR2 (2000)
Generic column to capture merge field name
COL59 VARCHAR2 (2000)
Generic column to capture merge field name
COL60 VARCHAR2 (2000)
Generic column to capture merge field name
COL61 VARCHAR2 (2000)
Generic column to capture merge field name
COL62 VARCHAR2 (2000)
Generic column to capture merge field name
COL63 VARCHAR2 (2000)
Generic column to capture merge field name
COL64 VARCHAR2 (2000)
Generic column to capture merge field name
COL65 VARCHAR2 (2000)
Generic column to capture merge field name
COL66 VARCHAR2 (2000)
Generic column to capture merge field name
COL67 VARCHAR2 (2000)
Generic column to capture merge field name
COL68 VARCHAR2 (2000)
Generic column to capture merge field name
COL69 VARCHAR2 (2000)
Generic column to capture merge field name
COL70 VARCHAR2 (2000)
Generic column to capture merge field name
COL71 VARCHAR2 (2000)
Generic column to capture merge field name
COL72 VARCHAR2 (2000)
Generic column to capture merge field name
COL73 VARCHAR2 (2000)
Generic column to capture merge field name
COL74 VARCHAR2 (2000)
Generic column to capture merge field name
COL75 VARCHAR2 (2000)
Generic column to capture merge field name
COL76 VARCHAR2 (2000)
Generic column to capture merge field name
COL77 VARCHAR2 (2000)
Generic column to capture merge field name
COL78 VARCHAR2 (2000)
Generic column to capture merge field name
COL79 VARCHAR2 (2000)
Generic column to capture merge field name
COL80 VARCHAR2 (2000)
Generic column to capture merge field name
COL81 VARCHAR2 (2000)
Generic column to capture merge field name
COL82 VARCHAR2 (2000)
Generic column to capture merge field name
COL83 VARCHAR2 (2000)
Generic column to capture merge field name
COL84 VARCHAR2 (2000)
Generic column to capture merge field name
COL85 VARCHAR2 (2000)
Generic column to capture merge field name
COL86 VARCHAR2 (2000)
Generic column to capture merge field name
COL87 VARCHAR2 (2000)
Generic column to capture merge field name
COL88 VARCHAR2 (2000)
Generic column to capture merge field name
COL89 VARCHAR2 (2000)
Generic column to capture merge field name
COL90 VARCHAR2 (2000)
Generic column to capture merge field name
COL91 VARCHAR2 (2000)
Generic column to capture merge field name
COL92 VARCHAR2 (2000)
Generic column to capture merge field name
COL93 VARCHAR2 (2000)
Generic column to capture merge field name
COL94 VARCHAR2 (2000)
Generic column to capture merge field name
COL95 VARCHAR2 (2000)
Generic column to capture merge field name
COL96 VARCHAR2 (2000)
Generic column to capture merge field name
COL97 VARCHAR2 (2000)
Generic column to capture merge field name
COL98 VARCHAR2 (2000)
Generic column to capture merge field name
COL99 VARCHAR2 (2000)
Generic column to capture merge field name
COL100 VARCHAR2 (2000)
Generic column to capture merge field name
PARTITION_ID VARCHAR2 (2000)
Column to capture information regarding the partition used to store this request.
Query Text

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


SELECT REQUEST_ID
,      JOB
,      PARTY_ID
,      PARTY_NAME
,      EMAIL_ADDRESS
,      FAX_ADDRESS
,      PRINT_ADDRESS
,      OUTCOME_CODE
,      MERGE_XML
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      EMAIL_STATUS
,      COL1
,      COL2
,      COL3
,      COL4
,      COL5
,      COL6
,      COL7
,      COL8
,      COL9
,      COL10
,      COL11
,      COL12
,      COL13
,      COL14
,      COL15
,      COL16
,      COL17
,      COL18
,      COL19
,      COL20
,      COL21
,      COL22
,      COL23
,      COL24
,      COL25
,      COL26
,      COL27
,      COL28
,      COL29
,      COL30
,      COL31
,      COL32
,      COL33
,      COL34
,      COL35
,      COL36
,      COL37
,      COL38
,      COL39
,      COL40
,      COL41
,      COL42
,      COL43
,      COL44
,      COL45
,      COL46
,      COL47
,      COL48
,      COL49
,      COL50
,      COL51
,      COL52
,      COL53
,      COL54
,      COL55
,      COL56
,      COL57
,      COL58
,      COL59
,      COL60
,      COL61
,      COL62
,      COL63
,      COL64
,      COL65
,      COL66
,      COL67
,      COL68
,      COL69
,      COL70
,      COL71
,      COL72
,      COL73
,      COL74
,      COL75
,      COL76
,      COL77
,      COL78
,      COL79
,      COL80
,      COL81
,      COL82
,      COL83
,      COL84
,      COL85
,      COL86
,      COL87
,      COL88
,      COL89
,      COL90
,      COL91
,      COL92
,      COL93
,      COL94
,      COL95
,      COL96
,      COL97
,      COL98
,      COL99
,      COL100
,      PARTITION_ID
FROM JTF.JTF_FM_PROCESSED;

Dependencies

[top of page]

JTF.JTF_FM_PROCESSED does not reference any database object

JTF.JTF_FM_PROCESSED is referenced by following:

SchemaJTF
ViewJTF_FM_PROCESSED#