Product: | AMS - Marketing |
---|---|
Description: | This view returns evnts Mapping information |
Implementation/DBA Data: | APPS.AMS_EVENT_MAPPING_V |
SELECT S.IMPORT_SOURCE_LINE_ID IMPORT_SOURCE_LINE_ID
, S.IMPORT_LIST_HEADER_ID IMPORT_LIST_HEADER_ID
, S.IMPORT_SUCCESSFUL_FLAG IMPORT_SUCCESSFUL_FLAG
, S.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, S.LAST_UPDATE_DATE LAST_UPDATE_DATE
, S.LAST_UPDATED_BY LAST_UPDATED_BY
, S.CREATION_DATE CREATION_DATE
, S.CREATED_BY CREATED_BY
, S.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, S.LOAD_STATUS LOAD_STATUS
, S.COL1 EVENT_SOURCE_CODE
, S.COL2 REGISTRATION_SOURCE_TYPE
, S.COL3 ATTENDANCE_FLAG
, S.COL175 WAITLISTED_FLAG
, S.COL4 CANCELLATION_FLAG
, S.COL5 CANCELLATION_REASON_CODE
, S.COL6 CONFIRMATION_CODE
, S.COL7 ORIGINAL_SYSTEM_REFERENCE
, S.COL8 REG_PARTY_ID
, S.COL9 REG_PARTY_TYPE
, S.COL10 REG_CONTACT_ID
, S.COL11 REG_PARTY_NAME
, S.COL12 REG_TITLE
, S.COL13 REG_FIRST_NAME
, S.COL14 REG_MIDDLE_NAME
, S.COL15 REG_LAST_NAME
, S.COL16 REG_ADDRESS1
, S.COL17 REG_ADDRESS2
, S.COL18 REG_ADDRESS3
, S.COL19 REG_ADDRESS4
, S.COL20 REG_GENDER
, S.COL21 REG_ADDRESS_LINE_PHOENETIC
, S.COL22 REG_ANALYSIS_FY
, S.COL23 REG_APT_FLAG
, S.COL24 REG_BEST_TIME_CONTACT_BEGIN
, S.COL25 REG_BEST_TIME_CONTACT_END
, S.COL26 REG_CATEGORY_CODE
, S.COL27 REG_CEO_NAME
, S.COL28 REG_CITY
, S.COL29 REG_COUNTRY
, S.COL30 REG_COUNTY
, S.COL31 REG_CURRENT_FY_POTENTIAL_REV
, S.COL32 REG_NEXT_FY_POTENTIAL_REV
, S.COL33 REG_HOUSEHOLD_INCOME
, S.COL34 REG_DECISION_MAKER_FLAG
, S.COL35 REG_DEPARTMENT
, S.COL36 REG_DUN_NO_C
, S.COL37 REG_EMAIL_ADDRESS
, S.COL38 REG_EMPLOYEE_TOTAL
, S.COL39 REG_FY_END_MONTH
, S.COL40 REG_FLOOR
, S.COL41 REG_GSA_INDICATOR_FLAG
, S.COL42 REG_HOUSE_NUMBER
, S.COL43 REG_IDENTIFYING_ADDRESS_FLAG
, S.COL44 REG_JGZZ_FISCAL_CODE
, S.COL45 REG_JOB_TITLE
, S.COL46 REG_LAST_ORDER_DATE
, S.COL47 REG_ORG_LEGAL_STATUS
, S.COL48 REG_LINE_OF_BUSINESS
, S.COL49 REG_MISSION_STATEMENT
, S.COL50 REG_ORG_NAME_PHOENETIC
, S.COL51 REG_OVERSEAS_ADDRESS_FLAG
, S.COL52 REG_NAME_SUFFIX
, S.COL53 REG_PHONE_AREA_CODE
, S.COL54 REG_PHONE_COUNTRY_CODE
, S.COL55 REG_PHONE_EXTENSION
, S.COL56 REG_PHONE_NUMBER
, S.COL57 REG_POSTAL_CODE
, S.COL58 REG_POSTAL_PLUS4_CODE
, S.COL59 REG_PO_BOX_NO
, S.COL60 REG_PROVINCE
, S.COL61 REG_RURAL_ROUTE_NO
, S.COL62 REG_RURAL_ROUTE_TYPE
, S.COL63 REG_SECONDARY_SUFFIX_ELEMENT
, S.COL64 REG_SIC_CODE
, S.COL65 REG_SIC_CODE_TYPE
, S.COL66 REG_SITE_USE_CODE
, S.COL67 REG_STATE
, S.COL68 REG_STREET
, S.COL69 REG_STREET_NUMBER
, S.COL70 REG_STREET_SUFFIX
, S.COL71 REG_SUITE
, S.COL72 REG_TAX_NAME
, S.COL73 REG_TAX_REFERENCE
, S.COL74 REG_TIMEZONE
, S.COL75 REG_TOTAL_NO_OF_ORDERS
, S.COL76 REG_TOTAL_ORDER_AMOUNT
, S.COL77 REG_YEAR_ESTABLISED
, S.COL78 REG_URL
, S.COL79 REG_SERVEY_NOTES
, S.COL80 REG_CONTACT_ME_FLAG
, S.COL81 REG_EMAIL_OK_FLAG
, S.COL100 ATT_PARTY_ID
, S.COL101 ATT_PARTY_TYPE
, S.COL102 ATT_CONTACT_ID
, S.COL103 ATT_PARTY_NAME
, S.COL104 ATT_TITLE
, S.COL105 ATT_FIRST_NAME
, S.COL106 ATT_MIDDLE_NAME
, S.COL107 ATT_LAST_NAME
, S.COL108 ATT_ADDRESS1
, S.COL109 ATT_ADDRESS2
, S.COL110 ATT_ADDRESS3
, S.COL111 ATT_ADDRESS4
, S.COL112 ATT_GENDER
, S.COL113 ATT_ADDRESS_LINE_PHOENETIC
, S.COL114 ATT_ANALYSIS_FY
, S.COL115 ATT_APT_FLAG
, S.COL116 ATT_BEST_TIME_CONTACT_BEGIN
, S.COL117 ATT_BEST_TIME_CONTACT_END
, S.COL118 ATT_CATEGORY_CODE
, S.COL119 ATT_CEO_NAME
, S.COL120 ATT_CITY
, S.COL121 ATT_COUNTRY
, S.COL122 ATT_COUNTY
, S.COL123 ATT_CURRENT_FY_POTENTIAL_REV
, S.COL124 ATT_NEXT_FY_POTENTIAL_REV
, S.COL125 ATT_HOUSEHOLD_INCOME
, S.COL126 ATT_DECISION_MAKER_FLAG
, S.COL127 ATT_DEPARTMENT
, S.COL128 ATT_DUN_NO
, S.COL129 ATT_EMAIL_ADDRESS
, S.COL130 ATT_EMPLOYEE_TOTAL
, S.COL131 ATT_FY_END_MONTH
, S.COL132 ATT_FLOOR
, S.COL133 ATT_GSA_INDICATOR_FLAG
, S.COL134 ATT_HOUSE_NUMBER
, S.COL135 ATT_IDENTIFYING_ADDRESS_FLAG
, S.COL136 ATT_JGZZ_FISCAL_CODE
, S.COL137 ATT_JOB_TITLE
, S.COL138 ATT_LAST_ORDER_DATE
, S.COL139 ATT_LEGAL_STATUS
, S.COL140 ATT_LINE_OF_BUSINESS
, S.COL141 ATT_MISSION_STATEMENT
, S.COL142 ATT_ORG_NAME_PHOENETIC
, S.COL143 ATT_OVERSEAS_ADDRESS_FLAG
, S.COL144 ATT_NAME_SUFFIX
, S.COL145 ATT_PHONE_AREA_CODE
, S.COL146 ATT_PHONE_COUNTRY_CODE
, S.COL147 ATT_PHONE_EXTENSION
, S.COL148 ATT_PHONE_NUMBER
, S.COL149 ATT_POSTAL_CODE
, S.COL150 ATT_POSTAL_PLUS4_CODE
, S.COL151 ATT_PO_BOX_NO
, S.COL152 ATT_PROVINCE
, S.COL153 ATT_RURAL_ROUTE_NO
, S.COL154 ATT_RURAL_ROUTE_TYPE
, S.COL155 ATT_SECONDARY_SUFFIX_ELEMENT
, S.COL156 ATT_SIC_CODE
, S.COL157 ATT_SIC_CODE_TYPE
, S.COL158 ATT_SITE_USE_CODE
, S.COL159 ATT_STATE
, S.COL160 ATT_STREET
, S.COL161 ATT_STREET_NUMBER
, S.COL162 ATT_STREET_SUFFIX
, S.COL163 ATT_SUITE
, S.COL164 ATT_TAX_NAME
, S.COL165 ATT_TAX_REFERENCE
, S.COL166 ATT_TIMEZONE
, S.COL167 ATT_TOTAL_NO_OF_ORDERS
, S.COL168 ATT_TOTAL_ORDER_AMOUNT
, S.COL169 ATT_YEAR_ESTABLISED
, S.COL170 ATT_URL
, S.COL171 ATT_SERVEY_NOTES
, S.COL172 ATT_CONTACT_ME_FLAG
, S.COL173 ATT_EMAIL_OK_FLAG
, S.BATCH_ID BATCH_ID
, S.CUSTOM_PROCESSING_STATUS CUSTOM_PROCESSING_STATUS
, S.COL242 AMS_COL201
, S.COL242 AMS_COL202
, S.COL242 AMS_COL203
, S.COL242 AMS_COL204
, S.COL242 AMS_COL205
, S.COL242 AMS_COL206
, S.COL242 AMS_COL207
, S.COL242 AMS_COL208
, S.COL242 AMS_COL209
, S.COL242 AMS_COL210
, S.COL242 AMS_COL211
, S.COL242 AMS_COL212
, S.COL242 AMS_COL213
, S.COL242 AMS_COL214
, S.COL242 AMS_COL215
, S.COL242 AMS_COL216
, S.COL242 AMS_COL217
, S.COL242 AMS_COL218
, S.COL242 AMS_COL219
, S.COL242 AMS_COL220
, S.COL242 AMS_COL221
, S.COL242 AMS_COL222
, S.COL242 AMS_COL223
, S.COL242 AMS_COL224
, S.COL242 AMS_COL225
, S.COL242 AMS_COL226
, S.COL242 AMS_COL227
, S.COL242 AMS_COL228
, S.COL242 AMS_COL229
, S.COL242 AMS_COL230
, S.COL242 AMS_COL231
, S.COL242 AMS_COL232
, S.COL242 AMS_COL233
, S.COL242 AMS_COL234
, S.COL242 AMS_COL235
, S.COL242 AMS_COL236
, S.COL242 AMS_COL237
, S.COL242 AMS_COL238
, S.COL242 AMS_COL239
, S.COL242 AMS_COL240
, S.COL242 AMS_COL241
, S.COL242 AMS_COL242
, S.COL242 AMS_COL243
, S.COL242 AMS_COL244
, S.COL242 AMS_COL245
, S.COL242 AMS_COL246
, S.COL242 AMS_COL247
, S.COL242 AMS_COL248
, S.COL242 AMS_COL249
, S.COL242 AMS_COL250
, S.COL242 AMS_COL251
, S.COL242 AMS_COL252
, S.COL242 AMS_COL253
, S.COL242 AMS_COL254
, S.COL242 AMS_COL255
, S.COL242 AMS_COL256
, S.COL242 AMS_COL257
, S.COL242 AMS_COL258
, S.COL242 AMS_COL259
, S.COL242 AMS_COL260
, S.COL242 AMS_COL261
, S.COL242 AMS_COL262
, S.COL242 AMS_COL263
, S.COL242 AMS_COL264
, S.COL242 AMS_COL265
, S.COL242 AMS_COL266
, S.COL242 AMS_COL267
, S.COL242 AMS_COL268
, S.COL242 AMS_COL269
, S.COL242 AMS_COL270
, S.COL242 AMS_COL271
, S.COL242 AMS_COL272
, S.COL242 AMS_COL273
, S.COL242 AMS_COL274
, S.COL242 AMS_COL275
, S.COL242 AMS_COL276
, S.COL242 AMS_COL277
, S.COL242 AMS_COL278
, S.COL242 AMS_COL279
, S.COL242 AMS_COL280
, S.COL242 AMS_COL281
, S.COL242 AMS_COL282
, S.COL242 AMS_COL283
, S.COL242 AMS_COL284
, S.COL242 AMS_COL285
, S.COL242 AMS_COL286
, S.COL242 AMS_COL287
, S.COL242 AMS_COL288
, S.COL242 AMS_COL289
, S.COL242 AMS_COL290
, S.COL242 AMS_COL291
, S.COL242 AMS_COL292
, S.COL242 AMS_COL293
, S.COL242 AMS_COL294
, S.COL242 AMS_COL295
, S.COL242 AMS_COL296
, S.COL242 AMS_COL297
, S.COL242 AMS_COL298
, S.COL242 AMS_COL299
, S.COL242 AMS_COL300
, S.COL242 AMS_COL301
, S.COL242 AMS_COL302
, S.COL242 AMS_COL303
, S.COL242 AMS_COL304
, S.COL242 AMS_COL305
, S.COL242 AMS_COL306
, S.COL242 AMS_COL307
, S.COL242 AMS_COL308
, S.COL242 AMS_COL309
, S.COL242 AMS_COL310
, S.COL242 AMS_COL311
, S.COL242 AMS_COL312
, S.COL242 AMS_COL313
, S.COL242 AMS_COL314
, S.COL242 AMS_COL315
, S.COL242 AMS_COL316
, S.COL242 AMS_COL317
, S.COL242 AMS_COL318
, S.COL242 AMS_COL319
, S.COL242 AMS_COL320
, S.COL242 AMS_COL321
, S.COL242 AMS_COL322
, S.COL242 AMS_COL323
, S.COL242 AMS_COL324
, S.COL242 AMS_COL325
, S.COL242 AMS_COL326
, S.COL242 AMS_COL327
, S.COL242 AMS_COL328
, S.COL242 AMS_COL329
, S.COL242 AMS_COL330
, S.COL242 AMS_COL331
, S.COL242 AMS_COL332
, S.COL242 AMS_COL333
, S.COL242 AMS_COL334
, S.COL242 AMS_COL335
, S.COL242 AMS_COL336
, S.COL242 AMS_COL337
, S.COL242 AMS_COL338
, S.COL242 AMS_COL339
, S.COL242 AMS_COL340
, S.COL242 AMS_COL341
, S.COL242 AMS_COL342
, S.COL242 AMS_COL343
, S.COL242 AMS_COL344
, S.COL242 AMS_COL345
, S.COL242 AMS_COL346
, S.COL242 AMS_COL347
, S.COL242 AMS_COL348
, S.COL242 AMS_COL349
, S.COL242 AMS_COL350
, S.COL242 AMS_COL351
, S.COL242 AMS_COL352
, S.COL242 AMS_COL353
, S.COL242 AMS_COL354
, S.COL242 AMS_COL355
, S.COL242 AMS_COL356
FROM AMS_IMP_SOURCE_LINES S
, AMS_IMP_LIST_HEADERS_ALL H
WHERE S.IMPORT_LIST_HEADER_ID = H.IMPORT_LIST_HEADER_ID
AND H.IMPORT_TYPE = 'EVENT'