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


VIEW: BEN.BEN_EXT_RSLT_DTL#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
EXT_RSLT_DTL_ID NUMBER (15) Yes
EXT_RSLT_ID NUMBER (15) Yes
BUSINESS_GROUP_ID NUMBER (15) Yes
EXT_RCD_ID NUMBER (15) Yes
PERSON_ID NUMBER (15) Yes
VAL_01 VARCHAR2 (600)
VAL_02 VARCHAR2 (600)
VAL_03 VARCHAR2 (600)
VAL_04 VARCHAR2 (600)
VAL_05 VARCHAR2 (600)
VAL_06 VARCHAR2 (600)
VAL_07 VARCHAR2 (600)
VAL_08 VARCHAR2 (600)
VAL_09 VARCHAR2 (600)
VAL_10 VARCHAR2 (600)
VAL_11 VARCHAR2 (600)
VAL_12 VARCHAR2 (600)
VAL_13 VARCHAR2 (600)
VAL_14 VARCHAR2 (600)
VAL_15 VARCHAR2 (600)
VAL_16 VARCHAR2 (600)
VAL_17 VARCHAR2 (600)
VAL_19 VARCHAR2 (600)
VAL_18 VARCHAR2 (600)
VAL_20 VARCHAR2 (600)
VAL_21 VARCHAR2 (600)
VAL_22 VARCHAR2 (600)
VAL_23 VARCHAR2 (600)
VAL_24 VARCHAR2 (600)
VAL_25 VARCHAR2 (600)
VAL_26 VARCHAR2 (600)
VAL_27 VARCHAR2 (600)
VAL_28 VARCHAR2 (600)
VAL_29 VARCHAR2 (600)
VAL_30 VARCHAR2 (600)
VAL_31 VARCHAR2 (600)
VAL_32 VARCHAR2 (600)
VAL_33 VARCHAR2 (600)
VAL_34 VARCHAR2 (600)
VAL_35 VARCHAR2 (600)
VAL_36 VARCHAR2 (600)
VAL_37 VARCHAR2 (600)
VAL_38 VARCHAR2 (600)
VAL_39 VARCHAR2 (600)
VAL_40 VARCHAR2 (600)
VAL_41 VARCHAR2 (600)
VAL_42 VARCHAR2 (600)
VAL_43 VARCHAR2 (600)
VAL_44 VARCHAR2 (600)
VAL_45 VARCHAR2 (600)
VAL_46 VARCHAR2 (600)
VAL_47 VARCHAR2 (600)
VAL_48 VARCHAR2 (600)
VAL_49 VARCHAR2 (600)
VAL_50 VARCHAR2 (600)
VAL_51 VARCHAR2 (600)
VAL_52 VARCHAR2 (600)
VAL_53 VARCHAR2 (600)
VAL_54 VARCHAR2 (600)
VAL_55 VARCHAR2 (600)
VAL_56 VARCHAR2 (600)
VAL_57 VARCHAR2 (600)
VAL_58 VARCHAR2 (600)
VAL_59 VARCHAR2 (600)
VAL_60 VARCHAR2 (600)
VAL_61 VARCHAR2 (600)
VAL_62 VARCHAR2 (600)
VAL_63 VARCHAR2 (600)
VAL_64 VARCHAR2 (600)
VAL_65 VARCHAR2 (600)
VAL_66 VARCHAR2 (600)
VAL_67 VARCHAR2 (600)
VAL_68 VARCHAR2 (600)
VAL_69 VARCHAR2 (600)
VAL_70 VARCHAR2 (600)
VAL_71 VARCHAR2 (600)
VAL_72 VARCHAR2 (600)
VAL_73 VARCHAR2 (600)
VAL_74 VARCHAR2 (600)
VAL_75 VARCHAR2 (600)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

