[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | JTF_FM_PROCESSED# |
|---|---|
| Object Type: | VIEW |
| Owner: | JTF |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| REQUEST_ID | NUMBER | Yes | ||
| JOB | NUMBER | Yes | ||
| PARTY_ID | NUMBER | |||
| PARTY_NAME | VARCHAR2 | (240) | ||
| EMAIL_ADDRESS | VARCHAR2 | (400) | ||
| FAX_ADDRESS | VARCHAR2 | (400) | ||
| PRINT_ADDRESS | VARCHAR2 | (400) | ||
| OUTCOME_CODE | VARCHAR2 | (30) | Yes | |
| MERGE_XML | BLOB | (4000) | ||
| CREATED_BY | NUMBER | Yes | ||
| CREATION_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | Yes | ||
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATE_LOGIN | NUMBER | |||
| EMAIL_STATUS | VARCHAR2 | (15) | ||
| COL1 | VARCHAR2 | (2000) | ||
| COL2 | VARCHAR2 | (2000) | ||
| COL3 | VARCHAR2 | (2000) | ||
| COL4 | VARCHAR2 | (2000) | ||
| COL5 | VARCHAR2 | (2000) | ||
| COL6 | VARCHAR2 | (2000) | ||
| COL7 | VARCHAR2 | (2000) | ||
| COL8 | VARCHAR2 | (2000) | ||
| COL9 | VARCHAR2 | (2000) | ||
| COL10 | VARCHAR2 | (2000) | ||
| COL11 | VARCHAR2 | (2000) | ||
| COL12 | VARCHAR2 | (2000) | ||
| COL13 | VARCHAR2 | (2000) | ||
| COL14 | VARCHAR2 | (2000) | ||
| COL15 | VARCHAR2 | (2000) | ||
| COL16 | VARCHAR2 | (2000) | ||
| COL17 | VARCHAR2 | (2000) | ||
| COL18 | VARCHAR2 | (2000) | ||
| COL19 | VARCHAR2 | (2000) | ||
| COL20 | VARCHAR2 | (2000) | ||
| COL21 | VARCHAR2 | (2000) | ||
| COL22 | VARCHAR2 | (2000) | ||
| COL23 | VARCHAR2 | (2000) | ||
| COL24 | VARCHAR2 | (2000) | ||
| COL25 | VARCHAR2 | (2000) | ||
| COL26 | VARCHAR2 | (2000) | ||
| COL27 | VARCHAR2 | (2000) | ||
| COL28 | VARCHAR2 | (2000) | ||
| COL29 | VARCHAR2 | (2000) | ||
| COL30 | VARCHAR2 | (2000) | ||
| COL31 | VARCHAR2 | (2000) | ||
| COL32 | VARCHAR2 | (2000) | ||
| COL33 | VARCHAR2 | (2000) | ||
| COL34 | VARCHAR2 | (2000) | ||
| COL35 | VARCHAR2 | (2000) | ||
| COL36 | VARCHAR2 | (2000) | ||
| COL37 | VARCHAR2 | (2000) | ||
| COL38 | VARCHAR2 | (2000) | ||
| COL39 | VARCHAR2 | (2000) | ||
| COL40 | VARCHAR2 | (2000) | ||
| COL41 | VARCHAR2 | (2000) | ||
| COL42 | VARCHAR2 | (2000) | ||
| COL43 | VARCHAR2 | (2000) | ||
| COL44 | VARCHAR2 | (2000) | ||
| COL45 | VARCHAR2 | (2000) | ||
| COL46 | VARCHAR2 | (2000) | ||
| COL47 | VARCHAR2 | (2000) | ||
| COL48 | VARCHAR2 | (2000) | ||
| COL49 | VARCHAR2 | (2000) | ||
| COL50 | VARCHAR2 | (2000) | ||
| COL51 | VARCHAR2 | (2000) | ||
| COL52 | VARCHAR2 | (2000) | ||
| COL53 | VARCHAR2 | (2000) | ||
| COL54 | VARCHAR2 | (2000) | ||
| COL55 | VARCHAR2 | (2000) | ||
| COL56 | VARCHAR2 | (2000) | ||
| COL57 | VARCHAR2 | (2000) | ||
| COL58 | VARCHAR2 | (2000) | ||
| COL59 | VARCHAR2 | (2000) | ||
| COL60 | VARCHAR2 | (2000) | ||
| COL61 | VARCHAR2 | (2000) | ||
| COL62 | VARCHAR2 | (2000) | ||
| COL63 | VARCHAR2 | (2000) | ||
| COL64 | VARCHAR2 | (2000) | ||
| COL65 | VARCHAR2 | (2000) | ||
| COL66 | VARCHAR2 | (2000) | ||
| COL67 | VARCHAR2 | (2000) | ||
| COL68 | VARCHAR2 | (2000) | ||
| COL69 | VARCHAR2 | (2000) | ||
| COL70 | VARCHAR2 | (2000) | ||
| COL71 | VARCHAR2 | (2000) | ||
| COL72 | VARCHAR2 | (2000) | ||
| COL73 | VARCHAR2 | (2000) | ||
| COL74 | VARCHAR2 | (2000) | ||
| COL75 | VARCHAR2 | (2000) | ||
| COL76 | VARCHAR2 | (2000) | ||
| COL77 | VARCHAR2 | (2000) | ||
| COL78 | VARCHAR2 | (2000) | ||
| COL79 | VARCHAR2 | (2000) | ||
| COL80 | VARCHAR2 | (2000) | ||
| COL81 | VARCHAR2 | (2000) | ||
| COL82 | VARCHAR2 | (2000) | ||
| COL83 | VARCHAR2 | (2000) | ||
| COL84 | VARCHAR2 | (2000) | ||
| COL85 | VARCHAR2 | (2000) | ||
| COL86 | VARCHAR2 | (2000) | ||
| COL87 | VARCHAR2 | (2000) | ||
| COL88 | VARCHAR2 | (2000) | ||
| COL89 | VARCHAR2 | (2000) | ||
| COL90 | VARCHAR2 | (2000) | ||
| COL91 | VARCHAR2 | (2000) | ||
| COL92 | VARCHAR2 | (2000) | ||
| COL93 | VARCHAR2 | (2000) | ||
| COL94 | VARCHAR2 | (2000) | ||
| COL95 | VARCHAR2 | (2000) | ||
| COL96 | VARCHAR2 | (2000) | ||
| COL97 | VARCHAR2 | (2000) | ||
| COL98 | VARCHAR2 | (2000) | ||
| COL99 | VARCHAR2 | (2000) | ||
| COL100 | VARCHAR2 | (2000) | ||
| PARTITION_ID | VARCHAR2 | (2000) |
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
APPS
JTF_FM_PROCESSED
|
|
|
|