View: AMS_HZ_B2C_MAPPING_V

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_B2C_MAPPING_V

View Text

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.PARTY_ID PARTY_ID
, 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
, COL34 GENDER
, COL35 HOUSEHOLD_INCOME
, COL36 SITE_USE_TYPE
, COL37 PERSON_PRE_NAME_ADJUNCT
, COL38 SALUTATION
, 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 PER_IMP_XML_ELEMENT_ID
, COL69 ADD_IMP_XML_ELEMENT_ID
, COL70 CP_IMP_XML_ELEMENT_ID
, COL71 EM_IMP_XML_ELEMENT_ID
, COL72 PERSON_LAST_NAME_PHONETIC
, COL73 PERSON_FIRST_NAME_PHONETIC
, COL74 URL
, COL75 SECOND_TITLE
, COL76 DATE_OF_BIRTH
, COL77 PERSON_ACADEMIC_TITLE
, COL78 PERSON_PREVIOUS_TITLE_NAME
, COL79 PERSON_KNOWN_AS
, COL80 PERSON_KNOWN_AS2
, COL81 PERSON_KNOWN_AS3
, COL82 PERSON_KNOWN_AS4
, COL83 PERSON_KNOWN_AS5
, COL84 PERSON_NAME_PHONETIC
, COL85 MIDDLE_NAME_PHONETIC
, COL86 FISCAL_CODE
, COL87 PLACE_OF_BIRTH
, COL88 DATE_OF_DEATH
, COL89 DECLARED_ETHNICITY
, COL90 MARITAL_STATUS
, COL91 PERSONAL_INCOME
, COL92 MARITAL_STATUS_EFFECTIVE_DATE
, COL93 HEAD_OF_HOUSEHOLD_FLAG
, COL94 HOUSEHOLD_SIZE
, COL95 LOCATION_DIRECTIONS
, COL96 ADDRESS_EFFECTIVE_DATE
, COL97 ADDRESS_EXPIRATION_DATE
, COL98 PERSON_ATTRIBUTE1
, COL99 PERSON_ATTRIBUTE2
, COL100 PERSON_ATTRIBUTE3
, COL101 PERSON_ATTRIBUTE4
, COL102 PERSON_ATTRIBUTE5
, COL103 PERSON_ATTRIBUTE6
, COL104 PERSON_ATTRIBUTE7
, COL105 PERSON_ATTRIBUTE8
, COL106 PERSON_ATTRIBUTE9
, COL107 PERSON_ATTRIBUTE10
, COL108 PERSON_ATTRIBUTE11
, COL109 PERSON_ATTRIBUTE12
, COL110 PERSON_ATTRIBUTE13
, COL111 PERSON_ATTRIBUTE14
, COL112 PERSON_ATTRIBUTE15
, COL113 ADDRESS_ATTRIBUTE1
, COL114 ADDRESS_ATTRIBUTE2
, COL115 ADDRESS_ATTRIBUTE3
, COL116 ADDRESS_ATTRIBUTE4
, COL117 ADDRESS_ATTRIBUTE5
, COL118 ADDRESS_ATTRIBUTE6
, COL119 ADDRESS_ATTRIBUTE7
, COL120 ADDRESS_ATTRIBUTE8
, COL121 ADDRESS_ATTRIBUTE9
, COL122 ADDRESS_ATTRIBUTE10
, COL123 ADDRESS_ATTRIBUTE11
, COL124 ADDRESS_ATTRIBUTE12
, COL125 ADDRESS_ATTRIBUTE13
, COL126 ADDRESS_ATTRIBUTE14
, COL127 ADDRESS_ATTRIBUTE15
, COL128 FAX_COUNTRY_CODE
, COL129 FAX_AREA_CODE
, COL130 FAX_NUMBER
, COL131 PERSON_ATTRIBUTE_CATEGORY
, COL132 ADDRESS_ATTRIBUTE_CATEGORY
, COL133 PARTY_SITE_USE
, COL134 SHORT_DESCRIPTION
, COL135 DESCRIPTION
, COL136 ORIG_SYSTEM_REFERENCE
, COL137 TAX_REFERENCE
, COL138 RENT_OWNED_INDICATOR
, PERSON_KEY PERSON_KEY
, PERSON_PARTY_ID PERSON_PARTY_ID
, PERSON_EXIST PERSON_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
, COL139 PHONE_TYPE
, COL140 PS_ATTRIBUTE_CATEGORY
, COL141 PS_ATTRIBUTE1
, COL142 PS_ATTRIBUTE2
, COL143 PS_ATTRIBUTE3
, COL144 PS_ATTRIBUTE4
, COL145 PS_ATTRIBUTE5
, COL146 PS_ATTRIBUTE6
, COL147 PS_ATTRIBUTE7
, COL148 PS_ATTRIBUTE8
, COL149 PS_ATTRIBUTE9
, COL150 PS_ATTRIBUTE10
, COL151 PS_ATTRIBUTE11
, COL152 PS_ATTRIBUTE12
, COL153 PS_ATTRIBUTE13
, COL154 PS_ATTRIBUTE14
, COL155 PS_ATTRIBUTE15
, COL156 PS_ATTRIBUTE16
, COL157 PS_ATTRIBUTE17
, COL158 PS_ATTRIBUTE18
, COL159 PS_ATTRIBUTE19
, COL160 PS_ATTRIBUTE20
, COL161 NATIVE_LANGUAGE
, COL162 PERSON_ATTRIBUTE16
, COL163 PERSON_ATTRIBUTE17
, COL164 PERSON_ATTRIBUTE18
, COL165 PERSON_ATTRIBUTE19
, COL166 PERSON_ATTRIBUTE20
, COL167 PERSON_ATTRIBUTE21
, COL168 PERSON_ATTRIBUTE22
, COL169 PERSON_ATTRIBUTE23
, COL170 PERSON_ATTRIBUTE24
, COL171 ADDRESS_ATTRIBUTE16
, COL172 ADDRESS_ATTRIBUTE17
, COL173 ADDRESS_ATTRIBUTE18
, COL174 ADDRESS_ATTRIBUTE19
, COL175 ADDRESS_ATTRIBUTE20
, 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
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 = 'B2C'
AND NVL(LINE.DUPLICATE_FLAG
, 'N') = 'N'

Columns