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

TABLE: EC.ECE_STAGE

Object Details
Object Name: ECE_STAGE
Object Type: TABLE
Owner: EC
FND Design Data: TableEC.ECE_STAGE
Subobject Name:
Status: VALID


This table is used for generic inbound and generic outbound
transactions to stage document data. For inbound processing,
documents are read from either a flat file or XML source and
inserted into this table. Rule validation, code conversion, and
other processing is done to the document in this table before
being inserted into the open interface table.

For outbound processing, this table is used for a storage
location before the data is written to the flat file or output
as an XML document.

This table contains columns FIELD1 through FIELD500. Each
of these columns maps to a specific column in a transaction
(for example, PO_NUMBER and CUSTOMER_NAME). The mapping
information is stored in the ECE_INTERFACE_COLUMN table.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 5
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ECE_STAGE_U1 NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnSTAGE_ID
ECE_STAGE_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnDOCUMENT_ID
Columns
Name Datatype Length Mandatory Comments
STAGE_ID NUMBER (15) Yes Staging Table ID
DOCUMENT_ID NUMBER (15) Yes Document ID
TRANSACTION_TYPE VARCHAR2 (10) Yes Transaction Type
TRANSACTION_LEVEL NUMBER (15) Yes Transaction Level
LINE_NUMBER NUMBER (15) Yes Line Number
PARENT_STAGE_ID NUMBER (15)
Parent Staging Table ID
RUN_ID NUMBER (15)
Request ID
DOCUMENT_NUMBER VARCHAR2 (500)
Document Number
STATUS VARCHAR2 (20)
Status of the Document in the Staging table
FIELD1 VARCHAR2 (500)
Staging field 1
FIELD2 VARCHAR2 (500)
Staging field 2
FIELD3 VARCHAR2 (500)
staging field 3
FIELD4 VARCHAR2 (500)
Staging field 4
FIELD5 VARCHAR2 (500)
Staging field 5
FIELD6 VARCHAR2 (500)
Staging field 6
FIELD7 VARCHAR2 (500)
Staging field 7
FIELD8 VARCHAR2 (500)
staging field 8
FIELD9 VARCHAR2 (500)
Staging field 9
FIELD10 VARCHAR2 (500)
Staging field 10
FIELD11 VARCHAR2 (500)
Staging field 11
FIELD12 VARCHAR2 (500)
Staging field 12
FIELD13 VARCHAR2 (500)
Staging field 13
FIELD14 VARCHAR2 (500)
Staging field 14
FIELD15 VARCHAR2 (500)
Staging field 15
FIELD16 VARCHAR2 (500)
Staging field 16
FIELD17 VARCHAR2 (500)
Staging field 17
FIELD18 VARCHAR2 (500)
Staging field 18
FIELD19 VARCHAR2 (500)
Staging field 19
FIELD20 VARCHAR2 (500)
Staging field 20
FIELD21 VARCHAR2 (500)
Staging field 21
FIELD22 VARCHAR2 (500)
Staging field 22
FIELD23 VARCHAR2 (500)
Staging field 23
FIELD24 VARCHAR2 (500)
Staging field 24
FIELD25 VARCHAR2 (500)
Staging field 25
FIELD26 VARCHAR2 (500)
Staging field 26
FIELD27 VARCHAR2 (500)
Staging field 27
FIELD28 VARCHAR2 (500)
Staging field 28
FIELD29 VARCHAR2 (500)
Staging field 29
FIELD30 VARCHAR2 (500)
Staging field 30
FIELD31 VARCHAR2 (500)
Staging field 31
FIELD32 VARCHAR2 (500)
Staging field 32
FIELD33 VARCHAR2 (500)
Staging field 33
FIELD34 VARCHAR2 (500)
Staging field 34
FIELD35 VARCHAR2 (500)
Staging field 35
FIELD36 VARCHAR2 (500)
Staging field 36
FIELD37 VARCHAR2 (500)
Staging field 37
FIELD38 VARCHAR2 (500)
Staging field 38
FIELD39 VARCHAR2 (500)
Staging field 39
FIELD40 VARCHAR2 (500)
Staging field 40
FIELD41 VARCHAR2 (500)
Staging field 41
FIELD42 VARCHAR2 (500)
Staging field 42
FIELD43 VARCHAR2 (500)
Staging field 43
FIELD44 VARCHAR2 (500)
Staging field 44
FIELD45 VARCHAR2 (500)
Staging field 45
FIELD46 VARCHAR2 (500)
Staging field 46
FIELD47 VARCHAR2 (500)
Staging field 47
FIELD48 VARCHAR2 (500)
Staging field 48
FIELD49 VARCHAR2 (500)
Staging field 49
FIELD50 VARCHAR2 (500)
Staging field 50
FIELD51 VARCHAR2 (500)
Staging field 51
FIELD52 VARCHAR2 (500)
Staging field 52
FIELD53 VARCHAR2 (500)
Staging field 53
FIELD54 VARCHAR2 (500)
Staging field 54
FIELD55 VARCHAR2 (500)
Staging field 55
FIELD56 VARCHAR2 (500)
Staging field 56
FIELD57 VARCHAR2 (500)
Staging field 57
FIELD58 VARCHAR2 (500)
Staging field 58
FIELD59 VARCHAR2 (500)
Staging field 59
FIELD60 VARCHAR2 (500)
Staging field 60
FIELD61 VARCHAR2 (500)
Staging field 61
FIELD62 VARCHAR2 (500)
Staging field 62
FIELD63 VARCHAR2 (500)
Staging field 63
FIELD64 VARCHAR2 (500)
Staging field 64
FIELD65 VARCHAR2 (500)
Staging field 65
FIELD66 VARCHAR2 (500)
Staging field 66
FIELD67 VARCHAR2 (500)
Staging field 67
FIELD68 VARCHAR2 (500)
Staging field 68
FIELD69 VARCHAR2 (500)
Staging field 69
FIELD70 VARCHAR2 (500)
Staging field 70
FIELD71 VARCHAR2 (500)
Staging field 71
FIELD72 VARCHAR2 (500)
Staging field 72
FIELD73 VARCHAR2 (500)
Staging field 73
FIELD74 VARCHAR2 (500)
Staging field 74
FIELD75 VARCHAR2 (500)
Staging field 75
FIELD76 VARCHAR2 (500)
Staging field 76
FIELD77 VARCHAR2 (500)
Staging field 77
FIELD78 VARCHAR2 (500)
Staging field 78
FIELD79 VARCHAR2 (500)
Staging field 79
FIELD80 VARCHAR2 (500)
Staging field 80
FIELD81 VARCHAR2 (500)
Staging field 81
FIELD82 VARCHAR2 (500)
Staging field 82
FIELD83 VARCHAR2 (500)
Staging field 83
FIELD84 VARCHAR2 (500)
Staging field 84
FIELD85 VARCHAR2 (500)
Staging field 85
FIELD86 VARCHAR2 (500)
Staging field 86
FIELD87 VARCHAR2 (500)
Staging field 87
FIELD88 VARCHAR2 (500)
Staging field 88
FIELD89 VARCHAR2 (500)
Staging field 89
FIELD90 VARCHAR2 (500)
Staging field 90
FIELD91 VARCHAR2 (500)
Staging field 91
FIELD92 VARCHAR2 (500)
Staging field 92
FIELD93 VARCHAR2 (500)
Staging field 93
FIELD94 VARCHAR2 (500)
Staging field 94
FIELD95 VARCHAR2 (500)
Staging field 95
FIELD96 VARCHAR2 (500)
Staging field 96
FIELD97 VARCHAR2 (500)
Staging field 97
FIELD98 VARCHAR2 (500)
Staging field 98
FIELD99 VARCHAR2 (500)
Staging field 99
FIELD100 VARCHAR2 (500)
Staging field 100
FIELD101 VARCHAR2 (500)
Staging field 101
FIELD102 VARCHAR2 (500)
Staging field 102
FIELD103 VARCHAR2 (500)
Staging field 103
FIELD104 VARCHAR2 (500)
Staging field 104
FIELD105 VARCHAR2 (500)
Staging field 105
FIELD106 VARCHAR2 (500)
Staging field 106
FIELD107 VARCHAR2 (500)
Staging field 107
FIELD108 VARCHAR2 (500)
Staging field 108
FIELD109 VARCHAR2 (500)
Staging field 109
FIELD110 VARCHAR2 (500)
Staging field 110
FIELD111 VARCHAR2 (500)
Staging field 111
FIELD112 VARCHAR2 (500)
Staging field 112
FIELD113 VARCHAR2 (500)
Staging field 113
FIELD114 VARCHAR2 (500)
Staging field 114
FIELD115 VARCHAR2 (500)
Staging field 115
FIELD116 VARCHAR2 (500)
Staging field 116
FIELD117 VARCHAR2 (500)
Staging field 117
FIELD118 VARCHAR2 (500)
Staging field 118
FIELD119 VARCHAR2 (500)
Staging field 119
FIELD120 VARCHAR2 (500)
Staging field 120
FIELD121 VARCHAR2 (500)
Staging field 121
FIELD122 VARCHAR2 (500)
Staging field 122
FIELD123 VARCHAR2 (500)
Staging field 123
FIELD124 VARCHAR2 (500)
Staging field 124
FIELD125 VARCHAR2 (500)
Staging field 125
FIELD126 VARCHAR2 (500)
Staging field 126
FIELD127 VARCHAR2 (500)
Staging field 127
FIELD128 VARCHAR2 (500)
Staging field 128
FIELD129 VARCHAR2 (500)
Staging field 129
FIELD130 VARCHAR2 (500)
Staging field 130
FIELD131 VARCHAR2 (500)
Staging field 131
FIELD132 VARCHAR2 (500)
Staging field 132
FIELD133 VARCHAR2 (500)
Staging field 133
FIELD134 VARCHAR2 (500)
Staging field 134
FIELD135 VARCHAR2 (500)
Staging field 135
FIELD136 VARCHAR2 (500)
Staging field 136
FIELD137 VARCHAR2 (500)
Staging field 137
FIELD138 VARCHAR2 (500)
Staging field 138
FIELD139 VARCHAR2 (500)
Staging field 139
FIELD140 VARCHAR2 (500)
Staging field 140
FIELD141 VARCHAR2 (500)
Staging field 141
FIELD142 VARCHAR2 (500)
Staging field 142
FIELD143 VARCHAR2 (500)
Staging field 143
FIELD144 VARCHAR2 (500)
Staging field 144
FIELD145 VARCHAR2 (500)
Staging field 145
FIELD146 VARCHAR2 (500)
Staging field 146
FIELD147 VARCHAR2 (500)
Staging field 147
FIELD148 VARCHAR2 (500)
Staging field 148
FIELD149 VARCHAR2 (500)
Staging field 149
FIELD150 VARCHAR2 (500)
Staging field 150
FIELD151 VARCHAR2 (500)
Staging field 151
FIELD152 VARCHAR2 (500)
Staging field 152
FIELD153 VARCHAR2 (500)
Staging field 153
FIELD154 VARCHAR2 (500)
Staging field 154
FIELD155 VARCHAR2 (500)
Staging field 155
FIELD156 VARCHAR2 (500)
Staging field 156
FIELD157 VARCHAR2 (500)
Staging field 157
FIELD158 VARCHAR2 (500)
Staging field 158
FIELD159 VARCHAR2 (500)
Staging field 159
FIELD160 VARCHAR2 (500)
Staging field 160
FIELD161 VARCHAR2 (500)
Staging field 161
FIELD162 VARCHAR2 (500)
Staging field 162
FIELD163 VARCHAR2 (500)
Staging field 163
FIELD164 VARCHAR2 (500)
Staging field 164
FIELD165 VARCHAR2 (500)
Staging field 165
FIELD166 VARCHAR2 (500)
Staging field 166
FIELD167 VARCHAR2 (500)
Staging field 167
FIELD168 VARCHAR2 (500)
Staging field 168
FIELD169 VARCHAR2 (500)
Staging field 169
FIELD170 VARCHAR2 (500)
Staging field 170
FIELD171 VARCHAR2 (500)
Staging field 171
FIELD172 VARCHAR2 (500)
Staging field 172
FIELD173 VARCHAR2 (500)
Staging field 173
FIELD174 VARCHAR2 (500)
Staging field 174
FIELD175 VARCHAR2 (500)
Staging field 175
FIELD176 VARCHAR2 (500)
Staging field 176
FIELD177 VARCHAR2 (500)
Staging field 177
FIELD178 VARCHAR2 (500)
Staging field 178
FIELD179 VARCHAR2 (500)
Staging field 179
FIELD180 VARCHAR2 (500)
Staging field 180
FIELD181 VARCHAR2 (500)
Staging field 181
FIELD182 VARCHAR2 (500)
Staging field 182
FIELD183 VARCHAR2 (500)
Staging field 183
FIELD184 VARCHAR2 (500)
Staging field 184
FIELD185 VARCHAR2 (500)
Staging field 185
FIELD186 VARCHAR2 (500)
Staging field 186
FIELD187 VARCHAR2 (500)
Staging field 187
FIELD188 VARCHAR2 (500)
Staging field 188
FIELD189 VARCHAR2 (500)
Staging field 189
FIELD190 VARCHAR2 (500)
Staging field 190
FIELD191 VARCHAR2 (500)
Staging field 191
FIELD192 VARCHAR2 (500)
Staging field 192
FIELD193 VARCHAR2 (500)
Staging field 193
FIELD194 VARCHAR2 (500)
Staging field 194
FIELD195 VARCHAR2 (500)
Staging field 195
FIELD196 VARCHAR2 (500)
Staging field 196
FIELD197 VARCHAR2 (500)
Staging field 197
FIELD198 VARCHAR2 (500)
Staging field 198
FIELD199 VARCHAR2 (500)
Staging field 199
FIELD200 VARCHAR2 (500)
Staging field 200
FIELD201 VARCHAR2 (500)
Staging field 201
FIELD202 VARCHAR2 (500)
Staging field 202
FIELD203 VARCHAR2 (500)
Staging field 203
FIELD204 VARCHAR2 (500)
Staging field 204
FIELD205 VARCHAR2 (500)
Staging field 205
FIELD206 VARCHAR2 (500)
Staging field 206
FIELD207 VARCHAR2 (500)
Staging field 207
FIELD208 VARCHAR2 (500)
Staging field 208
FIELD209 VARCHAR2 (500)
Staging field 209
FIELD210 VARCHAR2 (500)
Staging field 210
FIELD211 VARCHAR2 (500)
Staging field 211
FIELD212 VARCHAR2 (500)
Staging field 212
FIELD213 VARCHAR2 (500)
Staging field 213
FIELD214 VARCHAR2 (500)
Staging field 214
FIELD215 VARCHAR2 (500)
Staging field 215
FIELD216 VARCHAR2 (500)
Staging field 216
FIELD217 VARCHAR2 (500)
Staging field 217
FIELD218 VARCHAR2 (500)
Staging field 218
FIELD219 VARCHAR2 (500)
Staging field 219
FIELD220 VARCHAR2 (500)
Staging field 220
FIELD221 VARCHAR2 (500)
Staging field 221
FIELD222 VARCHAR2 (500)
Staging field 222
FIELD223 VARCHAR2 (500)
Staging field 223
FIELD224 VARCHAR2 (500)
Staging field 224
FIELD225 VARCHAR2 (500)
Staging field 225
FIELD226 VARCHAR2 (500)
Staging field 226
FIELD227 VARCHAR2 (500)
Staging field 227
FIELD228 VARCHAR2 (500)
Staging field 228
FIELD229 VARCHAR2 (500)
Staging field 229
FIELD230 VARCHAR2 (500)
Staging field 230
FIELD231 VARCHAR2 (500)
Staging field 231
FIELD232 VARCHAR2 (500)
Staging field 232
FIELD233 VARCHAR2 (500)
Staging field 233
FIELD234 VARCHAR2 (500)
Staging field 234
FIELD235 VARCHAR2 (500)
Staging field 235
FIELD236 VARCHAR2 (500)
Staging field 236
FIELD237 VARCHAR2 (500)
Staging field 237
FIELD238 VARCHAR2 (500)
Staging field 238
FIELD239 VARCHAR2 (500)
Staging field 239
FIELD240 VARCHAR2 (500)
Staging field 240
FIELD241 VARCHAR2 (500)
Staging field 241
FIELD242 VARCHAR2 (500)
Staging field 242
FIELD243 VARCHAR2 (500)
Staging field 243
FIELD244 VARCHAR2 (500)
Staging field 244
FIELD245 VARCHAR2 (500)
Staging field 245
FIELD246 VARCHAR2 (500)
Staging field 246
FIELD247 VARCHAR2 (500)
Staging field 247
FIELD248 VARCHAR2 (500)
Staging field 248
FIELD249 VARCHAR2 (500)
Staging field 249
FIELD250 VARCHAR2 (500)
Staging field 250
FIELD251 VARCHAR2 (500)
Staging field 251
FIELD252 VARCHAR2 (500)
Staging field 252
FIELD253 VARCHAR2 (500)
Staging field 253
FIELD254 VARCHAR2 (500)
Staging field 254
FIELD255 VARCHAR2 (500)
Staging field 255
FIELD256 VARCHAR2 (500)
Staging field 256
FIELD257 VARCHAR2 (500)
Staging field 257
FIELD258 VARCHAR2 (500)
Staging field 258
FIELD259 VARCHAR2 (500)
Staging field 259
FIELD260 VARCHAR2 (500)
Staging field 260
FIELD261 VARCHAR2 (500)
Staging field 261
FIELD262 VARCHAR2 (500)
Staging field 262
FIELD263 VARCHAR2 (500)
Staging field 263
FIELD264 VARCHAR2 (500)
Staging field 264
FIELD265 VARCHAR2 (500)
Staging field 265
FIELD266 VARCHAR2 (500)
Staging field 266
FIELD267 VARCHAR2 (500)
Staging field 267
FIELD268 VARCHAR2 (500)
Staging field 268
FIELD269 VARCHAR2 (500)
Staging field 269
FIELD270 VARCHAR2 (500)
Staging field 270
FIELD271 VARCHAR2 (500)
Staging field 271
FIELD272 VARCHAR2 (500)
Staging field 272
FIELD273 VARCHAR2 (500)
Staging field 273
FIELD274 VARCHAR2 (500)
Staging field 274
FIELD275 VARCHAR2 (500)
Staging field 275
FIELD276 VARCHAR2 (500)
Staging field 276
FIELD277 VARCHAR2 (500)
Staging field 277
FIELD278 VARCHAR2 (500)
Staging field 278
FIELD279 VARCHAR2 (500)
Staging field 279
FIELD280 VARCHAR2 (500)
Staging field 280
FIELD281 VARCHAR2 (500)
Staging field 281
FIELD282 VARCHAR2 (500)
Staging field 282
FIELD283 VARCHAR2 (500)
Staging field 283
FIELD284 VARCHAR2 (500)
Staging field 284
FIELD285 VARCHAR2 (500)
Staging field 285
FIELD286 VARCHAR2 (500)
Staging field 286
FIELD287 VARCHAR2 (500)
Staging field 287
FIELD288 VARCHAR2 (500)
Staging field 288
FIELD289 VARCHAR2 (500)
Staging field 289
FIELD290 VARCHAR2 (500)
Staging field 290
FIELD291 VARCHAR2 (500)
Staging field 291
FIELD292 VARCHAR2 (500)
Staging field 292
FIELD293 VARCHAR2 (500)
Staging field 293
FIELD294 VARCHAR2 (500)
Staging field 294
FIELD295 VARCHAR2 (500)
Staging field 295
FIELD296 VARCHAR2 (500)
Staging field 296
FIELD297 VARCHAR2 (500)
Staging field 297
FIELD298 VARCHAR2 (500)
Staging field 298
FIELD299 VARCHAR2 (500)
Staging field 299
FIELD300 VARCHAR2 (500)
Staging field 300
FIELD301 VARCHAR2 (500)
Staging field 301
FIELD302 VARCHAR2 (500)
Staging field 302
FIELD303 VARCHAR2 (500)
Staging field 303
FIELD304 VARCHAR2 (500)
Staging field 304
FIELD305 VARCHAR2 (500)
Staging field 305
FIELD306 VARCHAR2 (500)
Staging field 306
FIELD307 VARCHAR2 (500)
Staging field 307
FIELD308 VARCHAR2 (500)
Staging field 308
FIELD309 VARCHAR2 (500)
Staging field 309
FIELD310 VARCHAR2 (500)
Staging field 310
FIELD311 VARCHAR2 (500)
Staging field 311
FIELD312 VARCHAR2 (500)
Staging field 312
FIELD313 VARCHAR2 (500)
Staging field 313
FIELD314 VARCHAR2 (500)
Staging field 314
FIELD315 VARCHAR2 (500)
Staging field 315
FIELD316 VARCHAR2 (500)
Staging field 316
FIELD317 VARCHAR2 (500)
Staging field 317
FIELD318 VARCHAR2 (500)
Staging field 318
FIELD319 VARCHAR2 (500)
Staging field 319
FIELD320 VARCHAR2 (500)
Staging field 320
FIELD321 VARCHAR2 (500)
Staging field 321
FIELD322 VARCHAR2 (500)
Staging field 322
FIELD323 VARCHAR2 (500)
Staging field 323
FIELD324 VARCHAR2 (500)
Staging field 324
FIELD325 VARCHAR2 (500)
Staging field 325
FIELD326 VARCHAR2 (500)
Staging field 326
FIELD327 VARCHAR2 (500)
Staging field 327
FIELD328 VARCHAR2 (500)
Staging field 328
FIELD329 VARCHAR2 (500)
Staging field 329
FIELD330 VARCHAR2 (500)
Staging field 330
FIELD331 VARCHAR2 (500)
Staging field 331
FIELD332 VARCHAR2 (500)
Staging field 332
FIELD333 VARCHAR2 (500)
Staging field 333
FIELD334 VARCHAR2 (500)
Staging field 334
FIELD335 VARCHAR2 (500)
Staging field 335
FIELD336 VARCHAR2 (500)
Staging field 336
FIELD337 VARCHAR2 (500)
Staging field 337
FIELD338 VARCHAR2 (500)
Staging field 338
FIELD339 VARCHAR2 (500)
Staging field 339
FIELD340 VARCHAR2 (500)
Staging field 340
FIELD341 VARCHAR2 (500)
Staging field 341
FIELD342 VARCHAR2 (500)
Staging field 342
FIELD343 VARCHAR2 (500)
Staging field 343
FIELD344 VARCHAR2 (500)
Staging field 344
FIELD345 VARCHAR2 (500)
Staging field 345
FIELD346 VARCHAR2 (500)
Staging field 346
FIELD347 VARCHAR2 (500)
Staging field 347
FIELD348 VARCHAR2 (500)
Staging field 348
FIELD349 VARCHAR2 (500)
Staging field 349
FIELD350 VARCHAR2 (500)
Staging field 350
FIELD351 VARCHAR2 (500)
Staging field 351
FIELD352 VARCHAR2 (500)
Staging field 352
FIELD353 VARCHAR2 (500)
Staging field 353
FIELD354 VARCHAR2 (500)
Staging field 354
FIELD355 VARCHAR2 (500)
Staging field 355
FIELD356 VARCHAR2 (500)
Staging field 356
FIELD357 VARCHAR2 (500)
Staging field 357
FIELD358 VARCHAR2 (500)
Staging field 358
FIELD359 VARCHAR2 (500)
Staging field 359
FIELD360 VARCHAR2 (500)
Staging field 360
FIELD361 VARCHAR2 (500)
Staging field 361
FIELD362 VARCHAR2 (500)
Staging field 362
FIELD363 VARCHAR2 (500)
Staging field 363
FIELD364 VARCHAR2 (500)
Staging field 364
FIELD365 VARCHAR2 (500)
Staging field 365
FIELD366 VARCHAR2 (500)
Staging field 366
FIELD367 VARCHAR2 (500)
Staging field 367
FIELD368 VARCHAR2 (500)
Staging field 368
FIELD369 VARCHAR2 (500)
Staging field 369
FIELD370 VARCHAR2 (500)
Staging field 370
FIELD371 VARCHAR2 (500)
Staging field 371
FIELD372 VARCHAR2 (500)
Staging field 372
FIELD373 VARCHAR2 (500)
Staging field 373
FIELD374 VARCHAR2 (500)
Staging field 374
FIELD375 VARCHAR2 (500)
Staging field 375
FIELD376 VARCHAR2 (500)
Staging field 376
FIELD377 VARCHAR2 (500)
Staging field 377
FIELD378 VARCHAR2 (500)
Staging field 378
FIELD379 VARCHAR2 (500)
Staging field 379
FIELD380 VARCHAR2 (500)
Staging field 380
FIELD381 VARCHAR2 (500)
Staging field 381
FIELD382 VARCHAR2 (500)
Staging field 382
FIELD383 VARCHAR2 (500)
Staging field 383
FIELD384 VARCHAR2 (500)
Staging field 384
FIELD385 VARCHAR2 (500)
Staging field 385
FIELD386 VARCHAR2 (500)
Staging field 386
FIELD387 VARCHAR2 (500)
Staging field 387
FIELD388 VARCHAR2 (500)
Staging field 388
FIELD389 VARCHAR2 (500)
Staging field 389
FIELD390 VARCHAR2 (500)
Staging field 390
FIELD391 VARCHAR2 (500)
Staging field 391
FIELD392 VARCHAR2 (500)
Staging field 392
FIELD393 VARCHAR2 (500)
Staging field 393
FIELD394 VARCHAR2 (500)
Staging field 394
FIELD395 VARCHAR2 (500)
Staging field 395
FIELD396 VARCHAR2 (500)
Staging field 396
FIELD397 VARCHAR2 (500)
Staging field 397
FIELD398 VARCHAR2 (500)
Staging field 398
FIELD399 VARCHAR2 (500)
Staging field 399
FIELD400 VARCHAR2 (500)
Staging field 400
FIELD401 VARCHAR2 (500)
Staging field 401
FIELD402 VARCHAR2 (500)
Staging field 402
FIELD403 VARCHAR2 (500)
Staging field 403
FIELD404 VARCHAR2 (500)
Staging field 404
FIELD405 VARCHAR2 (500)
Staging field 405
FIELD406 VARCHAR2 (500)
Staging field 406
FIELD407 VARCHAR2 (500)
Staging field 407
FIELD408 VARCHAR2 (500)
Staging field 408
FIELD409 VARCHAR2 (500)
Staging field 409
FIELD410 VARCHAR2 (500)
Staging field 410
FIELD411 VARCHAR2 (500)
Staging field 411
FIELD412 VARCHAR2 (500)
Staging field 412
FIELD413 VARCHAR2 (500)
Staging field 413
FIELD414 VARCHAR2 (500)
Staging field 414
FIELD415 VARCHAR2 (500)
Staging field 415
FIELD416 VARCHAR2 (500)
Staging field 416
FIELD417 VARCHAR2 (500)
Staging field 417
FIELD418 VARCHAR2 (500)
Staging field 418
FIELD419 VARCHAR2 (500)
Staging field 419
FIELD420 VARCHAR2 (500)
Staging field 420
FIELD421 VARCHAR2 (500)
Staging field 421
FIELD422 VARCHAR2 (500)
Staging field 422
FIELD423 VARCHAR2 (500)
Staging field 423
FIELD424 VARCHAR2 (500)
Staging field 424
FIELD425 VARCHAR2 (500)
Staging field 425
FIELD426 VARCHAR2 (500)
Staging field 426
FIELD427 VARCHAR2 (500)
Staging field 427
FIELD428 VARCHAR2 (500)
Staging field 428
FIELD429 VARCHAR2 (500)
Staging field 429
FIELD430 VARCHAR2 (500)
Staging field 430
FIELD431 VARCHAR2 (500)
Staging field 431
FIELD432 VARCHAR2 (500)
Staging field 432
FIELD433 VARCHAR2 (500)
Staging field 433
FIELD434 VARCHAR2 (500)
Staging field 434
FIELD435 VARCHAR2 (500)
Staging field 435
FIELD436 VARCHAR2 (500)
Staging field 436
FIELD437 VARCHAR2 (500)
Staging field 437
FIELD438 VARCHAR2 (500)
Staging field 438
FIELD439 VARCHAR2 (500)
Staging field 439
FIELD440 VARCHAR2 (500)
Staging field 440
FIELD441 VARCHAR2 (500)
Staging field 441
FIELD442 VARCHAR2 (500)
Staging field 442
FIELD443 VARCHAR2 (500)
Staging field 443
FIELD444 VARCHAR2 (500)
Staging field 444
FIELD445 VARCHAR2 (500)
Staging field 445
FIELD446 VARCHAR2 (500)
Staging field 446
FIELD447 VARCHAR2 (500)
Staging field 447
FIELD448 VARCHAR2 (500)
Staging field 448
FIELD449 VARCHAR2 (500)
Staging field 449
FIELD450 VARCHAR2 (500)
Staging field 450
FIELD451 VARCHAR2 (500)
Staging field 451
FIELD452 VARCHAR2 (500)
Staging field 452
FIELD453 VARCHAR2 (500)
Staging field 453
FIELD454 VARCHAR2 (500)
Staging field 454
FIELD455 VARCHAR2 (500)
Staging field 455
FIELD456 VARCHAR2 (500)
Staging field 456
FIELD457 VARCHAR2 (500)
Staging field 457
FIELD458 VARCHAR2 (500)
Staging field 458
FIELD459 VARCHAR2 (500)
Staging field 459
FIELD460 VARCHAR2 (500)
Staging field 460
FIELD461 VARCHAR2 (500)
Staging field 461
FIELD462 VARCHAR2 (500)
Staging field 462
FIELD463 VARCHAR2 (500)
Staging field 463
FIELD464 VARCHAR2 (500)
Staging field 464
FIELD465 VARCHAR2 (500)
Staging field 465
FIELD466 VARCHAR2 (500)
Staging field 466
FIELD467 VARCHAR2 (500)
Staging field 467
FIELD468 VARCHAR2 (500)
Staging field 468
FIELD469 VARCHAR2 (500)
Staging field 469
FIELD470 VARCHAR2 (500)
Staging field 470
FIELD471 VARCHAR2 (500)
Staging field 471
FIELD472 VARCHAR2 (500)
Staging field 472
FIELD473 VARCHAR2 (500)
Staging field 473
FIELD474 VARCHAR2 (500)
Staging field 474
FIELD475 VARCHAR2 (500)
Staging field 475
FIELD476 VARCHAR2 (500)
Staging field 476
FIELD477 VARCHAR2 (500)
Staging field 477
FIELD478 VARCHAR2 (500)
Staging field 478
FIELD479 VARCHAR2 (500)
Staging field 479
FIELD480 VARCHAR2 (500)
Staging field 480
FIELD481 VARCHAR2 (500)
Staging field 481
FIELD482 VARCHAR2 (500)
Staging field 482
FIELD483 VARCHAR2 (500)
Staging field 483
FIELD484 VARCHAR2 (500)
Staging field 484
FIELD485 VARCHAR2 (500)
Staging field 485
FIELD486 VARCHAR2 (500)
Staging field 486
FIELD487 VARCHAR2 (500)
Staging field 487
FIELD488 VARCHAR2 (500)
Staging field 488
FIELD489 VARCHAR2 (500)
Staging field 489
FIELD490 VARCHAR2 (500)
Staging field 490
FIELD491 VARCHAR2 (500)
Staging field 491
FIELD492 VARCHAR2 (500)
Staging field 492
FIELD493 VARCHAR2 (500)
Staging field 493
FIELD494 VARCHAR2 (500)
Staging field 494
FIELD495 VARCHAR2 (500)
Staging field 495
FIELD496 VARCHAR2 (500)
Staging field 496
FIELD497 VARCHAR2 (500)
Staging field 497
FIELD498 VARCHAR2 (500)
Staging field 498
FIELD499 VARCHAR2 (500)
Staging field 499
FIELD500 VARCHAR2 (500)
Standard Who Column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
REQUEST_ID NUMBER

