View: AMS_LEAD_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_LEAD_MAPPING_V

View Text

SELECT IMPORT_SOURCE_LINE_ID IMPORT_SOURCE_LINE_ID
, IMPORT_LIST_HEADER_ID IMPORT_LIST_HEADER_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LOAD_STATUS LOAD_STATUS
, IMPORT_SUCCESSFUL_FLAG IMPORT_SUCCESSFUL_FLAG
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, COL1 SOURCE_SYSTEM
, COL2 IMP_LIST_HEADER_NUMBER
, COL243 LEAD_NOTE
, COL3 PROMOTION_CODE
, COL244 CUSTOMER_NAME
, COL4 SIC_CODE
, COL5 ANALYSIS_FY
, COL6 CUSTOMER_CATEGORY_CODE
, COL7 FISCAL_YEAREND_MONTH
, COL8 NUM_OF_EMPLOYEES
, COL9 POTENTIAL_REVENUE_CURR_FY
, COL10 POTENTIAL_REVENUE_NEXT_FY
, COL11 CUSTOMER_RANK
, COL12 TAX_REFERENCE
, COL13 YEAR_ESTABLISHED
, COL14 ADDR_DO_NOT_MAIL_FLAG
, COL245 URL
, COL15 CONT_DO_NOT_MAIL_FLAG
, COL246 COUNTRY
, COL247 ADDRESS1
, COL248 ADDRESS2
, COL249 ADDRESS3
, COL250 ADDRESS4
, COL16 CITY
, COL17 POSTAL_CODE
, COL18 STATE
, COL19 PROVINCE
, COL20 COUNTY
, COL21 EMAIL_ADDRESS
, COL22 SEX_CODE
, COL23 SALUTATION
, COL24 LAST_NAME
, COL25 TITLE
, COL26 FIRST_NAME
, COL27 JOB_TITLE
, COL28 PHONE_NUMBER
, COL29 PHONE_STATUS
, COL30 PHONE_TYPE
, COL31 AREA_CODE
, COL32 EXTENSION
, COL33 MIDDLE_INITIAL
, COL34 JOB_TITLE_CODE
, COL35 MAIL_STOP
, COL36 FAX_NUMBER
, COL37 FAX_AREA_CODE
, COL38 DO_NOT_EMAIL_FLAG
, COL39 DO_NOT_FAX_FLAG
, COL40 DO_NOT_PHONE_FLAG
, COL41 CONTACT_ROLE_CODE
, COL42 CHANNEL_CODE
, COL43 BUDGET_AMOUNT
, COL44 BUDGET_STATUS_CODE
, COL45 CURRENCY_CODE
, COL46 DECISION_TIMEFRAME_CODE
, COL47 CLOSE_REASON
, COL48 PARENT_PROJECT
, COL49 DESCRIPTION
, COL50 VEHICLE_RESPONSE_CODE
, COL51 INTEREST_TYPE_ID_1
, COL52 PRIMARY_INTEREST_CODE_ID_1
, COL53 SECONDARY_INTEREST_CODE_ID_1
, COL54 INVENTORY_ITEM_ID_1
, COL55 ORGANIZATION_ID_1
, COL56 UOM_CODE_1
, COL57 QUANTITY_1
, COL58 BUDGET_AMOUNT_1
, COL59 SOURCE_PROMOTION_ID_1
, COL60 OFFER_ID_1
, COL61 INTEREST_TYPE_ID_2
, COL62 PRIMARY_INTEREST_CODE_ID_2
, COL63 SECONDARY_INTEREST_CODE_ID_2
, COL64 INVENTORY_ITEM_ID_2
, COL65 ORGANIZATION_ID_2
, COL66 UOM_CODE_2
, COL67 QUANTITY_2
, COL68 BUDGET_AMOUNT_2
, COL69 SOURCE_PROMOTION_ID_2
, COL70 OFFER_ID_2
, COL71 INTEREST_TYPE_ID_3
, COL72 PRIMARY_INTEREST_CODE_ID_3
, COL73 SECONDARY_INTEREST_CODE_ID_3
, COL74 INVENTORY_ITEM_ID_3
, COL75 ORGANIZATION_ID_3
, COL76 UOM_CODE_3
, COL77 QUANTITY_3
, COL78 BUDGET_AMOUNT_3
, COL79 SOURCE_PROMOTION_ID_3
, COL80 OFFER_ID_3
, COL81 INTEREST_TYPE_ID_4
, COL82 PRIMARY_INTEREST_CODE_ID_4
, COL83 SECONDARY_INTEREST_CODE_ID_4
, COL84 INVENTORY_ITEM_ID_4
, COL85 ORGANIZATION_ID_4
, COL86 UOM_CODE_4
, COL87 QUANTITY_4
, COL88 BUDGET_AMOUNT_4
, COL89 SOURCE_PROMOTION_ID_4
, COL90 OFFER_ID_4
, COL91 INTEREST_TYPE_ID_5
, COL92 PRIMARY_INTEREST_CODE_ID_5
, COL93 SECONDARY_INTEREST_CODE_ID_5
, COL94 INVENTORY_ITEM_ID_5
, COL95 ORGANIZATION_ID_5
, COL96 UOM_CODE_5
, COL97 QUANTITY_5
, COL98 BUDGET_AMOUNT_5
, COL99 SOURCE_PROMOTION_ID_5
, COL100 OFFER_ID_5
, COL101 ORIG_SYSTEM_REFERENCE
, COL102 ORIG_SYSTEM_CODE
, COL103 URGENT_FLAG
, COL104 ACCEPT_FLAG
, COL105 ASSIGN_DATE
, COL106 ASSIGN_SALES_GROUP_ID
, COL107 ASSIGN_TO_PERSON_ID
, COL108 ASSIGN_TO_SALESFORCE_ID
, COL109 AUTO_ASSIGNMENT_TYPE
, COL110 DELETED_FLAG
, COL111 IMPORT_FLAG
, COL112 KEEP_FLAG
, COL113 PRM_ASSIGNMENT_TYPE
, COL114 QUALIFIED_FLAG
, COL115 REJECT_REASON_CODE
, COL116 SCORECARD_ID
, COL117 PRIMARY_CONTACT_FLAG
, COL118 ADDRESS_EFFECTIVE_DATE
, COL119 ADDRESS_LINES_PHONETIC
, COL120 ADDRESS_STYLE
, COL121 CONTENT_SOURCE_TYPE
, COL122 LOC_DESCRIPTION
, COL123 LOC_HIERARCHY_ID
, COL124 FA_LOCATION_ID
, COL125 FLOOR
, COL126 HOUSE_NUMBER
, COL127 LANGUAGE
, COL128 LOCATION_DIRECTIONS
, COL129 PO_BOX_NUMBER
, COL130 LOCATION_POSITION
, COL131 POSTAL_PLUS4_CODE
, COL132 SALES_TAX_GEOCODE
, COL133 SALES_TAX_INSIDE_CITY_LIMITS
, COL134 SHORT_DESCRIPTION
, COL135 STREET
, COL136 STREET_NUMBER
, COL137 STREET_SUFFIX
, COL138 SUITE
, COL139 TIME_ZONE
, COL140 LOC_VALIDATED_FLAG
, COL141 DUNS_NUMBER
, COL142 GROUP_TYPE
, COL143 GSA_INDICATOR_FLAG
, COL144 HQ_BRANCH_IND
, COL145 JGZZ_FISCAL_CODE
, COL146 KNOWN_AS
, COL147 KNOWN_AS2
, COL148 KNOWN_AS3
, COL149 KNOWN_AS4
, COL150 KNOWN_AS5
, COL151 LANGUAGE_NAME
, COL152 LAST_ORDERED_DATE
, COL153 MISSION_STATEMENT
, COL154 ORGANIZATION_NAME_PHONETIC
, COL155 PARTY_NUMBER
, COL156 PERSON_FIRST_NAME_PHONETIC
, COL157 PERSON_IDEN_TYPE
, COL158 PERSON_IDENTIFIER
, COL159 PERSON_LAST_NAME_PHONETIC
, COL160 PERSON_NAME_SUFFIX
, COL161 PERSON_PREVIOUS_LAST_NAME
, COL162 PARTY_REFERENCE_USE_FLAG
, COL163 SIC_CODE_TYPE
, COL164 TAX_NAME
, COL165 TOTAL_NUM_OF_ORDERS
, COL166 TOTAL_ORDERED_AMOUNT
, COL167 PARTIES_VALIDATED_FLAG
, COL168 PS_USES_COMMENTS
, COL169 PRIMARY_PER_TYPE
, COL170 SITE_USE_TYPE
, COL171 ADDRESSEE
, COL172 MAILSTOP
, COL173 PARTY_SITE_NAME
, COL174 PARTY_SITE_NUMBER
, COL175 ORG_CNT_COMMENTS
, COL176 CONTACT_NUMBER
, COL177 DECISION_MAKER_FLAG
, COL178 DEPARTMENT
, COL179 DEPARTMENT_CODE
, COL180 RANK
, COL181 PROMOTION_ID
, COL182 ROLE_LEVEL
, COL183 PRIMARY_CONTACT_PER_ROLE_TYPE
, COL184 CNT_PNT_CONTENT_SOURCE_TYPE
, COL185 PHONE_COUNTRY_CODE
, COL186 FAX_COUNTRY_CODE
, COL225 PHONE_CALLING_CALENDAR
, COL187 CNT_PNT_TIME_ZONE
, COL188 RAW_PHONE_NUMBER
, COL189 EMAIL_FORMAT
, COL190 FAX_EXTENSION
, COL191 ORG_CNT_TITLE
, COL192 OFFER_ID
, COL193 REQUEST_ID
, COL194 PROGRAM_APPLICATION_ID
, COL195 PROGRAM_ID
, COL196 PROGRAM_UPDATE_DATE
, COL197 LOAD_ERROR_MESSAGE
, COL198 PHONE_ID
, COL199 CONTACT_PARTY_ID
, COL200 SECURITY_GROUP_ID
, COL201 NET_WORTH
, COL202 LEAD_NUMBER
, COL203 PRM_SALES_LEAD_TYPE
, COL204 PRM_EXEC_SPONSOR_FLAG
, COL205 PRM_PRJ_LEAD_IN_PLACE_FLAG
, COL206 INCUMBENT_PARTNER_PARTY_ID
, COL207 INCUMBENT_PARTNER_RESOURCE_ID
, COL208 PRM_IND_CLASSIFICATION_CODE
, COL209 PARTY_TYPE
, COL210 PARTY_ID
, COL211 PARTY_SITE_ID
, COL212 LOCATION_ID
, COL213 REL_PARTY_ID
, COL214 SALES_LEAD_ID
, COL215 CUSTOMER_KEY
, COL216 ADDRESS_KEY
, COL217 CONTACT_KEY
, COL218 NEW_PARTY_FLAG
, COL219 NEW_LOC_FLAG
, COL220 NEW_PS_FLAG
, COL221 NEW_REL_FLAG
, COL222 NEW_CON_FLAG
, COL223 LEAD_RANK_ID
, COL224 MARKETING_SCORE
, COL225 LEAD_DATE
, COL226 PERSON_INITIALS
, COL227 CATEGORY_ID_1
, COL228 CATEGORY_ID_2
, COL229 CATEGORY_ID_3
, COL230 CATEGORY_ID_4
, COL231 CATEGORY_ID_5
, COL232 SALES_METHODOLOGY_ID
, COL233 DUNS_NUMBER_C
, COL234 SOURCE_PRIMARY_REFERENCE
, COL235 SOURCE_SECONDARY_REFERENCE
, COL236 NOTE_TYPE
, BATCH_ID BATCH_ID
, CUSTOM_PROCESSING_STATUS CUSTOM_PROCESSING_STATUS
, COL242 AMS_COL201
, COL242 AMS_COL202
, COL242 AMS_COL203
, COL242 AMS_COL204
, COL242 AMS_COL205
, COL242 AMS_COL206
, COL242 AMS_COL207
, COL242 AMS_COL208
, COL242 AMS_COL209
, COL242 AMS_COL210
, COL242 AMS_COL211
, COL242 AMS_COL212
, COL242 AMS_COL213
, COL242 AMS_COL214
, COL242 AMS_COL215
, COL242 AMS_COL216
, COL242 AMS_COL217
, COL242 AMS_COL218
, COL242 AMS_COL219
, COL242 AMS_COL220
, COL242 AMS_COL221
, COL242 AMS_COL222
, COL242 AMS_COL223
, COL242 AMS_COL224
, COL242 AMS_COL225
, COL242 AMS_COL226
, COL242 AMS_COL227
, COL242 AMS_COL228
, COL242 AMS_COL229
, COL242 AMS_COL230
, COL242 AMS_COL231
, COL242 AMS_COL232
, COL242 AMS_COL233
, COL242 AMS_COL234
, COL242 AMS_COL235
, COL242 AMS_COL236
, COL242 AMS_COL237
, COL242 AMS_COL238
, COL242 AMS_COL239
, COL242 AMS_COL240
, COL242 AMS_COL241
, COL242 AMS_COL242
, COL242 AMS_COL243
, COL242 AMS_COL244
, COL242 AMS_COL245
, COL242 AMS_COL246
, COL242 AMS_COL247
, COL242 AMS_COL248
, COL242 AMS_COL249
, COL242 AMS_COL250
, COL242 AMS_COL251
, COL242 AMS_COL252
, COL242 AMS_COL253
, COL242 AMS_COL254
, COL242 AMS_COL255
, COL242 AMS_COL256
, COL242 AMS_COL257
, COL242 AMS_COL258
, COL242 AMS_COL259
, COL242 AMS_COL260
, COL242 AMS_COL261
, COL242 AMS_COL262
, COL242 AMS_COL263
, COL242 AMS_COL264
, COL242 AMS_COL265
, COL242 AMS_COL266
, COL242 AMS_COL267
, COL242 AMS_COL268
, COL242 AMS_COL269
, COL242 AMS_COL270
, COL242 AMS_COL271
, COL242 AMS_COL272
, COL242 AMS_COL273
, COL242 AMS_COL274
, COL242 AMS_COL275
, COL242 AMS_COL276
, COL242 AMS_COL277
, COL242 AMS_COL278
, COL242 AMS_COL279
, COL242 AMS_COL280
, COL242 AMS_COL281
, COL242 AMS_COL282
, COL242 AMS_COL283
, COL242 AMS_COL284
, COL242 AMS_COL285
, COL242 AMS_COL286
, COL242 AMS_COL287
, COL242 AMS_COL288
, COL242 AMS_COL289
, COL242 AMS_COL290
, COL242 AMS_COL291
, COL242 AMS_COL292
, COL242 AMS_COL293
, COL242 AMS_COL294
, COL242 AMS_COL295
, COL242 AMS_COL296
, COL242 AMS_COL297
, COL242 AMS_COL298
, COL242 AMS_COL299
, COL242 AMS_COL300
, COL242 AMS_COL301
, COL242 AMS_COL302
, COL242 AMS_COL303
, COL242 AMS_COL304
, COL242 AMS_COL305
, COL242 AMS_COL306
, COL242 AMS_COL307
, COL242 AMS_COL308
, COL242 AMS_COL309
, COL242 AMS_COL310
, COL242 AMS_COL311
, COL242 AMS_COL312
, COL242 AMS_COL313
, COL242 AMS_COL314
, COL242 AMS_COL315
, COL242 AMS_COL316
, COL242 AMS_COL317
, COL242 AMS_COL318
, COL242 AMS_COL319
, COL242 AMS_COL320
, COL242 AMS_COL321
, COL242 AMS_COL322
, COL242 AMS_COL323
, COL242 AMS_COL324
, COL242 AMS_COL325
, COL242 AMS_COL326
, COL242 AMS_COL327
, COL242 AMS_COL328
, COL242 AMS_COL329
, COL242 AMS_COL330
, COL242 AMS_COL331
, COL242 AMS_COL332
, COL242 AMS_COL333
, COL242 AMS_COL334
, COL242 AMS_COL335
, COL242 AMS_COL336
, COL242 AMS_COL337
, COL242 AMS_COL338
, COL242 AMS_COL339
, COL242 AMS_COL340
, COL242 AMS_COL341
, COL242 AMS_COL342
, COL242 AMS_COL343
, COL242 AMS_COL344
, COL242 AMS_COL345
, COL242 AMS_COL346
, COL242 AMS_COL347
, COL242 AMS_COL348
, COL242 AMS_COL349
, COL242 AMS_COL350
, COL242 AMS_COL351
, COL242 AMS_COL352
, COL242 AMS_COL353
, COL242 AMS_COL354
, COL242 AMS_COL355
, COL242 AMS_COL356
, COL242 AMS_COL357
, COL242 AMS_COL358
, COL242 AMS_COL359
, COL242 AMS_COL360
, COL242 AMS_COL361
, COL242 AMS_COL362
, COL242 AMS_COL363
, COL242 AMS_COL364
, COL242 AMS_COL365
, COL242 AMS_COL366
, COL242 AMS_COL367
, COL242 AMS_COL368
, COL242 AMS_COL369
, COL242 AMS_COL370
, COL242 AMS_COL371
, COL242 AMS_COL372
, COL242 AMS_COL373
, COL242 AMS_COL374
, COL242 AMS_COL375
, COL242 AMS_COL376
, COL242 AMS_COL377
, COL242 AMS_COL378
, COL242 AMS_COL379
, COL242 AMS_COL380
, COL242 AMS_COL381
, COL242 AMS_COL382
, COL242 AMS_COL383
, COL242 AMS_COL384
, COL242 AMS_COL385
, COL242 AMS_COL386
, COL242 AMS_COL387
, COL242 AMS_COL388
, COL242 AMS_COL389
, COL242 AMS_COL390
, COL242 AMS_COL391
, COL242 AMS_COL392
, COL242 AMS_COL393
, COL242 AMS_COL394
, COL242 AMS_COL395
, COL242 AMS_COL396
, COL242 AMS_COL397
, COL242 AMS_COL398
, COL242 AMS_COL399
, COL242 AMS_COL400
, COL242 AMS_COL401
, COL242 AMS_COL402
, COL242 AMS_COL403
, COL242 AMS_COL404
, COL242 AMS_COL405
, COL242 AMS_COL406
, COL242 AMS_COL407
, COL242 AMS_COL408
, COL242 AMS_COL409
, COL242 AMS_COL410
, COL242 AMS_COL411
, COL242 AMS_COL412
, COL242 AMS_COL413
, COL242 AMS_COL414
, COL242 AMS_COL415
, COL242 AMS_COL416
, COL242 AMS_COL417
, COL242 AMS_COL418
, COL242 AMS_COL419
, COL242 AMS_COL420
, COL242 AMS_COL421
, COL242 AMS_COL422
, COL242 AMS_COL423
, COL242 AMS_COL424
, COL242 AMS_COL425
, COL242 AMS_COL426
, COL242 AMS_COL427
, COL242 AMS_COL428
, COL242 AMS_COL429
, COL242 AMS_COL430
, COL242 AMS_COL431
, COL242 AMS_COL432
, COL242 AMS_COL433
, COL242 AMS_COL434
, COL242 AMS_COL435
, COL242 AMS_COL436
FROM AMS_IMP_SOURCE_LINES

Columns