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


VIEW: ICX.ICX_POR_UPLOAD_IT_DUMP#

Object Details
Object Name: ICX_POR_UPLOAD_IT_DUMP#
Object Type: VIEW
Owner: ICX
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
JOB_NUMBER NUMBER
Yes
PRICE_BREAK_ID NUMBER

PRICE_BREAK_COUNT NUMBER

BEGINDATE VARCHAR2 (50)
ENDDATE VARCHAR2 (50)
LINE_NUMBER NUMBER
Yes
ROW_TYPE VARCHAR2 (20) Yes
LANGUAGE VARCHAR2 (4)
ACTION VARCHAR2 (20)
SYSTEM_ACTION VARCHAR2 (20)
ERROR_FLAG VARCHAR2 (1)
ERROR_MESSAGE VARCHAR2 (2000)
CATEGORY_NAME VARCHAR2 (2000)
CATEGORY_KEY VARCHAR2 (2000)
SUPPLIER_NAME VARCHAR2 (2000)
SUPPLIER_PART_NUM VARCHAR2 (2000)
DESCRIPTION VARCHAR2 (2000)
UNSPSC_CODE VARCHAR2 (2000)
ITEM_TYPE VARCHAR2 (2000)
OWNER_NAME VARCHAR2 (2000)
RT_CATEGORY_ID NUMBER

OLD_CATEGORY_ID NUMBER

RT_ITEM_ID NUMBER

UNPUBLISHED_ITEM_ID NUMBER

UNPUBLISHED_CATEGORY_ID NUMBER

SUPPLIER_ID NUMBER

OWNER_ID NUMBER

BUYER_ID NUMBER

PRICELIST_ID NUMBER

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

PAYMENT_TERM VARCHAR2 (30)
PRICE_FACTOR VARCHAR2 (240)
Query Text

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


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

Dependencies

[top of page]

ICX.ICX_POR_UPLOAD_IT_DUMP# references the following:

SchemaICX
TableICX_POR_UPLOAD_IT_DUMP
ICX.ICX_POR_UPLOAD_IT_DUMP# is referenced by following:

SchemaAPPS
SynonymICX_POR_UPLOAD_IT_DUMP