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


VIEW: BEN.BEN_COPY_ENTITY_RESULTS#

Object Details
Object Name: BEN_COPY_ENTITY_RESULTS#
Object Type: VIEW
Owner: BEN
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
COPY_ENTITY_RESULT_ID NUMBER (15) Yes
COPY_ENTITY_TXN_ID NUMBER (15) Yes
SRC_COPY_ENTITY_RESULT_ID NUMBER (15)
RESULT_TYPE_CD VARCHAR2 (30) Yes
NUMBER_OF_COPIES NUMBER (10)
MIRROR_ENTITY_RESULT_ID NUMBER (15)
MIRROR_SRC_ENTITY_RESULT_ID NUMBER (15)
PARENT_ENTITY_RESULT_ID NUMBER (15)
PD_MIRROR_SRC_ENTITY_RESULT_ID NUMBER (15)
PD_PARENT_ENTITY_RESULT_ID NUMBER (15)
GS_MIRROR_SRC_ENTITY_RESULT_ID NUMBER (15)
GS_PARENT_ENTITY_RESULT_ID NUMBER (15)
TABLE_NAME VARCHAR2 (30)
TABLE_ALIAS VARCHAR2 (30)
PARENT_TABLE_ALIAS VARCHAR2 (30)
INFORMATION_TYPE VARCHAR2 (30)
TABLE_ROUTE_ID NUMBER (15)
STATUS VARCHAR2 (30)
DML_OPERATION VARCHAR2 (30)
DATETRACK_MODE VARCHAR2 (30)
INFORMATION_CATEGORY VARCHAR2 (30)
INFORMATION1 NUMBER (15)
INFORMATION2 DATE

INFORMATION3 DATE

INFORMATION4 NUMBER (15)
INFORMATION5 VARCHAR2 (600)
INFORMATION6 VARCHAR2 (240)
INFORMATION7 VARCHAR2 (240)
INFORMATION8 VARCHAR2 (30)
INFORMATION9 VARCHAR2 (240)
INFORMATION10 DATE

