APPS.AMS_HZ_B2B_MAPPING_V
[Home] [Help]
| Product: | AMS - Marketing |
|---|---|
| Description: | This view stores the mapping of ams_imp_source_lines table. This is used to populate the data from the data file. |
| Implementation/DBA Data: |
APPS.AMS_HZ_B2B_MAPPING_V
|
SELECT LINE.IMPORT_SOURCE_LINE_ID IMPORT_SOURCE_LINE_ID
, LINE.LAST_UPDATE_DATE LAST_UPDATE_DATE
, LINE.LAST_UPDATED_BY LAST_UPDATED_BY
, LINE.CREATION_DATE CREATION_DATE
, LINE.CREATED_BY CREATED_BY
, LINE.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LINE.IMPORT_LIST_HEADER_ID IMPORT_LIST_HEADER_ID
, LINE.IMPORT_SUCCESSFUL_FLAG IMPORT_SUCCESSFUL_FLAG
, LINE.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, LINE.ENABLED_FLAG ENABLED_FLAG
, LINE.LOAD_STATUS LOAD_STATUS
, LINE.ORGANIZATION_ID ORGANIZATION_ID
, LINE.PARTY_ID PARTY_ID
, COL1 PARTY_NAME
, COL2 FISCAL_YEAREND_MONTH
, COL3 DUNS_NUMBER
, COL4 LEGAL_STATUS
, COL5 EMPLOYEES_TOTAL
, COL6 LINE_OF_BUSINESS
, COL7 YEAR_ESTABLISHED
, COL8 TAX_REFERENCE
, COL9 CEO_NAME
, COL10 PERSON_FIRST_NAME
, COL11 PERSON_MIDDLE_NAME
, COL12 PERSON_LAST_NAME
, COL13 PERSON_NAME_SUFFIX
, COL14 PERSON_NAME_PREFIX
, COL15 BEST_TIME_CONTACT_BEGIN
, COL16 BEST_TIME_CONTACT_END
, COL17 COUNTRY
, COL18 ADDRESS1
, COL19 ADDRESS2
, COL20 CITY
, COL21 COUNTY
, COL22 STATE
, COL23 PROVINCE
, COL24 POSTAL_CODE
, COL25 TIME_ZONE
, COL26 EMAIL_ADDRESS
, COL27 PHONE_COUNTRY_CODE
, COL28 PHONE_AREA_CODE
, COL29 PHONE_NUMBER
, COL30 PHONE_EXTENTION
, COL31 DEPARTMENT
, COL32 JOB_TITLE
, COL33 DECISION_MAKER_FLAG
, COL36 SITE_USE_TYPE
, COL37 SIC_CODE
, COL38 SIC_CODE_TYPE
, COL39 TOTAL_NUM_OF_ORDERS
, COL40 TOTAL_ORDERED_AMOUNT
, COL41 LAST_ORDERED_DATE
, COL42 ANALYSIS_FY
, COL43 CURR_FY_POTENTIAL_REVENUE
, COL44 NEXT_FY_POTENTIAL_REVENUE
, COL45 GSA_INDICATOR_FLAG
, COL46 MISSION_STATEMENT
, COL47 ORGANIZATION_NAME_PHONETIC
, COL48 CATEGORY_CODE
, COL49 JGZZ_FISCAL_CODE
, COL50 TAX_NAME
, COL51 ADDRESS3
, COL52 ADDRESS4
, COL53 ADDRESS_LINES_PHONETIC
, COL54 APARTMENT_FLAG
, COL55 PO_BOX_NUMBER
, COL56 HOUSE_NUMBER
, COL57 STREET_SUFFIX
, COL58 SECONDARY_SUFFIX_ELEMENT
, COL59 STREET
, COL60 RURAL_ROUTE_TYPE
, COL61 RURAL_ROUTE_NUMBER
, COL62 STREET_NUMBER
, COL63 FLOOR
, COL64 SUITE
, COL65 POSTAL_PLUS4_CODE
, COL66 OVERSEAS_ADDRESS_FLAG
, COL67 IDENTIFYING_ADDRESS_FLAG
, DEDUPE_KEY DEDUPE_KEY
, LINE.NOTES NOTES
, LINE.VEHICLE_RESPONSE_CODE VEHICLE_RESPONSE_CODE
, LINE.SALES_AGENT_EMAIL_ADDRESS SALES_AGENT_EMAIL_ADDRESS
, LINE.RESOURCE_ID RESOURCE_ID
, LINE.BATCH_ID BATCH_ID
, LINE.LOCATION_ID LOCATION_ID
, LINE.CONTACT_POINT_ID CONTACT_POINT_ID
, COL68 ORG_IMP_XML_ELEMENT_ID
, COL69 ADD_IMP_XML_ELEMENT_ID
, COL70 OCONT_IMP_XML_ELEMENT_ID
, COL71 CP_IMP_XML_ELEMENT_ID
, COL72 EM_IMP_XML_ELEMENT_ID
, COL73 ADDRESS_EFFECTIVE_DATE
, COL74 ADDRESS_EXPIRATION_DATE
, COL75 ANNUAL_REVENUE
, COL76 ANNUAL_REVENUE_CURRENCY
, COL77 BRANCH_FLAG
, COL78 BUSINESS_LINE
, COL79 BUSINESS_SCOPE
, COL80 CHIEF_EXECUTIVE_TITLE
, COL81 CONGRESSIONAL_DISTRICT_CODE
, COL82 CONTROL_YEAR
, COL83 CORPORATION_CLASS
, COL84 CREDIT_SCORE
, COL85 CREDIT_SCORE_COMMENTARY
, COL86 CUSTOMER_CATEGORY
, COL87 DB_RATING
, COL88 DATE_OF_BIRTH
, COL89 DATE_OF_DEATH
, COL90 DEBARMENTS_COUNT
, COL91 DEBARTMENTS_DATE
, COL92 DECLARED_ETHNICITY
, COL93 DEPARTMENT_INDICATOR
, COL94 DESCRIPTION
, COL95 DISADVANTAGED_INDICATOR
, COL96 ENQUIRY_DUNS
, COL97 EXPORT_INDICATOR
, COL98 FAILURE_SCORE
, COL99 FAILURE_SCORE_COMMENTARY
, COL100 FAILURE_SCORE_NATL_PERCENTILE
, COL101 FAILURE_SCORE_OVERRIDE_CODE
, COL102 FISCAL_CODE
, COL103 GLOBAL_FAILURE_SCORE
, COL104 HEADQUARTER_BRANCH_INDICATOR
, COL105 HEAD_OF_HOUSEHOLD_FLAG
, COL106 HOUSEHOLD_SIZE
, COL107 IMPORT_INDICATOR
, COL108 ORGANIZATION_KNOWN_AS
, COL109 ORGANIZATION_KNOWN_AS2
, COL110 ORGANIZATION_KNOWN_AS3
, COL111 ORGANIZATION_KNOWN_AS4
, COL112 ORGANIZATION_KNOWN_AS5
, COL113 PERSON_KNOWN_AS
, COL114 PERSON_KNOWN_AS2
, COL115 PERSON_KNOWN_AS3
, COL116 PERSON_KNOWN_AS4
, COL117 PERSON_KNOWN_AS5
, COL118 LABOR_SURPLUS_INDICATOR
, COL119 LOCAL_ACTIVITY_CODE
, COL120 LOCAL_ACTIVITY_CODE_TYPE
, COL121 LOCATION_DIRECTIONS
, COL122 LOCATION_STATUS
, COL123 MARITAL_STATUS
, COL124 MARITAL_STATUS_EFFECTIVE_DATE
, COL125 MINORITY_OWNED_INDICATOR
, COL126 MINORITY_OWNED_TYPE
, COL127 ORGANIZATION_ALIAS
, COL128 ORGANIZATION_TYPE
, COL129 ORGANIZATION_URL
, COL130 OUT_OF_BUSINESS_INDICATOR
, COL131 PERSONAL_INCOME
, COL132 PERSON_ACADEMIC_TITLE
, COL133 PERSON_FIRST_NAME_PHONETIC
, COL134 PERSON_LAST_NAME_PHONETIC
, COL135 MIDDLE_NAME_PHONETIC
, COL136 PERSON_NAME_PHONETIC
, COL137 PERSON_PREVIOUS_TITLE_NAME
, COL138 PLACE_OF_BIRTH
, COL139 PREFERRED_NAME
, COL140 PRINCIPAL_NAME
, COL141 PRINCIPAL_TITLE
, COL142 PUBLIC_PRIVATE_OWNERSHIP_FLAG
, COL143 RENT_OWNED_INDICATOR
, COL144 RENT_OWNER_INDICATOR
, COL145 SECOND_TITLE
, COL146 SHORT_DESCRIPTION
, COL147 SMALL_BUSINESS_INDICATOR
, COL148 TAX_ID
, COL149 WOMAN_OWNED_INDICATOR
, COL150 ORGANIZATION_ATTRIBUTE1
, COL151 ORGANIZATION_ATTRIBUTE2
, COL152 ORGANIZATION_ATTRIBUTE3
, COL153 ORGANIZATION_ATTRIBUTE4
, COL154 ORGANIZATION_ATTRIBUTE5
, COL155 ORGANIZATION_ATTRIBUTE6
, COL156 ORGANIZATION_ATTRIBUTE7
, COL157 ORGANIZATION_ATTRIBUTE8
, COL158 ORGANIZATION_ATTRIBUTE9
, COL159 ORGANIZATION_ATTRIBUTE10
, COL160 ORGANIZATION_ATTRIBUTE11
, COL161 ORGANIZATION_ATTRIBUTE12
, COL162 ORGANIZATION_ATTRIBUTE13
, COL163 ORGANIZATION_ATTRIBUTE14
, COL164 ORGANIZATION_ATTRIBUTE15
, COL165 PERSON_ATTRIBUTE1
, COL166 PERSON_ATTRIBUTE2
, COL167 PERSON_ATTRIBUTE3
, COL168 PERSON_ATTRIBUTE4
, COL169 PERSON_ATTRIBUTE5
, COL170 PERSON_ATTRIBUTE6
, COL171 PERSON_ATTRIBUTE7
, COL172 PERSON_ATTRIBUTE8
, COL173 PERSON_ATTRIBUTE9
, COL174 PERSON_ATTRIBUTE10
, COL175 PERSON_ATTRIBUTE11
, COL176 PERSON_ATTRIBUTE12
, COL177 PERSON_ATTRIBUTE13
, COL178 PERSON_ATTRIBUTE14
, COL179 PERSON_ATTRIBUTE15
, COL180 ORG_CONTACT_ATTRIBUTE1
, COL181 ORG_CONTACT_ATTRIBUTE2
, COL182 ORG_CONTACT_ATTRIBUTE3
, COL183 ORG_CONTACT_ATTRIBUTE4
, COL184 ORG_CONTACT_ATTRIBUTE5
, COL185 ORG_CONTACT_ATTRIBUTE6
, COL186 ORG_CONTACT_ATTRIBUTE7
, COL187 ORG_CONTACT_ATTRIBUTE8
, COL188 ORG_CONTACT_ATTRIBUTE9
, COL189 ORG_CONTACT_ATTRIBUTE10
, COL190 ORG_CONTACT_ATTRIBUTE11
, COL191 ORG_CONTACT_ATTRIBUTE12
, COL192 ORG_CONTACT_ATTRIBUTE13
, COL193 ORG_CONTACT_ATTRIBUTE14
, COL194 ORG_CONTACT_ATTRIBUTE15
, COL195 ADDRESS_ATTRIBUTE1
, COL196 ADDRESS_ATTRIBUTE2
, COL197 ADDRESS_ATTRIBUTE3
, COL198 ADDRESS_ATTRIBUTE4
, COL199 ADDRESS_ATTRIBUTE5
, COL200 ADDRESS_ATTRIBUTE6
, COL201 ADDRESS_ATTRIBUTE7
, COL202 ADDRESS_ATTRIBUTE8
, COL203 ADDRESS_ATTRIBUTE9
, COL204 ADDRESS_ATTRIBUTE10
, COL205 ADDRESS_ATTRIBUTE11
, COL206 ADDRESS_ATTRIBUTE12
, COL207 ADDRESS_ATTRIBUTE13
, COL208 ADDRESS_ATTRIBUTE14
, COL209 ADDRESS_ATTRIBUTE15
, COL210 FAX_COUNTRY_CODE
, COL211 FAX_AREA_CODE
, COL212 FAX_NUMBER
, COL213 ORG_ATTRIBUTE_CATEGORY
, COL214 PERSON_ATTRIBUTE_CATEGORY
, COL215 ORG_CONTACT_ATTRIBUTE_CATEGORY
, COL216 ADDRESS_ATTRIBUTE_CATEGORY
, COL217 PARTY_SITE_USE
, COL218 ORIG_SYSTEM_REFERENCE
, COL219 RELATIONSHIP_TYPE
, COL220 RELATIONSHIP_CODE
, ORG_KEY ORG_KEY
, PERSON_KEY PERSON_KEY
, ORG_EXIST ORG_EXIST
, ORG_PARTY_ID ORG_PARTY_ID
, OCONT_PARTY_ID OCONT_PARTY_ID
, OCONT_EXIST OCONT_EXIST
, ADDRESS_KEY ADDRESS_KEY
, PARTY_LOCATION_ID PARTY_LOCATION_ID
, REQUEST_ID REQUEST_ID
, RECORD_PROCESSED RECORD_PROCESSED
, TRANSPOSED_PHONE_NUMBER TRANSPOSED_PHONE_NUMBER
, CUSTOM_COLUMN1 CUSTOM_COLUMN1
, CUSTOM_COLUMN2 CUSTOM_COLUMN2
, CUSTOM_COLUMN3 CUSTOM_COLUMN3
, CUSTOM_COLUMN4 CUSTOM_COLUMN4
, CUSTOM_COLUMN5 CUSTOM_COLUMN5
, CUSTOM_COLUMN6 CUSTOM_COLUMN6
, CUSTOM_COLUMN7 CUSTOM_COLUMN7
, CUSTOM_COLUMN8 CUSTOM_COLUMN8
, CUSTOM_COLUMN9 CUSTOM_COLUMN9
, CUSTOM_COLUMN10 CUSTOM_COLUMN10
, CUSTOM_COLUMN11 CUSTOM_COLUMN11
, CUSTOM_COLUMN12 CUSTOM_COLUMN12
, CUSTOM_COLUMN13 CUSTOM_COLUMN13
, CUSTOM_COLUMN14 CUSTOM_COLUMN14
, CUSTOM_COLUMN15 CUSTOM_COLUMN15
, CUSTOM_COLUMN16 CUSTOM_COLUMN16
, CUSTOM_COLUMN17 CUSTOM_COLUMN17
, CUSTOM_COLUMN18 CUSTOM_COLUMN18
, CUSTOM_COLUMN19 CUSTOM_COLUMN19
, CUSTOM_COLUMN20 CUSTOM_COLUMN20
, CUSTOM_COLUMN21 CUSTOM_COLUMN21
, CUSTOM_COLUMN22 CUSTOM_COLUMN22
, CUSTOM_COLUMN23 CUSTOM_COLUMN23
, CUSTOM_COLUMN24 CUSTOM_COLUMN24
, CUSTOM_COLUMN25 CUSTOM_COLUMN25
, COL221 ORG_EMAIL_ADDRESS
, COL222 ORG_PH_COUNTRY_CODE
, COL223 ORG_PH_AREA_CODE
, COL224 ORG_PH_NUMBER
, COL225 ORG_PH_EXTENSION
, COL226 ORG_COUNTRY
, COL227 ORG_ADDRESS1
, COL228 ORG_ADDRESS2
, COL229 ORG_ADDRESS3
, COL230 ORG_ADDRESS4
, COL231 ORG_CITY
, COL232 ORG_COUNTY
, COL233 ORG_STATE
, COL234 ORG_PROVINCE
, COL235 ORG_POSTAL_CODE
, COL236 ORG_ADDR_ATTRIBUTE_CATEGORY
, COL237 ORG_ADDR_ATTRIBUTE1
, COL238 ORG_ADDR_ATTRIBUTE2
, COL239 ORG_ADDR_ATTRIBUTE3
, COL240 ORG_ADDR_ATTRIBUTE4
, COL241 ORG_ADDR_ATTRIBUTE5
, COL242 ORG_ADDR_ATTRIBUTE6
, COL243 ORG_ADDR_ATTRIBUTE7
, COL244 ORG_ADDR_ATTRIBUTE8
, COL245 ORG_ADDR_ATTRIBUTE9
, COL246 ORG_ADDR_ATTRIBUTE10
, COL247 ORG_ADDR_ATTRIBUTE11
, COL248 ORG_ADDR_ATTRIBUTE12
, COL249 ORG_ADDR_ATTRIBUTE13
, COL251 ORG_ADDR_ATTRIBUTE14
, COL252 ORG_ADDR_ATTRIBUTE15
, COL253 ORG_ADDR_ATTRIBUTE16
, COL254 ORG_ADDR_ATTRIBUTE17
, COL255 ORG_ADDR_ATTRIBUTE18
, COL256 ORG_ADDR_ATTRIBUTE19
, COL257 ORG_ADDR_ATTRIBUTE20
, COL258 ORG_PS_ATTRIBUTE_CATEGORY
, COL259 ORG_PS_ATTRIBUTE1
, COL260 ORG_PS_ATTRIBUTE2
, COL261 ORG_PS_ATTRIBUTE3
, COL262 ORG_PS_ATTRIBUTE4
, COL263 ORG_PS_ATTRIBUTE5
, COL264 ORG_PS_ATTRIBUTE6
, COL265 ORG_PS_ATTRIBUTE7
, COL266 ORG_PS_ATTRIBUTE8
, COL267 ORG_PS_ATTRIBUTE9
, COL268 ORG_PS_ATTRIBUTE10
, COL269 ORG_PS_ATTRIBUTE11
, COL270 ORG_PS_ATTRIBUTE12
, COL271 ORG_PS_ATTRIBUTE13
, COL272 ORG_PS_ATTRIBUTE14
, COL273 ORG_PS_ATTRIBUTE15
, COL274 ORG_PS_ATTRIBUTE16
, COL275 ORG_PS_ATTRIBUTE17
, COL276 ORG_PS_ATTRIBUTE18
, COL277 ORG_PS_ATTRIBUTE19
, COL278 ORG_PS_ATTRIBUTE20
, COL279 ORG_CPS_ATTRIBUTE_CATEGORY
, COL280 ORG_CPS_ATTRIBUTE1
, COL281 ORG_CPS_ATTRIBUTE2
, COL282 ORG_CPS_ATTRIBUTE3
, COL283 ORG_CPS_ATTRIBUTE4
, COL284 ORG_CPS_ATTRIBUTE5
, COL285 ORG_CPS_ATTRIBUTE6
, COL286 ORG_CPS_ATTRIBUTE7
, COL287 ORG_CPS_ATTRIBUTE8
, COL288 ORG_CPS_ATTRIBUTE9
, COL289 ORG_CPS_ATTRIBUTE10
, COL290 ORG_CPS_ATTRIBUTE11
, COL291 ORG_CPS_ATTRIBUTE12
, COL292 ORG_CPS_ATTRIBUTE13
, COL293 ORG_CPS_ATTRIBUTE14
, COL294 ORG_CPS_ATTRIBUTE15
, COL295 ORG_CPS_ATTRIBUTE16
, COL296 ORG_CPS_ATTRIBUTE17
, COL297 ORG_CPS_ATTRIBUTE18
, COL298 ORG_CPS_ATTRIBUTE19
, COL299 ORG_CPS_ATTRIBUTE20
, COL300 PHONE_TYPE
, COL301 ORG_PHONE_TYPE
, COL302 NATIVE_LANGUAGE
, ORG_LOCATION_ID ORG_LOCATION_ID
, ORG_ADDRESS_KEY ORG_ADDRESS_KEY
, COL303 ORGANIZATION_ATTRIBUTE16
, COL304 ORGANIZATION_ATTRIBUTE17
, COL305 ORGANIZATION_ATTRIBUTE18
, COL306 ORGANIZATION_ATTRIBUTE19
, COL307 ORGANIZATION_ATTRIBUTE20
, COL308 ORGANIZATION_ATTRIBUTE21
, COL309 ORGANIZATION_ATTRIBUTE22
, COL310 ORGANIZATION_ATTRIBUTE23
, COL311 ORGANIZATION_ATTRIBUTE24
, COL312 PERSON_ATTRIBUTE16
, COL313 PERSON_ATTRIBUTE17
, COL314 PERSON_ATTRIBUTE18
, COL315 PERSON_ATTRIBUTE19
, COL316 PERSON_ATTRIBUTE20
, COL317 PERSON_ATTRIBUTE21
, COL318 PERSON_ATTRIBUTE22
, COL319 PERSON_ATTRIBUTE23
, COL320 PERSON_ATTRIBUTE24
, COL321 ORG_CONTACT_ATTRIBUTE16
, COL322 ORG_CONTACT_ATTRIBUTE17
, COL323 ORG_CONTACT_ATTRIBUTE18
, COL324 ORG_CONTACT_ATTRIBUTE19
, COL325 ORG_CONTACT_ATTRIBUTE20
, COL326 ORG_CONTACT_ATTRIBUTE21
, COL327 ORG_CONTACT_ATTRIBUTE22
, COL328 ORG_CONTACT_ATTRIBUTE23
, COL329 ORG_CONTACT_ATTRIBUTE24
, COL330 ADDRESS_ATTRIBUTE16
, COL331 ADDRESS_ATTRIBUTE17
, COL332 ADDRESS_ATTRIBUTE18
, COL333 ADDRESS_ATTRIBUTE19
, COL334 ADDRESS_ATTRIBUTE20
, COL335 ORG_PS_PH_COUNTRY_CODE
, COL336 ORG_PS_PH_AREA_CODE
, COL337 ORG_PS_PH_NUMBER
, COL338 ORG_PS_PH_EXTENSION
, COL339 ORG_PS_PH_TYPE
, COL340 JOB_TITLE_CODE
, CUSTOM_PROCESSING_STATUS CUSTOM_PROCESSING_STATUS
, COL250 AMS_COL201
, COL250 AMS_COL202
, COL250 AMS_COL203
, COL250 AMS_COL204
, COL250 AMS_COL205
, COL250 AMS_COL206
, COL250 AMS_COL207
, COL250 AMS_COL208
, COL250 AMS_COL209
, COL250 AMS_COL210
, COL250 AMS_COL211
, COL250 AMS_COL212
, COL250 AMS_COL213
, COL250 AMS_COL214
, COL250 AMS_COL215
, COL250 AMS_COL216
, COL250 AMS_COL217
, COL250 AMS_COL218
, COL250 AMS_COL219
, COL250 AMS_COL220
, COL250 AMS_COL221
, COL250 AMS_COL222
, COL250 AMS_COL223
, COL250 AMS_COL224
, COL250 AMS_COL225
, COL250 AMS_COL226
, COL250 AMS_COL227
, COL250 AMS_COL228
, COL250 AMS_COL229
, COL250 AMS_COL230
, COL250 AMS_COL231
, COL250 AMS_COL232
, COL250 AMS_COL233
, COL250 AMS_COL234
, COL250 AMS_COL235
, COL250 AMS_COL236
, COL250 AMS_COL237
, COL250 AMS_COL238
, COL250 AMS_COL239
, COL250 AMS_COL240
, COL250 AMS_COL241
, COL250 AMS_COL242
, COL250 AMS_COL243
, COL250 AMS_COL244
, COL250 AMS_COL245
, COL250 AMS_COL246
, COL250 AMS_COL247
, COL250 AMS_COL248
, COL250 AMS_COL249
, COL250 AMS_COL250
, COL250 AMS_COL251
, COL250 AMS_COL252
, COL250 AMS_COL253
, COL250 AMS_COL254
, COL250 AMS_COL255
, COL250 AMS_COL256
, COL250 AMS_COL257
, COL250 AMS_COL258
, COL250 AMS_COL259
, COL250 AMS_COL260
, COL250 AMS_COL261
, COL250 AMS_COL262
, COL250 AMS_COL263
, COL250 AMS_COL264
, COL250 AMS_COL265
, COL250 AMS_COL266
, COL250 AMS_COL267
, COL250 AMS_COL268
, COL250 AMS_COL269
, COL250 AMS_COL270
, COL250 AMS_COL271
, COL250 AMS_COL272
, COL250 AMS_COL273
, COL250 AMS_COL274
, COL250 AMS_COL275
, COL250 AMS_COL276
, COL250 AMS_COL277
, COL250 AMS_COL278
, COL250 AMS_COL279
, COL250 AMS_COL280
, COL250 AMS_COL281
, COL250 AMS_COL282
, COL250 AMS_COL283
, COL250 AMS_COL284
, COL250 AMS_COL285
, COL250 AMS_COL286
, COL250 AMS_COL287
, COL250 AMS_COL288
, COL250 AMS_COL289
, COL250 AMS_COL290
, COL250 AMS_COL291
, COL250 AMS_COL292
, COL250 AMS_COL293
, COL250 AMS_COL294
, COL250 AMS_COL295
, COL250 AMS_COL296
, COL250 AMS_COL297
, COL250 AMS_COL298
, COL250 AMS_COL299
, COL250 AMS_COL300
, COL250 AMS_COL301
, COL250 AMS_COL302
, COL250 AMS_COL303
, COL250 AMS_COL304
, COL250 AMS_COL305
, COL250 AMS_COL306
, COL250 AMS_COL307
, COL250 AMS_COL308
, COL250 AMS_COL309
, COL250 AMS_COL310
, COL250 AMS_COL311
, COL250 AMS_COL312
, COL250 AMS_COL313
, COL250 AMS_COL314
, COL250 AMS_COL315
, COL250 AMS_COL316
, COL250 AMS_COL317
, COL250 AMS_COL318
, COL250 AMS_COL319
, COL250 AMS_COL320
, COL250 AMS_COL321
, COL250 AMS_COL322
, COL250 AMS_COL323
, COL250 AMS_COL324
, COL250 AMS_COL325
, COL250 AMS_COL326
, COL250 AMS_COL327
, COL250 AMS_COL328
, COL250 AMS_COL329
, COL250 AMS_COL330
, COL250 AMS_COL331
, COL250 AMS_COL332
, COL250 AMS_COL333
, COL250 AMS_COL334
, COL250 AMS_COL335
, COL250 AMS_COL336
, COL250 AMS_COL337
, COL250 AMS_COL338
, COL250 AMS_COL339
, COL250 AMS_COL340
, COL250 AMS_COL341
, COL250 AMS_COL342
, COL250 AMS_COL343
, COL250 AMS_COL344
, COL250 AMS_COL345
, COL250 AMS_COL346
, COL250 AMS_COL347
, COL250 AMS_COL348
, COL250 AMS_COL349
, COL250 AMS_COL350
, COL250 AMS_COL351
, COL250 AMS_COL352
, COL250 AMS_COL353
, COL250 AMS_COL354
, COL250 AMS_COL355
, COL250 AMS_COL356
, COL250 AMS_COL357
, COL250 AMS_COL358
, COL250 AMS_COL359
, COL250 AMS_COL360
, COL250 AMS_COL361
, COL250 AMS_COL362
, COL250 AMS_COL363
, COL250 AMS_COL364
, COL250 AMS_COL365
, COL250 AMS_COL366
, COL250 AMS_COL367
, COL250 AMS_COL368
, COL250 AMS_COL369
, COL250 AMS_COL370
, COL250 AMS_COL371
, COL250 AMS_COL372
, COL250 AMS_COL373
, COL250 AMS_COL374
, COL250 AMS_COL375
, COL250 AMS_COL376
, COL250 AMS_COL377
, COL250 AMS_COL378
, COL250 AMS_COL379
, COL250 AMS_COL380
, COL250 AMS_COL381
, COL250 AMS_COL382
, COL250 AMS_COL383
, COL250 AMS_COL384
, COL250 AMS_COL385
, COL250 AMS_COL386
, COL250 AMS_COL387
, COL250 AMS_COL388
, COL250 AMS_COL389
, COL250 AMS_COL390
, COL250 AMS_COL391
, COL250 AMS_COL392
, COL250 AMS_COL393
, COL250 AMS_COL394
, COL250 AMS_COL395
, COL250 AMS_COL396
, COL250 AMS_COL397
, COL250 AMS_COL398
, COL250 AMS_COL399
, COL250 AMS_COL400
, COL250 AMS_COL401
, COL250 AMS_COL402
, COL250 AMS_COL403
, COL250 AMS_COL404
, COL250 AMS_COL405
, COL250 AMS_COL406
, COL250 AMS_COL407
, COL250 AMS_COL408
, COL250 AMS_COL409
, COL250 AMS_COL410
, COL250 AMS_COL411
, COL250 AMS_COL412
, COL250 AMS_COL413
, COL250 AMS_COL414
, COL250 AMS_COL415
, COL250 AMS_COL416
, COL250 AMS_COL417
, COL250 AMS_COL418
, COL250 AMS_COL419
, COL250 AMS_COL420
, COL250 AMS_COL421
, COL250 AMS_COL422
, COL250 AMS_COL423
, COL250 AMS_COL424
, COL250 AMS_COL425
, COL250 AMS_COL426
, COL250 AMS_COL427
, COL250 AMS_COL428
, COL250 AMS_COL429
, COL250 AMS_COL430
, COL250 AMS_COL431
, COL250 AMS_COL432
, COL250 AMS_COL433
, COL250 AMS_COL434
, COL250 AMS_COL435
, COL250 AMS_COL436
, COL250 AMS_COL437
, COL250 AMS_COL438
, COL250 AMS_COL439
, COL250 AMS_COL440
, COL250 AMS_COL441
, COL250 AMS_COL442
, COL250 AMS_COL443
, COL250 AMS_COL444
, COL250 AMS_COL445
, COL250 AMS_COL446
, COL250 AMS_COL447
, COL250 AMS_COL448
, COL250 AMS_COL449
, COL250 AMS_COL450
, COL250 AMS_COL451
, COL250 AMS_COL452
, COL250 AMS_COL453
, COL250 AMS_COL454
, COL250 AMS_COL455
, COL250 AMS_COL456
, COL250 AMS_COL457
, COL250 AMS_COL458
, COL250 AMS_COL459
, COL250 AMS_COL460
, COL250 AMS_COL461
, COL250 AMS_COL462
, COL250 AMS_COL463
, COL250 AMS_COL464
, COL250 AMS_COL465
, COL250 AMS_COL466
, COL250 AMS_COL467
, COL250 AMS_COL468
, COL250 AMS_COL469
, COL250 AMS_COL470
, COL250 AMS_COL471
, COL250 AMS_COL472
, COL250 AMS_COL473
, COL250 AMS_COL474
, COL250 AMS_COL475
, COL250 AMS_COL476
, COL250 AMS_COL477
, COL250 AMS_COL478
, COL250 AMS_COL479
, COL250 AMS_COL480
, COL250 AMS_COL481
, COL250 AMS_COL482
, COL250 AMS_COL483
, COL250 AMS_COL484
, COL250 AMS_COL485
, COL250 AMS_COL486
, COL250 AMS_COL487
, COL250 AMS_COL488
, COL250 AMS_COL489
, COL250 AMS_COL490
, COL250 AMS_COL491
, COL250 AMS_COL492
, COL250 AMS_COL493
, COL250 AMS_COL494
, COL250 AMS_COL495
, COL250 AMS_COL496
, COL250 AMS_COL497
, COL250 AMS_COL498
, COL250 AMS_COL499
, COL250 AMS_COL500
, COL250 AMS_COL501
, COL250 AMS_COL502
, COL250 AMS_COL503
, COL250 AMS_COL504
, COL250 AMS_COL505
, COL250 AMS_COL506
, COL250 AMS_COL507
, COL250 AMS_COL508
, COL250 AMS_COL509
, COL250 AMS_COL510
, COL250 AMS_COL511
, COL250 AMS_COL512
, COL250 AMS_COL513
, COL250 AMS_COL514
, COL250 AMS_COL515
, COL250 AMS_COL516
, COL250 AMS_COL517
, COL250 AMS_COL518
, COL250 AMS_COL519
, COL250 AMS_COL520
, COL250 AMS_COL521
, COL250 AMS_COL522
, COL250 AMS_COL523
, COL250 AMS_COL524
, COL250 AMS_COL525
, COL250 AMS_COL526
, COL250 AMS_COL527
, COL250 AMS_COL528
, COL250 AMS_COL529
, COL250 AMS_COL530
, COL250 AMS_COL531
, COL250 AMS_COL532
, COL250 AMS_COL533
, COL250 AMS_COL534
, COL250 AMS_COL535
FROM AMS_IMP_SOURCE_LINES LINE
, AMS_IMP_LIST_HEADERS_ALL HEADER
WHERE LINE.IMPORT_LIST_HEADER_ID = HEADER.IMPORT_LIST_HEADER_ID
AND HEADER.IMPORT_TYPE = 'B2B'
AND NVL(LINE.DUPLICATE_FLAG
, 'N') = 'N'