[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | HZ_STAGED_CONTACT_POINTS# |
|---|---|
| Object Type: | VIEW |
| Owner: | AR |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PARTY_ID | NUMBER | (15) | ||
| CONTACT_POINT_ID | NUMBER | (15) | ||
| CONTACT_POINT_TYPE | VARCHAR2 | (30) | ||
| TX1 | VARCHAR2 | (2000) | ||
| TX2 | VARCHAR2 | (2000) | ||
| TX3 | VARCHAR2 | (2000) | ||
| TX4 | VARCHAR2 | (2000) | ||
| TX5 | VARCHAR2 | (2000) | ||
| TX6 | VARCHAR2 | (2000) | ||
| TX7 | VARCHAR2 | (2000) | ||
| TX8 | VARCHAR2 | (2000) | ||
| TX9 | VARCHAR2 | (2000) | ||
| TX10 | VARCHAR2 | (2000) | ||
| TX11 | VARCHAR2 | (2000) | ||
| TX12 | VARCHAR2 | (2000) | ||
| TX13 | VARCHAR2 | (2000) | ||
| TX14 | VARCHAR2 | (2000) | ||
| TX15 | VARCHAR2 | (2000) | ||
| TX16 | VARCHAR2 | (2000) | ||
| TX17 | VARCHAR2 | (2000) | ||
| TX18 | VARCHAR2 | (2000) | ||
| TX19 | VARCHAR2 | (2000) | ||
| TX20 | VARCHAR2 | (2000) | ||
| TX21 | VARCHAR2 | (2000) | ||
| TX22 | VARCHAR2 | (2000) | ||
| TX23 | VARCHAR2 | (2000) | ||
| TX24 | VARCHAR2 | (2000) | ||
| TX25 | VARCHAR2 | (2000) | ||
| TX26 | VARCHAR2 | (2000) | ||
| TX27 | VARCHAR2 | (2000) | ||
| TX28 | VARCHAR2 | (2000) | ||
| TX29 | VARCHAR2 | (2000) | ||
| TX30 | VARCHAR2 | (2000) | ||
| TX31 | VARCHAR2 | (2000) | ||
| TX32 | VARCHAR2 | (2000) | ||
| TX33 | VARCHAR2 | (2000) | ||
| TX34 | VARCHAR2 | (2000) | ||
| TX35 | VARCHAR2 | (2000) | ||
| TX36 | VARCHAR2 | (2000) | ||
| TX37 | VARCHAR2 | (2000) | ||
| TX38 | VARCHAR2 | (2000) | ||
| TX39 | VARCHAR2 | (2000) | ||
| TX40 | VARCHAR2 | (2000) | ||
| TX41 | VARCHAR2 | (2000) | ||
| TX42 | VARCHAR2 | (2000) | ||
| TX43 | VARCHAR2 | (2000) | ||
| TX44 | VARCHAR2 | (2000) | ||
| TX45 | VARCHAR2 | (2000) | ||
| TX46 | VARCHAR2 | (2000) | ||
| TX47 | VARCHAR2 | (2000) | ||
| TX48 | VARCHAR2 | (2000) | ||
| TX49 | VARCHAR2 | (2000) | ||
| TX50 | VARCHAR2 | (2000) | ||
| TX51 | VARCHAR2 | (2000) | ||
| TX52 | VARCHAR2 | (2000) | ||
| TX53 | VARCHAR2 | (2000) | ||
| TX54 | VARCHAR2 | (2000) | ||
| TX55 | VARCHAR2 | (2000) | ||
| TX56 | VARCHAR2 | (2000) | ||
| TX57 | VARCHAR2 | (2000) | ||
| TX58 | VARCHAR2 | (2000) | ||
| TX59 | VARCHAR2 | (2000) | ||
| TX60 | VARCHAR2 | (2000) | ||
| TX61 | VARCHAR2 | (2000) | ||
| TX62 | VARCHAR2 | (2000) | ||
| TX63 | VARCHAR2 | (2000) | ||
| TX64 | VARCHAR2 | (2000) | ||
| TX65 | VARCHAR2 | (2000) | ||
| TX66 | VARCHAR2 | (2000) | ||
| TX67 | VARCHAR2 | (2000) | ||
| TX68 | VARCHAR2 | (2000) | ||
| TX69 | VARCHAR2 | (2000) | ||
| TX70 | VARCHAR2 | (2000) | ||
| TX71 | VARCHAR2 | (2000) | ||
| TX72 | VARCHAR2 | (2000) | ||
| TX73 | VARCHAR2 | (2000) | ||
| TX74 | VARCHAR2 | (2000) | ||
| TX75 | VARCHAR2 | (2000) | ||
| TX76 | VARCHAR2 | (2000) | ||
| TX77 | VARCHAR2 | (2000) | ||
| TX78 | VARCHAR2 | (2000) | ||
| TX79 | VARCHAR2 | (2000) | ||
| TX80 | VARCHAR2 | (2000) | ||
| TX81 | VARCHAR2 | (2000) | ||
| TX82 | VARCHAR2 | (2000) | ||
| TX83 | VARCHAR2 | (2000) | ||
| TX84 | VARCHAR2 | (2000) | ||
| TX85 | VARCHAR2 | (2000) | ||
| TX86 | VARCHAR2 | (2000) | ||
| TX87 | VARCHAR2 | (2000) | ||
| TX88 | VARCHAR2 | (2000) | ||
| TX89 | VARCHAR2 | (2000) | ||
| TX90 | VARCHAR2 | (2000) | ||
| TX91 | VARCHAR2 | (2000) | ||
| TX92 | VARCHAR2 | (2000) | ||
| TX93 | VARCHAR2 | (2000) | ||
| TX94 | VARCHAR2 | (2000) | ||
| TX95 | VARCHAR2 | (2000) | ||
| TX96 | VARCHAR2 | (2000) | ||
| TX97 | VARCHAR2 | (2000) | ||
| TX98 | VARCHAR2 | (2000) | ||
| TX99 | VARCHAR2 | (2000) | ||
| TX100 | VARCHAR2 | (2000) | ||
| TX101 | VARCHAR2 | (2000) | ||
| TX102 | VARCHAR2 | (2000) | ||
| TX103 | VARCHAR2 | (2000) | ||
| TX104 | VARCHAR2 | (2000) | ||
| TX105 | VARCHAR2 | (2000) | ||
| TX106 | VARCHAR2 | (2000) | ||
| TX107 | VARCHAR2 | (2000) | ||
| TX108 | VARCHAR2 | (2000) | ||
| TX109 | VARCHAR2 | (2000) | ||
| TX110 | VARCHAR2 | (2000) | ||
| TX111 | VARCHAR2 | (2000) | ||
| TX112 | VARCHAR2 | (2000) | ||
| TX113 | VARCHAR2 | (2000) | ||
| TX114 | VARCHAR2 | (2000) | ||
| TX115 | VARCHAR2 | (2000) | ||
| TX116 | VARCHAR2 | (2000) | ||
| TX117 | VARCHAR2 | (2000) | ||
| TX118 | VARCHAR2 | (2000) | ||
| TX119 | VARCHAR2 | (2000) | ||
| TX120 | VARCHAR2 | (2000) | ||
| TX121 | VARCHAR2 | (2000) | ||
| TX122 | VARCHAR2 | (2000) | ||
| TX123 | VARCHAR2 | (2000) | ||
| TX124 | VARCHAR2 | (2000) | ||
| TX125 | VARCHAR2 | (2000) | ||
| TX126 | VARCHAR2 | (2000) | ||
| TX127 | VARCHAR2 | (2000) | ||
| TX128 | VARCHAR2 | (2000) | ||
| TX129 | VARCHAR2 | (2000) | ||
| TX130 | VARCHAR2 | (2000) | ||
| TX131 | VARCHAR2 | (2000) | ||
| TX132 | VARCHAR2 | (2000) | ||
| TX133 | VARCHAR2 | (2000) | ||
| TX134 | VARCHAR2 | (2000) | ||
| TX135 | VARCHAR2 | (2000) | ||
| TX136 | VARCHAR2 | (2000) | ||
| TX137 | VARCHAR2 | (2000) | ||
| TX138 | VARCHAR2 | (2000) | ||
| TX139 | VARCHAR2 | (2000) | ||
| TX140 | VARCHAR2 | (2000) | ||
| TX141 | VARCHAR2 | (2000) | ||
| TX142 | VARCHAR2 | (2000) | ||
| TX143 | VARCHAR2 | (2000) | ||
| TX144 | VARCHAR2 | (2000) | ||
| TX145 | VARCHAR2 | (2000) | ||
| TX146 | VARCHAR2 | (2000) | ||
| TX147 | VARCHAR2 | (2000) | ||
| TX148 | VARCHAR2 | (2000) | ||
| TX149 | VARCHAR2 | (2000) | ||
| TX150 | VARCHAR2 | (2000) | ||
| TX151 | VARCHAR2 | (2000) | ||
| TX152 | VARCHAR2 | (2000) | ||
| TX153 | VARCHAR2 | (2000) | ||
| TX154 | VARCHAR2 | (2000) | ||
| TX155 | VARCHAR2 | (2000) | ||
| TX156 | VARCHAR2 | (2000) | ||
| TX157 | VARCHAR2 | (2000) | ||
| TX158 | VARCHAR2 | (2000) | ||
| TX159 | VARCHAR2 | (2000) | ||
| TX160 | VARCHAR2 | (2000) | ||
| TX161 | VARCHAR2 | (2000) | ||
| TX162 | VARCHAR2 | (2000) | ||
| TX163 | VARCHAR2 | (2000) | ||
| TX164 | VARCHAR2 | (2000) | ||
| TX165 | VARCHAR2 | (2000) | ||
| TX166 | VARCHAR2 | (2000) | ||
| TX167 | VARCHAR2 | (2000) | ||
| TX168 | VARCHAR2 | (2000) | ||
| TX169 | VARCHAR2 | (2000) | ||
| TX170 | VARCHAR2 | (2000) | ||
| TX171 | VARCHAR2 | (2000) | ||
| TX172 | VARCHAR2 | (2000) | ||
| TX173 | VARCHAR2 | (2000) | ||
| TX174 | VARCHAR2 | (2000) | ||
| TX175 | VARCHAR2 | (2000) | ||
| TX176 | VARCHAR2 | (2000) | ||
| TX177 | VARCHAR2 | (2000) | ||
| TX178 | VARCHAR2 | (2000) | ||
| TX179 | VARCHAR2 | (2000) | ||
| TX180 | VARCHAR2 | (2000) | ||
| TX181 | VARCHAR2 | (2000) | ||
| TX182 | VARCHAR2 | (2000) | ||
| TX183 | VARCHAR2 | (2000) | ||
| TX184 | VARCHAR2 | (2000) | ||
| TX185 | VARCHAR2 | (2000) | ||
| TX186 | VARCHAR2 | (2000) | ||
| TX187 | VARCHAR2 | (2000) | ||
| TX188 | VARCHAR2 | (2000) | ||
| TX189 | VARCHAR2 | (2000) | ||
| TX190 | VARCHAR2 | (2000) | ||
| TX191 | VARCHAR2 | (2000) | ||
| TX192 | VARCHAR2 | (2000) | ||
| TX193 | VARCHAR2 | (2000) | ||
| TX194 | VARCHAR2 | (2000) | ||
| TX195 | VARCHAR2 | (2000) | ||
| TX196 | VARCHAR2 | (2000) | ||
| TX197 | VARCHAR2 | (2000) | ||
| TX198 | VARCHAR2 | (2000) | ||
| TX199 | VARCHAR2 | (2000) | ||
| TX200 | VARCHAR2 | (2000) | ||
| TX201 | VARCHAR2 | (2000) | ||
| TX202 | VARCHAR2 | (2000) | ||
| TX203 | VARCHAR2 | (2000) | ||
| TX204 | VARCHAR2 | (2000) | ||
| TX205 | VARCHAR2 | (2000) | ||
| TX206 | VARCHAR2 | (2000) | ||
| TX207 | VARCHAR2 | (2000) | ||
| TX208 | VARCHAR2 | (2000) | ||
| TX209 | VARCHAR2 | (2000) | ||
| TX210 | VARCHAR2 | (2000) | ||
| TX211 | VARCHAR2 | (2000) | ||
| TX212 | VARCHAR2 | (2000) | ||
| TX213 | VARCHAR2 | (2000) | ||
| TX214 | VARCHAR2 | (2000) | ||
| TX215 | VARCHAR2 | (2000) | ||
| TX216 | VARCHAR2 | (2000) | ||
| TX217 | VARCHAR2 | (2000) | ||
| TX218 | VARCHAR2 | (2000) | ||
| TX219 | VARCHAR2 | (2000) | ||
| TX220 | VARCHAR2 | (2000) | ||
| TX221 | VARCHAR2 | (2000) | ||
| TX222 | VARCHAR2 | (2000) | ||
| TX223 | VARCHAR2 | (2000) | ||
| TX224 | VARCHAR2 | (2000) | ||
| TX225 | VARCHAR2 | (2000) | ||
| TX226 | VARCHAR2 | (2000) | ||
| TX227 | VARCHAR2 | (2000) | ||
| TX228 | VARCHAR2 | (2000) | ||
| TX229 | VARCHAR2 | (2000) | ||
| TX230 | VARCHAR2 | (2000) | ||
| TX231 | VARCHAR2 | (2000) | ||
| TX232 | VARCHAR2 | (2000) | ||
| TX233 | VARCHAR2 | (2000) | ||
| TX234 | VARCHAR2 | (2000) | ||
| TX235 | VARCHAR2 | (2000) | ||
| TX236 | VARCHAR2 | (2000) | ||
| TX237 | VARCHAR2 | (2000) | ||
| TX238 | VARCHAR2 | (2000) | ||
| TX239 | VARCHAR2 | (2000) | ||
| TX240 | VARCHAR2 | (2000) | ||
| TX241 | VARCHAR2 | (2000) | ||
| TX242 | VARCHAR2 | (2000) | ||
| TX243 | VARCHAR2 | (2000) | ||
| TX244 | VARCHAR2 | (2000) | ||
| TX245 | VARCHAR2 | (2000) | ||
| TX246 | VARCHAR2 | (2000) | ||
| TX247 | VARCHAR2 | (2000) | ||
| TX248 | VARCHAR2 | (2000) | ||
| TX249 | VARCHAR2 | (2000) | ||
| TX250 | VARCHAR2 | (2000) | ||
| TX251 | VARCHAR2 | (2000) | ||
| TX252 | VARCHAR2 | (2000) | ||
| TX253 | VARCHAR2 | (2000) | ||
| TX254 | VARCHAR2 | (2000) | ||
| TX255 | VARCHAR2 | (2000) | ||
| CONCAT_COL | VARCHAR2 | (1) | ||
| ORG_CONTACT_ID | NUMBER | (15) | ||
| PARTY_SITE_ID | NUMBER | (15) | ||
| QKEY | VARCHAR2 | (255) | ||
| PERSON_PARTY_ID | NUMBER | (15) | ||
| STATUS_FLAG | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT PARTY_ID
, CONTACT_POINT_ID
, CONTACT_POINT_TYPE
, TX1
, TX2
, TX3
, TX4
, TX5
, TX6
, TX7
, TX8
, TX9
, TX10
, TX11
, TX12
, TX13
, TX14
, TX15
, TX16
, TX17
, TX18
, TX19
, TX20
, TX21
, TX22
, TX23
, TX24
, TX25
, TX26
, TX27
, TX28
, TX29
, TX30
, TX31
, TX32
, TX33
, TX34
, TX35
, TX36
, TX37
, TX38
, TX39
, TX40
, TX41
, TX42
, TX43
, TX44
, TX45
, TX46
, TX47
, TX48
, TX49
, TX50
, TX51
, TX52
, TX53
, TX54
, TX55
, TX56
, TX57
, TX58
, TX59
, TX60
, TX61
, TX62
, TX63
, TX64
, TX65
, TX66
, TX67
, TX68
, TX69
, TX70
, TX71
, TX72
, TX73
, TX74
, TX75
, TX76
, TX77
, TX78
, TX79
, TX80
, TX81
, TX82
, TX83
, TX84
, TX85
, TX86
, TX87
, TX88
, TX89
, TX90
, TX91
, TX92
, TX93
, TX94
, TX95
, TX96
, TX97
, TX98
, TX99
, TX100
, TX101
, TX102
, TX103
, TX104
, TX105
, TX106
, TX107
, TX108
, TX109
, TX110
, TX111
, TX112
, TX113
, TX114
, TX115
, TX116
, TX117
, TX118
, TX119
, TX120
, TX121
, TX122
, TX123
, TX124
, TX125
, TX126
, TX127
, TX128
, TX129
, TX130
, TX131
, TX132
, TX133
, TX134
, TX135
, TX136
, TX137
, TX138
, TX139
, TX140
, TX141
, TX142
, TX143
, TX144
, TX145
, TX146
, TX147
, TX148
, TX149
, TX150
, TX151
, TX152
, TX153
, TX154
, TX155
, TX156
, TX157
, TX158
, TX159
, TX160
, TX161
, TX162
, TX163
, TX164
, TX165
, TX166
, TX167
, TX168
, TX169
, TX170
, TX171
, TX172
, TX173
, TX174
, TX175
, TX176
, TX177
, TX178
, TX179
, TX180
, TX181
, TX182
, TX183
, TX184
, TX185
, TX186
, TX187
, TX188
, TX189
, TX190
, TX191
, TX192
, TX193
, TX194
, TX195
, TX196
, TX197
, TX198
, TX199
, TX200
, TX201
, TX202
, TX203
, TX204
, TX205
, TX206
, TX207
, TX208
, TX209
, TX210
, TX211
, TX212
, TX213
, TX214
, TX215
, TX216
, TX217
, TX218
, TX219
, TX220
, TX221
, TX222
, TX223
, TX224
, TX225
, TX226
, TX227
, TX228
, TX229
, TX230
, TX231
, TX232
, TX233
, TX234
, TX235
, TX236
, TX237
, TX238
, TX239
, TX240
, TX241
, TX242
, TX243
, TX244
, TX245
, TX246
, TX247
, TX248
, TX249
, TX250
, TX251
, TX252
, TX253
, TX254
, TX255
, CONCAT_COL
, ORG_CONTACT_ID
, PARTY_SITE_ID
, QKEY
, PERSON_PARTY_ID
, STATUS_FLAG
FROM AR.HZ_STAGED_CONTACT_POINTS#;
AR
HZ_STAGED_CONTACT_POINTS
APPS
HZ_STAGED_CONTACT_POINTS
|
|
|
|