VIEW: APPS.AMS_EVENT_MAPPING_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'