INFORMATION11 VARCHAR2 (30)
INFORMATION12 VARCHAR2 (30)
INFORMATION13 VARCHAR2 (30)
INFORMATION14 VARCHAR2 (30)
INFORMATION15 VARCHAR2 (30)
INFORMATION16 VARCHAR2 (30)
INFORMATION17 VARCHAR2 (30)
INFORMATION18 VARCHAR2 (30)
INFORMATION19 VARCHAR2 (30)
INFORMATION20 VARCHAR2 (30)
INFORMATION21 VARCHAR2 (30)
INFORMATION22 VARCHAR2 (30)
INFORMATION23 VARCHAR2 (30)
INFORMATION24 VARCHAR2 (30)
INFORMATION25 VARCHAR2 (30)
INFORMATION26 VARCHAR2 (30)
INFORMATION27 VARCHAR2 (30)
INFORMATION28 VARCHAR2 (30)
INFORMATION29 VARCHAR2 (30)
INFORMATION30 VARCHAR2 (30)
INFORMATION31 VARCHAR2 (30)
INFORMATION32 VARCHAR2 (30)
INFORMATION33 VARCHAR2 (30)
INFORMATION34 VARCHAR2 (30)
INFORMATION35 VARCHAR2 (30)
INFORMATION36 VARCHAR2 (30)
INFORMATION37 VARCHAR2 (30)
INFORMATION38 VARCHAR2 (30)
INFORMATION39 VARCHAR2 (30)
INFORMATION40 VARCHAR2 (30)
INFORMATION41 VARCHAR2 (30)
INFORMATION42 VARCHAR2 (30)
INFORMATION43 VARCHAR2 (30)
INFORMATION44 VARCHAR2 (30)
INFORMATION45 VARCHAR2 (30)
INFORMATION46 VARCHAR2 (30)
INFORMATION47 VARCHAR2 (30)
INFORMATION48 VARCHAR2 (30)
INFORMATION49 VARCHAR2 (30)
INFORMATION50 VARCHAR2 (30)
INFORMATION51 VARCHAR2 (30)
INFORMATION52 VARCHAR2 (30)
INFORMATION53 VARCHAR2 (30)
INFORMATION54 VARCHAR2 (30)
INFORMATION55 VARCHAR2 (30)
INFORMATION56 VARCHAR2 (30)
INFORMATION57 VARCHAR2 (30)
INFORMATION58 VARCHAR2 (30)
INFORMATION59 VARCHAR2 (30)
INFORMATION60 VARCHAR2 (30)
INFORMATION61 VARCHAR2 (30)
INFORMATION62 VARCHAR2 (30)
INFORMATION63 VARCHAR2 (30)
INFORMATION64 VARCHAR2 (30)
INFORMATION65 VARCHAR2 (30)
INFORMATION66 VARCHAR2 (30)
INFORMATION67 VARCHAR2 (30)
INFORMATION68 VARCHAR2 (30)
INFORMATION69 VARCHAR2 (30)
INFORMATION70 VARCHAR2 (30)
INFORMATION71 VARCHAR2 (30)
INFORMATION72 VARCHAR2 (30)
INFORMATION73 VARCHAR2 (30)
INFORMATION74 VARCHAR2 (30)
INFORMATION75 VARCHAR2 (30)
INFORMATION76 VARCHAR2 (30)
INFORMATION77 VARCHAR2 (30)
INFORMATION78 VARCHAR2 (30)
INFORMATION79 VARCHAR2 (30)
INFORMATION80 VARCHAR2 (30)
INFORMATION81 VARCHAR2 (30)
INFORMATION82 VARCHAR2 (30)
INFORMATION83 VARCHAR2 (30)
INFORMATION84 VARCHAR2 (30)
INFORMATION85 VARCHAR2 (30)
INFORMATION86 VARCHAR2 (30)
INFORMATION87 VARCHAR2 (30)
INFORMATION88 VARCHAR2 (30)
INFORMATION89 VARCHAR2 (30)
INFORMATION90 VARCHAR2 (30)
INFORMATION91 VARCHAR2 (30)
INFORMATION92 VARCHAR2 (30)
INFORMATION93 VARCHAR2 (30)
INFORMATION94 VARCHAR2 (30)
INFORMATION95 VARCHAR2 (30)
INFORMATION96 VARCHAR2 (30)
INFORMATION97 VARCHAR2 (30)
INFORMATION98 VARCHAR2 (30)
INFORMATION99 VARCHAR2 (30)
INFORMATION100 VARCHAR2 (30)
INFORMATION101 VARCHAR2 (30)
INFORMATION102 VARCHAR2 (30)
INFORMATION103 VARCHAR2 (30)
INFORMATION104 VARCHAR2 (30)
INFORMATION105 VARCHAR2 (30)
INFORMATION106 VARCHAR2 (30)
INFORMATION107 VARCHAR2 (30)
INFORMATION108 VARCHAR2 (30)
INFORMATION109 VARCHAR2 (30)
INFORMATION110 VARCHAR2 (30)
INFORMATION111 VARCHAR2 (150)
INFORMATION112 VARCHAR2 (150)
INFORMATION113 VARCHAR2 (150)
INFORMATION114 VARCHAR2 (150)
INFORMATION115 VARCHAR2 (150)
INFORMATION116 VARCHAR2 (150)
INFORMATION117 VARCHAR2 (150)
INFORMATION118 VARCHAR2 (150)
INFORMATION119 VARCHAR2 (150)
INFORMATION120 VARCHAR2 (150)
INFORMATION121 VARCHAR2 (150)
INFORMATION122 VARCHAR2 (150)
INFORMATION123 VARCHAR2 (150)
INFORMATION124 VARCHAR2 (150)
INFORMATION125 VARCHAR2 (150)
INFORMATION126 VARCHAR2 (150)
INFORMATION127 VARCHAR2 (150)
INFORMATION128 VARCHAR2 (150)
INFORMATION129 VARCHAR2 (150)
INFORMATION130 VARCHAR2 (150)
INFORMATION131 VARCHAR2 (150)
INFORMATION132 VARCHAR2 (150)
INFORMATION133 VARCHAR2 (150)
INFORMATION134 VARCHAR2 (150)
INFORMATION135 VARCHAR2 (150)
INFORMATION136 VARCHAR2 (150)
INFORMATION137 VARCHAR2 (150)
INFORMATION138 VARCHAR2 (150)
INFORMATION139 VARCHAR2 (150)
INFORMATION140 VARCHAR2 (150)
INFORMATION141 VARCHAR2 (150)
INFORMATION142 VARCHAR2 (150)
INFORMATION151 VARCHAR2 (240)
INFORMATION152 VARCHAR2 (240)
INFORMATION153 VARCHAR2 (240)
INFORMATION160 NUMBER (15)
INFORMATION161 NUMBER (15)
INFORMATION162 NUMBER (15)
INFORMATION166 DATE

