VIEW: APPS.AMS_HZ_B2C_MAPPING_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'