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


TABLE: AR.HZ_STAGED_CONTACT_POINTS

Object Details
Object Name: HZ_STAGED_CONTACT_POINTS
Object Type: TABLE
Owner: AR
FND Design Data: TableAR.HZ_STAGED_CONTACT_POINTS
Subobject Name:
Status: VALID


The HZ_STAGED_CONTACT_POINTS table is a staging area of contact point information. Only used for internal Data Quality Management processing.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
HZ_STAGED_CONTACT_POINTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCONTACT_POINT_ID
HZ_STAGED_CONTACT_POINTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARTY_ID
Columns
Name Datatype Length Mandatory Comments
PARTY_ID NUMBER (15)
Foreign key to HZ_PARTIES
CONTACT_POINT_ID NUMBER (15)
Foreign key to HZ_CONTACT_POINTS
CONTACT_POINT_TYPE VARCHAR2 (30)
Contact Point Type
TX1 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX2 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX3 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX4 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX5 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX6 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX7 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX8 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX9 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX10 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX11 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX12 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX13 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX14 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX15 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX16 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX17 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX18 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX19 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX20 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX21 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX22 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX23 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX24 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX25 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX26 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX27 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX28 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX29 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX30 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX31 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX32 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX33 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX34 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX35 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX36 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX37 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX38 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX39 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX40 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX41 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX42 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX43 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX44 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX45 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX46 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX47 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX48 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX49 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX50 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX51 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX52 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX53 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX54 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX55 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX56 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX57 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX58 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX59 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX60 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX61 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX62 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX63 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX64 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX65 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX66 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX67 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX68 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX69 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX70 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX71 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX72 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX73 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX74 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX75 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX76 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX77 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX78 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX79 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX80 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX81 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX82 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX83 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX84 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX85 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX86 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX87 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX88 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX89 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX90 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX91 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX92 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX93 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX94 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX95 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX96 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX97 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX98 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX99 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX100 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX101 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX102 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX103 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX104 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX105 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX106 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX107 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX108 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX109 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX110 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX111 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX112 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX113 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX114 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX115 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX116 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX117 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX118 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX119 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX120 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX121 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX122 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX123 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX124 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX125 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX126 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX127 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX128 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX129 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX130 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX131 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX132 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX133 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX134 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX135 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX136 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX137 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX138 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX139 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX140 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX141 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX142 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX143 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX144 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX145 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX146 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX147 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX148 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX149 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX150 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX151 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX152 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX153 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX154 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX155 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX156 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX157 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX158 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX159 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX160 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX161 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX162 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX163 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX164 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX165 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX166 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX167 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX168 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX169 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX170 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX171 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX172 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX173 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX174 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX175 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX176 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX177 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX178 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX179 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX180 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX181 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX182 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX183 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX184 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX185 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX186 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX187 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX188 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX189 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX190 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX191 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX192 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX193 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX194 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX195 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX196 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX197 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX198 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX199 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX200 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX201 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX202 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX203 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX204 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX205 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX206 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX207 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX208 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX209 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX210 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX211 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX212 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX213 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX214 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX215 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX216 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX217 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX218 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX219 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX220 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX221 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX222 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX223 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX224 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX225 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX226 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX227 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX228 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX229 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX230 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX231 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX232 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX233 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX234 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX235 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX236 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX237 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX238 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX239 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX240 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX241 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX242 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX243 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX244 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX245 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX246 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX247 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX248 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX249 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX250 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX251 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX252 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX253 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX254 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
TX255 VARCHAR2 (2000)
These columns hold the transformed data from the Main TCA tables.
CONCAT_COL VARCHAR2 (1)
A placeholder column for the intermedia index on the table.
ORG_CONTACT_ID NUMBER (15)
Identifier for the Org Contact. Foreign key to the HZ_ORG_CONTACTS table.
PARTY_SITE_ID NUMBER (15)
Identifier for the Party Site. Foreign key to the HZ_PARTY_SITES table.
QKEY VARCHAR2 (255)
Concatenation of specific transformed values
PERSON_PARTY_ID NUMBER (15)
Party identifier of Person parties
STATUS_FLAG VARCHAR2 (1)
Status of staged record. A for active, I for inactive.
Query Text

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;

Dependencies

[top of page]

AR.HZ_STAGED_CONTACT_POINTS does not reference any database object

AR.HZ_STAGED_CONTACT_POINTS is referenced by following:

SchemaAR
ViewHZ_STAGED_CONTACT_POINTS#