INFORMATION167 DATE

INFORMATION168 DATE

INFORMATION169 NUMBER (15)
INFORMATION170 VARCHAR2 (240)
INFORMATION173 VARCHAR2 (240)
INFORMATION174 NUMBER (15)
INFORMATION175 VARCHAR2 (240)
INFORMATION176 NUMBER (15)
INFORMATION177 VARCHAR2 (240)
INFORMATION178 NUMBER (15)
INFORMATION179 VARCHAR2 (240)
INFORMATION180 NUMBER (15)
INFORMATION181 VARCHAR2 (240)
INFORMATION182 VARCHAR2 (240)
INFORMATION185 VARCHAR2 (600)
INFORMATION186 VARCHAR2 (240)
INFORMATION187 VARCHAR2 (240)
INFORMATION188 VARCHAR2 (240)
INFORMATION216 VARCHAR2 (600)
INFORMATION217 VARCHAR2 (600)
INFORMATION218 VARCHAR2 (600)
INFORMATION219 VARCHAR2 (2000)
INFORMATION220 VARCHAR2 (2000)
INFORMATION221 NUMBER (15)
INFORMATION222 NUMBER (15)
INFORMATION223 NUMBER (15)
INFORMATION224 NUMBER (15)
INFORMATION225 NUMBER (15)
INFORMATION226 NUMBER (15)
INFORMATION227 NUMBER (15)
INFORMATION228 NUMBER (15)
INFORMATION229 NUMBER (15)
INFORMATION230 NUMBER (15)
INFORMATION231 NUMBER (15)
INFORMATION232 NUMBER (15)
INFORMATION233 NUMBER (15)
INFORMATION234 NUMBER (15)
INFORMATION235 NUMBER (15)
INFORMATION236 NUMBER (15)
INFORMATION237 NUMBER (15)
INFORMATION238 NUMBER (15)
INFORMATION239 NUMBER (15)
INFORMATION240 NUMBER (15)
INFORMATION241 NUMBER (15)
INFORMATION242 NUMBER (15)
INFORMATION243 NUMBER (15)
INFORMATION244 NUMBER (15)
INFORMATION245 NUMBER (15)
INFORMATION246 NUMBER (15)
INFORMATION247 NUMBER (15)
INFORMATION248 NUMBER (15)
INFORMATION249 NUMBER (15)
INFORMATION250 NUMBER (15)
INFORMATION251 NUMBER (15)
INFORMATION252 NUMBER (15)
INFORMATION253 NUMBER (15)
INFORMATION254 NUMBER (15)
INFORMATION255 NUMBER (15)
INFORMATION256 NUMBER (15)
INFORMATION257 NUMBER (15)
INFORMATION258 NUMBER (15)
INFORMATION259 NUMBER (15)
INFORMATION260 NUMBER (15)
INFORMATION261 NUMBER (15)
INFORMATION262 NUMBER (15)
INFORMATION263 NUMBER (15)
INFORMATION264 NUMBER (15)
INFORMATION265 NUMBER (15)
INFORMATION266 NUMBER (15)
INFORMATION267 NUMBER (15)
INFORMATION268 NUMBER (15)
INFORMATION269 NUMBER (15)
INFORMATION270 NUMBER (15)
INFORMATION271 NUMBER (15)
INFORMATION272 NUMBER (15)
INFORMATION273 NUMBER (15)
INFORMATION274 NUMBER (15)
INFORMATION275 NUMBER (15)
INFORMATION276 NUMBER (15)
INFORMATION277 NUMBER (15)
INFORMATION278 NUMBER (15)
INFORMATION279 NUMBER (15)
INFORMATION280 NUMBER (15)
INFORMATION281 NUMBER (15)
INFORMATION282 NUMBER (15)
INFORMATION283 NUMBER (15)
INFORMATION284 NUMBER (15)
INFORMATION285 NUMBER (15)
INFORMATION286 NUMBER (15)
INFORMATION287 NUMBER (22)
INFORMATION288 NUMBER (22)
INFORMATION289 NUMBER (22)
INFORMATION290 NUMBER (22)
INFORMATION291 NUMBER (22)
INFORMATION292 NUMBER (22)
INFORMATION293 NUMBER (38)
INFORMATION294 NUMBER (38)
INFORMATION295 NUMBER (38)
INFORMATION296 NUMBER (38)
INFORMATION297 NUMBER (38)
INFORMATION298 NUMBER (38)
INFORMATION299 NUMBER (38)
INFORMATION300 NUMBER (38)
INFORMATION301 NUMBER (38)
INFORMATION302 NUMBER (38)
INFORMATION303 NUMBER (38)
INFORMATION304 NUMBER (38)
INFORMATION306 DATE

