VIEW: ICX.ICX_POR_UPLOAD_IT_DUMP#

Source

View Text - Preformatted

select JOB_NUMBER JOB_NUMBER, PRICE_BREAK_ID PRICE_BREAK_ID, PRICE_BREAK_COUNT PRICE_BREAK_COUNT, BEGINDATE BEGINDATE, ENDDATE ENDDATE, LINE_NUMBER LINE_NUMBER, ROW_TYPE ROW_TYPE, LANGUAGE LANGUAGE, ACTION ACTION, SYSTEM_ACTION SYSTEM_ACTION, ERROR_FLAG ERROR_FLAG, ERROR_MESSAGE ERROR_MESSAGE, CATEGORY_NAME CATEGORY_NAME, CATEGORY_KEY CATEGORY_KEY, SUPPLIER_NAME SUPPLIER_NAME, SUPPLIER_PART_NUM SUPPLIER_PART_NUM, DESCRIPTION DESCRIPTION, UNSPSC_CODE UNSPSC_CODE, ITEM_TYPE ITEM_TYPE, OWNER_NAME OWNER_NAME, RT_CATEGORY_ID RT_CATEGORY_ID, OLD_CATEGORY_ID OLD_CATEGORY_ID, RT_ITEM_ID RT_ITEM_ID, UNPUBLISHED_ITEM_ID UNPUBLISHED_ITEM_ID, UNPUBLISHED_CATEGORY_ID UNPUBLISHED_CATEGORY_ID, SUPPLIER_ID SUPPLIER_ID, OWNER_ID OWNER_ID, BUYER_ID BUYER_ID, PRICELIST_ID PRICELIST_ID, PRICELINE_ROWID PRICELINE_ROWID, UNAPPROVED_PRICELINE_ROWID UNAPPROVED_PRICELINE_ROWID, UOM_NAME UOM_NAME, BUYER_NAME BUYER_NAME, PRICE_STRING PRICE_STRING, PRICELIST_NAME PRICELIST_NAME, CURRENCY_CODE CURRENCY_CODE, UOM_CODE UOM_CODE, PRICE_CODE PRICE_CODE, SUPPLIER_COMMENTS SUPPLIER_COMMENTS, REQUIRED_DESCRIPTORS REQUIRED_DESCRIPTORS, REQUIRED_TL_DESCRIPTORS REQUIRED_TL_DESCRIPTORS, ROOT1 ROOT1, ROOT2 ROOT2, ROOT3 ROOT3, ROOT4 ROOT4, ROOT5 ROOT5, ROOT6 ROOT6, ROOT7 ROOT7, ROOT8 ROOT8, ROOT9 ROOT9, ROOT10 ROOT10, ROOT11 ROOT11, ROOT12 ROOT12, ROOT13 ROOT13, ROOT14 ROOT14, ROOT15 ROOT15, ROOT16 ROOT16, ROOT17 ROOT17, ROOT18 ROOT18, ROOT19 ROOT19, ROOT20 ROOT20, ROOT21 ROOT21, ROOT22 ROOT22, ROOT23 ROOT23, ROOT24 ROOT24, ROOT25 ROOT25, ROOT26 ROOT26, ROOT27 ROOT27, ROOT28 ROOT28, ROOT29 ROOT29, ROOT30 ROOT30, ROOT31 ROOT31, ROOT32 ROOT32, ROOT33 ROOT33, ROOT34 ROOT34, ROOT35 ROOT35, ROOT36 ROOT36, ROOT37 ROOT37, ROOT38 ROOT38, ROOT39 ROOT39, ROOT40 ROOT40, ROOT41 ROOT41, ROOT42 ROOT42, ROOT43 ROOT43, ROOT44 ROOT44, ROOT45 ROOT45, ROOT46 ROOT46, ROOT47 ROOT47, ROOT48 ROOT48, ROOT49 ROOT49, ROOT50 ROOT50, ROOT51 ROOT51, ROOT52 ROOT52, ROOT53 ROOT53, ROOT54 ROOT54, ROOT55 ROOT55, ROOT56 ROOT56, ROOT57 ROOT57, ROOT58 ROOT58, ROOT59 ROOT59, ROOT60 ROOT60, ROOT61 ROOT61, ROOT62 ROOT62, ROOT63 ROOT63, ROOT64 ROOT64, ROOT65 ROOT65, ROOT66 ROOT66, ROOT67 ROOT67, ROOT68 ROOT68, ROOT69 ROOT69, ROOT70 ROOT70, ROOT71 ROOT71, ROOT72 ROOT72, ROOT73 ROOT73, ROOT74 ROOT74, ROOT75 ROOT75, ROOT76 ROOT76, ROOT77 ROOT77, ROOT78 ROOT78, ROOT79 ROOT79, ROOT80 ROOT80, ROOT81 ROOT81, ROOT82 ROOT82, ROOT83 ROOT83, ROOT84 ROOT84, ROOT85 ROOT85, ROOT86 ROOT86, ROOT87 ROOT87, ROOT88 ROOT88, ROOT89 ROOT89, ROOT90 ROOT90, ROOT91 ROOT91, ROOT92 ROOT92, ROOT93 ROOT93, ROOT94 ROOT94, ROOT95 ROOT95, ROOT96 ROOT96, ROOT97 ROOT97, ROOT98 ROOT98, ROOT99 ROOT99, ROOT100 ROOT100, ROOT101 ROOT101, ROOT102 ROOT102, ROOT103 ROOT103, ROOT104 ROOT104, ROOT105 ROOT105, ROOT106 ROOT106, ROOT107 ROOT107, ROOT108 ROOT108, ROOT109 ROOT109, ROOT110 ROOT110, ROOT111 ROOT111, ROOT112 ROOT112, ROOT113 ROOT113, ROOT114 ROOT114, ROOT115 ROOT115, ROOT116 ROOT116, ROOT117 ROOT117, ROOT118 ROOT118, ROOT119 ROOT119, ROOT120 ROOT120, ROOT121 ROOT121, ROOT122 ROOT122, ROOT123 ROOT123, ROOT124 ROOT124, ROOT125 ROOT125, ROOT126 ROOT126, ROOT127 ROOT127, ROOT128 ROOT128, ROOT129 ROOT129, ROOT130 ROOT130, ROOT131 ROOT131, ROOT132 ROOT132, ROOT133 ROOT133, ROOT134 ROOT134, ROOT135 ROOT135, ROOT136 ROOT136, ROOT137 ROOT137, ROOT138 ROOT138, ROOT139 ROOT139, ROOT140 ROOT140, ROOT141 ROOT141, ROOT142 ROOT142, ROOT143 ROOT143, ROOT144 ROOT144, ROOT145 ROOT145, ROOT146 ROOT146, ROOT147 ROOT147, ROOT148 ROOT148, ROOT149 ROOT149, ROOT150 ROOT150, ROOT151 ROOT151, ROOT152 ROOT152, ROOT153 ROOT153, ROOT154 ROOT154, ROOT155 ROOT155, ROOT156 ROOT156, ROOT157 ROOT157, ROOT158 ROOT158, ROOT159 ROOT159, ROOT160 ROOT160, ROOT161 ROOT161, ROOT162 ROOT162, ROOT163 ROOT163, ROOT164 ROOT164, ROOT165 ROOT165, ROOT166 ROOT166, ROOT167 ROOT167, ROOT168 ROOT168, ROOT169 ROOT169, ROOT170 ROOT170, ROOT171 ROOT171, ROOT172 ROOT172, ROOT173 ROOT173, ROOT174 ROOT174, ROOT175 ROOT175, ROOT176 ROOT176, ROOT177 ROOT177, ROOT178 ROOT178, ROOT179 ROOT179, ROOT180 ROOT180, ROOT181 ROOT181, ROOT182 ROOT182, ROOT183 ROOT183, ROOT184 ROOT184, ROOT185 ROOT185, ROOT186 ROOT186, ROOT187 ROOT187, ROOT188 ROOT188, ROOT189 ROOT189, ROOT190 ROOT190, ROOT191 ROOT191, ROOT192 ROOT192, ROOT193 ROOT193, ROOT194 ROOT194, ROOT195 ROOT195, ROOT196 ROOT196, ROOT197 ROOT197, ROOT198 ROOT198, ROOT199 ROOT199, ROOT200 ROOT200, ROOT201 ROOT201, ROOT202 ROOT202, ROOT203 ROOT203, ROOT204 ROOT204, ROOT205 ROOT205, ROOT206 ROOT206, ROOT207 ROOT207, ROOT208 ROOT208, ROOT209 ROOT209, ROOT210 ROOT210, ROOT211 ROOT211, ROOT212 ROOT212, ROOT213 ROOT213, ROOT214 ROOT214, ROOT215 ROOT215, ROOT216 ROOT216, ROOT217 ROOT217, ROOT218 ROOT218, ROOT219 ROOT219, ROOT220 ROOT220, ROOT221 ROOT221, ROOT222 ROOT222, ROOT223 ROOT223, ROOT224 ROOT224, ROOT225 ROOT225, ROOT226 ROOT226, ROOT227 ROOT227, ROOT228 ROOT228, ROOT229 ROOT229, ROOT230 ROOT230, ROOT231 ROOT231, ROOT232 ROOT232, ROOT233 ROOT233, ROOT234 ROOT234, ROOT235 ROOT235, ROOT236 ROOT236, ROOT237 ROOT237, ROOT238 ROOT238, ROOT239 ROOT239, ROOT240 ROOT240, ROOT241 ROOT241, ROOT242 ROOT242, ROOT243 ROOT243, ROOT244 ROOT244, ROOT245 ROOT245, ROOT246 ROOT246, ROOT247 ROOT247, ROOT248 ROOT248, ROOT249 ROOT249, ROOT250 ROOT250, LOCAL1 LOCAL1, LOCAL2 LOCAL2, LOCAL3 LOCAL3, LOCAL4 LOCAL4, LOCAL5 LOCAL5, LOCAL6 LOCAL6, LOCAL7 LOCAL7, LOCAL8 LOCAL8, LOCAL9 LOCAL9, LOCAL10 LOCAL10, LOCAL11 LOCAL11, LOCAL12 LOCAL12, LOCAL13 LOCAL13, LOCAL14 LOCAL14, LOCAL15 LOCAL15, LOCAL16 LOCAL16, LOCAL17 LOCAL17, LOCAL18 LOCAL18, LOCAL19 LOCAL19, LOCAL20 LOCAL20, LOCAL21 LOCAL21, LOCAL22 LOCAL22, LOCAL23 LOCAL23, LOCAL24 LOCAL24, LOCAL25 LOCAL25, LOCAL26 LOCAL26, LOCAL27 LOCAL27, LOCAL28 LOCAL28, LOCAL29 LOCAL29, LOCAL30 LOCAL30, LOCAL31 LOCAL31, LOCAL32 LOCAL32, LOCAL33 LOCAL33, LOCAL34 LOCAL34, LOCAL35 LOCAL35, LOCAL36 LOCAL36, LOCAL37 LOCAL37, LOCAL38 LOCAL38, LOCAL39 LOCAL39, LOCAL40 LOCAL40, LOCAL41 LOCAL41, LOCAL42 LOCAL42, LOCAL43 LOCAL43, LOCAL44 LOCAL44, LOCAL45 LOCAL45, LOCAL46 LOCAL46, LOCAL47 LOCAL47, LOCAL48 LOCAL48, LOCAL49 LOCAL49, LOCAL50 LOCAL50, PROCESSED_FLAG PROCESSED_FLAG, OLD_PRICE_BREAK_ID OLD_PRICE_BREAK_ID, PAYMENT_TERM PAYMENT_TERM, PRICE_FACTOR PRICE_FACTOR from "ICX"."ICX_POR_UPLOAD_IT_DUMP"