REQUEST_ID NUMBER (15)
OBJECT_VERSION_NUMBER NUMBER (9)
PRMY_SORT_VAL VARCHAR2 (600)
SCND_SORT_VAL VARCHAR2 (600)
THRD_SORT_VAL VARCHAR2 (600)
TRANS_SEQ_NUM NUMBER (15)
RCRD_SEQ_NUM NUMBER (15)
VAL_76 VARCHAR2 (600)
VAL_77 VARCHAR2 (600)
VAL_78 VARCHAR2 (600)
VAL_79 VARCHAR2 (600)
VAL_80 VARCHAR2 (600)
VAL_81 VARCHAR2 (600)
VAL_82 VARCHAR2 (600)
VAL_83 VARCHAR2 (600)
VAL_84 VARCHAR2 (600)
VAL_85 VARCHAR2 (600)
VAL_86 VARCHAR2 (600)
VAL_87 VARCHAR2 (600)
VAL_88 VARCHAR2 (600)
VAL_89 VARCHAR2 (600)
VAL_90 VARCHAR2 (600)
VAL_91 VARCHAR2 (600)
VAL_92 VARCHAR2 (600)
VAL_93 VARCHAR2 (600)
VAL_94 VARCHAR2 (600)
VAL_95 VARCHAR2 (600)
VAL_96 VARCHAR2 (600)
VAL_97 VARCHAR2 (600)
VAL_98 VARCHAR2 (600)
VAL_99 VARCHAR2 (600)
VAL_100 VARCHAR2 (600)
VAL_101 VARCHAR2 (600)
VAL_102 VARCHAR2 (600)
VAL_103 VARCHAR2 (600)
VAL_104 VARCHAR2 (600)
VAL_105 VARCHAR2 (600)
VAL_106 VARCHAR2 (600)
VAL_107 VARCHAR2 (600)
VAL_108 VARCHAR2 (600)
VAL_109 VARCHAR2 (600)
VAL_110 VARCHAR2 (600)
VAL_111 VARCHAR2 (600)
VAL_112 VARCHAR2 (600)
VAL_113 VARCHAR2 (600)
VAL_114 VARCHAR2 (600)
VAL_115 VARCHAR2 (600)
VAL_116 VARCHAR2 (600)
VAL_117 VARCHAR2 (600)
VAL_118 VARCHAR2 (600)
VAL_119 VARCHAR2 (600)
VAL_120 VARCHAR2 (600)
VAL_121 VARCHAR2 (600)
VAL_122 VARCHAR2 (600)
VAL_123 VARCHAR2 (600)
VAL_124 VARCHAR2 (600)
VAL_125 VARCHAR2 (600)
VAL_126 VARCHAR2 (600)
VAL_127 VARCHAR2 (600)
VAL_128 VARCHAR2 (600)
VAL_129 VARCHAR2 (600)
VAL_130 VARCHAR2 (600)
VAL_131 VARCHAR2 (600)
VAL_132 VARCHAR2 (600)
VAL_133 VARCHAR2 (600)
VAL_134 VARCHAR2 (600)
VAL_135 VARCHAR2 (600)
VAL_136 VARCHAR2 (600)
VAL_137 VARCHAR2 (600)
VAL_138 VARCHAR2 (600)
VAL_139 VARCHAR2 (600)
VAL_140 VARCHAR2 (600)
VAL_141 VARCHAR2 (600)
VAL_142 VARCHAR2 (600)
VAL_143 VARCHAR2 (600)
VAL_144 VARCHAR2 (600)
VAL_145 VARCHAR2 (600)
VAL_146 VARCHAR2 (600)
VAL_147 VARCHAR2 (600)
VAL_148 VARCHAR2 (600)
VAL_149 VARCHAR2 (600)
VAL_150 VARCHAR2 (600)
VAL_151 VARCHAR2 (600)
VAL_152 VARCHAR2 (600)
VAL_153 VARCHAR2 (600)
VAL_154 VARCHAR2 (600)
VAL_155 VARCHAR2 (600)
VAL_156 VARCHAR2 (600)
VAL_157 VARCHAR2 (600)
VAL_158 VARCHAR2 (600)
VAL_159 VARCHAR2 (600)
VAL_160 VARCHAR2 (600)
VAL_161 VARCHAR2 (600)
VAL_162 VARCHAR2 (600)
VAL_163 VARCHAR2 (600)
VAL_164 VARCHAR2 (600)
VAL_165 VARCHAR2 (600)
VAL_166 VARCHAR2 (600)
VAL_167 VARCHAR2 (600)
VAL_168 VARCHAR2 (600)
VAL_169 VARCHAR2 (600)
VAL_170 VARCHAR2 (600)
VAL_171 VARCHAR2 (600)
VAL_172 VARCHAR2 (600)
VAL_173 VARCHAR2 (600)
VAL_174 VARCHAR2 (600)
VAL_175 VARCHAR2 (600)
VAL_176 VARCHAR2 (600)
VAL_177 VARCHAR2 (600)
VAL_178 VARCHAR2 (600)
VAL_179 VARCHAR2 (600)
VAL_180 VARCHAR2 (600)
VAL_181 VARCHAR2 (600)
VAL_182 VARCHAR2 (600)
VAL_183 VARCHAR2 (600)
VAL_184 VARCHAR2 (600)
VAL_185 VARCHAR2 (600)
VAL_186 VARCHAR2 (600)
VAL_187 VARCHAR2 (600)
VAL_188 VARCHAR2 (600)
VAL_189 VARCHAR2 (600)
VAL_190 VARCHAR2 (600)
VAL_191 VARCHAR2 (600)
VAL_192 VARCHAR2 (600)
VAL_193 VARCHAR2 (600)
VAL_194 VARCHAR2 (600)
VAL_195 VARCHAR2 (600)
VAL_196 VARCHAR2 (600)
VAL_197 VARCHAR2 (600)
VAL_198 VARCHAR2 (600)
VAL_199 VARCHAR2 (600)
VAL_200 VARCHAR2 (600)
VAL_201 VARCHAR2 (600)
VAL_202 VARCHAR2 (600)
VAL_203 VARCHAR2 (600)
VAL_204 VARCHAR2 (600)
VAL_205 VARCHAR2 (600)
VAL_206 VARCHAR2 (600)
VAL_207 VARCHAR2 (600)
VAL_208 VARCHAR2 (600)
VAL_209 VARCHAR2 (600)
VAL_210 VARCHAR2 (600)
VAL_211 VARCHAR2 (600)
VAL_212 VARCHAR2 (600)
VAL_213 VARCHAR2 (600)
VAL_214 VARCHAR2 (600)
VAL_215 VARCHAR2 (600)
VAL_216 VARCHAR2 (600)
VAL_217 VARCHAR2 (600)
VAL_218 VARCHAR2 (600)
VAL_219 VARCHAR2 (600)
VAL_220 VARCHAR2 (600)
VAL_221 VARCHAR2 (600)
VAL_222 VARCHAR2 (600)
VAL_223 VARCHAR2 (600)
VAL_224 VARCHAR2 (600)
VAL_225 VARCHAR2 (600)
VAL_226 VARCHAR2 (600)
VAL_227 VARCHAR2 (600)
VAL_228 VARCHAR2 (600)
VAL_229 VARCHAR2 (600)
VAL_230 VARCHAR2 (600)
VAL_231 VARCHAR2 (600)
VAL_232 VARCHAR2 (600)
VAL_233 VARCHAR2 (600)
VAL_234 VARCHAR2 (600)
VAL_235 VARCHAR2 (600)
VAL_236 VARCHAR2 (600)
VAL_237 VARCHAR2 (600)
VAL_238 VARCHAR2 (600)
VAL_239 VARCHAR2 (600)
VAL_240 VARCHAR2 (600)
VAL_241 VARCHAR2 (600)
VAL_242 VARCHAR2 (600)
VAL_243 VARCHAR2 (600)
VAL_244 VARCHAR2 (600)
VAL_245 VARCHAR2 (600)
VAL_246 VARCHAR2 (600)
VAL_247 VARCHAR2 (600)
VAL_248 VARCHAR2 (600)
VAL_249 VARCHAR2 (600)
VAL_250 VARCHAR2 (600)
VAL_251 VARCHAR2 (600)
VAL_252 VARCHAR2 (600)
VAL_253 VARCHAR2 (600)
VAL_254 VARCHAR2 (600)
VAL_255 VARCHAR2 (600)
VAL_256 VARCHAR2 (600)
VAL_257 VARCHAR2 (600)
VAL_258 VARCHAR2 (600)
VAL_259 VARCHAR2 (600)
VAL_260 VARCHAR2 (600)
VAL_261 VARCHAR2 (600)
VAL_262 VARCHAR2 (600)
VAL_263 VARCHAR2 (600)
VAL_264 VARCHAR2 (600)
VAL_265 VARCHAR2 (600)
VAL_266 VARCHAR2 (600)
VAL_267 VARCHAR2 (600)
VAL_268 VARCHAR2 (600)
VAL_269 VARCHAR2 (600)
VAL_270 VARCHAR2 (600)
VAL_271 VARCHAR2 (600)
VAL_272 VARCHAR2 (600)
VAL_273 VARCHAR2 (600)
VAL_274 VARCHAR2 (600)
VAL_275 VARCHAR2 (600)
VAL_276 VARCHAR2 (600)
VAL_277 VARCHAR2 (600)
VAL_278 VARCHAR2 (600)
VAL_279 VARCHAR2 (600)
VAL_280 VARCHAR2 (600)
VAL_281 VARCHAR2 (600)
VAL_282 VARCHAR2 (600)
VAL_283 VARCHAR2 (600)
VAL_284 VARCHAR2 (600)
VAL_285 VARCHAR2 (600)
VAL_286 VARCHAR2 (600)
VAL_287 VARCHAR2 (600)
VAL_288 VARCHAR2 (600)
VAL_289 VARCHAR2 (600)
VAL_290 VARCHAR2 (600)
VAL_291 VARCHAR2 (600)
VAL_292 VARCHAR2 (600)
VAL_293 VARCHAR2 (600)
VAL_294 VARCHAR2 (600)
VAL_295 VARCHAR2 (600)
VAL_296 VARCHAR2 (600)
VAL_297 VARCHAR2 (600)
VAL_298 VARCHAR2 (600)
VAL_299 VARCHAR2 (600)
VAL_300 VARCHAR2 (600)
EXT_RCD_IN_FILE_ID NUMBER (15)
GROUP_VAL_01 VARCHAR2 (600)
GROUP_VAL_02 VARCHAR2 (600)
EXT_PER_BG_ID NUMBER (15)
Query Text

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


