HZ_IMP_ORG_PROFILES_SR_V

Details

• Schema: FUSION

• Object owner: HZ

• Object type: VIEW

Columns

Name

ACTION_CODE PROCESS_CODE PROCESS_ID RECORD_DATE RECORD_ID SOURCE_RECORD_ID RECORD_VERSION SOURCE_RECORD_DATE SOURCE_RECORD_VERSION YEAR_ESTABLISHED WOMAN_OWNED_IND UNIQUE_NAME_SUFFIX UNIQUE_NAME_ALIAS TOTAL_PAYMENTS TOTAL_EMP_MIN_IND TOTAL_EMP_EST_IND TOTAL_EMPLOYEES_TEXT TOTAL_EMPLOYEES_IND SUFFIX_OVERRIDDEN_FLAG STOCK_SYMBOL SMALL_BUS_IND SEBL_USER_KEY_LOC RENT_OWN_IND REGISTRATION_TYPE PUBLIC_PRIVATE_OWNERSHIP_FLAG PRINCIPAL_TITLE PRINCIPAL_NAME PREF_FUNCTIONAL_CURRENCY PARTY_NUMBER PARENT_SUB_IND PARENT_DUNS_NUM_C ORGANIZATION_TYPE ORGANIZATION_SIZE ORGANIZATION_NAME OOB_IND NEXT_FY_POTENTIAL_REVENUE MISSION_STATEMENT MINORITY_OWNED_TYPE MINORITY_OWNED_IND LOCAL_BUS_IDEN_TYPE LOCAL_BUS_IDENTIFIER LINE_OF_BUSINESS LEGAL_STATUS LABOR_SURPLUS_IND JGZZ_FISCAL_CODE INCORP_YEAR IMPORT_IND HQ_BRANCH_IND HOME_COUNTRY GSA_INDICATOR_FLAG GROWTH_STRATEGY_DESC GLOBAL_ULTIMATE_DUNS_NUM_C FISCAL_YEAREND_MONTH EXPORT_IND EMP_AT_PRIMARY_ADR_TEXT EMP_AT_PRIMARY_ADR_MIN_IND EMP_AT_PRIMARY_ADR_EST_IND EMP_AT_PRIMARY_ADR EMPLOYEES_TOTAL DUNS_NUMBER_C DO_NOT_CONFUSE_WITH DOMESTIC_ULTIMATE_DUNS_NUM_C DISADV_8A_IND CURR_FY_POTENTIAL_REVENUE CURRENCY_CODE CURCY_CONV_RATE_TYPE CORP_CURRENCY_CODE CORPORATION_CLASS CONTROL_YR CONG_DIST_CODE COMMENTS CERT_REASON_CODE CERTIFICATION_LEVEL CEO_TITLE CEO_NAME BUSINESS_SCOPE BRANCH_FLAG BANK_OR_BRANCH_NUMBER ANALYSIS_FY ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE16 ATTRIBUTE17 ATTRIBUTE18 ATTRIBUTE19 ATTRIBUTE20 ATTRIBUTE21 ATTRIBUTE22 ATTRIBUTE23 ATTRIBUTE24 ATTRIBUTE25 ATTRIBUTE26 ATTRIBUTE27 ATTRIBUTE28 ATTRIBUTE29 ATTRIBUTE30 ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER10 ATTRIBUTE_NUMBER11 ATTRIBUTE_NUMBER12 ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 ATTRIBUTE_DATE6 ATTRIBUTE_DATE7 ATTRIBUTE_DATE8 ATTRIBUTE_DATE9 ATTRIBUTE_DATE10 ATTRIBUTE_DATE11 ATTRIBUTE_DATE12 PREFERRED_CONTACT_METHOD BANK_CODE BRANCH_CODE DB_RATING TRADING_PARTNER_IDENTIFIER DATA_CLOUD_STATUS SALES_PROFILE_TYPE SALES_PROFILE_STATUS INTERNAL_FLAG NAMED_FLAG LAST_ASSIGNED_DATE OWNER_PARTY_ID EXTN_ATTRIBUTE_TIMESTAMP001 EXTN_ATTRIBUTE_TIMESTAMP002 EXTN_ATTRIBUTE_TIMESTAMP003 EXTN_ATTRIBUTE_NUMBER001 EXTN_ATTRIBUTE_NUMBER002 EXTN_ATTRIBUTE_NUMBER003 EXTN_ATTRIBUTE_NUMBER004 EXTN_ATTRIBUTE_NUMBER005 EXTN_ATTRIBUTE_NUMBER006 EXTN_ATTRIBUTE_NUMBER007 EXTN_ATTRIBUTE_NUMBER008 EXTN_ATTRIBUTE_CHAR001 EXTN_ATTRIBUTE_CHAR002 EXTN_ATTRIBUTE_CHAR003 EXTN_ATTRIBUTE_CHAR004 EXTN_ATTRIBUTE_CHAR005 EXTN_ATTRIBUTE_CHAR006 EXTN_ATTRIBUTE_CHAR007 EXTN_ATTRIBUTE_CHAR008 EXTN_ATTRIBUTE_CHAR009 EXTN_ATTRIBUTE_CHAR010 EXTN_ATTRIBUTE_CHAR011 EXTN_ATTRIBUTE_CHAR012 EXTN_ATTRIBUTE_CHAR013 EXTN_ATTRIBUTE_CHAR014 EXTN_ATTRIBUTE_TIMESTAMP004 EXTN_ATTRIBUTE_TIMESTAMP005 EXTN_ATTRIBUTE_TIMESTAMP006 EXTN_ATTRIBUTE_NUMBER009 EXTN_ATTRIBUTE_NUMBER010 EXTN_ATTRIBUTE_NUMBER011 EXTN_ATTRIBUTE_NUMBER012 EXTN_ATTRIBUTE_NUMBER013 EXTN_ATTRIBUTE_NUMBER014 EXTN_ATTRIBUTE_NUMBER015 EXTN_ATTRIBUTE_NUMBER016 EXTN_ATTRIBUTE_CHAR015 EXTN_ATTRIBUTE_CHAR016 EXTN_ATTRIBUTE_CHAR017 EXTN_ATTRIBUTE_CHAR018 EXTN_ATTRIBUTE_CHAR019 EXTN_ATTRIBUTE_CHAR020 EXTN_ATTRIBUTE_CHAR021 EXTN_ATTRIBUTE_CHAR022 EXTN_ATTRIBUTE_CHAR023 EXTN_ATTRIBUTE_CHAR024 EXTN_ATTRIBUTE_CHAR025 EXTN_ATTRIBUTE_CHAR026 EXTN_ATTRIBUTE_CHAR027 EXTN_ATTRIBUTE_CHAR028 EXTN_ATTRIBUTE_CLOB001 EXTN_ATTRIBUTE_CLOB002 EXTN_ATTRIBUTE_TIMESTAMP007 EXTN_ATTRIBUTE_TIMESTAMP008 EXTN_ATTRIBUTE_TIMESTAMP009 EXTN_ATTRIBUTE_NUMBER017 EXTN_ATTRIBUTE_NUMBER018 EXTN_ATTRIBUTE_NUMBER019 EXTN_ATTRIBUTE_NUMBER020 EXTN_ATTRIBUTE_NUMBER021 EXTN_ATTRIBUTE_NUMBER022 EXTN_ATTRIBUTE_NUMBER023 EXTN_ATTRIBUTE_NUMBER024 EXTN_ATTRIBUTE_CHAR029 EXTN_ATTRIBUTE_CHAR030 EXTN_ATTRIBUTE_CHAR031 EXTN_ATTRIBUTE_CHAR032 EXTN_ATTRIBUTE_CHAR033 EXTN_ATTRIBUTE_CHAR034 EXTN_ATTRIBUTE_CHAR035 EXTN_ATTRIBUTE_CHAR036 EXTN_ATTRIBUTE_CHAR037 EXTN_ATTRIBUTE_CHAR038 EXTN_ATTRIBUTE_CHAR039 EXTN_ATTRIBUTE_CHAR040 EXTN_ATTRIBUTE_CHAR041 EXTN_ATTRIBUTE_CHAR042 EXTN_ATTRIBUTE_TIMESTAMP010 EXTN_ATTRIBUTE_TIMESTAMP011 EXTN_ATTRIBUTE_TIMESTAMP012 EXTN_ATTRIBUTE_NUMBER025 EXTN_ATTRIBUTE_NUMBER026 EXTN_ATTRIBUTE_NUMBER027 EXTN_ATTRIBUTE_NUMBER028 EXTN_ATTRIBUTE_NUMBER029 EXTN_ATTRIBUTE_NUMBER030 EXTN_ATTRIBUTE_NUMBER031 EXTN_ATTRIBUTE_NUMBER032 EXTN_ATTRIBUTE_CHAR043 EXTN_ATTRIBUTE_CHAR044 EXTN_ATTRIBUTE_CHAR045 EXTN_ATTRIBUTE_CHAR046 EXTN_ATTRIBUTE_CHAR047 EXTN_ATTRIBUTE_CHAR048 EXTN_ATTRIBUTE_CHAR049 EXTN_ATTRIBUTE_CHAR050 EXTN_ATTRIBUTE_CHAR051 EXTN_ATTRIBUTE_CHAR052 EXTN_ATTRIBUTE_CHAR053 EXTN_ATTRIBUTE_CHAR054 EXTN_ATTRIBUTE_CHAR055 EXTN_ATTRIBUTE_CHAR056 EXTN_ATTRIBUTE_CLOB003 EXTN_ATTRIBUTE_CLOB004 EXTN_ATTRIBUTE_TIMESTAMP013 EXTN_ATTRIBUTE_TIMESTAMP014 EXTN_ATTRIBUTE_TIMESTAMP015 EXTN_ATTRIBUTE_NUMBER033 EXTN_ATTRIBUTE_NUMBER034 EXTN_ATTRIBUTE_NUMBER035 EXTN_ATTRIBUTE_NUMBER036 EXTN_ATTRIBUTE_NUMBER037 EXTN_ATTRIBUTE_NUMBER038 EXTN_ATTRIBUTE_NUMBER039 EXTN_ATTRIBUTE_NUMBER040 EXTN_ATTRIBUTE_CHAR057 EXTN_ATTRIBUTE_CHAR058 EXTN_ATTRIBUTE_CHAR059 EXTN_ATTRIBUTE_CHAR060 EXTN_ATTRIBUTE_CHAR061 EXTN_ATTRIBUTE_CHAR062 EXTN_ATTRIBUTE_CHAR063 EXTN_ATTRIBUTE_CHAR064 EXTN_ATTRIBUTE_CHAR065 EXTN_ATTRIBUTE_CHAR066 EXTN_ATTRIBUTE_CHAR067 EXTN_ATTRIBUTE_CHAR068 EXTN_ATTRIBUTE_CHAR069 EXTN_ATTRIBUTE_CHAR070 EXTN_ATTRIBUTE_TIMESTAMP016 EXTN_ATTRIBUTE_TIMESTAMP017 EXTN_ATTRIBUTE_TIMESTAMP018 EXTN_ATTRIBUTE_NUMBER041 EXTN_ATTRIBUTE_NUMBER042 EXTN_ATTRIBUTE_NUMBER043 EXTN_ATTRIBUTE_NUMBER044 EXTN_ATTRIBUTE_NUMBER045 EXTN_ATTRIBUTE_NUMBER046 EXTN_ATTRIBUTE_NUMBER047 EXTN_ATTRIBUTE_NUMBER048 EXTN_ATTRIBUTE_CHAR071 EXTN_ATTRIBUTE_CHAR072 EXTN_ATTRIBUTE_CHAR073 EXTN_ATTRIBUTE_CHAR074 EXTN_ATTRIBUTE_CHAR075 EXTN_ATTRIBUTE_CHAR076 EXTN_ATTRIBUTE_CHAR077 EXTN_ATTRIBUTE_CHAR078 EXTN_ATTRIBUTE_CHAR079 EXTN_ATTRIBUTE_CHAR080 EXTN_ATTRIBUTE_CHAR081 EXTN_ATTRIBUTE_CHAR082 EXTN_ATTRIBUTE_CHAR083 EXTN_ATTRIBUTE_CHAR084 EXTN_ATTRIBUTE_CLOB005 EXTN_ATTRIBUTE_CLOB006 EXTN_ATTRIBUTE_TIMESTAMP019 EXTN_ATTRIBUTE_TIMESTAMP020 EXTN_ATTRIBUTE_TIMESTAMP021 EXTN_ATTRIBUTE_NUMBER049 EXTN_ATTRIBUTE_NUMBER050 EXTN_ATTRIBUTE_NUMBER051 EXTN_ATTRIBUTE_NUMBER052 EXTN_ATTRIBUTE_NUMBER053 EXTN_ATTRIBUTE_NUMBER054 EXTN_ATTRIBUTE_NUMBER055 EXTN_ATTRIBUTE_NUMBER056 EXTN_ATTRIBUTE_CHAR085 EXTN_ATTRIBUTE_CHAR086 EXTN_ATTRIBUTE_CHAR087 EXTN_ATTRIBUTE_CHAR088 EXTN_ATTRIBUTE_CHAR089 EXTN_ATTRIBUTE_CHAR090 EXTN_ATTRIBUTE_CHAR091 EXTN_ATTRIBUTE_CHAR092 EXTN_ATTRIBUTE_CHAR093 EXTN_ATTRIBUTE_CHAR094 EXTN_ATTRIBUTE_CHAR095 EXTN_ATTRIBUTE_CHAR096 EXTN_ATTRIBUTE_CHAR097 EXTN_ATTRIBUTE_CHAR098 EXTN_ATTRIBUTE_TIMESTAMP022 EXTN_ATTRIBUTE_TIMESTAMP023 EXTN_ATTRIBUTE_TIMESTAMP024 EXTN_ATTRIBUTE_NUMBER057 EXTN_ATTRIBUTE_NUMBER058 EXTN_ATTRIBUTE_NUMBER059 EXTN_ATTRIBUTE_NUMBER060 EXTN_ATTRIBUTE_NUMBER061 EXTN_ATTRIBUTE_NUMBER062 EXTN_ATTRIBUTE_NUMBER063 EXTN_ATTRIBUTE_NUMBER064 EXTN_ATTRIBUTE_CHAR099 EXTN_ATTRIBUTE_CHAR100 EXTN_ATTRIBUTE_CHAR101 EXTN_ATTRIBUTE_CHAR102 EXTN_ATTRIBUTE_CHAR103 EXTN_ATTRIBUTE_CHAR104 EXTN_ATTRIBUTE_CHAR105 EXTN_ATTRIBUTE_CHAR106 EXTN_ATTRIBUTE_CHAR107 EXTN_ATTRIBUTE_CHAR108 EXTN_ATTRIBUTE_CHAR109 EXTN_ATTRIBUTE_CHAR110 EXTN_ATTRIBUTE_CHAR111 EXTN_ATTRIBUTE_CHAR112 EXTN_ATTRIBUTE_CLOB007 EXTN_ATTRIBUTE_CLOB008 EXTN_ATTRIBUTE_TIMESTAMP025 EXTN_ATTRIBUTE_TIMESTAMP026 EXTN_ATTRIBUTE_TIMESTAMP027 EXTN_ATTRIBUTE_NUMBER065 EXTN_ATTRIBUTE_NUMBER066 EXTN_ATTRIBUTE_NUMBER067 EXTN_ATTRIBUTE_NUMBER068 EXTN_ATTRIBUTE_NUMBER069 EXTN_ATTRIBUTE_NUMBER070 EXTN_ATTRIBUTE_NUMBER071 EXTN_ATTRIBUTE_NUMBER072 EXTN_ATTRIBUTE_CHAR113 EXTN_ATTRIBUTE_CHAR114 EXTN_ATTRIBUTE_CHAR115 EXTN_ATTRIBUTE_CHAR116 EXTN_ATTRIBUTE_CHAR117 EXTN_ATTRIBUTE_CHAR118 EXTN_ATTRIBUTE_CHAR119 EXTN_ATTRIBUTE_CHAR120 EXTN_ATTRIBUTE_CHAR121 EXTN_ATTRIBUTE_CHAR122 EXTN_ATTRIBUTE_CHAR123 EXTN_ATTRIBUTE_CHAR124 EXTN_ATTRIBUTE_CHAR125 EXTN_ATTRIBUTE_CHAR126 EXTN_ATTRIBUTE_TIMESTAMP028 EXTN_ATTRIBUTE_TIMESTAMP029 EXTN_ATTRIBUTE_TIMESTAMP030 EXTN_ATTRIBUTE_NUMBER073 EXTN_ATTRIBUTE_NUMBER074 EXTN_ATTRIBUTE_NUMBER075 EXTN_ATTRIBUTE_NUMBER076 EXTN_ATTRIBUTE_NUMBER077 EXTN_ATTRIBUTE_NUMBER078 EXTN_ATTRIBUTE_NUMBER079 EXTN_ATTRIBUTE_NUMBER080 EXTN_ATTRIBUTE_CHAR127 EXTN_ATTRIBUTE_CHAR128 EXTN_ATTRIBUTE_CHAR129 EXTN_ATTRIBUTE_CHAR130 EXTN_ATTRIBUTE_CHAR131 EXTN_ATTRIBUTE_CHAR132 EXTN_ATTRIBUTE_CHAR133 EXTN_ATTRIBUTE_CHAR134 EXTN_ATTRIBUTE_CHAR135 EXTN_ATTRIBUTE_CHAR136 EXTN_ATTRIBUTE_CHAR137 EXTN_ATTRIBUTE_CHAR138 EXTN_ATTRIBUTE_CHAR139 EXTN_ATTRIBUTE_CHAR140 EXTN_ATTRIBUTE_CLOB009 EXTN_ATTRIBUTE_CLOB010 EXTN_ATTRIBUTE_TIMESTAMP031 EXTN_ATTRIBUTE_TIMESTAMP032 EXTN_ATTRIBUTE_TIMESTAMP033 EXTN_ATTRIBUTE_NUMBER081 EXTN_ATTRIBUTE_NUMBER082 EXTN_ATTRIBUTE_NUMBER083 EXTN_ATTRIBUTE_NUMBER084 EXTN_ATTRIBUTE_NUMBER085 EXTN_ATTRIBUTE_NUMBER086 EXTN_ATTRIBUTE_NUMBER087 EXTN_ATTRIBUTE_NUMBER088 EXTN_ATTRIBUTE_CHAR141 EXTN_ATTRIBUTE_CHAR142 EXTN_ATTRIBUTE_CHAR143 EXTN_ATTRIBUTE_CHAR144 EXTN_ATTRIBUTE_CHAR145 EXTN_ATTRIBUTE_CHAR146 EXTN_ATTRIBUTE_CHAR147 EXTN_ATTRIBUTE_CHAR148 EXTN_ATTRIBUTE_CHAR149 EXTN_ATTRIBUTE_CHAR150 EXTN_ATTRIBUTE_CHAR151 EXTN_ATTRIBUTE_CHAR152 EXTN_ATTRIBUTE_CHAR153 EXTN_ATTRIBUTE_CHAR154 EXTN_ATTRIBUTE_TIMESTAMP034 EXTN_ATTRIBUTE_TIMESTAMP035 EXTN_ATTRIBUTE_TIMESTAMP036 EXTN_ATTRIBUTE_NUMBER089 EXTN_ATTRIBUTE_NUMBER090 EXTN_ATTRIBUTE_NUMBER091 EXTN_ATTRIBUTE_NUMBER092 EXTN_ATTRIBUTE_NUMBER093 EXTN_ATTRIBUTE_NUMBER094 EXTN_ATTRIBUTE_NUMBER095 EXTN_ATTRIBUTE_NUMBER096 EXTN_ATTRIBUTE_CHAR155 EXTN_ATTRIBUTE_CHAR156 EXTN_ATTRIBUTE_CHAR157 EXTN_ATTRIBUTE_CHAR158 EXTN_ATTRIBUTE_CHAR159 EXTN_ATTRIBUTE_CHAR160 EXTN_ATTRIBUTE_CHAR161 EXTN_ATTRIBUTE_CHAR162 EXTN_ATTRIBUTE_CHAR163 EXTN_ATTRIBUTE_CHAR164 EXTN_ATTRIBUTE_CHAR165 EXTN_ATTRIBUTE_CHAR166 EXTN_ATTRIBUTE_CHAR167 EXTN_ATTRIBUTE_CHAR168 EXTN_ATTRIBUTE_CLOB011 EXTN_ATTRIBUTE_CLOB012 EXTN_ATTRIBUTE_TIMESTAMP037 EXTN_ATTRIBUTE_TIMESTAMP038 EXTN_ATTRIBUTE_TIMESTAMP039 EXTN_ATTRIBUTE_NUMBER097 EXTN_ATTRIBUTE_NUMBER098 EXTN_ATTRIBUTE_NUMBER099 EXTN_ATTRIBUTE_NUMBER100 EXTN_ATTRIBUTE_NUMBER101 EXTN_ATTRIBUTE_NUMBER102 EXTN_ATTRIBUTE_NUMBER103 EXTN_ATTRIBUTE_NUMBER104 EXTN_ATTRIBUTE_CHAR169 EXTN_ATTRIBUTE_CHAR170 EXTN_ATTRIBUTE_CHAR171 EXTN_ATTRIBUTE_CHAR172 EXTN_ATTRIBUTE_CHAR173 EXTN_ATTRIBUTE_CHAR174 EXTN_ATTRIBUTE_CHAR175 EXTN_ATTRIBUTE_CHAR176 EXTN_ATTRIBUTE_CHAR177 EXTN_ATTRIBUTE_CHAR178 EXTN_ATTRIBUTE_CHAR179 EXTN_ATTRIBUTE_CHAR180 EXTN_ATTRIBUTE_CHAR181 EXTN_ATTRIBUTE_CHAR182 EXTN_ATTRIBUTE_TIMESTAMP040 EXTN_ATTRIBUTE_TIMESTAMP041 EXTN_ATTRIBUTE_TIMESTAMP042 EXTN_ATTRIBUTE_NUMBER105 EXTN_ATTRIBUTE_NUMBER106 EXTN_ATTRIBUTE_NUMBER107 EXTN_ATTRIBUTE_NUMBER108 EXTN_ATTRIBUTE_NUMBER109 EXTN_ATTRIBUTE_NUMBER110 EXTN_ATTRIBUTE_NUMBER111 EXTN_ATTRIBUTE_NUMBER112 EXTN_ATTRIBUTE_CHAR183 EXTN_ATTRIBUTE_CHAR184 EXTN_ATTRIBUTE_CHAR185 EXTN_ATTRIBUTE_CHAR186 EXTN_ATTRIBUTE_CHAR187 EXTN_ATTRIBUTE_CHAR188 EXTN_ATTRIBUTE_CHAR189 EXTN_ATTRIBUTE_CHAR190 EXTN_ATTRIBUTE_CHAR191 EXTN_ATTRIBUTE_CHAR192 EXTN_ATTRIBUTE_CHAR193 EXTN_ATTRIBUTE_CHAR194 EXTN_ATTRIBUTE_CHAR195 EXTN_ATTRIBUTE_CHAR196 EXTN_ATTRIBUTE_CLOB013 EXTN_ATTRIBUTE_CLOB014 EXTN_ATTRIBUTE_TIMESTAMP043 EXTN_ATTRIBUTE_TIMESTAMP044 EXTN_ATTRIBUTE_TIMESTAMP045 EXTN_ATTRIBUTE_NUMBER113 EXTN_ATTRIBUTE_NUMBER114 EXTN_ATTRIBUTE_NUMBER115 EXTN_ATTRIBUTE_NUMBER116 EXTN_ATTRIBUTE_NUMBER117 EXTN_ATTRIBUTE_NUMBER118 EXTN_ATTRIBUTE_NUMBER119 EXTN_ATTRIBUTE_NUMBER120 EXTN_ATTRIBUTE_CHAR197 EXTN_ATTRIBUTE_CHAR198 EXTN_ATTRIBUTE_CHAR199 EXTN_ATTRIBUTE_CHAR200 EXTN_ATTRIBUTE_CHAR201 EXTN_ATTRIBUTE_CHAR202 EXTN_ATTRIBUTE_CHAR203 EXTN_ATTRIBUTE_CHAR204 EXTN_ATTRIBUTE_CHAR205 EXTN_ATTRIBUTE_CHAR206 EXTN_ATTRIBUTE_CHAR207 EXTN_ATTRIBUTE_CHAR208 EXTN_ATTRIBUTE_CHAR209 EXTN_ATTRIBUTE_CHAR210 EXTN_ATTRIBUTE_TIMESTAMP046 EXTN_ATTRIBUTE_TIMESTAMP047 EXTN_ATTRIBUTE_TIMESTAMP048 EXTN_ATTRIBUTE_NUMBER121 EXTN_ATTRIBUTE_NUMBER122 EXTN_ATTRIBUTE_NUMBER123 EXTN_ATTRIBUTE_NUMBER124 EXTN_ATTRIBUTE_NUMBER125 EXTN_ATTRIBUTE_NUMBER126 EXTN_ATTRIBUTE_NUMBER127 EXTN_ATTRIBUTE_NUMBER128 EXTN_ATTRIBUTE_CHAR211 EXTN_ATTRIBUTE_CHAR212 EXTN_ATTRIBUTE_CHAR213 EXTN_ATTRIBUTE_CHAR214 EXTN_ATTRIBUTE_CHAR215 EXTN_ATTRIBUTE_CHAR216 EXTN_ATTRIBUTE_CHAR217 EXTN_ATTRIBUTE_CHAR218 EXTN_ATTRIBUTE_CHAR219 EXTN_ATTRIBUTE_CHAR220 EXTN_ATTRIBUTE_CHAR221 EXTN_ATTRIBUTE_CHAR222 EXTN_ATTRIBUTE_CHAR223 EXTN_ATTRIBUTE_CHAR224 EXTN_ATTRIBUTE_CLOB015 EXTN_ATTRIBUTE_CLOB016 EXTN_ATTRIBUTE_TIMESTAMP049 EXTN_ATTRIBUTE_TIMESTAMP050 EXTN_ATTRIBUTE_NUMBER129 EXTN_ATTRIBUTE_NUMBER130 EXTN_ATTRIBUTE_NUMBER131 EXTN_ATTRIBUTE_NUMBER132 EXTN_ATTRIBUTE_NUMBER133 EXTN_ATTRIBUTE_NUMBER134 EXTN_ATTRIBUTE_NUMBER135 EXTN_ATTRIBUTE_NUMBER136 EXTN_ATTRIBUTE_CHAR225 EXTN_ATTRIBUTE_CHAR226 EXTN_ATTRIBUTE_CHAR227 EXTN_ATTRIBUTE_CHAR228 EXTN_ATTRIBUTE_CHAR229 EXTN_ATTRIBUTE_CHAR230 EXTN_ATTRIBUTE_CHAR231 EXTN_ATTRIBUTE_CHAR232 EXTN_ATTRIBUTE_CHAR233 EXTN_ATTRIBUTE_CHAR234 EXTN_ATTRIBUTE_CHAR235 EXTN_ATTRIBUTE_CHAR236 EXTN_ATTRIBUTE_CHAR237 EXTN_ATTRIBUTE_CHAR238 EXTN_ATTRIBUTE_NUMBER137 EXTN_ATTRIBUTE_NUMBER138 EXTN_ATTRIBUTE_NUMBER139 EXTN_ATTRIBUTE_NUMBER140 EXTN_ATTRIBUTE_NUMBER141 EXTN_ATTRIBUTE_NUMBER142 EXTN_ATTRIBUTE_NUMBER143 EXTN_ATTRIBUTE_NUMBER144 EXTN_ATTRIBUTE_CHAR239 EXTN_ATTRIBUTE_CHAR240 EXTN_ATTRIBUTE_CHAR241 EXTN_ATTRIBUTE_CHAR242 EXTN_ATTRIBUTE_CHAR243 EXTN_ATTRIBUTE_CHAR244 EXTN_ATTRIBUTE_CHAR245 EXTN_ATTRIBUTE_CHAR246 EXTN_ATTRIBUTE_CHAR247 EXTN_ATTRIBUTE_CHAR248 EXTN_ATTRIBUTE_CHAR249 EXTN_ATTRIBUTE_CHAR250 EXTN_ATTRIBUTE_CHAR251 EXTN_ATTRIBUTE_CHAR252 EXTN_ATTRIBUTE_CLOB017 EXTN_ATTRIBUTE_CLOB018 EXTN_ATTRIBUTE_NUMBER145 EXTN_ATTRIBUTE_NUMBER146 EXTN_ATTRIBUTE_NUMBER147 EXTN_ATTRIBUTE_NUMBER148 EXTN_ATTRIBUTE_NUMBER149 EXTN_ATTRIBUTE_NUMBER150 EXTN_ATTRIBUTE_NUMBER151 EXTN_ATTRIBUTE_NUMBER152 EXTN_ATTRIBUTE_CHAR253 EXTN_ATTRIBUTE_CHAR254 EXTN_ATTRIBUTE_CHAR255 EXTN_ATTRIBUTE_CHAR256 EXTN_ATTRIBUTE_CHAR257 EXTN_ATTRIBUTE_CHAR258 EXTN_ATTRIBUTE_CHAR259 EXTN_ATTRIBUTE_CHAR260 EXTN_ATTRIBUTE_CHAR261 EXTN_ATTRIBUTE_CHAR262 EXTN_ATTRIBUTE_CHAR263 EXTN_ATTRIBUTE_CHAR264 EXTN_ATTRIBUTE_CHAR265 EXTN_ATTRIBUTE_CHAR266 EXTN_ATTRIBUTE_NUMBER153 EXTN_ATTRIBUTE_NUMBER154 EXTN_ATTRIBUTE_NUMBER155 EXTN_ATTRIBUTE_NUMBER156 EXTN_ATTRIBUTE_NUMBER157 EXTN_ATTRIBUTE_NUMBER158 EXTN_ATTRIBUTE_NUMBER159 EXTN_ATTRIBUTE_NUMBER160 EXTN_ATTRIBUTE_CHAR267 EXTN_ATTRIBUTE_CHAR268 EXTN_ATTRIBUTE_CHAR269 EXTN_ATTRIBUTE_CHAR270 EXTN_ATTRIBUTE_CHAR271 EXTN_ATTRIBUTE_CHAR272 EXTN_ATTRIBUTE_CHAR273 EXTN_ATTRIBUTE_CHAR274 EXTN_ATTRIBUTE_CHAR275 EXTN_ATTRIBUTE_CHAR276 EXTN_ATTRIBUTE_CHAR277 EXTN_ATTRIBUTE_CHAR278 EXTN_ATTRIBUTE_CHAR279 EXTN_ATTRIBUTE_CHAR280 EXTN_ATTRIBUTE_CLOB019 EXTN_ATTRIBUTE_CLOB020 EXTN_ATTRIBUTE_NUMBER161 EXTN_ATTRIBUTE_NUMBER162 EXTN_ATTRIBUTE_NUMBER163 EXTN_ATTRIBUTE_NUMBER164 EXTN_ATTRIBUTE_NUMBER165 EXTN_ATTRIBUTE_NUMBER166 EXTN_ATTRIBUTE_NUMBER167 EXTN_ATTRIBUTE_NUMBER168 EXTN_ATTRIBUTE_CHAR281 EXTN_ATTRIBUTE_CHAR282 EXTN_ATTRIBUTE_CHAR283 EXTN_ATTRIBUTE_CHAR284 EXTN_ATTRIBUTE_CHAR285 EXTN_ATTRIBUTE_CHAR286 EXTN_ATTRIBUTE_CHAR287 EXTN_ATTRIBUTE_CHAR288 EXTN_ATTRIBUTE_CHAR289 EXTN_ATTRIBUTE_CHAR290 EXTN_ATTRIBUTE_CHAR291 EXTN_ATTRIBUTE_CHAR292 EXTN_ATTRIBUTE_CHAR293 EXTN_ATTRIBUTE_CHAR294 EXTN_ATTRIBUTE_NUMBER169 EXTN_ATTRIBUTE_NUMBER170 EXTN_ATTRIBUTE_NUMBER171 EXTN_ATTRIBUTE_NUMBER172 EXTN_ATTRIBUTE_NUMBER173 EXTN_ATTRIBUTE_NUMBER174 EXTN_ATTRIBUTE_NUMBER175 EXTN_ATTRIBUTE_NUMBER176 EXTN_ATTRIBUTE_CHAR295 EXTN_ATTRIBUTE_CHAR296 EXTN_ATTRIBUTE_CHAR297 EXTN_ATTRIBUTE_CHAR298 EXTN_ATTRIBUTE_CHAR299 EXTN_ATTRIBUTE_CHAR300 EXTN_ATTRIBUTE_CHAR301 EXTN_ATTRIBUTE_CHAR302 EXTN_ATTRIBUTE_CHAR303 EXTN_ATTRIBUTE_CHAR304 EXTN_ATTRIBUTE_CHAR305 EXTN_ATTRIBUTE_CHAR306 EXTN_ATTRIBUTE_CHAR307 EXTN_ATTRIBUTE_CHAR308 EXTN_ATTRIBUTE_CLOB021 EXTN_ATTRIBUTE_CLOB022 EXTN_ATTRIBUTE_NUMBER177 EXTN_ATTRIBUTE_NUMBER178 EXTN_ATTRIBUTE_NUMBER179 EXTN_ATTRIBUTE_NUMBER180 EXTN_ATTRIBUTE_NUMBER181 EXTN_ATTRIBUTE_NUMBER182 EXTN_ATTRIBUTE_NUMBER183 EXTN_ATTRIBUTE_NUMBER184 EXTN_ATTRIBUTE_CHAR309 EXTN_ATTRIBUTE_CHAR310 EXTN_ATTRIBUTE_CHAR311 EXTN_ATTRIBUTE_CHAR312 EXTN_ATTRIBUTE_CHAR313 EXTN_ATTRIBUTE_CHAR314 EXTN_ATTRIBUTE_CHAR315 EXTN_ATTRIBUTE_CHAR316 EXTN_ATTRIBUTE_CHAR317 EXTN_ATTRIBUTE_CHAR318 EXTN_ATTRIBUTE_CHAR319 EXTN_ATTRIBUTE_CHAR320 EXTN_ATTRIBUTE_CHAR321 EXTN_ATTRIBUTE_CHAR322 EXTN_ATTRIBUTE_NUMBER185 EXTN_ATTRIBUTE_NUMBER186 EXTN_ATTRIBUTE_NUMBER187 EXTN_ATTRIBUTE_NUMBER188 EXTN_ATTRIBUTE_NUMBER189 EXTN_ATTRIBUTE_NUMBER190 EXTN_ATTRIBUTE_NUMBER191 EXTN_ATTRIBUTE_NUMBER192 EXTN_ATTRIBUTE_CHAR323 EXTN_ATTRIBUTE_CHAR324 EXTN_ATTRIBUTE_CHAR325 EXTN_ATTRIBUTE_CHAR326 EXTN_ATTRIBUTE_CHAR327 EXTN_ATTRIBUTE_CHAR328 EXTN_ATTRIBUTE_CHAR329 EXTN_ATTRIBUTE_CHAR330 EXTN_ATTRIBUTE_CHAR331 EXTN_ATTRIBUTE_CHAR332 EXTN_ATTRIBUTE_CHAR333 EXTN_ATTRIBUTE_CHAR334 EXTN_ATTRIBUTE_CHAR335 EXTN_ATTRIBUTE_CHAR336 EXTN_ATTRIBUTE_CLOB023 EXTN_ATTRIBUTE_CLOB024 EXTN_ATTRIBUTE_NUMBER193 EXTN_ATTRIBUTE_NUMBER194 EXTN_ATTRIBUTE_NUMBER195 EXTN_ATTRIBUTE_NUMBER196 EXTN_ATTRIBUTE_NUMBER197 EXTN_ATTRIBUTE_NUMBER198 EXTN_ATTRIBUTE_NUMBER199 EXTN_ATTRIBUTE_NUMBER200 EXTN_ATTRIBUTE_CHAR337 EXTN_ATTRIBUTE_CHAR338 EXTN_ATTRIBUTE_CHAR339 EXTN_ATTRIBUTE_CHAR340 EXTN_ATTRIBUTE_CHAR341 EXTN_ATTRIBUTE_CHAR342 EXTN_ATTRIBUTE_CHAR343 EXTN_ATTRIBUTE_CHAR344 EXTN_ATTRIBUTE_CHAR345 EXTN_ATTRIBUTE_CHAR346 EXTN_ATTRIBUTE_CHAR347 EXTN_ATTRIBUTE_CHAR348 EXTN_ATTRIBUTE_CHAR349 EXTN_ATTRIBUTE_CHAR350 EXTN_ATTRIBUTE_CLOB025

