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

TABLE: AR.HZ_SRCH_CPTS

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


The HZ_SRCH_CPTS table temporarily stores the transformed data for contact points in the interface tables. The transformed data is used for duplicate identification of contact point records within the interface tables, or between the interface table contact point records and the TCA Registry. Duplicate identification is a Data Quality Management process that resolves duplicates before you import records from the interface tables into TCA. Data in this table is only used for the duration of the duplicate identification process, and is emptied at the end of it.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
HZ_SRCH_CPTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnBATCH_ID
ColumnPARTY_OS
ColumnPARTY_OSR
Columns
Name Datatype Length Mandatory Comments
INT_ROW_ID ROWID (10)
ROWID of the HZ_IMP_CONTACT_PTS_INT interface table row.
BATCH_ID NUMBER (15) Yes Interface batch identifier. Foreign key to HZ_BATCH_SUMMARY.
CONTACT_POINT_ID NUMBER (15)
Foreign key to HZ_IMP_CONTACTPOINTS_SG. Contact point identifier is generated by import during Source System Management phase.
CONTACT_PT_OSR VARCHAR2 (255) Yes Source identifier of contact point in the interface tables
CONTACT_PT_OS VARCHAR2 (30) Yes Source system of contact point in the interface tables
NEW_PARTY_FLAG VARCHAR2 (1)
Y or N indicates whether this new contact point is for a new or existing party. Y for new, N for existing.
CONTACT_POINT_TYPE VARCHAR2 (30)
Contact point type of the contact point
PARTY_ID NUMBER (15)
Foreign key to HZ_IMP_PARTIES_SG. Party identifier is generated by import during Source System Management phase.
PARTY_OSR VARCHAR2 (255) Yes Source identifier of party in the interface tables
PARTY_OS VARCHAR2 (30) Yes Source system of party in the interface tables
PARTY_SITE_ID NUMBER (15)
Foreign key to HZ_IMP_ADDRESSES_SG
PARTY_SITE_OSR VARCHAR2 (255)
Source identifier of party site in the interface tables
PARTY_SITE_OS VARCHAR2 (30)
Source system of party site in the interface tables
TX1 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX2 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX3 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX4 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX5 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX6 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX7 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX8 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX9 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX10 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX11 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX12 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX13 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX14 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX15 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX16 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX17 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX18 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX19 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX20 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX21 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX22 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX23 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX24 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX25 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX26 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX27 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX28 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX29 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX30 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX31 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX32 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX33 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX34 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX35 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX36 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX37 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX38 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX39 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX40 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX41 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX42 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX43 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX44 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX45 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX46 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX47 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX48 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX49 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX50 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX51 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX52 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX53 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX54 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX55 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX56 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX57 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX58 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX59 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX60 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX61 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX62 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX63 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX64 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX65 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX66 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX67 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX68 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX69 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX70 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX71 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX72 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX73 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX74 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX75 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX76 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX77 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX78 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX79 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX80 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX81 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX82 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX83 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX84 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX85 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX86 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX87 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX88 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX89 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX90 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX91 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX92 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX93 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX94 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX95 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX96 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX97 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX98 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX99 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX100 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX101 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX102 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX103 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX104 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX105 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX106 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX107 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX108 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX109 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX110 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX111 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX112 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX113 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX114 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX115 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX116 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX117 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX118 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX119 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX120 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX121 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX122 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX123 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX124 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX125 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX126 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX127 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX128 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX129 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX130 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX131 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX132 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX133 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX134 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX135 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX136 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX137 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX138 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX139 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX140 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX141 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX142 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX143 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX144 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX145 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX146 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX147 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX148 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX149 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX150 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX151 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX152 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX153 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX154 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX155 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX156 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX157 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX158 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX159 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX160 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX161 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX162 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX163 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX164 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX165 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX166 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX167 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX168 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX169 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX170 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX171 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX172 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX173 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX174 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX175 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX176 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX177 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX178 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX179 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX180 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX181 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX182 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX183 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX184 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX185 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX186 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX187 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX188 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX189 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX190 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX191 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX192 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX193 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX194 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX195 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX196 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX197 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX198 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX199 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX200 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX201 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX202 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX203 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX204 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX205 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX206 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX207 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX208 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX209 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX210 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX211 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX212 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX213 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX214 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX215 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX216 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX217 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX218 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX219 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX220 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX221 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX222 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX223 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX224 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX225 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX226 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX227 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX228 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX229 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX230 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX231 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX232 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX233 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX234 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX235 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX236 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX237 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX238 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX239 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX240 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX241 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX242 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX243 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX244 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX245 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX246 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX247 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX248 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX249 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX250 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX251 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX252 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX253 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX254 VARCHAR2 (2000)
Transformed data from the main TCA tables
TX255 VARCHAR2 (2000)
Transformed data from the main TCA tables
Query Text

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


SELECT INT_ROW_ID
,      BATCH_ID
,      CONTACT_POINT_ID
,      CONTACT_PT_OSR
,      CONTACT_PT_OS
,      NEW_PARTY_FLAG
,      CONTACT_POINT_TYPE
,      PARTY_ID
,      PARTY_OSR
,      PARTY_OS
,      PARTY_SITE_ID
,      PARTY_SITE_OSR
,      PARTY_SITE_OS
,      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
FROM AR.HZ_SRCH_CPTS;

Dependencies

[top of page]

AR.HZ_SRCH_CPTS does not reference any database object

AR.HZ_SRCH_CPTS is referenced by following:

SchemaAR
ViewHZ_SRCH_CPTS#