SELECT EXT_RSLT_DTL_ID
,      EXT_RSLT_ID
,      BUSINESS_GROUP_ID
,      EXT_RCD_ID
,      PERSON_ID
,      VAL_01
,      VAL_02
,      VAL_03
,      VAL_04
,      VAL_05
,      VAL_06
,      VAL_07
,      VAL_08
,      VAL_09
,      VAL_10
,      VAL_11
,      VAL_12
,      VAL_13
,      VAL_14
,      VAL_15
,      VAL_16
,      VAL_17
,      VAL_19
,      VAL_18
,      VAL_20
,      VAL_21
,      VAL_22
,      VAL_23
,      VAL_24
,      VAL_25
,      VAL_26
,      VAL_27
,      VAL_28
,      VAL_29
,      VAL_30
,      VAL_31
,      VAL_32
,      VAL_33
,      VAL_34
,      VAL_35
,      VAL_36
,      VAL_37
,      VAL_38
,      VAL_39
,      VAL_40
,      VAL_41
,      VAL_42
,      VAL_43
,      VAL_44
,      VAL_45
,      VAL_46
,      VAL_47
,      VAL_48
,      VAL_49
,      VAL_50
,      VAL_51
,      VAL_52
,      VAL_53
,      VAL_54
,      VAL_55
,      VAL_56
,      VAL_57
,      VAL_58
,      VAL_59
,      VAL_60
,      VAL_61
,      VAL_62
,      VAL_63
,      VAL_64
,      VAL_65
,      VAL_66
,      VAL_67
,      VAL_68
,      VAL_69
,      VAL_70
,      VAL_71
,      VAL_72
,      VAL_73
,      VAL_74
,      VAL_75
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      OBJECT_VERSION_NUMBER
,      PRMY_SORT_VAL
,      SCND_SORT_VAL
,      THRD_SORT_VAL
,      TRANS_SEQ_NUM
,      RCRD_SEQ_NUM
,      VAL_76
,      VAL_77
,      VAL_78
,      VAL_79
,      VAL_80
,      VAL_81
,      VAL_82
,      VAL_83
,      VAL_84
,      VAL_85
,      VAL_86
,      VAL_87
,      VAL_88
,      VAL_89
,      VAL_90
,      VAL_91
,      VAL_92
,      VAL_93
,      VAL_94
,      VAL_95
,      VAL_96
,      VAL_97
,      VAL_98
,      VAL_99
,      VAL_100
,      VAL_101
,      VAL_102
,      VAL_103
,      VAL_104
,      VAL_105
,      VAL_106
,      VAL_107
,      VAL_108
,      VAL_109
,      VAL_110
,      VAL_111
,      VAL_112
,      VAL_113
,      VAL_114
,      VAL_115
,      VAL_116
,      VAL_117
,      VAL_118
,      VAL_119
,      VAL_120
,      VAL_121
,      VAL_122
,      VAL_123
,      VAL_124
,      VAL_125
,      VAL_126
,      VAL_127
,      VAL_128
,      VAL_129
,      VAL_130
,      VAL_131
,      VAL_132
,      VAL_133
,      VAL_134
,      VAL_135
,      VAL_136
,      VAL_137
,      VAL_138
,      VAL_139
,      VAL_140
,      VAL_141
,      VAL_142
,      VAL_143
,      VAL_144
,      VAL_145
,      VAL_146
,      VAL_147
,      VAL_148
,      VAL_149
,      VAL_150
,      VAL_151
,      VAL_152
,      VAL_153
,      VAL_154
,      VAL_155
,      VAL_156
,      VAL_157
,      VAL_158
,      VAL_159
,      VAL_160
,      VAL_161
,      VAL_162
,      VAL_163
,      VAL_164
,      VAL_165
,      VAL_166
,      VAL_167
,      VAL_168
,      VAL_169
,      VAL_170
,      VAL_171
,      VAL_172
,      VAL_173
,      VAL_174
,      VAL_175
,      VAL_176
,      VAL_177
,      VAL_178
,      VAL_179
,      VAL_180
,      VAL_181
,      VAL_182
,      VAL_183
,      VAL_184
,      VAL_185
,      VAL_186
,      VAL_187
,      VAL_188
,      VAL_189
,      VAL_190
,      VAL_191
,      VAL_192
,      VAL_193
,      VAL_194
,      VAL_195
,      VAL_196
,      VAL_197
,      VAL_198
,      VAL_199
,      VAL_200
,      VAL_201
,      VAL_202
,      VAL_203
,      VAL_204
,      VAL_205
,      VAL_206
,      VAL_207
,      VAL_208
,      VAL_209
,      VAL_210
,      VAL_211
,      VAL_212
,      VAL_213
,      VAL_214
,      VAL_215
,      VAL_216
,      VAL_217
,      VAL_218
,      VAL_219
,      VAL_220
,      VAL_221
,      VAL_222
,      VAL_223
,      VAL_224
,      VAL_225
,      VAL_226
,      VAL_227
,      VAL_228
,      VAL_229
,      VAL_230
,      VAL_231
,      VAL_232
,      VAL_233
,      VAL_234
,      VAL_235
,      VAL_236
,      VAL_237
,      VAL_238
,      VAL_239
,      VAL_240
,      VAL_241
,      VAL_242
,      VAL_243
,      VAL_244
,      VAL_245
,      VAL_246
,      VAL_247
,      VAL_248
,      VAL_249
,      VAL_250
,      VAL_251
,      VAL_252
,      VAL_253
,      VAL_254
,      VAL_255
,      VAL_256
,      VAL_257
,      VAL_258
,      VAL_259
,      VAL_260
,      VAL_261
,      VAL_262
,      VAL_263
,      VAL_264
,      VAL_265
,      VAL_266
,      VAL_267
,      VAL_268
,      VAL_269
,      VAL_270
,      VAL_271
,      VAL_272
,      VAL_273
,      VAL_274
,      VAL_275
,      VAL_276
,      VAL_277
,      VAL_278
,      VAL_279
,      VAL_280
,      VAL_281
,      VAL_282
,      VAL_283
,      VAL_284
,      VAL_285
,      VAL_286
,      VAL_287
,      VAL_288
,      VAL_289
,      VAL_290
,      VAL_291
,      VAL_292
,      VAL_293
,      VAL_294
,      VAL_295
,      VAL_296
,      VAL_297
,      VAL_298
,      VAL_299
,      VAL_300
,      EXT_RCD_IN_FILE_ID
,      GROUP_VAL_01
,      GROUP_VAL_02
,      EXT_PER_BG_ID
FROM BEN.BEN_EXT_RSLT_DTL#;

Dependencies

[top of page]

BEN.BEN_EXT_RSLT_DTL# references the following:

SchemaBEN
TableBEN_EXT_RSLT_DTL
BEN.BEN_EXT_RSLT_DTL# is referenced by following:

SchemaAPPS
SynonymBEN_EXT_RSLT_DTL
TriggerBEN_EXT_RSLT_DTL_WHO