VIEW: APPS.AMS_HZ_B2B_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.organization_id organization_id, line.PARTY_ID PARTY_ID, COL1 PARTY_NAME, COL2 FISCAL_YEAREND_MONTH, COL3 DUNS_NUMBER, COL4 LEGAL_STATUS, COL5 EMPLOYEES_TOTAL, COL6 LINE_OF_BUSINESS, COL7 YEAR_ESTABLISHED, COL8 TAX_REFERENCE, COL9 CEO_NAME, 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, COL31 DEPARTMENT, COL32 JOB_TITLE, COL33 DECISION_MAKER_FLAG, COL36 SITE_USE_TYPE, COL37 SIC_CODE, COL38 SIC_CODE_TYPE, COL39 TOTAL_NUM_OF_ORDERS, COL40 TOTAL_ORDERED_AMOUNT, COL41 LAST_ORDERED_DATE, COL42 ANALYSIS_FY, COL43 CURR_FY_POTENTIAL_REVENUE, COL44 NEXT_FY_POTENTIAL_REVENUE, COL45 GSA_INDICATOR_FLAG, COL46 MISSION_STATEMENT, COL47 ORGANIZATION_NAME_PHONETIC, COL48 CATEGORY_CODE, COL49 JGZZ_FISCAL_CODE, COL50 TAX_NAME, 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 ORG_IMP_XML_ELEMENT_ID, COL69 ADD_IMP_XML_ELEMENT_ID, COL70 OCONT_IMP_XML_ELEMENT_ID, COL71 CP_IMP_XML_ELEMENT_ID, COL72 EM_IMP_XML_ELEMENT_ID, COL73 ADDRESS_EFFECTIVE_DATE, COL74 ADDRESS_EXPIRATION_DATE, COL75 ANNUAL_REVENUE, COL76 ANNUAL_REVENUE_CURRENCY, COL77 BRANCH_FLAG, COL78 BUSINESS_LINE, COL79 BUSINESS_SCOPE, COL80 CHIEF_EXECUTIVE_TITLE, COL81 CONGRESSIONAL_DISTRICT_CODE, COL82 CONTROL_YEAR, COL83 CORPORATION_CLASS, COL84 CREDIT_SCORE, COL85 CREDIT_SCORE_COMMENTARY, COL86 CUSTOMER_CATEGORY, COL87 DB_RATING, COL88 DATE_OF_BIRTH, COL89 DATE_OF_DEATH, COL90 DEBARMENTS_COUNT, COL91 DEBARTMENTS_DATE, COL92 DECLARED_ETHNICITY, COL93 DEPARTMENT_INDICATOR, COL94 DESCRIPTION, COL95 DISADVANTAGED_INDICATOR, COL96 ENQUIRY_DUNS, COL97 EXPORT_INDICATOR, COL98 FAILURE_SCORE, COL99 FAILURE_SCORE_COMMENTARY, COL100 FAILURE_SCORE_NATL_PERCENTILE, COL101 FAILURE_SCORE_OVERRIDE_CODE, COL102 FISCAL_CODE, COL103 GLOBAL_FAILURE_SCORE, COL104 HEADQUARTER_BRANCH_INDICATOR, COL105 HEAD_OF_HOUSEHOLD_FLAG, COL106 HOUSEHOLD_SIZE, COL107 IMPORT_INDICATOR, COL108 ORGANIZATION_KNOWN_AS, COL109 ORGANIZATION_KNOWN_AS2, COL110 ORGANIZATION_KNOWN_AS3, COL111 ORGANIZATION_KNOWN_AS4, COL112 ORGANIZATION_KNOWN_AS5, COL113 PERSON_KNOWN_AS, COL114 PERSON_KNOWN_AS2, COL115 PERSON_KNOWN_AS3, COL116 PERSON_KNOWN_AS4, COL117 PERSON_KNOWN_AS5, COL118 LABOR_SURPLUS_INDICATOR, COL119 LOCAL_ACTIVITY_CODE, COL120 LOCAL_ACTIVITY_CODE_TYPE, COL121 LOCATION_DIRECTIONS, COL122 LOCATION_STATUS, COL123 MARITAL_STATUS, COL124 MARITAL_STATUS_EFFECTIVE_DATE, COL125 MINORITY_OWNED_INDICATOR, COL126 MINORITY_OWNED_TYPE, COL127 ORGANIZATION_ALIAS, COL128 ORGANIZATION_TYPE, COL129 ORGANIZATION_URL, COL130 OUT_OF_BUSINESS_INDICATOR, COL131 PERSONAL_INCOME, COL132 PERSON_ACADEMIC_TITLE, COL133 PERSON_FIRST_NAME_PHONETIC, COL134 PERSON_LAST_NAME_PHONETIC, COL135 MIDDLE_NAME_PHONETIC, COL136 PERSON_NAME_PHONETIC, COL137 PERSON_PREVIOUS_TITLE_NAME, COL138 PLACE_OF_BIRTH, COL139 PREFERRED_NAME, COL140 PRINCIPAL_NAME, COL141 PRINCIPAL_TITLE, COL142 PUBLIC_PRIVATE_OWNERSHIP_FLAG, COL143 RENT_OWNED_INDICATOR, COL144 RENT_OWNER_INDICATOR, COL145 SECOND_TITLE, COL146 SHORT_DESCRIPTION, COL147 SMALL_BUSINESS_INDICATOR, COL148 TAX_ID, COL149 WOMAN_OWNED_INDICATOR, COL150 ORGANIZATION_ATTRIBUTE1, COL151 ORGANIZATION_ATTRIBUTE2, COL152 ORGANIZATION_ATTRIBUTE3, COL153 ORGANIZATION_ATTRIBUTE4, COL154 ORGANIZATION_ATTRIBUTE5, COL155 ORGANIZATION_ATTRIBUTE6, COL156 ORGANIZATION_ATTRIBUTE7, COL157 ORGANIZATION_ATTRIBUTE8, COL158 ORGANIZATION_ATTRIBUTE9, COL159 ORGANIZATION_ATTRIBUTE10, COL160 ORGANIZATION_ATTRIBUTE11, COL161 ORGANIZATION_ATTRIBUTE12, COL162 ORGANIZATION_ATTRIBUTE13, COL163 ORGANIZATION_ATTRIBUTE14, COL164 ORGANIZATION_ATTRIBUTE15, COL165 PERSON_ATTRIBUTE1, COL166 PERSON_ATTRIBUTE2, COL167 PERSON_ATTRIBUTE3, COL168 PERSON_ATTRIBUTE4, COL169 PERSON_ATTRIBUTE5, COL170 PERSON_ATTRIBUTE6, COL171 PERSON_ATTRIBUTE7, COL172 PERSON_ATTRIBUTE8, COL173 PERSON_ATTRIBUTE9, COL174 PERSON_ATTRIBUTE10, COL175 PERSON_ATTRIBUTE11, COL176 PERSON_ATTRIBUTE12, COL177 PERSON_ATTRIBUTE13, COL178 PERSON_ATTRIBUTE14, COL179 PERSON_ATTRIBUTE15, COL180 ORG_CONTACT_ATTRIBUTE1, COL181 ORG_CONTACT_ATTRIBUTE2, COL182 ORG_CONTACT_ATTRIBUTE3, COL183 ORG_CONTACT_ATTRIBUTE4, COL184 ORG_CONTACT_ATTRIBUTE5, COL185 ORG_CONTACT_ATTRIBUTE6, COL186 ORG_CONTACT_ATTRIBUTE7, COL187 ORG_CONTACT_ATTRIBUTE8, COL188 ORG_CONTACT_ATTRIBUTE9, COL189 ORG_CONTACT_ATTRIBUTE10, COL190 ORG_CONTACT_ATTRIBUTE11, COL191 ORG_CONTACT_ATTRIBUTE12, COL192 ORG_CONTACT_ATTRIBUTE13, COL193 ORG_CONTACT_ATTRIBUTE14, COL194 ORG_CONTACT_ATTRIBUTE15, COL195 ADDRESS_ATTRIBUTE1, COL196 ADDRESS_ATTRIBUTE2, COL197 ADDRESS_ATTRIBUTE3, COL198 ADDRESS_ATTRIBUTE4, COL199 ADDRESS_ATTRIBUTE5, COL200 ADDRESS_ATTRIBUTE6, COL201 ADDRESS_ATTRIBUTE7, COL202 ADDRESS_ATTRIBUTE8, COL203 ADDRESS_ATTRIBUTE9, COL204 ADDRESS_ATTRIBUTE10, COL205 ADDRESS_ATTRIBUTE11, COL206 ADDRESS_ATTRIBUTE12, COL207 ADDRESS_ATTRIBUTE13, COL208 ADDRESS_ATTRIBUTE14, COL209 ADDRESS_ATTRIBUTE15, COL210 FAX_COUNTRY_CODE, COL211 FAX_AREA_CODE, COL212 FAX_NUMBER, COL213 ORG_ATTRIBUTE_CATEGORY, COL214 PERSON_ATTRIBUTE_CATEGORY, COL215 ORG_CONTACT_ATTRIBUTE_CATEGORY, COL216 ADDRESS_ATTRIBUTE_CATEGORY, COL217 PARTY_SITE_USE, COL218 ORIG_SYSTEM_REFERENCE, COL219 RELATIONSHIP_TYPE, COL220 RELATIONSHIP_CODE, ORG_KEY ORG_KEY, PERSON_KEY PERSON_KEY, ORG_EXIST ORG_EXIST, ORG_PARTY_ID ORG_PARTY_ID, OCONT_PARTY_ID OCONT_PARTY_ID, OCONT_EXIST OCONT_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, COL221 ORG_EMAIL_ADDRESS, COL222 ORG_PH_COUNTRY_CODE, COL223 ORG_PH_AREA_CODE, COL224 ORG_PH_NUMBER, COL225 ORG_PH_EXTENSION, COL226 ORG_COUNTRY, COL227 ORG_ADDRESS1, COL228 ORG_ADDRESS2, COL229 ORG_ADDRESS3, COL230 ORG_ADDRESS4, COL231 ORG_CITY, COL232 ORG_COUNTY, COL233 ORG_STATE, COL234 ORG_PROVINCE, COL235 ORG_POSTAL_CODE, COL236 ORG_ADDR_ATTRIBUTE_CATEGORY, COL237 ORG_ADDR_ATTRIBUTE1, COL238 ORG_ADDR_ATTRIBUTE2, COL239 ORG_ADDR_ATTRIBUTE3, COL240 ORG_ADDR_ATTRIBUTE4, COL241 ORG_ADDR_ATTRIBUTE5, COL242 ORG_ADDR_ATTRIBUTE6, COL243 ORG_ADDR_ATTRIBUTE7, COL244 ORG_ADDR_ATTRIBUTE8, COL245 ORG_ADDR_ATTRIBUTE9, COL246 ORG_ADDR_ATTRIBUTE10, COL247 ORG_ADDR_ATTRIBUTE11, COL248 ORG_ADDR_ATTRIBUTE12, COL249 ORG_ADDR_ATTRIBUTE13, COL251 ORG_ADDR_ATTRIBUTE14, COL252 ORG_ADDR_ATTRIBUTE15, COL253 ORG_ADDR_ATTRIBUTE16, COL254 ORG_ADDR_ATTRIBUTE17, COL255 ORG_ADDR_ATTRIBUTE18, COL256 ORG_ADDR_ATTRIBUTE19, COL257 ORG_ADDR_ATTRIBUTE20, COL258 ORG_PS_ATTRIBUTE_CATEGORY, COL259 ORG_PS_ATTRIBUTE1, COL260 ORG_PS_ATTRIBUTE2, COL261 ORG_PS_ATTRIBUTE3, COL262 ORG_PS_ATTRIBUTE4, COL263 ORG_PS_ATTRIBUTE5, COL264 ORG_PS_ATTRIBUTE6, COL265 ORG_PS_ATTRIBUTE7, COL266 ORG_PS_ATTRIBUTE8, COL267 ORG_PS_ATTRIBUTE9, COL268 ORG_PS_ATTRIBUTE10, COL269 ORG_PS_ATTRIBUTE11, COL270 ORG_PS_ATTRIBUTE12, COL271 ORG_PS_ATTRIBUTE13, COL272 ORG_PS_ATTRIBUTE14, COL273 ORG_PS_ATTRIBUTE15, COL274 ORG_PS_ATTRIBUTE16, COL275 ORG_PS_ATTRIBUTE17, COL276 ORG_PS_ATTRIBUTE18, COL277 ORG_PS_ATTRIBUTE19, COL278 ORG_PS_ATTRIBUTE20, COL279 ORG_CPS_ATTRIBUTE_CATEGORY, COL280 ORG_CPS_ATTRIBUTE1, COL281 ORG_CPS_ATTRIBUTE2, COL282 ORG_CPS_ATTRIBUTE3, COL283 ORG_CPS_ATTRIBUTE4, COL284 ORG_CPS_ATTRIBUTE5, COL285 ORG_CPS_ATTRIBUTE6, COL286 ORG_CPS_ATTRIBUTE7, COL287 ORG_CPS_ATTRIBUTE8, COL288 ORG_CPS_ATTRIBUTE9, COL289 ORG_CPS_ATTRIBUTE10, COL290 ORG_CPS_ATTRIBUTE11, COL291 ORG_CPS_ATTRIBUTE12, COL292 ORG_CPS_ATTRIBUTE13, COL293 ORG_CPS_ATTRIBUTE14, COL294 ORG_CPS_ATTRIBUTE15, COL295 ORG_CPS_ATTRIBUTE16, COL296 ORG_CPS_ATTRIBUTE17, COL297 ORG_CPS_ATTRIBUTE18, COL298 ORG_CPS_ATTRIBUTE19, COL299 ORG_CPS_ATTRIBUTE20, COL300 PHONE_TYPE, COL301 ORG_PHONE_TYPE, COL302 NATIVE_LANGUAGE, ORG_LOCATION_ID ORG_LOCATION_ID, ORG_ADDRESS_KEY ORG_ADDRESS_KEY, COL303 ORGANIZATION_ATTRIBUTE16, COL304 ORGANIZATION_ATTRIBUTE17, COL305 ORGANIZATION_ATTRIBUTE18, COL306 ORGANIZATION_ATTRIBUTE19, COL307 ORGANIZATION_ATTRIBUTE20, COL308 ORGANIZATION_ATTRIBUTE21, COL309 ORGANIZATION_ATTRIBUTE22, COL310 ORGANIZATION_ATTRIBUTE23, COL311 ORGANIZATION_ATTRIBUTE24, COL312 PERSON_ATTRIBUTE16, COL313 PERSON_ATTRIBUTE17, COL314 PERSON_ATTRIBUTE18, COL315 PERSON_ATTRIBUTE19, COL316 PERSON_ATTRIBUTE20, COL317 PERSON_ATTRIBUTE21, COL318 PERSON_ATTRIBUTE22, COL319 PERSON_ATTRIBUTE23, COL320 PERSON_ATTRIBUTE24, COL321 ORG_CONTACT_ATTRIBUTE16, COL322 ORG_CONTACT_ATTRIBUTE17, COL323 ORG_CONTACT_ATTRIBUTE18, COL324 ORG_CONTACT_ATTRIBUTE19, COL325 ORG_CONTACT_ATTRIBUTE20, COL326 ORG_CONTACT_ATTRIBUTE21, COL327 ORG_CONTACT_ATTRIBUTE22, COL328 ORG_CONTACT_ATTRIBUTE23, COL329 ORG_CONTACT_ATTRIBUTE24, COL330 ADDRESS_ATTRIBUTE16, COL331 ADDRESS_ATTRIBUTE17, COL332 ADDRESS_ATTRIBUTE18, COL333 ADDRESS_ATTRIBUTE19, COL334 ADDRESS_ATTRIBUTE20, COL335 ORG_PS_PH_COUNTRY_CODE, COL336 ORG_PS_PH_AREA_CODE, COL337 ORG_PS_PH_NUMBER, COL338 ORG_PS_PH_EXTENSION, COL339 ORG_PS_PH_TYPE, COL340 JOB_TITLE_CODE, 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, COL250 AMS_COL401, COL250 AMS_COL402, COL250 AMS_COL403, COL250 AMS_COL404, COL250 AMS_COL405, COL250 AMS_COL406, COL250 AMS_COL407, COL250 AMS_COL408, COL250 AMS_COL409, COL250 AMS_COL410, COL250 AMS_COL411, COL250 AMS_COL412, COL250 AMS_COL413, COL250 AMS_COL414, COL250 AMS_COL415, COL250 AMS_COL416, COL250 AMS_COL417, COL250 AMS_COL418, COL250 AMS_COL419, COL250 AMS_COL420, COL250 AMS_COL421, COL250 AMS_COL422, COL250 AMS_COL423, COL250 AMS_COL424, COL250 AMS_COL425, COL250 AMS_COL426, COL250 AMS_COL427, COL250 AMS_COL428, COL250 AMS_COL429, COL250 AMS_COL430, COL250 AMS_COL431, COL250 AMS_COL432, COL250 AMS_COL433, COL250 AMS_COL434, COL250 AMS_COL435, COL250 AMS_COL436, COL250 AMS_COL437, COL250 AMS_COL438, COL250 AMS_COL439, COL250 AMS_COL440, COL250 AMS_COL441, COL250 AMS_COL442, COL250 AMS_COL443, COL250 AMS_COL444, COL250 AMS_COL445, COL250 AMS_COL446, COL250 AMS_COL447, COL250 AMS_COL448, COL250 AMS_COL449, COL250 AMS_COL450, COL250 AMS_COL451, COL250 AMS_COL452, COL250 AMS_COL453, COL250 AMS_COL454, COL250 AMS_COL455, COL250 AMS_COL456, COL250 AMS_COL457, COL250 AMS_COL458, COL250 AMS_COL459, COL250 AMS_COL460, COL250 AMS_COL461, COL250 AMS_COL462, COL250 AMS_COL463, COL250 AMS_COL464, COL250 AMS_COL465, COL250 AMS_COL466, COL250 AMS_COL467, COL250 AMS_COL468, COL250 AMS_COL469, COL250 AMS_COL470, COL250 AMS_COL471, COL250 AMS_COL472, COL250 AMS_COL473, COL250 AMS_COL474, COL250 AMS_COL475, COL250 AMS_COL476, COL250 AMS_COL477, COL250 AMS_COL478, COL250 AMS_COL479, COL250 AMS_COL480, COL250 AMS_COL481, COL250 AMS_COL482, COL250 AMS_COL483, COL250 AMS_COL484, COL250 AMS_COL485, COL250 AMS_COL486, COL250 AMS_COL487, COL250 AMS_COL488, COL250 AMS_COL489, COL250 AMS_COL490, COL250 AMS_COL491, COL250 AMS_COL492, COL250 AMS_COL493, COL250 AMS_COL494, COL250 AMS_COL495, COL250 AMS_COL496, COL250 AMS_COL497, COL250 AMS_COL498, COL250 AMS_COL499, COL250 AMS_COL500, COL250 AMS_COL501, COL250 AMS_COL502, COL250 AMS_COL503, COL250 AMS_COL504, COL250 AMS_COL505, COL250 AMS_COL506, COL250 AMS_COL507, COL250 AMS_COL508, COL250 AMS_COL509, COL250 AMS_COL510, COL250 AMS_COL511, COL250 AMS_COL512, COL250 AMS_COL513, COL250 AMS_COL514, COL250 AMS_COL515, COL250 AMS_COL516, COL250 AMS_COL517, COL250 AMS_COL518, COL250 AMS_COL519, COL250 AMS_COL520, COL250 AMS_COL521, COL250 AMS_COL522, COL250 AMS_COL523, COL250 AMS_COL524, COL250 AMS_COL525, COL250 AMS_COL526, COL250 AMS_COL527, COL250 AMS_COL528, COL250 AMS_COL529, COL250 AMS_COL530, COL250 AMS_COL531, COL250 AMS_COL532, COL250 AMS_COL533, COL250 AMS_COL534, COL250 AMS_COL535 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 = 'B2B' 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.ORGANIZATION_ID ORGANIZATION_ID
, LINE.PARTY_ID PARTY_ID
, COL1 PARTY_NAME
, COL2 FISCAL_YEAREND_MONTH
, COL3 DUNS_NUMBER
, COL4 LEGAL_STATUS
, COL5 EMPLOYEES_TOTAL
, COL6 LINE_OF_BUSINESS
, COL7 YEAR_ESTABLISHED
, COL8 TAX_REFERENCE
, COL9 CEO_NAME
, 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
, COL31 DEPARTMENT
, COL32 JOB_TITLE
, COL33 DECISION_MAKER_FLAG
, COL36 SITE_USE_TYPE
, COL37 SIC_CODE
, COL38 SIC_CODE_TYPE
, COL39 TOTAL_NUM_OF_ORDERS
, COL40 TOTAL_ORDERED_AMOUNT
, COL41 LAST_ORDERED_DATE
, COL42 ANALYSIS_FY
, COL43 CURR_FY_POTENTIAL_REVENUE
, COL44 NEXT_FY_POTENTIAL_REVENUE
, COL45 GSA_INDICATOR_FLAG
, COL46 MISSION_STATEMENT
, COL47 ORGANIZATION_NAME_PHONETIC
, COL48 CATEGORY_CODE
, COL49 JGZZ_FISCAL_CODE
, COL50 TAX_NAME
, 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 ORG_IMP_XML_ELEMENT_ID
, COL69 ADD_IMP_XML_ELEMENT_ID
, COL70 OCONT_IMP_XML_ELEMENT_ID
, COL71 CP_IMP_XML_ELEMENT_ID
, COL72 EM_IMP_XML_ELEMENT_ID
, COL73 ADDRESS_EFFECTIVE_DATE
, COL74 ADDRESS_EXPIRATION_DATE
, COL75 ANNUAL_REVENUE
, COL76 ANNUAL_REVENUE_CURRENCY
, COL77 BRANCH_FLAG
, COL78 BUSINESS_LINE
, COL79 BUSINESS_SCOPE
, COL80 CHIEF_EXECUTIVE_TITLE
, COL81 CONGRESSIONAL_DISTRICT_CODE
, COL82 CONTROL_YEAR
, COL83 CORPORATION_CLASS
, COL84 CREDIT_SCORE
, COL85 CREDIT_SCORE_COMMENTARY
, COL86 CUSTOMER_CATEGORY
, COL87 DB_RATING
, COL88 DATE_OF_BIRTH
, COL89 DATE_OF_DEATH
, COL90 DEBARMENTS_COUNT
, COL91 DEBARTMENTS_DATE
, COL92 DECLARED_ETHNICITY
, COL93 DEPARTMENT_INDICATOR
, COL94 DESCRIPTION
, COL95 DISADVANTAGED_INDICATOR
, COL96 ENQUIRY_DUNS
, COL97 EXPORT_INDICATOR
, COL98 FAILURE_SCORE
, COL99 FAILURE_SCORE_COMMENTARY
, COL100 FAILURE_SCORE_NATL_PERCENTILE
, COL101 FAILURE_SCORE_OVERRIDE_CODE
, COL102 FISCAL_CODE
, COL103 GLOBAL_FAILURE_SCORE
, COL104 HEADQUARTER_BRANCH_INDICATOR
, COL105 HEAD_OF_HOUSEHOLD_FLAG
, COL106 HOUSEHOLD_SIZE
, COL107 IMPORT_INDICATOR
, COL108 ORGANIZATION_KNOWN_AS
, COL109 ORGANIZATION_KNOWN_AS2
, COL110 ORGANIZATION_KNOWN_AS3
, COL111 ORGANIZATION_KNOWN_AS4
, COL112 ORGANIZATION_KNOWN_AS5
, COL113 PERSON_KNOWN_AS
, COL114 PERSON_KNOWN_AS2
, COL115 PERSON_KNOWN_AS3
, COL116 PERSON_KNOWN_AS4
, COL117 PERSON_KNOWN_AS5
, COL118 LABOR_SURPLUS_INDICATOR
, COL119 LOCAL_ACTIVITY_CODE
, COL120 LOCAL_ACTIVITY_CODE_TYPE
, COL121 LOCATION_DIRECTIONS
, COL122 LOCATION_STATUS
, COL123 MARITAL_STATUS
, COL124 MARITAL_STATUS_EFFECTIVE_DATE
, COL125 MINORITY_OWNED_INDICATOR
, COL126 MINORITY_OWNED_TYPE
, COL127 ORGANIZATION_ALIAS
, COL128 ORGANIZATION_TYPE
, COL129 ORGANIZATION_URL
, COL130 OUT_OF_BUSINESS_INDICATOR
, COL131 PERSONAL_INCOME
, COL132 PERSON_ACADEMIC_TITLE
, COL133 PERSON_FIRST_NAME_PHONETIC
, COL134 PERSON_LAST_NAME_PHONETIC
, COL135 MIDDLE_NAME_PHONETIC
, COL136 PERSON_NAME_PHONETIC
, COL137 PERSON_PREVIOUS_TITLE_NAME
, COL138 PLACE_OF_BIRTH
, COL139 PREFERRED_NAME
, COL140 PRINCIPAL_NAME
, COL141 PRINCIPAL_TITLE
, COL142 PUBLIC_PRIVATE_OWNERSHIP_FLAG
, COL143 RENT_OWNED_INDICATOR
, COL144 RENT_OWNER_INDICATOR
, COL145 SECOND_TITLE
, COL146 SHORT_DESCRIPTION
, COL147 SMALL_BUSINESS_INDICATOR
, COL148 TAX_ID
, COL149 WOMAN_OWNED_INDICATOR
, COL150 ORGANIZATION_ATTRIBUTE1
, COL151 ORGANIZATION_ATTRIBUTE2
, COL152 ORGANIZATION_ATTRIBUTE3
, COL153 ORGANIZATION_ATTRIBUTE4
, COL154 ORGANIZATION_ATTRIBUTE5
, COL155 ORGANIZATION_ATTRIBUTE6
, COL156 ORGANIZATION_ATTRIBUTE7
, COL157 ORGANIZATION_ATTRIBUTE8
, COL158 ORGANIZATION_ATTRIBUTE9
, COL159 ORGANIZATION_ATTRIBUTE10
, COL160 ORGANIZATION_ATTRIBUTE11
, COL161 ORGANIZATION_ATTRIBUTE12
, COL162 ORGANIZATION_ATTRIBUTE13
, COL163 ORGANIZATION_ATTRIBUTE14
, COL164 ORGANIZATION_ATTRIBUTE15
, COL165 PERSON_ATTRIBUTE1
, COL166 PERSON_ATTRIBUTE2
, COL167 PERSON_ATTRIBUTE3
, COL168 PERSON_ATTRIBUTE4
, COL169 PERSON_ATTRIBUTE5
, COL170 PERSON_ATTRIBUTE6
, COL171 PERSON_ATTRIBUTE7
, COL172 PERSON_ATTRIBUTE8
, COL173 PERSON_ATTRIBUTE9
, COL174 PERSON_ATTRIBUTE10
, COL175 PERSON_ATTRIBUTE11
, COL176 PERSON_ATTRIBUTE12
, COL177 PERSON_ATTRIBUTE13
, COL178 PERSON_ATTRIBUTE14
, COL179 PERSON_ATTRIBUTE15
, COL180 ORG_CONTACT_ATTRIBUTE1
, COL181 ORG_CONTACT_ATTRIBUTE2
, COL182 ORG_CONTACT_ATTRIBUTE3
, COL183 ORG_CONTACT_ATTRIBUTE4
, COL184 ORG_CONTACT_ATTRIBUTE5
, COL185 ORG_CONTACT_ATTRIBUTE6
, COL186 ORG_CONTACT_ATTRIBUTE7
, COL187 ORG_CONTACT_ATTRIBUTE8
, COL188 ORG_CONTACT_ATTRIBUTE9
, COL189 ORG_CONTACT_ATTRIBUTE10
, COL190 ORG_CONTACT_ATTRIBUTE11
, COL191 ORG_CONTACT_ATTRIBUTE12
, COL192 ORG_CONTACT_ATTRIBUTE13
, COL193 ORG_CONTACT_ATTRIBUTE14
, COL194 ORG_CONTACT_ATTRIBUTE15
, COL195 ADDRESS_ATTRIBUTE1
, COL196 ADDRESS_ATTRIBUTE2
, COL197 ADDRESS_ATTRIBUTE3
, COL198 ADDRESS_ATTRIBUTE4
, COL199 ADDRESS_ATTRIBUTE5
, COL200 ADDRESS_ATTRIBUTE6
, COL201 ADDRESS_ATTRIBUTE7
, COL202 ADDRESS_ATTRIBUTE8
, COL203 ADDRESS_ATTRIBUTE9
, COL204 ADDRESS_ATTRIBUTE10
, COL205 ADDRESS_ATTRIBUTE11
, COL206 ADDRESS_ATTRIBUTE12
, COL207 ADDRESS_ATTRIBUTE13
, COL208 ADDRESS_ATTRIBUTE14
, COL209 ADDRESS_ATTRIBUTE15
, COL210 FAX_COUNTRY_CODE
, COL211 FAX_AREA_CODE
, COL212 FAX_NUMBER
, COL213 ORG_ATTRIBUTE_CATEGORY
, COL214 PERSON_ATTRIBUTE_CATEGORY
, COL215 ORG_CONTACT_ATTRIBUTE_CATEGORY
, COL216 ADDRESS_ATTRIBUTE_CATEGORY
, COL217 PARTY_SITE_USE
, COL218 ORIG_SYSTEM_REFERENCE
, COL219 RELATIONSHIP_TYPE
, COL220 RELATIONSHIP_CODE
, ORG_KEY ORG_KEY
, PERSON_KEY PERSON_KEY
, ORG_EXIST ORG_EXIST
, ORG_PARTY_ID ORG_PARTY_ID
, OCONT_PARTY_ID OCONT_PARTY_ID
, OCONT_EXIST OCONT_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
, COL221 ORG_EMAIL_ADDRESS
, COL222 ORG_PH_COUNTRY_CODE
, COL223 ORG_PH_AREA_CODE
, COL224 ORG_PH_NUMBER
, COL225 ORG_PH_EXTENSION
, COL226 ORG_COUNTRY
, COL227 ORG_ADDRESS1
, COL228 ORG_ADDRESS2
, COL229 ORG_ADDRESS3
, COL230 ORG_ADDRESS4
, COL231 ORG_CITY
, COL232 ORG_COUNTY
, COL233 ORG_STATE
, COL234 ORG_PROVINCE
, COL235 ORG_POSTAL_CODE
, COL236 ORG_ADDR_ATTRIBUTE_CATEGORY
, COL237 ORG_ADDR_ATTRIBUTE1
, COL238 ORG_ADDR_ATTRIBUTE2
, COL239 ORG_ADDR_ATTRIBUTE3
, COL240 ORG_ADDR_ATTRIBUTE4
, COL241 ORG_ADDR_ATTRIBUTE5
, COL242 ORG_ADDR_ATTRIBUTE6
, COL243 ORG_ADDR_ATTRIBUTE7
, COL244 ORG_ADDR_ATTRIBUTE8
, COL245 ORG_ADDR_ATTRIBUTE9
, COL246 ORG_ADDR_ATTRIBUTE10
, COL247 ORG_ADDR_ATTRIBUTE11
, COL248 ORG_ADDR_ATTRIBUTE12
, COL249 ORG_ADDR_ATTRIBUTE13
, COL251 ORG_ADDR_ATTRIBUTE14
, COL252 ORG_ADDR_ATTRIBUTE15
, COL253 ORG_ADDR_ATTRIBUTE16
, COL254 ORG_ADDR_ATTRIBUTE17
, COL255 ORG_ADDR_ATTRIBUTE18
, COL256 ORG_ADDR_ATTRIBUTE19
, COL257 ORG_ADDR_ATTRIBUTE20
, COL258 ORG_PS_ATTRIBUTE_CATEGORY
, COL259 ORG_PS_ATTRIBUTE1
, COL260 ORG_PS_ATTRIBUTE2
, COL261 ORG_PS_ATTRIBUTE3
, COL262 ORG_PS_ATTRIBUTE4
, COL263 ORG_PS_ATTRIBUTE5
, COL264 ORG_PS_ATTRIBUTE6
, COL265 ORG_PS_ATTRIBUTE7
, COL266 ORG_PS_ATTRIBUTE8
, COL267 ORG_PS_ATTRIBUTE9
, COL268 ORG_PS_ATTRIBUTE10
, COL269 ORG_PS_ATTRIBUTE11
, COL270 ORG_PS_ATTRIBUTE12
, COL271 ORG_PS_ATTRIBUTE13
, COL272 ORG_PS_ATTRIBUTE14
, COL273 ORG_PS_ATTRIBUTE15
, COL274 ORG_PS_ATTRIBUTE16
, COL275 ORG_PS_ATTRIBUTE17
, COL276 ORG_PS_ATTRIBUTE18
, COL277 ORG_PS_ATTRIBUTE19
, COL278 ORG_PS_ATTRIBUTE20
, COL279 ORG_CPS_ATTRIBUTE_CATEGORY
, COL280 ORG_CPS_ATTRIBUTE1
, COL281 ORG_CPS_ATTRIBUTE2
, COL282 ORG_CPS_ATTRIBUTE3
, COL283 ORG_CPS_ATTRIBUTE4
, COL284 ORG_CPS_ATTRIBUTE5
, COL285 ORG_CPS_ATTRIBUTE6
, COL286 ORG_CPS_ATTRIBUTE7
, COL287 ORG_CPS_ATTRIBUTE8
, COL288 ORG_CPS_ATTRIBUTE9
, COL289 ORG_CPS_ATTRIBUTE10
, COL290 ORG_CPS_ATTRIBUTE11
, COL291 ORG_CPS_ATTRIBUTE12
, COL292 ORG_CPS_ATTRIBUTE13
, COL293 ORG_CPS_ATTRIBUTE14
, COL294 ORG_CPS_ATTRIBUTE15
, COL295 ORG_CPS_ATTRIBUTE16
, COL296 ORG_CPS_ATTRIBUTE17
, COL297 ORG_CPS_ATTRIBUTE18
, COL298 ORG_CPS_ATTRIBUTE19
, COL299 ORG_CPS_ATTRIBUTE20
, COL300 PHONE_TYPE
, COL301 ORG_PHONE_TYPE
, COL302 NATIVE_LANGUAGE
, ORG_LOCATION_ID ORG_LOCATION_ID
, ORG_ADDRESS_KEY ORG_ADDRESS_KEY
, COL303 ORGANIZATION_ATTRIBUTE16
, COL304 ORGANIZATION_ATTRIBUTE17
, COL305 ORGANIZATION_ATTRIBUTE18
, COL306 ORGANIZATION_ATTRIBUTE19
, COL307 ORGANIZATION_ATTRIBUTE20
, COL308 ORGANIZATION_ATTRIBUTE21
, COL309 ORGANIZATION_ATTRIBUTE22
, COL310 ORGANIZATION_ATTRIBUTE23
, COL311 ORGANIZATION_ATTRIBUTE24
, COL312 PERSON_ATTRIBUTE16
, COL313 PERSON_ATTRIBUTE17
, COL314 PERSON_ATTRIBUTE18
, COL315 PERSON_ATTRIBUTE19
, COL316 PERSON_ATTRIBUTE20
, COL317 PERSON_ATTRIBUTE21
, COL318 PERSON_ATTRIBUTE22
, COL319 PERSON_ATTRIBUTE23
, COL320 PERSON_ATTRIBUTE24
, COL321 ORG_CONTACT_ATTRIBUTE16
, COL322 ORG_CONTACT_ATTRIBUTE17
, COL323 ORG_CONTACT_ATTRIBUTE18
, COL324 ORG_CONTACT_ATTRIBUTE19
, COL325 ORG_CONTACT_ATTRIBUTE20
, COL326 ORG_CONTACT_ATTRIBUTE21
, COL327 ORG_CONTACT_ATTRIBUTE22
, COL328 ORG_CONTACT_ATTRIBUTE23
, COL329 ORG_CONTACT_ATTRIBUTE24
, COL330 ADDRESS_ATTRIBUTE16
, COL331 ADDRESS_ATTRIBUTE17
, COL332 ADDRESS_ATTRIBUTE18
, COL333 ADDRESS_ATTRIBUTE19
, COL334 ADDRESS_ATTRIBUTE20
, COL335 ORG_PS_PH_COUNTRY_CODE
, COL336 ORG_PS_PH_AREA_CODE
, COL337 ORG_PS_PH_NUMBER
, COL338 ORG_PS_PH_EXTENSION
, COL339 ORG_PS_PH_TYPE
, COL340 JOB_TITLE_CODE
, 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
, COL250 AMS_COL401
, COL250 AMS_COL402
, COL250 AMS_COL403
, COL250 AMS_COL404
, COL250 AMS_COL405
, COL250 AMS_COL406
, COL250 AMS_COL407
, COL250 AMS_COL408
, COL250 AMS_COL409
, COL250 AMS_COL410
, COL250 AMS_COL411
, COL250 AMS_COL412
, COL250 AMS_COL413
, COL250 AMS_COL414
, COL250 AMS_COL415
, COL250 AMS_COL416
, COL250 AMS_COL417
, COL250 AMS_COL418
, COL250 AMS_COL419
, COL250 AMS_COL420
, COL250 AMS_COL421
, COL250 AMS_COL422
, COL250 AMS_COL423
, COL250 AMS_COL424
, COL250 AMS_COL425
, COL250 AMS_COL426
, COL250 AMS_COL427
, COL250 AMS_COL428
, COL250 AMS_COL429
, COL250 AMS_COL430
, COL250 AMS_COL431
, COL250 AMS_COL432
, COL250 AMS_COL433
, COL250 AMS_COL434
, COL250 AMS_COL435
, COL250 AMS_COL436
, COL250 AMS_COL437
, COL250 AMS_COL438
, COL250 AMS_COL439
, COL250 AMS_COL440
, COL250 AMS_COL441
, COL250 AMS_COL442
, COL250 AMS_COL443
, COL250 AMS_COL444
, COL250 AMS_COL445
, COL250 AMS_COL446
, COL250 AMS_COL447
, COL250 AMS_COL448
, COL250 AMS_COL449
, COL250 AMS_COL450
, COL250 AMS_COL451
, COL250 AMS_COL452
, COL250 AMS_COL453
, COL250 AMS_COL454
, COL250 AMS_COL455
, COL250 AMS_COL456
, COL250 AMS_COL457
, COL250 AMS_COL458
, COL250 AMS_COL459
, COL250 AMS_COL460
, COL250 AMS_COL461
, COL250 AMS_COL462
, COL250 AMS_COL463
, COL250 AMS_COL464
, COL250 AMS_COL465
, COL250 AMS_COL466
, COL250 AMS_COL467
, COL250 AMS_COL468
, COL250 AMS_COL469
, COL250 AMS_COL470
, COL250 AMS_COL471
, COL250 AMS_COL472
, COL250 AMS_COL473
, COL250 AMS_COL474
, COL250 AMS_COL475
, COL250 AMS_COL476
, COL250 AMS_COL477
, COL250 AMS_COL478
, COL250 AMS_COL479
, COL250 AMS_COL480
, COL250 AMS_COL481
, COL250 AMS_COL482
, COL250 AMS_COL483
, COL250 AMS_COL484
, COL250 AMS_COL485
, COL250 AMS_COL486
, COL250 AMS_COL487
, COL250 AMS_COL488
, COL250 AMS_COL489
, COL250 AMS_COL490
, COL250 AMS_COL491
, COL250 AMS_COL492
, COL250 AMS_COL493
, COL250 AMS_COL494
, COL250 AMS_COL495
, COL250 AMS_COL496
, COL250 AMS_COL497
, COL250 AMS_COL498
, COL250 AMS_COL499
, COL250 AMS_COL500
, COL250 AMS_COL501
, COL250 AMS_COL502
, COL250 AMS_COL503
, COL250 AMS_COL504
, COL250 AMS_COL505
, COL250 AMS_COL506
, COL250 AMS_COL507
, COL250 AMS_COL508
, COL250 AMS_COL509
, COL250 AMS_COL510
, COL250 AMS_COL511
, COL250 AMS_COL512
, COL250 AMS_COL513
, COL250 AMS_COL514
, COL250 AMS_COL515
, COL250 AMS_COL516
, COL250 AMS_COL517
, COL250 AMS_COL518
, COL250 AMS_COL519
, COL250 AMS_COL520
, COL250 AMS_COL521
, COL250 AMS_COL522
, COL250 AMS_COL523
, COL250 AMS_COL524
, COL250 AMS_COL525
, COL250 AMS_COL526
, COL250 AMS_COL527
, COL250 AMS_COL528
, COL250 AMS_COL529
, COL250 AMS_COL530
, COL250 AMS_COL531
, COL250 AMS_COL532
, COL250 AMS_COL533
, COL250 AMS_COL534
, COL250 AMS_COL535
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 = 'B2B'
AND NVL(LINE.DUPLICATE_FLAG
, 'N') = 'N'