View Text - HTML Formatted

SELECT JOB_NUMBER JOB_NUMBER
, PRICE_BREAK_ID PRICE_BREAK_ID
, PRICE_BREAK_COUNT PRICE_BREAK_COUNT
, BEGINDATE BEGINDATE
, ENDDATE ENDDATE
, LINE_NUMBER LINE_NUMBER
, ROW_TYPE ROW_TYPE
, LANGUAGE LANGUAGE
, ACTION ACTION
, SYSTEM_ACTION SYSTEM_ACTION
, ERROR_FLAG ERROR_FLAG
, ERROR_MESSAGE ERROR_MESSAGE
, CATEGORY_NAME CATEGORY_NAME
, CATEGORY_KEY CATEGORY_KEY
, SUPPLIER_NAME SUPPLIER_NAME
, SUPPLIER_PART_NUM SUPPLIER_PART_NUM
, DESCRIPTION DESCRIPTION
, UNSPSC_CODE UNSPSC_CODE
, ITEM_TYPE ITEM_TYPE
, OWNER_NAME OWNER_NAME
, RT_CATEGORY_ID RT_CATEGORY_ID
, OLD_CATEGORY_ID OLD_CATEGORY_ID
, RT_ITEM_ID RT_ITEM_ID
, UNPUBLISHED_ITEM_ID UNPUBLISHED_ITEM_ID
, UNPUBLISHED_CATEGORY_ID UNPUBLISHED_CATEGORY_ID
, SUPPLIER_ID SUPPLIER_ID
, OWNER_ID OWNER_ID
, BUYER_ID BUYER_ID
, PRICELIST_ID PRICELIST_ID
, PRICELINE_ROWID PRICELINE_ROWID
, UNAPPROVED_PRICELINE_ROWID UNAPPROVED_PRICELINE_ROWID
, UOM_NAME UOM_NAME
, BUYER_NAME BUYER_NAME
, PRICE_STRING PRICE_STRING
, PRICELIST_NAME PRICELIST_NAME
, CURRENCY_CODE CURRENCY_CODE
, UOM_CODE UOM_CODE
, PRICE_CODE PRICE_CODE
, SUPPLIER_COMMENTS SUPPLIER_COMMENTS
, REQUIRED_DESCRIPTORS REQUIRED_DESCRIPTORS
, REQUIRED_TL_DESCRIPTORS REQUIRED_TL_DESCRIPTORS
, ROOT1 ROOT1
, ROOT2 ROOT2
, ROOT3 ROOT3
, ROOT4 ROOT4
, ROOT5 ROOT5
, ROOT6 ROOT6
, ROOT7 ROOT7
, ROOT8 ROOT8
, ROOT9 ROOT9
, ROOT10 ROOT10
, ROOT11 ROOT11
, ROOT12 ROOT12
, ROOT13 ROOT13
, ROOT14 ROOT14
, ROOT15 ROOT15
, ROOT16 ROOT16
, ROOT17 ROOT17
, ROOT18 ROOT18
, ROOT19 ROOT19
, ROOT20 ROOT20
, ROOT21 ROOT21
, ROOT22 ROOT22
, ROOT23 ROOT23
, ROOT24 ROOT24
, ROOT25 ROOT25
, ROOT26 ROOT26
, ROOT27 ROOT27
, ROOT28 ROOT28
, ROOT29 ROOT29
, ROOT30 ROOT30
, ROOT31 ROOT31
, ROOT32 ROOT32
, ROOT33 ROOT33
, ROOT34 ROOT34
, ROOT35 ROOT35
, ROOT36 ROOT36
, ROOT37 ROOT37
, ROOT38 ROOT38
, ROOT39 ROOT39
, ROOT40 ROOT40
, ROOT41 ROOT41
, ROOT42 ROOT42
, ROOT43 ROOT43
, ROOT44 ROOT44
, ROOT45 ROOT45
, ROOT46 ROOT46
, ROOT47 ROOT47
, ROOT48 ROOT48
, ROOT49 ROOT49
, ROOT50 ROOT50
, ROOT51 ROOT51
, ROOT52 ROOT52
, ROOT53 ROOT53
, ROOT54 ROOT54
, ROOT55 ROOT55
, ROOT56 ROOT56
, ROOT57 ROOT57
, ROOT58 ROOT58
, ROOT59 ROOT59
, ROOT60 ROOT60
, ROOT61 ROOT61
, ROOT62 ROOT62
, ROOT63 ROOT63
, ROOT64 ROOT64
, ROOT65 ROOT65
, ROOT66 ROOT66
, ROOT67 ROOT67
, ROOT68 ROOT68
, ROOT69 ROOT69
, ROOT70 ROOT70
, ROOT71 ROOT71
, ROOT72 ROOT72
, ROOT73 ROOT73
, ROOT74 ROOT74
, ROOT75 ROOT75
, ROOT76 ROOT76
, ROOT77 ROOT77
, ROOT78 ROOT78
, ROOT79 ROOT79
, ROOT80 ROOT80
, ROOT81 ROOT81
, ROOT82 ROOT82
, ROOT83 ROOT83
, ROOT84 ROOT84
, ROOT85 ROOT85
, ROOT86 ROOT86
, ROOT87 ROOT87
, ROOT88 ROOT88
, ROOT89 ROOT89
, ROOT90 ROOT90
, ROOT91 ROOT91
, ROOT92 ROOT92
, ROOT93 ROOT93
, ROOT94 ROOT94
, ROOT95 ROOT95
, ROOT96 ROOT96
, ROOT97 ROOT97
, ROOT98 ROOT98
, ROOT99 ROOT99
, ROOT100 ROOT100
, ROOT101 ROOT101
, ROOT102 ROOT102
, ROOT103 ROOT103
, ROOT104 ROOT104
, ROOT105 ROOT105
, ROOT106 ROOT106
, ROOT107 ROOT107
, ROOT108 ROOT108
, ROOT109 ROOT109
, ROOT110 ROOT110
, ROOT111 ROOT111
, ROOT112 ROOT112
, ROOT113 ROOT113
, ROOT114 ROOT114
, ROOT115 ROOT115
, ROOT116 ROOT116
, ROOT117 ROOT117
, ROOT118 ROOT118
, ROOT119 ROOT119
, ROOT120 ROOT120
, ROOT121 ROOT121
, ROOT122 ROOT122
, ROOT123 ROOT123
, ROOT124 ROOT124
, ROOT125 ROOT125
, ROOT126 ROOT126
, ROOT127 ROOT127
, ROOT128 ROOT128
, ROOT129 ROOT129
, ROOT130 ROOT130
, ROOT131 ROOT131
, ROOT132 ROOT132
, ROOT133 ROOT133
, ROOT134 ROOT134
, ROOT135 ROOT135
, ROOT136 ROOT136
, ROOT137 ROOT137
, ROOT138 ROOT138
, ROOT139 ROOT139
, ROOT140 ROOT140
, ROOT141 ROOT141
, ROOT142 ROOT142
, ROOT143 ROOT143
, ROOT144 ROOT144
, ROOT145 ROOT145
, ROOT146 ROOT146
, ROOT147 ROOT147
, ROOT148 ROOT148
, ROOT149 ROOT149
, ROOT150 ROOT150
, ROOT151 ROOT151
, ROOT152 ROOT152
, ROOT153 ROOT153
, ROOT154 ROOT154
, ROOT155 ROOT155
, ROOT156 ROOT156
, ROOT157 ROOT157
, ROOT158 ROOT158
, ROOT159 ROOT159
, ROOT160 ROOT160
, ROOT161 ROOT161
, ROOT162 ROOT162
, ROOT163 ROOT163
, ROOT164 ROOT164
, ROOT165 ROOT165
, ROOT166 ROOT166
, ROOT167 ROOT167
, ROOT168 ROOT168
, ROOT169 ROOT169
, ROOT170 ROOT170
, ROOT171 ROOT171
, ROOT172 ROOT172
, ROOT173 ROOT173
, ROOT174 ROOT174
, ROOT175 ROOT175
, ROOT176 ROOT176
, ROOT177 ROOT177
, ROOT178 ROOT178
, ROOT179 ROOT179
, ROOT180 ROOT180
, ROOT181 ROOT181
, ROOT182 ROOT182
, ROOT183 ROOT183
, ROOT184 ROOT184
, ROOT185 ROOT185
, ROOT186 ROOT186
, ROOT187 ROOT187
, ROOT188 ROOT188
, ROOT189 ROOT189
, ROOT190 ROOT190
, ROOT191 ROOT191
, ROOT192 ROOT192
, ROOT193 ROOT193
, ROOT194 ROOT194
, ROOT195 ROOT195
, ROOT196 ROOT196
, ROOT197 ROOT197
, ROOT198 ROOT198
, ROOT199 ROOT199
, ROOT200 ROOT200
, ROOT201 ROOT201
, ROOT202 ROOT202
, ROOT203 ROOT203
, ROOT204 ROOT204
, ROOT205 ROOT205
, ROOT206 ROOT206
, ROOT207 ROOT207
, ROOT208 ROOT208
, ROOT209 ROOT209
, ROOT210 ROOT210
, ROOT211 ROOT211
, ROOT212 ROOT212
, ROOT213 ROOT213
, ROOT214 ROOT214
, ROOT215 ROOT215
, ROOT216 ROOT216
, ROOT217 ROOT217
, ROOT218 ROOT218
, ROOT219 ROOT219
, ROOT220 ROOT220
, ROOT221 ROOT221
, ROOT222 ROOT222
, ROOT223 ROOT223
, ROOT224 ROOT224
, ROOT225 ROOT225
, ROOT226 ROOT226
, ROOT227 ROOT227
, ROOT228 ROOT228
, ROOT229 ROOT229
, ROOT230 ROOT230
, ROOT231 ROOT231
, ROOT232 ROOT232
, ROOT233 ROOT233
, ROOT234 ROOT234
, ROOT235 ROOT235
, ROOT236 ROOT236
, ROOT237 ROOT237
, ROOT238 ROOT238
, ROOT239 ROOT239
, ROOT240 ROOT240
, ROOT241 ROOT241
, ROOT242 ROOT242
, ROOT243 ROOT243
, ROOT244 ROOT244
, ROOT245 ROOT245
, ROOT246 ROOT246
, ROOT247 ROOT247
, ROOT248 ROOT248
, ROOT249 ROOT249
, ROOT250 ROOT250
, LOCAL1 LOCAL1
, LOCAL2 LOCAL2
, LOCAL3 LOCAL3
, LOCAL4 LOCAL4
, LOCAL5 LOCAL5
, LOCAL6 LOCAL6
, LOCAL7 LOCAL7
, LOCAL8 LOCAL8
, LOCAL9 LOCAL9
, LOCAL10 LOCAL10
, LOCAL11 LOCAL11
, LOCAL12 LOCAL12
, LOCAL13 LOCAL13
, LOCAL14 LOCAL14
, LOCAL15 LOCAL15
, LOCAL16 LOCAL16
, LOCAL17 LOCAL17
, LOCAL18 LOCAL18
, LOCAL19 LOCAL19
, LOCAL20 LOCAL20
, LOCAL21 LOCAL21
, LOCAL22 LOCAL22
, LOCAL23 LOCAL23
, LOCAL24 LOCAL24
, LOCAL25 LOCAL25
, LOCAL26 LOCAL26
, LOCAL27 LOCAL27
, LOCAL28 LOCAL28
, LOCAL29 LOCAL29
, LOCAL30 LOCAL30
, LOCAL31 LOCAL31
, LOCAL32 LOCAL32
, LOCAL33 LOCAL33
, LOCAL34 LOCAL34
, LOCAL35 LOCAL35
, LOCAL36 LOCAL36
, LOCAL37 LOCAL37
, LOCAL38 LOCAL38
, LOCAL39 LOCAL39
, LOCAL40 LOCAL40
, LOCAL41 LOCAL41
, LOCAL42 LOCAL42
, LOCAL43 LOCAL43
, LOCAL44 LOCAL44
, LOCAL45 LOCAL45
, LOCAL46 LOCAL46
, LOCAL47 LOCAL47
, LOCAL48 LOCAL48
, LOCAL49 LOCAL49
, LOCAL50 LOCAL50
, PROCESSED_FLAG PROCESSED_FLAG
, OLD_PRICE_BREAK_ID OLD_PRICE_BREAK_ID
, PAYMENT_TERM PAYMENT_TERM
, PRICE_FACTOR PRICE_FACTOR
FROM "ICX"."ICX_POR_UPLOAD_IT_DUMP"