INFORMATION307 DATE

INFORMATION308 DATE

INFORMATION309 DATE

INFORMATION310 DATE

INFORMATION311 DATE

INFORMATION312 DATE

INFORMATION313 DATE

INFORMATION314 DATE

INFORMATION315 DATE

INFORMATION316 DATE

INFORMATION317 DATE

INFORMATION318 DATE

INFORMATION319 DATE

INFORMATION320 DATE

INFORMATION323 CLOB (4000)
OBJECT_VERSION_NUMBER NUMBER (9) Yes
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

FUTURE_DATA_EXISTS VARCHAR2 (30)
ORDER_IN_HIERARCHY NUMBER (15)
ORDER_IN_GROUP NUMBER (15)
INFORMATION190 VARCHAR2 (30)
INFORMATION191 VARCHAR2 (30)
INFORMATION192 VARCHAR2 (30)
INFORMATION193 VARCHAR2 (30)
INFORMATION194 VARCHAR2 (30)
INFORMATION195 VARCHAR2 (30)
INFORMATION196 VARCHAR2 (30)
INFORMATION197 VARCHAR2 (30)
INFORMATION198 VARCHAR2 (30)
INFORMATION199 VARCHAR2 (30)
INFORMATION325 CLOB (4000)
Query Text

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


SELECT COPY_ENTITY_RESULT_ID
,      COPY_ENTITY_TXN_ID
,      SRC_COPY_ENTITY_RESULT_ID
,      RESULT_TYPE_CD
,      NUMBER_OF_COPIES
,      MIRROR_ENTITY_RESULT_ID
,      MIRROR_SRC_ENTITY_RESULT_ID
,      PARENT_ENTITY_RESULT_ID
,      PD_MIRROR_SRC_ENTITY_RESULT_ID
,      PD_PARENT_ENTITY_RESULT_ID
,      GS_MIRROR_SRC_ENTITY_RESULT_ID
,      GS_PARENT_ENTITY_RESULT_ID
,      TABLE_NAME
,      TABLE_ALIAS
,      PARENT_TABLE_ALIAS
,      INFORMATION_TYPE
,      TABLE_ROUTE_ID
,      STATUS
,      DML_OPERATION
,      DATETRACK_MODE
,      INFORMATION_CATEGORY
,      INFORMATION1
,      INFORMATION2
,      INFORMATION3
,      INFORMATION4
,      INFORMATION5
,      INFORMATION6
,      INFORMATION7
,      INFORMATION8
,      INFORMATION9
,      INFORMATION10
,      INFORMATION11
,      INFORMATION12
,      INFORMATION13
,      INFORMATION14
,      INFORMATION15
,      INFORMATION16
,      INFORMATION17
,      INFORMATION18
,      INFORMATION19
,      INFORMATION20
,      INFORMATION21
,      INFORMATION22
,      INFORMATION23
,      INFORMATION24
,      INFORMATION25
,      INFORMATION26
,      INFORMATION27
,      INFORMATION28
,      INFORMATION29
,      INFORMATION30
,      INFORMATION31
,      INFORMATION32
,      INFORMATION33
,      INFORMATION34
,      INFORMATION35
,      INFORMATION36
,      INFORMATION37
,      INFORMATION38
,      INFORMATION39
,      INFORMATION40
,      INFORMATION41
,      INFORMATION42
,      INFORMATION43
,      INFORMATION44
,      INFORMATION45
,      INFORMATION46
,      INFORMATION47
,      INFORMATION48
,      INFORMATION49
,      INFORMATION50
,      INFORMATION51
,      INFORMATION52
,      INFORMATION53
,      INFORMATION54
,      INFORMATION55
,      INFORMATION56
,      INFORMATION57
,      INFORMATION58
,      INFORMATION59
,      INFORMATION60
,      INFORMATION61
,      INFORMATION62
,      INFORMATION63
,      INFORMATION64
,      INFORMATION65
,      INFORMATION66
,      INFORMATION67
,      INFORMATION68
,      INFORMATION69
,      INFORMATION70
,      INFORMATION71
,      INFORMATION72
,      INFORMATION73
,      INFORMATION74
,      INFORMATION75
,      INFORMATION76
,      INFORMATION77
,      INFORMATION78
,      INFORMATION79
,      INFORMATION80
,      INFORMATION81
,      INFORMATION82
,      INFORMATION83
,      INFORMATION84
,      INFORMATION85
,      INFORMATION86
,      INFORMATION87
,      INFORMATION88
,      INFORMATION89
,      INFORMATION90
,      INFORMATION91
,      INFORMATION92
,      INFORMATION93
,      INFORMATION94
,      INFORMATION95
,      INFORMATION96
,      INFORMATION97
,      INFORMATION98
,      INFORMATION99
,      INFORMATION100
,      INFORMATION101
,      INFORMATION102
,      INFORMATION103
,      INFORMATION104
,      INFORMATION105
,      INFORMATION106
,      INFORMATION107
,      INFORMATION108
,      INFORMATION109
,      INFORMATION110
,      INFORMATION111
,      INFORMATION112
,      INFORMATION113
,      INFORMATION114
,      INFORMATION115
,      INFORMATION116
,      INFORMATION117
,      INFORMATION118
,      INFORMATION119
,      INFORMATION120
,      INFORMATION121
,      INFORMATION122
,      INFORMATION123
,      INFORMATION124
,      INFORMATION125
,      INFORMATION126
,      INFORMATION127
,      INFORMATION128
,      INFORMATION129
,      INFORMATION130
,      INFORMATION131
,      INFORMATION132
,      INFORMATION133
,      INFORMATION134
,      INFORMATION135
,      INFORMATION136
,      INFORMATION137
,      INFORMATION138
,      INFORMATION139
,      INFORMATION140
,      INFORMATION141
,      INFORMATION142
,      INFORMATION151
,      INFORMATION152
,      INFORMATION153
,      INFORMATION160
,      INFORMATION161
,      INFORMATION162
,      INFORMATION166
,      INFORMATION167
,      INFORMATION168
,      INFORMATION169
,      INFORMATION170
,      INFORMATION173
,      INFORMATION174
,      INFORMATION175
,      INFORMATION176
,      INFORMATION177
,      INFORMATION178
,      INFORMATION179
,      INFORMATION180
,      INFORMATION181
,      INFORMATION182
,      INFORMATION185
,      INFORMATION186
,      INFORMATION187
,      INFORMATION188
,      INFORMATION216
,      INFORMATION217
,      INFORMATION218
,      INFORMATION219
,      INFORMATION220
,      INFORMATION221
,      INFORMATION222
,      INFORMATION223
,      INFORMATION224
,      INFORMATION225
,      INFORMATION226
,      INFORMATION227
,      INFORMATION228
,      INFORMATION229
,      INFORMATION230
,      INFORMATION231
,      INFORMATION232
,      INFORMATION233
,      INFORMATION234
,      INFORMATION235
,      INFORMATION236
,      INFORMATION237
,      INFORMATION238
,      INFORMATION239
,      INFORMATION240
,      INFORMATION241
,      INFORMATION242
,      INFORMATION243
,      INFORMATION244
,      INFORMATION245
,      INFORMATION246
,      INFORMATION247
,      INFORMATION248
,      INFORMATION249
,      INFORMATION250
,      INFORMATION251
,      INFORMATION252
,      INFORMATION253
,      INFORMATION254
,      INFORMATION255
,      INFORMATION256
,      INFORMATION257
,      INFORMATION258
,      INFORMATION259
,      INFORMATION260
,      INFORMATION261
,      INFORMATION262
,      INFORMATION263
,      INFORMATION264
,      INFORMATION265
,      INFORMATION266
,      INFORMATION267
,      INFORMATION268
,      INFORMATION269
,      INFORMATION270
,      INFORMATION271
,      INFORMATION272
,      INFORMATION273
,      INFORMATION274
,      INFORMATION275
,      INFORMATION276
,      INFORMATION277
,      INFORMATION278
,      INFORMATION279
,      INFORMATION280
,      INFORMATION281
,      INFORMATION282
,      INFORMATION283
,      INFORMATION284
,      INFORMATION285
,      INFORMATION286
,      INFORMATION287
,      INFORMATION288
,      INFORMATION289
,      INFORMATION290
,      INFORMATION291
,      INFORMATION292
,      INFORMATION293
,      INFORMATION294
,      INFORMATION295
,      INFORMATION296
,      INFORMATION297
,      INFORMATION298
,      INFORMATION299
,      INFORMATION300
,      INFORMATION301
,      INFORMATION302
,      INFORMATION303
,      INFORMATION304
,      INFORMATION306
,      INFORMATION307
,      INFORMATION308
,      INFORMATION309
,      INFORMATION310
,      INFORMATION311
,      INFORMATION312
,      INFORMATION313
,      INFORMATION314
,      INFORMATION315
,      INFORMATION316
,      INFORMATION317
,      INFORMATION318
,      INFORMATION319
,      INFORMATION320
,      INFORMATION323
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      FUTURE_DATA_EXISTS
,      ORDER_IN_HIERARCHY
,      ORDER_IN_GROUP
,      INFORMATION190
,      INFORMATION191
,      INFORMATION192
,      INFORMATION193
,      INFORMATION194
,      INFORMATION195
,      INFORMATION196
,      INFORMATION197
,      INFORMATION198
,      INFORMATION199
,      INFORMATION325
FROM BEN.BEN_COPY_ENTITY_RESULTS#;

Dependencies

[top of page]

BEN.BEN_COPY_ENTITY_RESULTS# references the following:

SchemaBEN
TableBEN_COPY_ENTITY_RESULTS
BEN.BEN_COPY_ENTITY_RESULTS# is referenced by following:

SchemaAPPS
SynonymBEN_COPY_ENTITY_RESULTS
TriggerBEN_COPY_ENTITY_RESULTS_WHO