Query

SQL_Statement

SELECT DECODE(P_INT.ACTION_FLAG, 'I', 'INSERT', 'U', 'UPDATE', P_INT.ACTION_CODE) ACTION_CODE, 'HZ_IMPORT' PROCESS_CODE, P_INT.BATCH_ID PROCESS_ID, (SELECT TO_TIMESTAMP(NULL) FROM DUAL) RECORD_DATE, P_INT.PARTY_ID RECORD_ID, P_INT.PARTY_T_ID SOURCE_RECORD_ID, (SELECT TO_NUMBER(NULL) FROM DUAL) RECORD_VERSION, (SELECT TO_TIMESTAMP(NULL) FROM DUAL) SOURCE_RECORD_DATE, (SELECT TO_NUMBER(NULL) FROM DUAL) SOURCE_RECORD_VERSION, P_INT.YEAR_ESTABLISHED, P_INT.WOMAN_OWNED_IND, P_INT.UNIQUE_NAME_SUFFIX, P_INT.UNIQUE_NAME_ALIAS, P_INT.TOTAL_PAYMENTS, P_INT.TOTAL_EMP_MIN_IND, P_INT.TOTAL_EMP_EST_IND, P_INT.TOTAL_EMPLOYEES_TEXT, P_INT.TOTAL_EMPLOYEES_IND, P_INT.SUFFIX_OVERRIDDEN_FLAG, P_INT.STOCK_SYMBOL, P_INT.SMALL_BUS_IND, P_INT.SEBL_USER_KEY_LOC, P_INT.RENT_OWN_IND, P_INT.REGISTRATION_TYPE, P_INT.PUBLIC_PRIVATE_OWNERSHIP_FLAG, P_INT.PRINCIPAL_TITLE, P_INT.PRINCIPAL_NAME, P_INT.PREF_FUNCTIONAL_CURRENCY, P_INT.PARTY_NUMBER, P_INT.PARENT_SUB_IND, P_INT.PARENT_DUNS_NUM_C, P_INT.ORGANIZATION_TYPE, P_INT.ORGANIZATION_SIZE, P_INT.ORGANIZATION_NAME, P_INT.OOB_IND, P_INT.NEXT_FY_POTENTIAL_REVENUE, P_INT.MISSION_STATEMENT, P_INT.MINORITY_OWNED_TYPE, P_INT.MINORITY_OWNED_IND, P_INT.LOCAL_BUS_IDEN_TYPE, P_INT.LOCAL_BUS_IDENTIFIER, P_INT.LINE_OF_BUSINESS, P_INT.LEGAL_STATUS, P_INT.LABOR_SURPLUS_IND, P_INT.JGZZ_FISCAL_CODE, P_INT.INCORP_YEAR, P_INT.IMPORT_IND, P_INT.HQ_BRANCH_IND, P_INT.HOME_COUNTRY, P_INT.GSA_INDICATOR_FLAG, P_INT.GROWTH_STRATEGY_DESC, P_INT.GLOBAL_ULTIMATE_DUNS_NUM_C, P_INT.FISCAL_YEAREND_MONTH, P_INT.EXPORT_IND, P_INT.EMP_AT_PRIMARY_ADR_TEXT, P_INT.EMP_AT_PRIMARY_ADR_MIN_IND, P_INT.EMP_AT_PRIMARY_ADR_EST_IND, P_INT.EMP_AT_PRIMARY_ADR, P_INT.EMPLOYEES_TOTAL, P_INT.DUNS_NUMBER_C, P_INT.DO_NOT_CONFUSE_WITH, P_INT.DOMESTIC_ULTIMATE_DUNS_NUM_C, P_INT.DISADV_8A_IND, P_INT.CURR_FY_POTENTIAL_REVENUE, P_INT.CURRENCY_CODE, P_INT.CURCY_CONV_RATE_TYPE, P_INT.CORP_CURRENCY_CODE, P_INT.CORPORATION_CLASS, P_INT.CONTROL_YR, P_INT.CONG_DIST_CODE, P_INT.COMMENTS, P_INT.CERT_REASON_CODE, P_INT.CERTIFICATION_LEVEL, P_INT.CEO_TITLE, P_INT.CEO_NAME, P_INT.BUSINESS_SCOPE, P_INT.BRANCH_FLAG, P_INT.BANK_OR_BRANCH_NUMBER, P_INT.ANALYSIS_FY, P_INT.ATTRIBUTE_CATEGORY, P_INT.ATTRIBUTE1, P_INT.ATTRIBUTE2, P_INT.ATTRIBUTE3, P_INT.ATTRIBUTE4, P_INT.ATTRIBUTE5, P_INT.ATTRIBUTE6, P_INT.ATTRIBUTE7, P_INT.ATTRIBUTE8, P_INT.ATTRIBUTE9, P_INT.ATTRIBUTE10, P_INT.ATTRIBUTE11, P_INT.ATTRIBUTE12, P_INT.ATTRIBUTE13, P_INT.ATTRIBUTE14, P_INT.ATTRIBUTE15, P_INT.ATTRIBUTE16, P_INT.ATTRIBUTE17, P_INT.ATTRIBUTE18, P_INT.ATTRIBUTE19, P_INT.ATTRIBUTE20, P_INT.ATTRIBUTE21, P_INT.ATTRIBUTE22, P_INT.ATTRIBUTE23, P_INT.ATTRIBUTE24, P_INT.ATTRIBUTE25, P_INT.ATTRIBUTE26, P_INT.ATTRIBUTE27, P_INT.ATTRIBUTE28, P_INT.ATTRIBUTE29, P_INT.ATTRIBUTE30, P_INT.ATTRIBUTE_NUMBER1, P_INT.ATTRIBUTE_NUMBER2, P_INT.ATTRIBUTE_NUMBER3, P_INT.ATTRIBUTE_NUMBER4, P_INT.ATTRIBUTE_NUMBER5, P_INT.ATTRIBUTE_NUMBER6, P_INT.ATTRIBUTE_NUMBER7, P_INT.ATTRIBUTE_NUMBER8, P_INT.ATTRIBUTE_NUMBER9, P_INT.ATTRIBUTE_NUMBER10, P_INT.ATTRIBUTE_NUMBER11, P_INT.ATTRIBUTE_NUMBER12, P_INT.ATTRIBUTE_DATE1, P_INT.ATTRIBUTE_DATE2, P_INT.ATTRIBUTE_DATE3, P_INT.ATTRIBUTE_DATE4, P_INT.ATTRIBUTE_DATE5, P_INT.ATTRIBUTE_DATE6, P_INT.ATTRIBUTE_DATE7, P_INT.ATTRIBUTE_DATE8, P_INT.ATTRIBUTE_DATE9, P_INT.ATTRIBUTE_DATE10, P_INT.ATTRIBUTE_DATE11, P_INT.ATTRIBUTE_DATE12, P_INT.PREFERRED_CONTACT_METHOD, P_INT.BANK_CODE, P_INT.BRANCH_CODE, P_INT.DB_RATING, P_INT.TRADING_PARTNER_IDENTIFIER, P_INT.DATA_CLOUD_STATUS, P_INT.SALES_PROFILE_TYPE, P_INT.SALES_PROFILE_STATUS, P_INT.INTERNAL_FLAG, P_INT.NAMED_FLAG, P_INT.LAST_ASSIGNED_DATE, P_INT.OWNER_PARTY_ID, OP_EXTN.EXTN_ATTRIBUTE_TIMESTAMP001, OP_EXTN.EXTN_ATTRIBUTE_TIMESTAMP002, OP_EXTN.EXTN_ATTRIBUTE_TIMESTAMP003, OP_EXTN.EXTN_ATTRIBUTE_NUMBER001, OP_EXTN.EXTN_ATTRIBUTE_NUMBER002, OP_EXTN.EXTN_ATTRIBUTE_NUMBER003, OP_EXTN.EXTN_ATTRIBUTE_NUMBER004, OP_EXTN.EXTN_ATTRIBUTE_NUMBER005, OP_EXTN.EXTN_ATTRIBUTE_NUMBER006, OP_EXTN.EXTN_ATTRIBUTE_NUMBER007, OP_EXTN.EXTN_ATTRIBUTE_NUMBER008, OP_EXTN.EXTN_ATTRIBUTE_CHAR001, OP_EXTN.EXTN_ATTRIBUTE_CHAR002, OP_EXTN.EXTN_ATTRIBUTE_CHAR003, OP_EXTN.EXTN_ATTRIBUTE_CHAR004, OP_EXTN.EXTN_ATTRIBUTE_CHAR005, OP_EXTN.EXTN_ATTRIBUTE_CHAR006, OP_EXTN.EXTN_ATTRIBUTE_CHAR007, OP_EXTN.EXTN_ATTRIBUTE_CHAR008, OP_EXTN.EXTN_ATTRIBUTE_CHAR009, OP_EXTN.EXTN_ATTRIBUTE_CHAR010, OP_EXTN.EXTN_ATTRIBUTE_CHAR011, OP_EXTN.EXTN_ATTRIBUTE_CHAR012, OP_EXTN.EXTN_ATTRIBUTE_CHAR013, OP_EXTN.EXTN_ATTRIBUTE_CHAR014, OP_EXTN.EXTN_ATTRIBUTE_TIMESTAMP004, OP_EXTN.EXTN_ATTRIBUTE_TIMESTAMP005, OP_EXTN.EXTN_ATTRIBUTE_TIMESTAMP006, OP_EXTN.EXTN_ATTRIBUTE_NUMBER009, OP_EXTN.EXTN_ATTRIBUTE_NUMBER010, OP_EXTN.EXTN_ATTRIBUTE_NUMBER011, OP_EXTN.EXTN_ATTRIBUTE_NUMBER012, OP_EXTN.EXTN_ATTRIBUTE_NUMBER013, OP_EXTN.EXTN_ATTRIBUTE_NUMBER014, OP_EXTN.EXTN_ATTRIBUTE_NUMBER015, OP_EXTN.EXTN_ATTRIBUTE_NUMBER016, OP_EXTN.EXTN_ATTRIBUTE_CHAR015, OP_EXTN.EXTN_ATTRIBUTE_CHAR016, OP_EXTN.EXTN_ATTRIBUTE_CHAR017, OP_EXTN.EXTN_ATTRIBUTE_CHAR018, OP_EXTN.EXTN_ATTRIBUTE_CHAR019, OP_EXTN.EXTN_ATTRIBUTE_CHAR020, OP_EXTN.EXTN_ATTRIBUTE_CHAR021, OP_EXTN.EXTN_ATTRIBUTE_CHAR022, OP_EXTN.EXTN_ATTRIBUTE_CHAR023, OP_EXTN.EXTN_ATTRIBUTE_CHAR024, OP_EXTN.EXTN_ATTRIBUTE_CHAR025, OP_EXTN.EXTN_ATTRIBUTE_CHAR026, OP_EXTN.EXTN_ATTRIBUTE_CHAR027, OP_EXTN.EXTN_ATTRIBUTE_CHAR028, OP_EXTN.EXTN_ATTRIBUTE_CLOB001, OP_EXTN.EXTN_ATTRIBUTE_CLOB002, OP_EXTN.EXTN_ATTRIBUTE_TIMESTAMP007, OP_EXTN.EXTN_ATTRIBUTE_TIMESTAMP008, OP_EXTN.EXTN_ATTRIBUTE_TIMESTAMP009, OP_EXTN.EXTN_ATTRIBUTE_NUMBER017, OP_EXTN.EXTN_ATTRIBUTE_NUMBER018, OP_EXTN.EXTN_ATTRIBUTE_NUMBER019, OP_EXTN.EXTN_ATTRIBUTE_NUMBER020, OP_EXTN.EXTN_ATTRIBUTE_NUMBER021, OP_EXTN.EXTN_ATTRIBUTE_NUMBER022, OP_EXTN.EXTN_ATTRIBUTE_NUMBER023, OP_EXTN.EXTN_ATTRIBUTE_NUMBER024, OP_EXTN.EXTN_ATTRIBUTE_CHAR029, OP_EXTN.EXTN_ATTRIBUTE_CHAR030, OP_EXTN.EXTN_ATTRIBUTE_CHAR031, OP_EXTN.EXTN_ATTRIBUTE_CHAR032, OP_EXTN.EXTN_ATTRIBUTE_CHAR033, OP_EXTN.EXTN_ATTRIBUTE_CHAR034, OP_EXTN.EXTN_ATTRIBUTE_CHAR035, OP_EXTN.EXTN_ATTRIBUTE_CHAR036, OP_EXTN.EXTN_ATTRIBUTE_CHAR037, OP_EXTN.EXTN_ATTRIBUTE_CHAR038, OP_EXTN.EXTN_ATTRIBUTE_CHAR039, OP_EXTN.EXTN_ATTRIBUTE_CHAR040, OP_EXTN.EXTN_ATTRIBUTE_CHAR041, OP_EXTN.EXTN_ATTRIBUTE_CHAR042, OP_EXTN.EXTN_ATTRIBUTE_TIMESTAMP010, OP_EXTN.EXTN_ATTRIBUTE_TIMESTAMP011, OP_EXTN.EXTN_ATTRIBUTE_TIMESTAMP012, OP_EXTN.EXTN_ATTRIBUTE_NUMBER025, OP_EXTN.EXTN_ATTRIBUTE_NUMBER026, OP_EXTN.EXTN_ATTRIBUTE_NUMBER027, OP_EXTN.EXTN_ATTRIBUTE_NUMBER028, OP_EXTN.EXTN_ATTRIBUTE_NUMBER029, OP_EXTN.EXTN_ATTRIBUTE_NUMBER030, OP_EXTN.EXTN_ATTRIBUTE_NUMBER031, OP_EXTN.EXTN_ATTRIBUTE_NUMBER032, OP_EXTN.EXTN_ATTRIBUTE_CHAR043, OP_EXTN.EXTN_ATTRIBUTE_CHAR044, OP_EXTN.EXTN_ATTRIBUTE_CHAR045, OP_EXTN.EXTN_ATTRIBUTE_CHAR046, OP_EXTN.EXTN_ATTRIBUTE_CHAR047, OP_EXTN.EXTN_ATTRIBUTE_CHAR048, OP_EXTN.EXTN_ATTRIBUTE_CHAR049, OP_EXTN.EXTN_ATTRIBUTE_CHAR050, OP_EXTN.EXTN_ATTRIBUTE_CHAR051, OP_EXTN.EXTN_ATTRIBUTE_CHAR052, OP_EXTN.EXTN_ATTRIBUTE_CHAR053, OP_EXTN.EXTN_ATTRIBUTE_CHAR054, OP_EXTN.EXTN_ATTRIBUTE_CHAR055, OP_EXTN.EXTN_ATTRIBUTE_CHAR056, OP_EXTN.EXTN_ATTRIBUTE_CLOB003, OP_EXTN.EXTN_ATTRIBUTE_CLOB004, OP_EXTN.EXTN_ATTRIBUTE_TIMESTAMP013, OP_EXTN.EXTN_ATTRIBUTE_TIMESTAMP014, OP_EXTN.EXTN_ATTRIBUTE_TIMESTAMP015, OP_EXTN.EXTN_ATTRIBUTE_NUMBER033, OP_EXTN.EXTN_ATTRIBUTE_NUMBER034, OP_EXTN.EXTN_ATTRIBUTE_NUMBER035, OP_EXTN.EXTN_ATTRIBUTE_NUMBER036, OP_EXTN.EXTN_ATTRIBUTE_NUMBER037, OP_EXTN.EXTN_ATTRIBUTE_NUMBER038, OP_EXTN.EXTN_ATTRIBUTE_NUMBER039, OP_EXTN.EXTN_ATTRIBUTE_NUMBER040, OP_EXTN.EXTN_ATTRIBUTE_CHAR057, OP_EXTN.EXTN_ATTRIBUTE_CHAR058, OP_EXTN.EXTN_ATTRIBUTE_CHAR059, OP_EXTN.EXTN_ATTRIBUTE_CHAR060, OP_EXTN.EXTN_ATTRIBUTE_CHAR061, OP_EXTN.EXTN_ATTRIBUTE_CHAR062, OP_EXTN.EXTN_ATTRIBUTE_CHAR063, OP_EXTN.EXTN_ATTRIBUTE_CHAR064, OP_EXTN.EXTN_ATTRIBUTE_CHAR065, OP_EXTN.EXTN_ATTRIBUTE_CHAR066, OP_EXTN.EXTN_ATTRIBUTE_CHAR067, OP_EXTN.EXTN_ATTRIBUTE_CHAR068, OP_EXTN.EXTN_ATTRIBUTE_CHAR069, OP_EXTN.EXTN_ATTRIBUTE_CHAR070, OP_EXTN.EXTN_ATTRIBUTE_TIMESTAMP016, OP_EXTN.EXTN_ATTRIBUTE_TIMESTAMP017, OP_EXTN.EXTN_ATTRIBUTE_TIMESTAMP018, OP_EXTN.EXTN_ATTRIBUTE_NUMBER041, OP_EXTN.EXTN_ATTRIBUTE_NUMBER042, OP_EXTN.EXTN_ATTRIBUTE_NUMBER043, OP_EXTN.EXTN_ATTRIBUTE_NUMBER044, OP_EXTN.EXTN_ATTRIBUTE_NUMBER045, OP_EXTN.EXTN_ATTRIBUTE_NUMBER046, OP_EXTN.EXTN_ATTRIBUTE_NUMBER047, OP_EXTN.EXTN_ATTRIBUTE_NUMBER048, OP_EXTN.EXTN_ATTRIBUTE_CHAR071, OP_EXTN.EXTN_ATTRIBUTE_CHAR072, OP_EXTN.EXTN_ATTRIBUTE_CHAR073, OP_EXTN.EXTN_ATTRIBUTE_CHAR074, OP_EXTN.EXTN_ATTRIBUTE_CHAR075, OP_EXTN.EXTN_ATTRIBUTE_CHAR076, OP_EXTN.EXTN_ATTRIBUTE_CHAR077, OP_EXTN.EXTN_ATTRIBUTE_CHAR078, OP_EXTN.EXTN_ATTRIBUTE_CHAR079, OP_EXTN.EXTN_ATTRIBUTE_CHAR080, OP_EXTN.EXTN_ATTRIBUTE_CHAR081, OP_EXTN.EXTN_ATTRIBUTE_CHAR082, OP_EXTN.EXTN_ATTRIBUTE_CHAR083, OP_EXTN.EXTN_ATTRIBUTE_CHAR084, OP_EXTN.EXTN_ATTRIBUTE_CLOB005, OP_EXTN.EXTN_ATTRIBUTE_CLOB006, OP_EXTN.EXTN_ATTRIBUTE_TIMESTAMP019, OP_EXTN.EXTN_ATTRIBUTE_TIMESTAMP020, OP_EXTN.EXTN_ATTRIBUTE_TIMESTAMP021, OP_EXTN.EXTN_ATTRIBUTE_NUMBER049, OP_EXTN.EXTN_ATTRIBUTE_NUMBER050, OP_EXTN.EXTN_ATTRIBUTE_NUMBER051, OP_EXTN.EXTN_ATTRIBUTE_NUMBER052, OP_EXTN.EXTN_ATTRIBUTE_NUMBER053, OP_EXTN.EXTN_ATTRIBUTE_NUMBER054, OP_EXTN.EXTN_ATTRIBUTE_NUMBER055, OP_EXTN.EXTN_ATTRIBUTE_NUMBER056, OP_EXTN.EXTN_ATTRIBUTE_CHAR085, OP_EXTN.EXTN_ATTRIBUTE_CHAR086, OP_EXTN.EXTN_ATTRIBUTE_CHAR087, OP_EXTN.EXTN_ATTRIBUTE_CHAR088, OP_EXTN.EXTN_ATTRIBUTE_CHAR089, OP_EXTN.EXTN_ATTRIBUTE_CHAR090, OP_EXTN.EXTN_ATTRIBUTE_CHAR091, OP_EXTN.EXTN_ATTRIBUTE_CHAR092, OP_EXTN.EXTN_ATTRIBUTE_CHAR093, OP_EXTN.EXTN_ATTRIBUTE_CHAR094, OP_EXTN.EXTN_ATTRIBUTE_CHAR095, OP_EXTN.EXTN_ATTRIBUTE_CHAR096, OP_EXTN.EXTN_ATTRIBUTE_CHAR097, OP_EXTN.EXTN_ATTRIBUTE_CHAR098, OP_EXTN.EXTN_ATTRIBUTE_TIMESTAMP022, OP_EXTN.EXTN_ATTRIBUTE_TIMESTAMP023, OP_EXTN.EXTN_ATTRIBUTE_TIMESTAMP024, OP_EXTN.EXTN_ATTRIBUTE_NUMBER057, OP_EXTN.EXTN_ATTRIBUTE_NUMBER058, OP_EXTN.EXTN_ATTRIBUTE_NUMBER059, OP_EXTN.EXTN_ATTRIBUTE_NUMBER060, OP_EXTN.EXTN_ATTRIBUTE_NUMBER061, OP_EXTN.EXTN_ATTRIBUTE_NUMBER062, OP_EXTN.EXTN_ATTRIBUTE_NUMBER063, OP_EXTN.EXTN_ATTRIBUTE_NUMBER064, OP_EXTN.EXTN_ATTRIBUTE_CHAR099, OP_EXTN.EXTN_ATTRIBUTE_CHAR100, OP_EXTN.EXTN_ATTRIBUTE_CHAR101, OP_EXTN.EXTN_ATTRIBUTE_CHAR102, OP_EXTN.EXTN_ATTRIBUTE_CHAR103, OP_EXTN.EXTN_ATTRIBUTE_CHAR104, OP_EXTN.EXTN_ATTRIBUTE_CHAR105, OP_EXTN.EXTN_ATTRIBUTE_CHAR106, OP_EXTN.EXTN_ATTRIBUTE_CHAR107, OP_EXTN.EXTN_ATTRIBUTE_CHAR108, OP_EXTN.EXTN_ATTRIBUTE_CHAR109, OP_EXTN.EXTN_ATTRIBUTE_CHAR110, OP_EXTN.EXTN_ATTRIBUTE_CHAR111, OP_EXTN.EXTN_ATTRIBUTE_CHAR112, OP_EXTN.EXTN_ATTRIBUTE_CLOB007, OP_EXTN.EXTN_ATTRIBUTE_CLOB008, OP_EXTN.EXTN_ATTRIBUTE_TIMESTAMP025, OP_EXTN.EXTN_ATTRIBUTE_TIMESTAMP026, OP_EXTN.EXTN_ATTRIBUTE_TIMESTAMP027, OP_EXTN.EXTN_ATTRIBUTE_NUMBER065, OP_EXTN.EXTN_ATTRIBUTE_NUMBER066, OP_EXTN.EXTN_ATTRIBUTE_NUMBER067, OP_EXTN.EXTN_ATTRIBUTE_NUMBER068, OP_EXTN.EXTN_ATTRIBUTE_NUMBER069, OP_EXTN.EXTN_ATTRIBUTE_NUMBER070, OP_EXTN.EXTN_ATTRIBUTE_NUMBER071, OP_EXTN.EXTN_ATTRIBUTE_NUMBER072, OP_EXTN.EXTN_ATTRIBUTE_CHAR113, OP_EXTN.EXTN_ATTRIBUTE_CHAR114, OP_EXTN.EXTN_ATTRIBUTE_CHAR115, OP_EXTN.EXTN_ATTRIBUTE_CHAR116, OP_EXTN.EXTN_ATTRIBUTE_CHAR117, OP_EXTN.EXTN_ATTRIBUTE_CHAR118, OP_EXTN.EXTN_ATTRIBUTE_CHAR119, OP_EXTN.EXTN_ATTRIBUTE_CHAR120, OP_EXTN.EXTN_ATTRIBUTE_CHAR121, OP_EXTN.EXTN_ATTRIBUTE_CHAR122, OP_EXTN.EXTN_ATTRIBUTE_CHAR123, OP_EXTN.EXTN_ATTRIBUTE_CHAR124, OP_EXTN.EXTN_ATTRIBUTE_CHAR125, OP_EXTN.EXTN_ATTRIBUTE_CHAR126, OP_EXTN.EXTN_ATTRIBUTE_TIMESTAMP028, OP_EXTN.EXTN_ATTRIBUTE_TIMESTAMP029, OP_EXTN.EXTN_ATTRIBUTE_TIMESTAMP030, OP_EXTN.EXTN_ATTRIBUTE_NUMBER073, OP_EXTN.EXTN_ATTRIBUTE_NUMBER074, OP_EXTN.EXTN_ATTRIBUTE_NUMBER075, OP_EXTN.EXTN_ATTRIBUTE_NUMBER076, OP_EXTN.EXTN_ATTRIBUTE_NUMBER077, OP_EXTN.EXTN_ATTRIBUTE_NUMBER078, OP_EXTN.EXTN_ATTRIBUTE_NUMBER079, OP_EXTN.EXTN_ATTRIBUTE_NUMBER080, OP_EXTN.EXTN_ATTRIBUTE_CHAR127, OP_EXTN.EXTN_ATTRIBUTE_CHAR128, OP_EXTN.EXTN_ATTRIBUTE_CHAR129, OP_EXTN.EXTN_ATTRIBUTE_CHAR130, OP_EXTN.EXTN_ATTRIBUTE_CHAR131, OP_EXTN.EXTN_ATTRIBUTE_CHAR132, OP_EXTN.EXTN_ATTRIBUTE_CHAR133, OP_EXTN.EXTN_ATTRIBUTE_CHAR134, OP_EXTN.EXTN_ATTRIBUTE_CHAR135, OP_EXTN.EXTN_ATTRIBUTE_CHAR136, OP_EXTN.EXTN_ATTRIBUTE_CHAR137, OP_EXTN.EXTN_ATTRIBUTE_CHAR138, OP_EXTN.EXTN_ATTRIBUTE_CHAR139, OP_EXTN.EXTN_ATTRIBUTE_CHAR140, OP_EXTN.EXTN_ATTRIBUTE_CLOB009, OP_EXTN.EXTN_ATTRIBUTE_CLOB010, OP_EXTN.EXTN_ATTRIBUTE_TIMESTAMP031, OP_EXTN.EXTN_ATTRIBUTE_TIMESTAMP032, OP_EXTN.EXTN_ATTRIBUTE_TIMESTAMP033, OP_EXTN.EXTN_ATTRIBUTE_NUMBER081, OP_EXTN.EXTN_ATTRIBUTE_NUMBER082, OP_EXTN.EXTN_ATTRIBUTE_NUMBER083, OP_EXTN.EXTN_ATTRIBUTE_NUMBER084, OP_EXTN.EXTN_ATTRIBUTE_NUMBER085, OP_EXTN.EXTN_ATTRIBUTE_NUMBER086, OP_EXTN.EXTN_ATTRIBUTE_NUMBER087, OP_EXTN.EXTN_ATTRIBUTE_NUMBER088, OP_EXTN.EXTN_ATTRIBUTE_CHAR141, OP_EXTN.EXTN_ATTRIBUTE_CHAR142, OP_EXTN.EXTN_ATTRIBUTE_CHAR143, OP_EXTN.EXTN_ATTRIBUTE_CHAR144, OP_EXTN.EXTN_ATTRIBUTE_CHAR145, OP_EXTN.EXTN_ATTRIBUTE_CHAR146, OP_EXTN.EXTN_ATTRIBUTE_CHAR147, OP_EXTN.EXTN_ATTRIBUTE_CHAR148, OP_EXTN.EXTN_ATTRIBUTE_CHAR149, OP_EXTN.EXTN_ATTRIBUTE_CHAR150, OP_EXTN.EXTN_ATTRIBUTE_CHAR151, OP_EXTN.EXTN_ATTRIBUTE_CHAR152, OP_EXTN.EXTN_ATTRIBUTE_CHAR153, OP_EXTN.EXTN_ATTRIBUTE_CHAR154, OP_EXTN.EXTN_ATTRIBUTE_TIMESTAMP034, OP_EXTN.EXTN_ATTRIBUTE_TIMESTAMP035, OP_EXTN.EXTN_ATTRIBUTE_TIMESTAMP036, OP_EXTN.EXTN_ATTRIBUTE_NUMBER089, OP_EXTN.EXTN_ATTRIBUTE_NUMBER090, OP_EXTN.EXTN_ATTRIBUTE_NUMBER091, OP_EXTN.EXTN_ATTRIBUTE_NUMBER092, OP_EXTN.EXTN_ATTRIBUTE_NUMBER093, OP_EXTN.EXTN_ATTRIBUTE_NUMBER094, OP_EXTN.EXTN_ATTRIBUTE_NUMBER095, OP_EXTN.EXTN_ATTRIBUTE_NUMBER096, OP_EXTN.EXTN_ATTRIBUTE_CHAR155, OP_EXTN.EXTN_ATTRIBUTE_CHAR156, OP_EXTN.EXTN_ATTRIBUTE_CHAR157, OP_EXTN.EXTN_ATTRIBUTE_CHAR158, OP_EXTN.EXTN_ATTRIBUTE_CHAR159, OP_EXTN.EXTN_ATTRIBUTE_CHAR160, OP_EXTN.EXTN_ATTRIBUTE_CHAR161, OP_EXTN.EXTN_ATTRIBUTE_CHAR162, OP_EXTN.EXTN_ATTRIBUTE_CHAR163, OP_EXTN.EXTN_ATTRIBUTE_CHAR164, OP_EXTN.EXTN_ATTRIBUTE_CHAR165, OP_EXTN.EXTN_ATTRIBUTE_CHAR166, OP_EXTN.EXTN_ATTRIBUTE_CHAR167, OP_EXTN.EXTN_ATTRIBUTE_CHAR168, OP_EXTN.EXTN_ATTRIBUTE_CLOB011, OP_EXTN.EXTN_ATTRIBUTE_CLOB012, OP_EXTN.EXTN_ATTRIBUTE_TIMESTAMP037, OP_EXTN.EXTN_ATTRIBUTE_TIMESTAMP038, OP_EXTN.EXTN_ATTRIBUTE_TIMESTAMP039, OP_EXTN.EXTN_ATTRIBUTE_NUMBER097, OP_EXTN.EXTN_ATTRIBUTE_NUMBER098, OP_EXTN.EXTN_ATTRIBUTE_NUMBER099, OP_EXTN.EXTN_ATTRIBUTE_NUMBER100, OP_EXTN.EXTN_ATTRIBUTE_NUMBER101, OP_EXTN.EXTN_ATTRIBUTE_NUMBER102, OP_EXTN.EXTN_ATTRIBUTE_NUMBER103, OP_EXTN.EXTN_ATTRIBUTE_NUMBER104, OP_EXTN.EXTN_ATTRIBUTE_CHAR169, OP_EXTN.EXTN_ATTRIBUTE_CHAR170, OP_EXTN.EXTN_ATTRIBUTE_CHAR171, OP_EXTN.EXTN_ATTRIBUTE_CHAR172, OP_EXTN.EXTN_ATTRIBUTE_CHAR173, OP_EXTN.EXTN_ATTRIBUTE_CHAR174, OP_EXTN.EXTN_ATTRIBUTE_CHAR175, OP_EXTN.EXTN_ATTRIBUTE_CHAR176, OP_EXTN.EXTN_ATTRIBUTE_CHAR177, OP_EXTN.EXTN_ATTRIBUTE_CHAR178, OP_EXTN.EXTN_ATTRIBUTE_CHAR179, OP_EXTN.EXTN_ATTRIBUTE_CHAR180, OP_EXTN.EXTN_ATTRIBUTE_CHAR181, OP_EXTN.EXTN_ATTRIBUTE_CHAR182, OP_EXTN.EXTN_ATTRIBUTE_TIMESTAMP040, OP_EXTN.EXTN_ATTRIBUTE_TIMESTAMP041, OP_EXTN.EXTN_ATTRIBUTE_TIMESTAMP042, OP_EXTN.EXTN_ATTRIBUTE_NUMBER105, OP_EXTN.EXTN_ATTRIBUTE_NUMBER106, OP_EXTN.EXTN_ATTRIBUTE_NUMBER107, OP_EXTN.EXTN_ATTRIBUTE_NUMBER108, OP_EXTN.EXTN_ATTRIBUTE_NUMBER109, OP_EXTN.EXTN_ATTRIBUTE_NUMBER110, OP_EXTN.EXTN_ATTRIBUTE_NUMBER111, OP_EXTN.EXTN_ATTRIBUTE_NUMBER112, OP_EXTN.EXTN_ATTRIBUTE_CHAR183, OP_EXTN.EXTN_ATTRIBUTE_CHAR184, OP_EXTN.EXTN_ATTRIBUTE_CHAR185, OP_EXTN.EXTN_ATTRIBUTE_CHAR186, OP_EXTN.EXTN_ATTRIBUTE_CHAR187, OP_EXTN.EXTN_ATTRIBUTE_CHAR188, OP_EXTN.EXTN_ATTRIBUTE_CHAR189, OP_EXTN.EXTN_ATTRIBUTE_CHAR190, OP_EXTN.EXTN_ATTRIBUTE_CHAR191, OP_EXTN.EXTN_ATTRIBUTE_CHAR192, OP_EXTN.EXTN_ATTRIBUTE_CHAR193, OP_EXTN.EXTN_ATTRIBUTE_CHAR194, OP_EXTN.EXTN_ATTRIBUTE_CHAR195, OP_EXTN.EXTN_ATTRIBUTE_CHAR196, OP_EXTN.EXTN_ATTRIBUTE_CLOB013, OP_EXTN.EXTN_ATTRIBUTE_CLOB014, OP_EXTN.EXTN_ATTRIBUTE_TIMESTAMP043, OP_EXTN.EXTN_ATTRIBUTE_TIMESTAMP044, OP_EXTN.EXTN_ATTRIBUTE_TIMESTAMP045, OP_EXTN.EXTN_ATTRIBUTE_NUMBER113, OP_EXTN.EXTN_ATTRIBUTE_NUMBER114, OP_EXTN.EXTN_ATTRIBUTE_NUMBER115, OP_EXTN.EXTN_ATTRIBUTE_NUMBER116, OP_EXTN.EXTN_ATTRIBUTE_NUMBER117, OP_EXTN.EXTN_ATTRIBUTE_NUMBER118, OP_EXTN.EXTN_ATTRIBUTE_NUMBER119, OP_EXTN.EXTN_ATTRIBUTE_NUMBER120, OP_EXTN.EXTN_ATTRIBUTE_CHAR197, OP_EXTN.EXTN_ATTRIBUTE_CHAR198, OP_EXTN.EXTN_ATTRIBUTE_CHAR199, OP_EXTN.EXTN_ATTRIBUTE_CHAR200, OP_EXTN.EXTN_ATTRIBUTE_CHAR201, OP_EXTN.EXTN_ATTRIBUTE_CHAR202, OP_EXTN.EXTN_ATTRIBUTE_CHAR203, OP_EXTN.EXTN_ATTRIBUTE_CHAR204, OP_EXTN.EXTN_ATTRIBUTE_CHAR205, OP_EXTN.EXTN_ATTRIBUTE_CHAR206, OP_EXTN.EXTN_ATTRIBUTE_CHAR207, OP_EXTN.EXTN_ATTRIBUTE_CHAR208, OP_EXTN.EXTN_ATTRIBUTE_CHAR209, OP_EXTN.EXTN_ATTRIBUTE_CHAR210, OP_EXTN.EXTN_ATTRIBUTE_TIMESTAMP046, OP_EXTN.EXTN_ATTRIBUTE_TIMESTAMP047, OP_EXTN.EXTN_ATTRIBUTE_TIMESTAMP048, OP_EXTN.EXTN_ATTRIBUTE_NUMBER121, OP_EXTN.EXTN_ATTRIBUTE_NUMBER122, OP_EXTN.EXTN_ATTRIBUTE_NUMBER123, OP_EXTN.EXTN_ATTRIBUTE_NUMBER124, OP_EXTN.EXTN_ATTRIBUTE_NUMBER125, OP_EXTN.EXTN_ATTRIBUTE_NUMBER126, OP_EXTN.EXTN_ATTRIBUTE_NUMBER127, OP_EXTN.EXTN_ATTRIBUTE_NUMBER128, OP_EXTN.EXTN_ATTRIBUTE_CHAR211, OP_EXTN.EXTN_ATTRIBUTE_CHAR212, OP_EXTN.EXTN_ATTRIBUTE_CHAR213, OP_EXTN.EXTN_ATTRIBUTE_CHAR214, OP_EXTN.EXTN_ATTRIBUTE_CHAR215, OP_EXTN.EXTN_ATTRIBUTE_CHAR216, OP_EXTN.EXTN_ATTRIBUTE_CHAR217, OP_EXTN.EXTN_ATTRIBUTE_CHAR218, OP_EXTN.EXTN_ATTRIBUTE_CHAR219, OP_EXTN.EXTN_ATTRIBUTE_CHAR220, OP_EXTN.EXTN_ATTRIBUTE_CHAR221, OP_EXTN.EXTN_ATTRIBUTE_CHAR222, OP_EXTN.EXTN_ATTRIBUTE_CHAR223, OP_EXTN.EXTN_ATTRIBUTE_CHAR224, OP_EXTN.EXTN_ATTRIBUTE_CLOB015, OP_EXTN.EXTN_ATTRIBUTE_CLOB016, OP_EXTN.EXTN_ATTRIBUTE_TIMESTAMP049, OP_EXTN.EXTN_ATTRIBUTE_TIMESTAMP050, OP_EXTN.EXTN_ATTRIBUTE_NUMBER129, OP_EXTN.EXTN_ATTRIBUTE_NUMBER130, OP_EXTN.EXTN_ATTRIBUTE_NUMBER131, OP_EXTN.EXTN_ATTRIBUTE_NUMBER132, OP_EXTN.EXTN_ATTRIBUTE_NUMBER133, OP_EXTN.EXTN_ATTRIBUTE_NUMBER134, OP_EXTN.EXTN_ATTRIBUTE_NUMBER135, OP_EXTN.EXTN_ATTRIBUTE_NUMBER136, OP_EXTN.EXTN_ATTRIBUTE_CHAR225, OP_EXTN.EXTN_ATTRIBUTE_CHAR226, OP_EXTN.EXTN_ATTRIBUTE_CHAR227, OP_EXTN.EXTN_ATTRIBUTE_CHAR228, OP_EXTN.EXTN_ATTRIBUTE_CHAR229, OP_EXTN.EXTN_ATTRIBUTE_CHAR230, OP_EXTN.EXTN_ATTRIBUTE_CHAR231, OP_EXTN.EXTN_ATTRIBUTE_CHAR232, OP_EXTN.EXTN_ATTRIBUTE_CHAR233, OP_EXTN.EXTN_ATTRIBUTE_CHAR234, OP_EXTN.EXTN_ATTRIBUTE_CHAR235, OP_EXTN.EXTN_ATTRIBUTE_CHAR236, OP_EXTN.EXTN_ATTRIBUTE_CHAR237, OP_EXTN.EXTN_ATTRIBUTE_CHAR238, OP_EXTN.EXTN_ATTRIBUTE_NUMBER137, OP_EXTN.EXTN_ATTRIBUTE_NUMBER138, OP_EXTN.EXTN_ATTRIBUTE_NUMBER139, OP_EXTN.EXTN_ATTRIBUTE_NUMBER140, OP_EXTN.EXTN_ATTRIBUTE_NUMBER141, OP_EXTN.EXTN_ATTRIBUTE_NUMBER142, OP_EXTN.EXTN_ATTRIBUTE_NUMBER143, OP_EXTN.EXTN_ATTRIBUTE_NUMBER144, OP_EXTN.EXTN_ATTRIBUTE_CHAR239, OP_EXTN.EXTN_ATTRIBUTE_CHAR240, OP_EXTN.EXTN_ATTRIBUTE_CHAR241, OP_EXTN.EXTN_ATTRIBUTE_CHAR242, OP_EXTN.EXTN_ATTRIBUTE_CHAR243, OP_EXTN.EXTN_ATTRIBUTE_CHAR244, OP_EXTN.EXTN_ATTRIBUTE_CHAR245, OP_EXTN.EXTN_ATTRIBUTE_CHAR246, OP_EXTN.EXTN_ATTRIBUTE_CHAR247, OP_EXTN.EXTN_ATTRIBUTE_CHAR248, OP_EXTN.EXTN_ATTRIBUTE_CHAR249, OP_EXTN.EXTN_ATTRIBUTE_CHAR250, OP_EXTN.EXTN_ATTRIBUTE_CHAR251, OP_EXTN.EXTN_ATTRIBUTE_CHAR252, OP_EXTN.EXTN_ATTRIBUTE_CLOB017, OP_EXTN.EXTN_ATTRIBUTE_CLOB018, OP_EXTN.EXTN_ATTRIBUTE_NUMBER145, OP_EXTN.EXTN_ATTRIBUTE_NUMBER146, OP_EXTN.EXTN_ATTRIBUTE_NUMBER147, OP_EXTN.EXTN_ATTRIBUTE_NUMBER148, OP_EXTN.EXTN_ATTRIBUTE_NUMBER149, OP_EXTN.EXTN_ATTRIBUTE_NUMBER150, OP_EXTN.EXTN_ATTRIBUTE_NUMBER151, OP_EXTN.EXTN_ATTRIBUTE_NUMBER152, OP_EXTN.EXTN_ATTRIBUTE_CHAR253, OP_EXTN.EXTN_ATTRIBUTE_CHAR254, OP_EXTN.EXTN_ATTRIBUTE_CHAR255, OP_EXTN.EXTN_ATTRIBUTE_CHAR256, OP_EXTN.EXTN_ATTRIBUTE_CHAR257, OP_EXTN.EXTN_ATTRIBUTE_CHAR258, OP_EXTN.EXTN_ATTRIBUTE_CHAR259, OP_EXTN.EXTN_ATTRIBUTE_CHAR260, OP_EXTN.EXTN_ATTRIBUTE_CHAR261, OP_EXTN.EXTN_ATTRIBUTE_CHAR262, OP_EXTN.EXTN_ATTRIBUTE_CHAR263, OP_EXTN.EXTN_ATTRIBUTE_CHAR264, OP_EXTN.EXTN_ATTRIBUTE_CHAR265, OP_EXTN.EXTN_ATTRIBUTE_CHAR266, OP_EXTN.EXTN_ATTRIBUTE_NUMBER153, OP_EXTN.EXTN_ATTRIBUTE_NUMBER154, OP_EXTN.EXTN_ATTRIBUTE_NUMBER155, OP_EXTN.EXTN_ATTRIBUTE_NUMBER156, OP_EXTN.EXTN_ATTRIBUTE_NUMBER157, OP_EXTN.EXTN_ATTRIBUTE_NUMBER158, OP_EXTN.EXTN_ATTRIBUTE_NUMBER159, OP_EXTN.EXTN_ATTRIBUTE_NUMBER160, OP_EXTN.EXTN_ATTRIBUTE_CHAR267, OP_EXTN.EXTN_ATTRIBUTE_CHAR268, OP_EXTN.EXTN_ATTRIBUTE_CHAR269, OP_EXTN.EXTN_ATTRIBUTE_CHAR270, OP_EXTN.EXTN_ATTRIBUTE_CHAR271, OP_EXTN.EXTN_ATTRIBUTE_CHAR272, OP_EXTN.EXTN_ATTRIBUTE_CHAR273, OP_EXTN.EXTN_ATTRIBUTE_CHAR274, OP_EXTN.EXTN_ATTRIBUTE_CHAR275, OP_EXTN.EXTN_ATTRIBUTE_CHAR276, OP_EXTN.EXTN_ATTRIBUTE_CHAR277, OP_EXTN.EXTN_ATTRIBUTE_CHAR278, OP_EXTN.EXTN_ATTRIBUTE_CHAR279, OP_EXTN.EXTN_ATTRIBUTE_CHAR280, OP_EXTN.EXTN_ATTRIBUTE_CLOB019, OP_EXTN.EXTN_ATTRIBUTE_CLOB020, OP_EXTN.EXTN_ATTRIBUTE_NUMBER161, OP_EXTN.EXTN_ATTRIBUTE_NUMBER162, OP_EXTN.EXTN_ATTRIBUTE_NUMBER163, OP_EXTN.EXTN_ATTRIBUTE_NUMBER164, OP_EXTN.EXTN_ATTRIBUTE_NUMBER165, OP_EXTN.EXTN_ATTRIBUTE_NUMBER166, OP_EXTN.EXTN_ATTRIBUTE_NUMBER167, OP_EXTN.EXTN_ATTRIBUTE_NUMBER168, OP_EXTN.EXTN_ATTRIBUTE_CHAR281, OP_EXTN.EXTN_ATTRIBUTE_CHAR282, OP_EXTN.EXTN_ATTRIBUTE_CHAR283, OP_EXTN.EXTN_ATTRIBUTE_CHAR284, OP_EXTN.EXTN_ATTRIBUTE_CHAR285, OP_EXTN.EXTN_ATTRIBUTE_CHAR286, OP_EXTN.EXTN_ATTRIBUTE_CHAR287, OP_EXTN.EXTN_ATTRIBUTE_CHAR288, OP_EXTN.EXTN_ATTRIBUTE_CHAR289, OP_EXTN.EXTN_ATTRIBUTE_CHAR290, OP_EXTN.EXTN_ATTRIBUTE_CHAR291, OP_EXTN.EXTN_ATTRIBUTE_CHAR292, OP_EXTN.EXTN_ATTRIBUTE_CHAR293, OP_EXTN.EXTN_ATTRIBUTE_CHAR294, OP_EXTN.EXTN_ATTRIBUTE_NUMBER169, OP_EXTN.EXTN_ATTRIBUTE_NUMBER170, OP_EXTN.EXTN_ATTRIBUTE_NUMBER171, OP_EXTN.EXTN_ATTRIBUTE_NUMBER172, OP_EXTN.EXTN_ATTRIBUTE_NUMBER173, OP_EXTN.EXTN_ATTRIBUTE_NUMBER174, OP_EXTN.EXTN_ATTRIBUTE_NUMBER175, OP_EXTN.EXTN_ATTRIBUTE_NUMBER176, OP_EXTN.EXTN_ATTRIBUTE_CHAR295, OP_EXTN.EXTN_ATTRIBUTE_CHAR296, OP_EXTN.EXTN_ATTRIBUTE_CHAR297, OP_EXTN.EXTN_ATTRIBUTE_CHAR298, OP_EXTN.EXTN_ATTRIBUTE_CHAR299, OP_EXTN.EXTN_ATTRIBUTE_CHAR300, OP_EXTN.EXTN_ATTRIBUTE_CHAR301, OP_EXTN.EXTN_ATTRIBUTE_CHAR302, OP_EXTN.EXTN_ATTRIBUTE_CHAR303, OP_EXTN.EXTN_ATTRIBUTE_CHAR304, OP_EXTN.EXTN_ATTRIBUTE_CHAR305, OP_EXTN.EXTN_ATTRIBUTE_CHAR306, OP_EXTN.EXTN_ATTRIBUTE_CHAR307, OP_EXTN.EXTN_ATTRIBUTE_CHAR308, OP_EXTN.EXTN_ATTRIBUTE_CLOB021, OP_EXTN.EXTN_ATTRIBUTE_CLOB022, OP_EXTN.EXTN_ATTRIBUTE_NUMBER177, OP_EXTN.EXTN_ATTRIBUTE_NUMBER178, OP_EXTN.EXTN_ATTRIBUTE_NUMBER179, OP_EXTN.EXTN_ATTRIBUTE_NUMBER180, OP_EXTN.EXTN_ATTRIBUTE_NUMBER181, OP_EXTN.EXTN_ATTRIBUTE_NUMBER182, OP_EXTN.EXTN_ATTRIBUTE_NUMBER183, OP_EXTN.EXTN_ATTRIBUTE_NUMBER184, OP_EXTN.EXTN_ATTRIBUTE_CHAR309, OP_EXTN.EXTN_ATTRIBUTE_CHAR310, OP_EXTN.EXTN_ATTRIBUTE_CHAR311, OP_EXTN.EXTN_ATTRIBUTE_CHAR312, OP_EXTN.EXTN_ATTRIBUTE_CHAR313, OP_EXTN.EXTN_ATTRIBUTE_CHAR314, OP_EXTN.EXTN_ATTRIBUTE_CHAR315, OP_EXTN.EXTN_ATTRIBUTE_CHAR316, OP_EXTN.EXTN_ATTRIBUTE_CHAR317, OP_EXTN.EXTN_ATTRIBUTE_CHAR318, OP_EXTN.EXTN_ATTRIBUTE_CHAR319, OP_EXTN.EXTN_ATTRIBUTE_CHAR320, OP_EXTN.EXTN_ATTRIBUTE_CHAR321, OP_EXTN.EXTN_ATTRIBUTE_CHAR322, OP_EXTN.EXTN_ATTRIBUTE_NUMBER185, OP_EXTN.EXTN_ATTRIBUTE_NUMBER186, OP_EXTN.EXTN_ATTRIBUTE_NUMBER187, OP_EXTN.EXTN_ATTRIBUTE_NUMBER188, OP_EXTN.EXTN_ATTRIBUTE_NUMBER189, OP_EXTN.EXTN_ATTRIBUTE_NUMBER190, OP_EXTN.EXTN_ATTRIBUTE_NUMBER191, OP_EXTN.EXTN_ATTRIBUTE_NUMBER192, OP_EXTN.EXTN_ATTRIBUTE_CHAR323, OP_EXTN.EXTN_ATTRIBUTE_CHAR324, OP_EXTN.EXTN_ATTRIBUTE_CHAR325, OP_EXTN.EXTN_ATTRIBUTE_CHAR326, OP_EXTN.EXTN_ATTRIBUTE_CHAR327, OP_EXTN.EXTN_ATTRIBUTE_CHAR328, OP_EXTN.EXTN_ATTRIBUTE_CHAR329, OP_EXTN.EXTN_ATTRIBUTE_CHAR330, OP_EXTN.EXTN_ATTRIBUTE_CHAR331, OP_EXTN.EXTN_ATTRIBUTE_CHAR332, OP_EXTN.EXTN_ATTRIBUTE_CHAR333, OP_EXTN.EXTN_ATTRIBUTE_CHAR334, OP_EXTN.EXTN_ATTRIBUTE_CHAR335, OP_EXTN.EXTN_ATTRIBUTE_CHAR336, OP_EXTN.EXTN_ATTRIBUTE_CLOB023, OP_EXTN.EXTN_ATTRIBUTE_CLOB024, OP_EXTN.EXTN_ATTRIBUTE_NUMBER193, OP_EXTN.EXTN_ATTRIBUTE_NUMBER194, OP_EXTN.EXTN_ATTRIBUTE_NUMBER195, OP_EXTN.EXTN_ATTRIBUTE_NUMBER196, OP_EXTN.EXTN_ATTRIBUTE_NUMBER197, OP_EXTN.EXTN_ATTRIBUTE_NUMBER198, OP_EXTN.EXTN_ATTRIBUTE_NUMBER199, OP_EXTN.EXTN_ATTRIBUTE_NUMBER200, OP_EXTN.EXTN_ATTRIBUTE_CHAR337, OP_EXTN.EXTN_ATTRIBUTE_CHAR338, OP_EXTN.EXTN_ATTRIBUTE_CHAR339, OP_EXTN.EXTN_ATTRIBUTE_CHAR340, OP_EXTN.EXTN_ATTRIBUTE_CHAR341, OP_EXTN.EXTN_ATTRIBUTE_CHAR342, OP_EXTN.EXTN_ATTRIBUTE_CHAR343, OP_EXTN.EXTN_ATTRIBUTE_CHAR344, OP_EXTN.EXTN_ATTRIBUTE_CHAR345, OP_EXTN.EXTN_ATTRIBUTE_CHAR346, OP_EXTN.EXTN_ATTRIBUTE_CHAR347, OP_EXTN.EXTN_ATTRIBUTE_CHAR348, OP_EXTN.EXTN_ATTRIBUTE_CHAR349, OP_EXTN.EXTN_ATTRIBUTE_CHAR350, OP_EXTN.EXTN_ATTRIBUTE_CLOB025 FROM HZ_IMP_PARTIES_T P_INT, HZ_IMP_ORG_PROFILE_EXTN OP_EXTN WHERE P_INT.BATCH_ID = OP_EXTN.BATCH_ID(+) AND P_INT.PARTY_ID = OP_EXTN.PARTY_ID(+) AND P_INT.PARTY_TYPE = 'ORGANIZATION' AND P_INT.INTERFACE_STATUS IS NULL