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

TABLE: ICX.ICX_POR_UPLOAD_IT_DUMP

Object Details
Object Name: ICX_POR_UPLOAD_IT_DUMP
Object Type: TABLE
Owner: ICX
FND Design Data: TableICX.ICX_POR_UPLOAD_IT_DUMP
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
JOB_NUMBER NUMBER
Yes Job unique identifier
PRICE_BREAK_ID NUMBER

Price break identifier
PRICE_BREAK_COUNT NUMBER

Price break count
BEGINDATE VARCHAR2 (50)
Begin date
ENDDATE VARCHAR2 (50)
End date
LINE_NUMBER NUMBER
Yes Line Number
ROW_TYPE VARCHAR2 (20) Yes Indicates type of line being loaded. It could be ITEM_PRICE or PRICE
LANGUAGE VARCHAR2 (4)
Language of the line
ACTION VARCHAR2 (20)
Action requested by the user on the line
SYSTEM_ACTION VARCHAR2 (20)
Defined system action.
ERROR_FLAG VARCHAR2 (1)
Indicates whether an error has been found during validation.
ERROR_MESSAGE VARCHAR2 (2000)
Stores error messages if any.
CATEGORY_NAME VARCHAR2 (2000)
Category Name
CATEGORY_KEY VARCHAR2 (2000)
Category Key
SUPPLIER_NAME VARCHAR2 (2000)
Supplier Name
SUPPLIER_PART_NUM VARCHAR2 (2000)
Supplier Item Number
DESCRIPTION VARCHAR2 (2000)
Item Description
UNSPSC_CODE VARCHAR2 (2000)
UNSPSC Code.
ITEM_TYPE VARCHAR2 (2000)
Item Type
OWNER_NAME VARCHAR2 (2000)
Item Owner Name
RT_CATEGORY_ID NUMBER

Category ID
OLD_CATEGORY_ID NUMBER

Old Category ID. Used for reclassification.
RT_ITEM_ID NUMBER

Item ID
UNPUBLISHED_ITEM_ID NUMBER

Unpublished Item ID
UNPUBLISHED_CATEGORY_ID NUMBER

Unpublished Category ID
SUPPLIER_ID NUMBER

Supplier ID
OWNER_ID NUMBER

Item Owner ID
BUYER_ID NUMBER

Buyer ID
PRICELIST_ID NUMBER

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

Old price break id
PAYMENT_TERM VARCHAR2 (30)
Payment Term(For Exchange use)
PRICE_FACTOR VARCHAR2 (240)
Price Factor(For Exchange use)
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 does not reference any database object

ICX.ICX_POR_UPLOAD_IT_DUMP is referenced by following:

SchemaICX
ViewICX_POR_UPLOAD_IT_DUMP#