[Home] [Help]
[Dependency Information]
Object Name: | JTF_FM_PROCESSED |
---|---|
Object Type: | TABLE |
Owner: | JTF |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
Table that stores information all the requests that have been processed
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SYS_IL0000243055C00009$$ | LOB | UNIQUE |
![]() |
|
JTF_FM_PROCESSED_N1 | NORMAL | NONUNIQUE |
![]() |
![]() |
JTF_FM_PROCESSED_U1 | NORMAL | NONUNIQUE |
![]() |
![]() ![]() |
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. |
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;
JTF.JTF_FM_PROCESSED does not reference any database object
JTF.JTF_FM_PROCESSED is referenced by following:
|
|
|