Standard Who column
PROGRAM_APPLICATION_ID NUMBER

Standard Who column
PROGRAM_UPDATE_DATE DATE

Standard Who column
TP_CODE VARCHAR2 (80)
Trading Partner Code
MAP_ID NUMBER

Transaction Map ID
Query Text

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


SELECT STAGE_ID
,      DOCUMENT_ID
,      TRANSACTION_TYPE
,      TRANSACTION_LEVEL
,      LINE_NUMBER
,      PARENT_STAGE_ID
,      RUN_ID
,      DOCUMENT_NUMBER
,      STATUS
,      FIELD1
,      FIELD2
,      FIELD3
,      FIELD4
,      FIELD5
,      FIELD6
,      FIELD7
,      FIELD8
,      FIELD9
,      FIELD10
,      FIELD11
,      FIELD12
,      FIELD13
,      FIELD14
,      FIELD15
,      FIELD16
,      FIELD17
,      FIELD18
,      FIELD19
,      FIELD20
,      FIELD21
,      FIELD22
,      FIELD23
,      FIELD24
,      FIELD25
,      FIELD26
,      FIELD27
,      FIELD28
,      FIELD29
,      FIELD30
,      FIELD31
,      FIELD32
,      FIELD33
,      FIELD34
,      FIELD35
,      FIELD36
,      FIELD37
,      FIELD38
,      FIELD39
,      FIELD40
,      FIELD41
,      FIELD42
,      FIELD43
,      FIELD44
,      FIELD45
,      FIELD46
,      FIELD47
,      FIELD48
,      FIELD49
,      FIELD50
,      FIELD51
,      FIELD52
,      FIELD53
,      FIELD54
,      FIELD55
,      FIELD56
,      FIELD57
,      FIELD58
,      FIELD59
,      FIELD60
,      FIELD61
,      FIELD62
,      FIELD63
,      FIELD64
,      FIELD65
,      FIELD66
,      FIELD67
,      FIELD68
,      FIELD69
,      FIELD70
,      FIELD71
,      FIELD72
,      FIELD73
,      FIELD74
,      FIELD75
,      FIELD76
,      FIELD77
,      FIELD78
,      FIELD79
,      FIELD80
,      FIELD81
,      FIELD82
,      FIELD83
,      FIELD84
,      FIELD85
,      FIELD86
,      FIELD87
,      FIELD88
,      FIELD89
,      FIELD90
,      FIELD91
,      FIELD92
,      FIELD93
,      FIELD94
,      FIELD95
,      FIELD96
,      FIELD97
,      FIELD98
,      FIELD99
,      FIELD100
,      FIELD101
,      FIELD102
,      FIELD103
,      FIELD104
,      FIELD105
,      FIELD106
,      FIELD107
,      FIELD108
,      FIELD109
,      FIELD110
,      FIELD111
,      FIELD112
,      FIELD113
,      FIELD114
,      FIELD115
,      FIELD116
,      FIELD117
,      FIELD118
,      FIELD119
,      FIELD120
,      FIELD121
,      FIELD122
,      FIELD123
,      FIELD124
,      FIELD125
,      FIELD126
,      FIELD127
,      FIELD128
,      FIELD129
,      FIELD130
,      FIELD131
,      FIELD132
,      FIELD133
,      FIELD134
,      FIELD135
,      FIELD136
,      FIELD137
,      FIELD138
,      FIELD139
,      FIELD140
,      FIELD141
,      FIELD142
,      FIELD143
,      FIELD144
,      FIELD145
,      FIELD146
,      FIELD147
,      FIELD148
,      FIELD149
,      FIELD150
,      FIELD151
,      FIELD152
,      FIELD153
,      FIELD154
,      FIELD155
,      FIELD156
,      FIELD157
,      FIELD158
,      FIELD159
,      FIELD160
,      FIELD161
,      FIELD162
,      FIELD163
,      FIELD164
,      FIELD165
,      FIELD166
,      FIELD167
,      FIELD168
,      FIELD169
,      FIELD170
,      FIELD171
,      FIELD172
,      FIELD173
,      FIELD174
,      FIELD175
,      FIELD176
,      FIELD177
,      FIELD178
,      FIELD179
,      FIELD180
,      FIELD181
,      FIELD182
,      FIELD183
,      FIELD184
,      FIELD185
,      FIELD186
,      FIELD187
,      FIELD188
,      FIELD189
,      FIELD190
,      FIELD191
,      FIELD192
,      FIELD193
,      FIELD194
,      FIELD195
,      FIELD196
,      FIELD197
,      FIELD198
,      FIELD199
,      FIELD200
,      FIELD201
,      FIELD202
,      FIELD203
,      FIELD204
,      FIELD205
,      FIELD206
,      FIELD207
,      FIELD208
,      FIELD209
,      FIELD210
,      FIELD211
,      FIELD212
,      FIELD213
,      FIELD214
,      FIELD215
,      FIELD216
,      FIELD217
,      FIELD218
,      FIELD219
,      FIELD220
,      FIELD221
,      FIELD222
,      FIELD223
,      FIELD224
,      FIELD225
,      FIELD226
,      FIELD227
,      FIELD228
,      FIELD229
,      FIELD230
,      FIELD231
,      FIELD232
,      FIELD233
,      FIELD234
,      FIELD235
,      FIELD236
,      FIELD237
,      FIELD238
,      FIELD239
,      FIELD240
,      FIELD241
,      FIELD242
,      FIELD243
,      FIELD244
,      FIELD245
,      FIELD246
,      FIELD247
,      FIELD248
,      FIELD249
,      FIELD250
,      FIELD251
,      FIELD252
,      FIELD253
,      FIELD254
,      FIELD255
,      FIELD256
,      FIELD257
,      FIELD258
,      FIELD259
,      FIELD260
,      FIELD261
,      FIELD262
,      FIELD263
,      FIELD264
,      FIELD265
,      FIELD266
,      FIELD267
,      FIELD268
,      FIELD269
,      FIELD270
,      FIELD271
,      FIELD272
,      FIELD273
,      FIELD274
,      FIELD275
,      FIELD276
,      FIELD277
,      FIELD278
,      FIELD279
,      FIELD280
,      FIELD281
,      FIELD282
,      FIELD283
,      FIELD284
,      FIELD285
,      FIELD286
,      FIELD287
,      FIELD288
,      FIELD289
,      FIELD290
,      FIELD291
,      FIELD292
,      FIELD293
,      FIELD294
,      FIELD295
,      FIELD296
,      FIELD297
,      FIELD298
,      FIELD299
,      FIELD300
,      FIELD301
,      FIELD302
,      FIELD303
,      FIELD304
,      FIELD305
,      FIELD306
,      FIELD307
,      FIELD308
,      FIELD309
,      FIELD310
,      FIELD311
,      FIELD312
,      FIELD313
,      FIELD314
,      FIELD315
,      FIELD316
,      FIELD317
,      FIELD318
,      FIELD319
,      FIELD320
,      FIELD321
,      FIELD322
,      FIELD323
,      FIELD324
,      FIELD325
,      FIELD326
,      FIELD327
,      FIELD328
,      FIELD329
,      FIELD330
,      FIELD331
,      FIELD332
,      FIELD333
,      FIELD334
,      FIELD335
,      FIELD336
,      FIELD337
,      FIELD338
,      FIELD339
,      FIELD340
,      FIELD341
,      FIELD342
,      FIELD343
,      FIELD344
,      FIELD345
,      FIELD346
,      FIELD347
,      FIELD348
,      FIELD349
,      FIELD350
,      FIELD351
,      FIELD352
,      FIELD353
,      FIELD354
,      FIELD355
,      FIELD356
,      FIELD357
,      FIELD358
,      FIELD359
,      FIELD360
,      FIELD361
,      FIELD362
,      FIELD363
,      FIELD364
,      FIELD365
,      FIELD366
,      FIELD367
,      FIELD368
,      FIELD369
,      FIELD370
,      FIELD371
,      FIELD372
,      FIELD373
,      FIELD374
,      FIELD375
,      FIELD376
,      FIELD377
,      FIELD378
,      FIELD379
,      FIELD380
,      FIELD381
,      FIELD382
,      FIELD383
,      FIELD384
,      FIELD385
,      FIELD386
,      FIELD387
,      FIELD388
,      FIELD389
,      FIELD390
,      FIELD391
,      FIELD392
,      FIELD393
,      FIELD394
,      FIELD395
,      FIELD396
,      FIELD397
,      FIELD398
,      FIELD399
,      FIELD400
,      FIELD401
,      FIELD402
,      FIELD403
,      FIELD404
,      FIELD405
,      FIELD406
,      FIELD407
,      FIELD408
,      FIELD409
,      FIELD410
,      FIELD411
,      FIELD412
,      FIELD413
,      FIELD414
,      FIELD415
,      FIELD416
,      FIELD417
,      FIELD418
,      FIELD419
,      FIELD420
,      FIELD421
,      FIELD422
,      FIELD423
,      FIELD424
,      FIELD425
,      FIELD426
,      FIELD427
,      FIELD428
,      FIELD429
,      FIELD430
,      FIELD431
,      FIELD432
,      FIELD433
,      FIELD434
,      FIELD435
,      FIELD436
,      FIELD437
,      FIELD438
,      FIELD439
,      FIELD440
,      FIELD441
,      FIELD442
,      FIELD443
,      FIELD444
,      FIELD445
,      FIELD446
,      FIELD447
,      FIELD448
,      FIELD449
,      FIELD450
,      FIELD451
,      FIELD452
,      FIELD453
,      FIELD454
,      FIELD455
,      FIELD456
,      FIELD457
,      FIELD458
,      FIELD459
,      FIELD460
,      FIELD461
,      FIELD462
,      FIELD463
,      FIELD464
,      FIELD465
,      FIELD466
,      FIELD467
,      FIELD468
,      FIELD469
,      FIELD470
,      FIELD471
,      FIELD472
,      FIELD473
,      FIELD474
,      FIELD475
,      FIELD476
,      FIELD477
,      FIELD478
,      FIELD479
,      FIELD480
,      FIELD481
,      FIELD482
,      FIELD483
,      FIELD484
,      FIELD485
,      FIELD486
,      FIELD487
,      FIELD488
,      FIELD489
,      FIELD490
,      FIELD491
,      FIELD492
,      FIELD493
,      FIELD494
,      FIELD495
,      FIELD496
,      FIELD497
,      FIELD498
,      FIELD499
,      FIELD500
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      TP_CODE
,      MAP_ID
FROM EC.ECE_STAGE;

Dependencies

[top of page]

EC.ECE_STAGE does not reference any database object

EC.ECE_STAGE is referenced by following:

SchemaAPPS
SynonymECE_STAGE