AR_XML_INVOICE_TP_V

Details

• Schema: FUSION

• Object owner: AR

• Object type: VIEW

Columns

Name

CUSTOMER_ACCOUNT_ID SITE_USE_ID CUSTOMER_ACCOUNT_ROLE_ID PARTY_NAME ACCOUNT_NUMBER LOCATION SITE_USE_CODE ADDRESS_LINE_ONE ADDRESS_LINE_TWO ADDRESS_LINE_THREE ADDRESS_LINE_FOUR ADDRESS CITY COUNTY STATE PROVINCE POSTAL_CODE TERRITORY_SHORT_NAME COMPLETE_ADDRESS NAME EMAIL_ADDRESS PRIMARY_PHONE_COUNTRY_CODE PRIMARY_PHONE_AREA_CODE PRIMARY_PHONE_NUMBER PRIMARY_PHONE_EXTENSION ACCOUNT_SITE_LANGUAGE PARTY_ID TAXPAYER_ID_NUMBER TRADE_PARTNER_CODE CUSTOMER_TRX_ID BILL_OR_SHIP TRADE_PARTY_USER_ONE TRADE_PARTY_USER_TWO TRADE_PARTY_USER_THREE TRADE_PARTY_USER_FOUR TRADE_PARTY_USER_FIVE TRADE_PARTY_USER_SIX TRADE_PARTY_USER_SEVEN TRADE_PARTY_USER_EIGHT TRADE_PARTY_USER_NINE TRADE_PARTY_USER_TEN TRADE_PARTY_USER_ELEVEN TRADE_PARTY_USER_TWELVE TRADE_PARTY_USER_THIRTEEN TRADE_PARTY_USER_FOURTEEN TRADE_PARTY_USER_FIFTEEN TRADE_PARTY_USER_SIXTEEN TRADE_PARTY_USER_SEVENTEEN TRADE_PARTY_USER_EIGHTEEN TRADE_PARTY_USER_NINETEEN TRADE_PARTY_USER_TWENTY TRADE_PARTY_USER_TWENTY_ONE TRADE_PARTY_USER_TWENTY_TWO TRADE_PARTY_USER_TWENTY_THREE TRADE_PARTY_USER_TWENTY_FOUR TRADE_PARTY_USER_TWENTY_FIVE TRADE_PARTY_USER_TWENTY_SIX TRADE_PARTY_USER_TWENTY_SEVEN TRADE_PARTY_USER_TWENTY_EIGHT TRADE_PARTY_USER_TWENTY_NINE TRADE_PARTY_USER_THIRTY SITE_NUMBER COUNTRY_CODE CUSTOMER_TAX_REG_NUMBER TAX_REGIME_NAME SITE_ATTRIBUTE_CATEGORY SITE_ATTRIBUTE_NUMBER1 SITE_ATTRIBUTE_NUMBER2 SITE_ATTRIBUTE_NUMBER3 SITE_ATTRIBUTE_NUMBER4 SITE_ATTRIBUTE_NUMBER5 SITE_ATTRIBUTE_NUMBER6 SITE_ATTRIBUTE_NUMBER7 SITE_ATTRIBUTE_NUMBER8 SITE_ATTRIBUTE_NUMBER9 SITE_ATTRIBUTE_NUMBER10 SITE_ATTRIBUTE_NUMBER11 SITE_ATTRIBUTE_NUMBER12 SITE_ATTRIBUTE_DATE1 SITE_ATTRIBUTE_DATE2 SITE_ATTRIBUTE_DATE3 SITE_ATTRIBUTE_DATE4 SITE_ATTRIBUTE_DATE5 SITE_ATTRIBUTE_DATE6 SITE_ATTRIBUTE_DATE7 SITE_ATTRIBUTE_DATE8 SITE_ATTRIBUTE_DATE9 SITE_ATTRIBUTE_DATE10 SITE_ATTRIBUTE_DATE11 SITE_ATTRIBUTE_DATE12 SITE_ATTRIBUTE1 SITE_ATTRIBUTE2 SITE_ATTRIBUTE3 SITE_ATTRIBUTE4 SITE_ATTRIBUTE5 SITE_ATTRIBUTE6 SITE_ATTRIBUTE7 SITE_ATTRIBUTE8 SITE_ATTRIBUTE9 SITE_ATTRIBUTE10 SITE_ATTRIBUTE11 SITE_ATTRIBUTE12 SITE_ATTRIBUTE13 SITE_ATTRIBUTE14 SITE_ATTRIBUTE15 SITE_ATTRIBUTE16 SITE_ATTRIBUTE17 SITE_ATTRIBUTE18 SITE_ATTRIBUTE19 SITE_ATTRIBUTE20 SITE_ATTRIBUTE21 SITE_ATTRIBUTE22 SITE_ATTRIBUTE23 SITE_ATTRIBUTE24 SITE_ATTRIBUTE25 SITE_ATTRIBUTE26 SITE_ATTRIBUTE27 SITE_ATTRIBUTE28 SITE_ATTRIBUTE29 SITE_ATTRIBUTE30 TRANSLATED_CUSTOMER_NAME PROF_ATTRIBUTE_CATEGORY PROF_ATTRIBUTE1 PROF_ATTRIBUTE2 PROF_ATTRIBUTE3 PROF_ATTRIBUTE4 PROF_ATTRIBUTE5 PROF_ATTRIBUTE6 PROF_ATTRIBUTE7 PROF_ATTRIBUTE8 PROF_ATTRIBUTE9 PROF_ATTRIBUTE10 PROF_ATTRIBUTE11 PROF_ATTRIBUTE12 PROF_ATTRIBUTE13 PROF_ATTRIBUTE14 PROF_ATTRIBUTE15 PROF_GLOBAL_ATTRIBUTE_CATEGORY PROF_GLOBAL_ATTRIBUTE1 PROF_GLOBAL_ATTRIBUTE2 PROF_GLOBAL_ATTRIBUTE3 PROF_GLOBAL_ATTRIBUTE4 PROF_GLOBAL_ATTRIBUTE5 PROF_GLOBAL_ATTRIBUTE6 PROF_GLOBAL_ATTRIBUTE7 PROF_GLOBAL_ATTRIBUTE8 PROF_GLOBAL_ATTRIBUTE9 PROF_GLOBAL_ATTRIBUTE10 PROF_GLOBAL_ATTRIBUTE11 PROF_GLOBAL_ATTRIBUTE12 PROF_GLOBAL_ATTRIBUTE13 PROF_GLOBAL_ATTRIBUTE14 PROF_GLOBAL_ATTRIBUTE15 PROF_GLOBAL_ATTRIBUTE16 PROF_GLOBAL_ATTRIBUTE17 PROF_GLOBAL_ATTRIBUTE18 PROF_GLOBAL_ATTRIBUTE19 PROF_GLOBAL_ATTRIBUTE20 PROF_GLOBAL_ATTRIBUTE_NUMBER1 PROF_GLOBAL_ATTRIBUTE_NUMBER2 PROF_GLOBAL_ATTRIBUTE_NUMBER3 PROF_GLOBAL_ATTRIBUTE_NUMBER4 PROF_GLOBAL_ATTRIBUTE_NUMBER5 PROF_GLOBAL_ATTRIBUTE_DATE1 PROF_GLOBAL_ATTRIBUTE_DATE2 PROF_GLOBAL_ATTRIBUTE_DATE3 PROF_GLOBAL_ATTRIBUTE_DATE4 PROF_GLOBAL_ATTRIBUTE_DATE5 ACCT_SITE_CONTACT_NAME ACCT_SITE_PHONE_COUNTRY_CODE ACCT_SITE_PHONE_AREACODE ACCT_SITE_PHONE_NUMBER ACCT_SITE_PHONE_EXTENSION ACCT_SITE_EMAIL_ADDRESS CONCATENATED_SITE_PURPOSE REQUEST_ID

Query

SQL_Statement

SELECT cext.ACCOUNT_ID CUSTOMER_ACCOUNT_ID, cext.ACCOUNT_SITE_USE_ID SITE_USE_ID, cext.CONTACT_ID CUSTOMER_ACCOUNT_ROLE_ID, cext.PARTY_NAME, cext.ACCOUNT_NUMBER, cext.LOCATION, cext.SITE_USE_CODE, cext.ADDRESS_LINE1 ADDRESS_LINE_ONE, cext.ADDRESS_LINE2 ADDRESS_LINE_TWO, cext.ADDRESS_LINE3 ADDRESS_LINE_THREE, cext.ADDRESS_LINE4 ADDRESS_LINE_FOUR, cext.ADDRESS, cext.CITY, cext.COUNTY, cext.STATE, cext.PROVINCE, cext.POSTAL_CODE, cext.TERRITORY_SHORT_NAME, cext.COMPLETE_ADDRESS, cext.NAME, cext.EMAIL_ADDRESS, cext.PRIMARY_PHONE_COUNTRY_CODE, cext.PRIMARY_PHONE_AREA_CODE, cext.PRIMARY_PHONE_NUMBER, cext.PRIMARY_PHONE_EXTENSION, cext.ACCOUNT_SITE_LANGUAGE, cext.PARTY_ID, cext.TAXPAYER_ID_NUMBER, cext.TRADE_PARTNER_CODE, hext.customer_trx_id, 'BILL_TO' BILL_OR_SHIP, ar_xml_view_functions.tp_function1 (cext.PARTY_SITE_ID) Trade_Party_User_One, ar_xml_view_functions.tp_function2 (cext.PARTY_SITE_ID) Trade_Party_User_Two, ar_xml_view_functions.tp_function3 (cext.PARTY_SITE_ID) Trade_Party_User_Three, ar_xml_view_functions.tp_function4 (cext.PARTY_SITE_ID) Trade_Party_User_Four, ar_xml_view_functions.tp_function5 (cext.PARTY_SITE_ID) Trade_Party_User_Five, ar_xml_view_functions.tp_function6 (cext.PARTY_SITE_ID) Trade_Party_User_Six, ar_xml_view_functions.tp_function7 (cext.PARTY_SITE_ID) Trade_Party_User_Seven, ar_xml_view_functions.tp_function8 (cext.PARTY_SITE_ID) Trade_Party_User_Eight, ar_xml_view_functions.tp_function9 (cext.PARTY_SITE_ID) Trade_Party_User_Nine , ar_xml_view_functions.tp_function10 (cext.PARTY_SITE_ID) Trade_Party_User_Ten, ar_xml_view_functions.tp_function11 (cext.PARTY_SITE_ID) Trade_Party_User_Eleven, ar_xml_view_functions.tp_function12 (cext.PARTY_SITE_ID) Trade_Party_User_Twelve, ar_xml_view_functions.tp_function13 (cext.PARTY_SITE_ID) Trade_Party_User_Thirteen, ar_xml_view_functions.tp_function14 (cext.PARTY_SITE_ID) Trade_Party_User_Fourteen, ar_xml_view_functions.tp_function15 (cext.PARTY_SITE_ID) Trade_Party_User_Fifteen, ar_xml_view_functions.tp_function16 (cext.PARTY_SITE_ID) Trade_Party_User_Sixteen, ar_xml_view_functions.tp_function17 (cext.PARTY_SITE_ID) Trade_Party_User_Seventeen, ar_xml_view_functions.tp_function18 (cext.PARTY_SITE_ID) Trade_Party_User_Eighteen, ar_xml_view_functions.tp_function19 (cext.PARTY_SITE_ID) Trade_Party_User_Nineteen, ar_xml_view_functions.tp_function20 (cext.PARTY_SITE_ID) Trade_Party_User_Twenty, ar_xml_view_functions.tp_function21 (cext.PARTY_SITE_ID) Trade_Party_User_Twenty_One, ar_xml_view_functions.tp_function22 (cext.PARTY_SITE_ID) Trade_Party_User_Twenty_Two, ar_xml_view_functions.tp_function23 (cext.PARTY_SITE_ID) Trade_Party_User_Twenty_Three, ar_xml_view_functions.tp_function24 (cext.PARTY_SITE_ID) Trade_Party_User_Twenty_Four, ar_xml_view_functions.tp_function25 (cext.PARTY_SITE_ID) Trade_Party_User_Twenty_Five, ar_xml_view_functions.tp_function26 (cext.PARTY_SITE_ID) Trade_Party_User_Twenty_Six, ar_xml_view_functions.tp_function27 (cext.PARTY_SITE_ID) Trade_Party_User_Twenty_Seven, ar_xml_view_functions.tp_function28 (cext.PARTY_SITE_ID) Trade_Party_User_Twenty_Eight, ar_xml_view_functions.tp_function29 (cext.PARTY_SITE_ID) Trade_Party_User_Twenty_Nine, ar_xml_view_functions.tp_function30 (cext.PARTY_SITE_ID) Trade_Party_User_Thirty, cext.SITE_NUMBER, cext.COUNTRY_CODE, hext.THIRD_PARTY_REG_NUMBER CUSTOMER_TAX_REG_NUMBER, hext.BILL_TO_REGN_TAX_REGIME_CODE TAX_REGIME_NAME, cext.ACCT_SITE_ATTRIBUTE_CATEGORY SITE_ATTRIBUTE_CATEGORY, cext.ACCT_SITE_ATTRIBUTE_NUMBER1 SITE_ATTRIBUTE_NUMBER1, cext.ACCT_SITE_ATTRIBUTE_NUMBER2 SITE_ATTRIBUTE_NUMBER2, cext.ACCT_SITE_ATTRIBUTE_NUMBER3 SITE_ATTRIBUTE_NUMBER3, cext.ACCT_SITE_ATTRIBUTE_NUMBER4 SITE_ATTRIBUTE_NUMBER4, cext.ACCT_SITE_ATTRIBUTE_NUMBER5 SITE_ATTRIBUTE_NUMBER5, cext.ACCT_SITE_ATTRIBUTE_NUMBER6 SITE_ATTRIBUTE_NUMBER6, cext.ACCT_SITE_ATTRIBUTE_NUMBER7 SITE_ATTRIBUTE_NUMBER7, cext.ACCT_SITE_ATTRIBUTE_NUMBER8 SITE_ATTRIBUTE_NUMBER8, cext.ACCT_SITE_ATTRIBUTE_NUMBER9 SITE_ATTRIBUTE_NUMBER9, cext.ACCT_SITE_ATTRIBUTE_NUMBER10 SITE_ATTRIBUTE_NUMBER10, cext.ACCT_SITE_ATTRIBUTE_NUMBER11 SITE_ATTRIBUTE_NUMBER11, cext.ACCT_SITE_ATTRIBUTE_NUMBER12 SITE_ATTRIBUTE_NUMBER12, cext.ACCT_SITE_ATTRIBUTE_DATE1 SITE_ATTRIBUTE_DATE1, cext.ACCT_SITE_ATTRIBUTE_DATE2 SITE_ATTRIBUTE_DATE2, cext.ACCT_SITE_ATTRIBUTE_DATE3 SITE_ATTRIBUTE_DATE3, cext.ACCT_SITE_ATTRIBUTE_DATE4 SITE_ATTRIBUTE_DATE4, cext.ACCT_SITE_ATTRIBUTE_DATE5 SITE_ATTRIBUTE_DATE5, cext.ACCT_SITE_ATTRIBUTE_DATE6 SITE_ATTRIBUTE_DATE6, cext.ACCT_SITE_ATTRIBUTE_DATE7 SITE_ATTRIBUTE_DATE7, cext.ACCT_SITE_ATTRIBUTE_DATE8 SITE_ATTRIBUTE_DATE8, cext.ACCT_SITE_ATTRIBUTE_DATE9 SITE_ATTRIBUTE_DATE9, cext.ACCT_SITE_ATTRIBUTE_DATE10 SITE_ATTRIBUTE_DATE10, cext.ACCT_SITE_ATTRIBUTE_DATE11 SITE_ATTRIBUTE_DATE11, cext.ACCT_SITE_ATTRIBUTE_DATE12 SITE_ATTRIBUTE_DATE12, cext.ACCT_SITE_ATTRIBUTE1 SITE_ATTRIBUTE1, cext.ACCT_SITE_ATTRIBUTE2 SITE_ATTRIBUTE2, cext.ACCT_SITE_ATTRIBUTE3 SITE_ATTRIBUTE3, cext.ACCT_SITE_ATTRIBUTE4 SITE_ATTRIBUTE4, cext.ACCT_SITE_ATTRIBUTE5 SITE_ATTRIBUTE5, cext.ACCT_SITE_ATTRIBUTE6 SITE_ATTRIBUTE6, cext.ACCT_SITE_ATTRIBUTE7 SITE_ATTRIBUTE7, cext.ACCT_SITE_ATTRIBUTE8 SITE_ATTRIBUTE8, cext.ACCT_SITE_ATTRIBUTE9 SITE_ATTRIBUTE9, cext.ACCT_SITE_ATTRIBUTE10 SITE_ATTRIBUTE10, cext.ACCT_SITE_ATTRIBUTE11 SITE_ATTRIBUTE11, cext.ACCT_SITE_ATTRIBUTE12 SITE_ATTRIBUTE12, cext.ACCT_SITE_ATTRIBUTE13 SITE_ATTRIBUTE13, cext.ACCT_SITE_ATTRIBUTE14 SITE_ATTRIBUTE14, cext.ACCT_SITE_ATTRIBUTE15 SITE_ATTRIBUTE15, cext.ACCT_SITE_ATTRIBUTE16 SITE_ATTRIBUTE16, cext.ACCT_SITE_ATTRIBUTE17 SITE_ATTRIBUTE17, cext.ACCT_SITE_ATTRIBUTE18 SITE_ATTRIBUTE18, cext.ACCT_SITE_ATTRIBUTE19 SITE_ATTRIBUTE19, cext.ACCT_SITE_ATTRIBUTE20 SITE_ATTRIBUTE20, cext.ACCT_SITE_ATTRIBUTE21 SITE_ATTRIBUTE21, cext.ACCT_SITE_ATTRIBUTE22 SITE_ATTRIBUTE22, cext.ACCT_SITE_ATTRIBUTE23 SITE_ATTRIBUTE23, cext.ACCT_SITE_ATTRIBUTE24 SITE_ATTRIBUTE24, cext.ACCT_SITE_ATTRIBUTE25 SITE_ATTRIBUTE25, cext.ACCT_SITE_ATTRIBUTE26 SITE_ATTRIBUTE26, cext.ACCT_SITE_ATTRIBUTE27 SITE_ATTRIBUTE27, cext.ACCT_SITE_ATTRIBUTE28 SITE_ATTRIBUTE28, cext.ACCT_SITE_ATTRIBUTE29 SITE_ATTRIBUTE29, cext.ACCT_SITE_ATTRIBUTE30 SITE_ATTRIBUTE30, cext.TRANSLATED_CUSTOMER_NAME, cext.PROF_ATTRIBUTE_CATEGORY, cext.PROF_ATTRIBUTE1, cext.PROF_ATTRIBUTE2, cext.PROF_ATTRIBUTE3, cext.PROF_ATTRIBUTE4, cext.PROF_ATTRIBUTE5, cext.PROF_ATTRIBUTE6, cext.PROF_ATTRIBUTE7, cext.PROF_ATTRIBUTE8, cext.PROF_ATTRIBUTE9, cext.PROF_ATTRIBUTE10, cext.PROF_ATTRIBUTE11, cext.PROF_ATTRIBUTE12, cext.PROF_ATTRIBUTE13, cext.PROF_ATTRIBUTE14, cext.PROF_ATTRIBUTE15, cext.PROF_GLOBAL_ATTRIBUTE_CATEGORY, cext.PROF_GLOBAL_ATTRIBUTE1, cext.PROF_GLOBAL_ATTRIBUTE2, cext.PROF_GLOBAL_ATTRIBUTE3, cext.PROF_GLOBAL_ATTRIBUTE4, cext.PROF_GLOBAL_ATTRIBUTE5, cext.PROF_GLOBAL_ATTRIBUTE6, cext.PROF_GLOBAL_ATTRIBUTE7, cext.PROF_GLOBAL_ATTRIBUTE8, cext.PROF_GLOBAL_ATTRIBUTE9, cext.PROF_GLOBAL_ATTRIBUTE10, cext.PROF_GLOBAL_ATTRIBUTE11, cext.PROF_GLOBAL_ATTRIBUTE12, cext.PROF_GLOBAL_ATTRIBUTE13, cext.PROF_GLOBAL_ATTRIBUTE14, cext.PROF_GLOBAL_ATTRIBUTE15, cext.PROF_GLOBAL_ATTRIBUTE16, cext.PROF_GLOBAL_ATTRIBUTE17, cext.PROF_GLOBAL_ATTRIBUTE18, cext.PROF_GLOBAL_ATTRIBUTE19, cext.PROF_GLOBAL_ATTRIBUTE20, cext.PROF_GLOBAL_ATTRIBUTE_NUMBER1, cext.PROF_GLOBAL_ATTRIBUTE_NUMBER2, cext.PROF_GLOBAL_ATTRIBUTE_NUMBER3, cext.PROF_GLOBAL_ATTRIBUTE_NUMBER4, cext.PROF_GLOBAL_ATTRIBUTE_NUMBER5, cext.PROF_GLOBAL_ATTRIBUTE_DATE1, cext.PROF_GLOBAL_ATTRIBUTE_DATE2, cext.PROF_GLOBAL_ATTRIBUTE_DATE3, cext.PROF_GLOBAL_ATTRIBUTE_DATE4, cext.PROF_GLOBAL_ATTRIBUTE_DATE5, NULL ACCT_SITE_CONTACT_NAME, NULL ACCT_SITE_PHONE_COUNTRY_CODE, NULL ACCT_SITE_PHONE_AREACODE, NULL ACCT_SITE_PHONE_NUMBER, NULL ACCT_SITE_PHONE_EXTENSION, NULL ACCT_SITE_EMAIL_ADDRESS, cext.CONCATENATED_SITE_PURPOSE, cext.REQUEST_ID FROM AR_DOC_TRANSFER_HEADER_EXT hext, AR_DOC_TRANSFER_CUSTOMER_EXT cext WHERE cext.ACCOUNT_ID = hext.BILL_TO_CUSTOMER_ID AND cext.ACCOUNT_SITE_USE_ID = hext.BILL_TO_SITE_USE_ID AND cext.SHIP_TO_PARTY_ID = -1 AND cext.PARTY_SITE_USE_ID = -1 AND cext.CONTACT_ID = hext.BILL_TO_CONTACT_ID AND cext.REQUEST_ID = hext.REQUEST_ID UNION ALL SELECT cext.SHIP_TO_PARTY_ID CUSTOMER_ACCOUNT_ID, cext.PARTY_SITE_USE_ID SITE_USE_ID, cext.CONTACT_ID CUSTOMER_ACCOUNT_ROLE_ID, cext.PARTY_NAME, cext.ACCOUNT_NUMBER, cext.LOCATION, cext.SITE_USE_CODE, cext.ADDRESS_LINE1 ADDRESS_LINE_ONE, cext.ADDRESS_LINE2 ADDRESS_LINE_TWO, cext.ADDRESS_LINE3 ADDRESS_LINE_THREE, cext.ADDRESS_LINE4 ADDRESS_LINE_FOUR, cext.ADDRESS, cext.CITY, cext.COUNTY, cext.STATE, cext.PROVINCE, cext.POSTAL_CODE, cext.TERRITORY_SHORT_NAME, cext.COMPLETE_ADDRESS, cext.NAME, cext.EMAIL_ADDRESS, cext.PRIMARY_PHONE_COUNTRY_CODE, cext.PRIMARY_PHONE_AREA_CODE, cext.PRIMARY_PHONE_NUMBER, cext.PRIMARY_PHONE_EXTENSION, cext.ACCOUNT_SITE_LANGUAGE, cext.PARTY_ID, cext.TAXPAYER_ID_NUMBER, cext.TRADE_PARTNER_CODE, hext.customer_trx_id, 'SHIP_TO' BILL_OR_SHIP, ar_xml_view_functions.tp_function1 (cext.PARTY_SITE_ID) Trade_Party_User_One, ar_xml_view_functions.tp_function2 (cext.PARTY_SITE_ID) Trade_Party_User_Two, ar_xml_view_functions.tp_function3 (cext.PARTY_SITE_ID) Trade_Party_User_Three, ar_xml_view_functions.tp_function4 (cext.PARTY_SITE_ID) Trade_Party_User_Four, ar_xml_view_functions.tp_function5 (cext.PARTY_SITE_ID) Trade_Party_User_Five, ar_xml_view_functions.tp_function6 (cext.PARTY_SITE_ID) Trade_Party_User_Six, ar_xml_view_functions.tp_function7 (cext.PARTY_SITE_ID) Trade_Party_User_Seven, ar_xml_view_functions.tp_function8 (cext.PARTY_SITE_ID) Trade_Party_User_Eight, ar_xml_view_functions.tp_function9 (cext.PARTY_SITE_ID) Trade_Party_User_Nine , ar_xml_view_functions.tp_function10 (cext.PARTY_SITE_ID) Trade_Party_User_Ten, ar_xml_view_functions.tp_function11 (cext.PARTY_SITE_ID) Trade_Party_User_Eleven, ar_xml_view_functions.tp_function12 (cext.PARTY_SITE_ID) Trade_Party_User_Twelve, ar_xml_view_functions.tp_function13 (cext.PARTY_SITE_ID) Trade_Party_User_Thirteen, ar_xml_view_functions.tp_function14 (cext.PARTY_SITE_ID) Trade_Party_User_Fourteen, ar_xml_view_functions.tp_function15 (cext.PARTY_SITE_ID) Trade_Party_User_Fifteen, ar_xml_view_functions.tp_function16 (cext.PARTY_SITE_ID) Trade_Party_User_Sixteen, ar_xml_view_functions.tp_function17 (cext.PARTY_SITE_ID) Trade_Party_User_Seventeen, ar_xml_view_functions.tp_function18 (cext.PARTY_SITE_ID) Trade_Party_User_Eighteen, ar_xml_view_functions.tp_function19 (cext.PARTY_SITE_ID) Trade_Party_User_Nineteen, ar_xml_view_functions.tp_function20 (cext.PARTY_SITE_ID) Trade_Party_User_Twenty, ar_xml_view_functions.tp_function21 (cext.PARTY_SITE_ID) Trade_Party_User_Twenty_One, ar_xml_view_functions.tp_function22 (cext.PARTY_SITE_ID) Trade_Party_User_Twenty_Two, ar_xml_view_functions.tp_function23 (cext.PARTY_SITE_ID) Trade_Party_User_Twenty_Three, ar_xml_view_functions.tp_function24 (cext.PARTY_SITE_ID) Trade_Party_User_Twenty_Four, ar_xml_view_functions.tp_function25 (cext.PARTY_SITE_ID) Trade_Party_User_Twenty_Five, ar_xml_view_functions.tp_function26 (cext.PARTY_SITE_ID) Trade_Party_User_Twenty_Six, ar_xml_view_functions.tp_function27 (cext.PARTY_SITE_ID) Trade_Party_User_Twenty_Seven, ar_xml_view_functions.tp_function28 (cext.PARTY_SITE_ID) Trade_Party_User_Twenty_Eight, ar_xml_view_functions.tp_function29 (cext.PARTY_SITE_ID) Trade_Party_User_Twenty_Nine, ar_xml_view_functions.tp_function30 (cext.PARTY_SITE_ID) Trade_Party_User_Thirty, cext.SITE_NUMBER, cext.COUNTRY_CODE, cext.CUSTOMER_TAX_REG_NUMBER, cext.TAX_REGIME_NAME, cext.PARTY_SITE_ATTRIBUTE_CATEGORY SITE_ATTRIBUTE_CATEGORY, cext.PARTY_SITE_ATTRIBUTE_NUMBER1 SITE_ATTRIBUTE_NUMBER1, cext.PARTY_SITE_ATTRIBUTE_NUMBER2 SITE_ATTRIBUTE_NUMBER2, cext.PARTY_SITE_ATTRIBUTE_NUMBER3 SITE_ATTRIBUTE_NUMBER3, cext.PARTY_SITE_ATTRIBUTE_NUMBER4 SITE_ATTRIBUTE_NUMBER4, cext.PARTY_SITE_ATTRIBUTE_NUMBER5 SITE_ATTRIBUTE_NUMBER5, cext.PARTY_SITE_ATTRIBUTE_NUMBER6 SITE_ATTRIBUTE_NUMBER6, cext.PARTY_SITE_ATTRIBUTE_NUMBER7 SITE_ATTRIBUTE_NUMBER7, cext.PARTY_SITE_ATTRIBUTE_NUMBER8 SITE_ATTRIBUTE_NUMBER8, cext.PARTY_SITE_ATTRIBUTE_NUMBER9 SITE_ATTRIBUTE_NUMBER9, cext.PARTY_SITE_ATTRIBUTE_NUMBER10 SITE_ATTRIBUTE_NUMBER10, cext.PARTY_SITE_ATTRIBUTE_NUMBER11 SITE_ATTRIBUTE_NUMBER11, cext.PARTY_SITE_ATTRIBUTE_NUMBER12 SITE_ATTRIBUTE_NUMBER12, cext.PARTY_SITE_ATTRIBUTE_DATE1 SITE_ATTRIBUTE_DATE1, cext.PARTY_SITE_ATTRIBUTE_DATE2 SITE_ATTRIBUTE_DATE2, cext.PARTY_SITE_ATTRIBUTE_DATE3 SITE_ATTRIBUTE_DATE3, cext.PARTY_SITE_ATTRIBUTE_DATE4 SITE_ATTRIBUTE_DATE4, cext.PARTY_SITE_ATTRIBUTE_DATE5 SITE_ATTRIBUTE_DATE5, cext.PARTY_SITE_ATTRIBUTE_DATE6 SITE_ATTRIBUTE_DATE6, cext.PARTY_SITE_ATTRIBUTE_DATE7 SITE_ATTRIBUTE_DATE7, cext.PARTY_SITE_ATTRIBUTE_DATE8 SITE_ATTRIBUTE_DATE8, cext.PARTY_SITE_ATTRIBUTE_DATE9 SITE_ATTRIBUTE_DATE9, cext.PARTY_SITE_ATTRIBUTE_DATE10 SITE_ATTRIBUTE_DATE10, cext.PARTY_SITE_ATTRIBUTE_DATE11 SITE_ATTRIBUTE_DATE11, cext.PARTY_SITE_ATTRIBUTE_DATE12 SITE_ATTRIBUTE_DATE12, cext.PARTY_SITE_ATTRIBUTE1 SITE_ATTRIBUTE1, cext.PARTY_SITE_ATTRIBUTE2 SITE_ATTRIBUTE2, cext.PARTY_SITE_ATTRIBUTE3 SITE_ATTRIBUTE3, cext.PARTY_SITE_ATTRIBUTE4 SITE_ATTRIBUTE4, cext.PARTY_SITE_ATTRIBUTE5 SITE_ATTRIBUTE5, cext.PARTY_SITE_ATTRIBUTE6 SITE_ATTRIBUTE6, cext.PARTY_SITE_ATTRIBUTE7 SITE_ATTRIBUTE7, cext.PARTY_SITE_ATTRIBUTE8 SITE_ATTRIBUTE8, cext.PARTY_SITE_ATTRIBUTE9 SITE_ATTRIBUTE9, cext.PARTY_SITE_ATTRIBUTE10 SITE_ATTRIBUTE10, cext.PARTY_SITE_ATTRIBUTE11 SITE_ATTRIBUTE11, cext.PARTY_SITE_ATTRIBUTE12 SITE_ATTRIBUTE12, cext.PARTY_SITE_ATTRIBUTE13 SITE_ATTRIBUTE13, cext.PARTY_SITE_ATTRIBUTE14 SITE_ATTRIBUTE14, cext.PARTY_SITE_ATTRIBUTE15 SITE_ATTRIBUTE15, cext.PARTY_SITE_ATTRIBUTE16 SITE_ATTRIBUTE16, cext.PARTY_SITE_ATTRIBUTE17 SITE_ATTRIBUTE17, cext.PARTY_SITE_ATTRIBUTE18 SITE_ATTRIBUTE18, cext.PARTY_SITE_ATTRIBUTE19 SITE_ATTRIBUTE19, cext.PARTY_SITE_ATTRIBUTE20 SITE_ATTRIBUTE20, cext.PARTY_SITE_ATTRIBUTE21 SITE_ATTRIBUTE21, cext.PARTY_SITE_ATTRIBUTE22 SITE_ATTRIBUTE22, cext.PARTY_SITE_ATTRIBUTE23 SITE_ATTRIBUTE23, cext.PARTY_SITE_ATTRIBUTE24 SITE_ATTRIBUTE24, cext.PARTY_SITE_ATTRIBUTE25 SITE_ATTRIBUTE25, cext.PARTY_SITE_ATTRIBUTE26 SITE_ATTRIBUTE26, cext.PARTY_SITE_ATTRIBUTE27 SITE_ATTRIBUTE27, cext.PARTY_SITE_ATTRIBUTE28 SITE_ATTRIBUTE28, cext.PARTY_SITE_ATTRIBUTE29 SITE_ATTRIBUTE29, cext.PARTY_SITE_ATTRIBUTE30 SITE_ATTRIBUTE30, cext.TRANSLATED_CUSTOMER_NAME, NULL PROF_ATTRIBUTE_CATEGORY, NULL PROF_ATTRIBUTE1, NULL PROF_ATTRIBUTE2, NULL PROF_ATTRIBUTE3, NULL PROF_ATTRIBUTE4, NULL PROF_ATTRIBUTE5, NULL PROF_ATTRIBUTE6, NULL PROF_ATTRIBUTE7, NULL PROF_ATTRIBUTE8, NULL PROF_ATTRIBUTE9, NULL PROF_ATTRIBUTE10, NULL PROF_ATTRIBUTE11, NULL PROF_ATTRIBUTE12, NULL PROF_ATTRIBUTE13, NULL PROF_ATTRIBUTE14, NULL PROF_ATTRIBUTE15, NULL PROF_GLOBAL_ATTRIBUTE_CATEGORY, NULL PROF_GLOBAL_ATTRIBUTE1, NULL PROF_GLOBAL_ATTRIBUTE2, NULL PROF_GLOBAL_ATTRIBUTE3, NULL PROF_GLOBAL_ATTRIBUTE4, NULL PROF_GLOBAL_ATTRIBUTE5, NULL PROF_GLOBAL_ATTRIBUTE6, NULL PROF_GLOBAL_ATTRIBUTE7, NULL PROF_GLOBAL_ATTRIBUTE8, NULL PROF_GLOBAL_ATTRIBUTE9, NULL PROF_GLOBAL_ATTRIBUTE10, NULL PROF_GLOBAL_ATTRIBUTE11, NULL PROF_GLOBAL_ATTRIBUTE12, NULL PROF_GLOBAL_ATTRIBUTE13, NULL PROF_GLOBAL_ATTRIBUTE14, NULL PROF_GLOBAL_ATTRIBUTE15, NULL PROF_GLOBAL_ATTRIBUTE16, NULL PROF_GLOBAL_ATTRIBUTE17, NULL PROF_GLOBAL_ATTRIBUTE18, NULL PROF_GLOBAL_ATTRIBUTE19, NULL PROF_GLOBAL_ATTRIBUTE20, NULL PROF_GLOBAL_ATTRIBUTE_NUMBER1, NULL PROF_GLOBAL_ATTRIBUTE_NUMBER2, NULL PROF_GLOBAL_ATTRIBUTE_NUMBER3, NULL PROF_GLOBAL_ATTRIBUTE_NUMBER4, NULL PROF_GLOBAL_ATTRIBUTE_NUMBER5, NULL PROF_GLOBAL_ATTRIBUTE_DATE1, NULL PROF_GLOBAL_ATTRIBUTE_DATE2, NULL PROF_GLOBAL_ATTRIBUTE_DATE3, NULL PROF_GLOBAL_ATTRIBUTE_DATE4, NULL PROF_GLOBAL_ATTRIBUTE_DATE5, NULL ACCT_SITE_CONTACT_NAME, NULL ACCT_SITE_PHONE_COUNTRY_CODE, NULL ACCT_SITE_PHONE_AREACODE, NULL ACCT_SITE_PHONE_NUMBER, NULL ACCT_SITE_PHONE_EXTENSION, NULL ACCT_SITE_EMAIL_ADDRESS, cext.CONCATENATED_SITE_PURPOSE, cext.REQUEST_ID FROM AR_DOC_TRANSFER_HEADER_EXT hext, AR_DOC_TRANSFER_CUSTOMER_EXT cext WHERE cext.ACCOUNT_ID = -1 AND cext.ACCOUNT_SITE_USE_ID = -1 AND cext.SHIP_TO_PARTY_ID = hext.SHIP_TO_PARTY_ID AND cext.PARTY_SITE_USE_ID = hext.SHIP_TO_PARTY_SITE_USE_ID AND cext.CONTACT_ID = hext.SHIP_TO_PARTY_CONTACT_ID AND cext.REQUEST_ID = hext.REQUEST_ID UNION ALL SELECT cext.ACCOUNT_ID CUSTOMER_ACCOUNT_ID, cext.ACCOUNT_SITE_USE_ID SITE_USE_ID, cext.CONTACT_ID CUSTOMER_ACCOUNT_ROLE_ID, cext.PARTY_NAME, cext.ACCOUNT_NUMBER, cext.LOCATION, cext.SITE_USE_CODE, cext.ADDRESS_LINE1 ADDRESS_LINE_ONE, cext.ADDRESS_LINE2 ADDRESS_LINE_TWO, cext.ADDRESS_LINE3 ADDRESS_LINE_THREE, cext.ADDRESS_LINE4 ADDRESS_LINE_FOUR, cext.ADDRESS, cext.CITY, cext.COUNTY, cext.STATE, cext.PROVINCE, cext.POSTAL_CODE, cext.TERRITORY_SHORT_NAME, cext.COMPLETE_ADDRESS, cext.NAME, cext.EMAIL_ADDRESS, cext.PRIMARY_PHONE_COUNTRY_CODE, cext.PRIMARY_PHONE_AREA_CODE, cext.PRIMARY_PHONE_NUMBER, cext.PRIMARY_PHONE_EXTENSION, cext.ACCOUNT_SITE_LANGUAGE, cext.PARTY_ID, cext.TAXPAYER_ID_NUMBER, cext.TRADE_PARTNER_CODE, hext.customer_trx_id, 'PAYING' BILL_OR_SHIP, ar_xml_view_functions.tp_function1 (cext.PARTY_SITE_ID) Trade_Party_User_One, ar_xml_view_functions.tp_function2 (cext.PARTY_SITE_ID) Trade_Party_User_Two, ar_xml_view_functions.tp_function3 (cext.PARTY_SITE_ID) Trade_Party_User_Three, ar_xml_view_functions.tp_function4 (cext.PARTY_SITE_ID) Trade_Party_User_Four, ar_xml_view_functions.tp_function5 (cext.PARTY_SITE_ID) Trade_Party_User_Five, ar_xml_view_functions.tp_function6 (cext.PARTY_SITE_ID) Trade_Party_User_Six, ar_xml_view_functions.tp_function7 (cext.PARTY_SITE_ID) Trade_Party_User_Seven, ar_xml_view_functions.tp_function8 (cext.PARTY_SITE_ID) Trade_Party_User_Eight, ar_xml_view_functions.tp_function9 (cext.PARTY_SITE_ID) Trade_Party_User_Nine , ar_xml_view_functions.tp_function10 (cext.PARTY_SITE_ID) Trade_Party_User_Ten, ar_xml_view_functions.tp_function11 (cext.PARTY_SITE_ID) Trade_Party_User_Eleven, ar_xml_view_functions.tp_function12 (cext.PARTY_SITE_ID) Trade_Party_User_Twelve, ar_xml_view_functions.tp_function13 (cext.PARTY_SITE_ID) Trade_Party_User_Thirteen, ar_xml_view_functions.tp_function14 (cext.PARTY_SITE_ID) Trade_Party_User_Fourteen, ar_xml_view_functions.tp_function15 (cext.PARTY_SITE_ID) Trade_Party_User_Fifteen, ar_xml_view_functions.tp_function16 (cext.PARTY_SITE_ID) Trade_Party_User_Sixteen, ar_xml_view_functions.tp_function17 (cext.PARTY_SITE_ID) Trade_Party_User_Seventeen, ar_xml_view_functions.tp_function18 (cext.PARTY_SITE_ID) Trade_Party_User_Eighteen, ar_xml_view_functions.tp_function19 (cext.PARTY_SITE_ID) Trade_Party_User_Nineteen, ar_xml_view_functions.tp_function20 (cext.PARTY_SITE_ID) Trade_Party_User_Twenty, ar_xml_view_functions.tp_function21 (cext.PARTY_SITE_ID) Trade_Party_User_Twenty_One, ar_xml_view_functions.tp_function22 (cext.PARTY_SITE_ID) Trade_Party_User_Twenty_Two, ar_xml_view_functions.tp_function23 (cext.PARTY_SITE_ID) Trade_Party_User_Twenty_Three, ar_xml_view_functions.tp_function24 (cext.PARTY_SITE_ID) Trade_Party_User_Twenty_Four, ar_xml_view_functions.tp_function25 (cext.PARTY_SITE_ID) Trade_Party_User_Twenty_Five, ar_xml_view_functions.tp_function26 (cext.PARTY_SITE_ID) Trade_Party_User_Twenty_Six, ar_xml_view_functions.tp_function27 (cext.PARTY_SITE_ID) Trade_Party_User_Twenty_Seven, ar_xml_view_functions.tp_function28 (cext.PARTY_SITE_ID) Trade_Party_User_Twenty_Eight, ar_xml_view_functions.tp_function29 (cext.PARTY_SITE_ID) Trade_Party_User_Twenty_Nine, ar_xml_view_functions.tp_function30 (cext.PARTY_SITE_ID) Trade_Party_User_Thirty, cext.SITE_NUMBER, cext.COUNTRY_CODE, cext.CUSTOMER_TAX_REG_NUMBER, cext.TAX_REGIME_NAME, cext.ACCT_SITE_ATTRIBUTE_CATEGORY SITE_ATTRIBUTE_CATEGORY, cext.ACCT_SITE_ATTRIBUTE_NUMBER1 SITE_ATTRIBUTE_NUMBER1, cext.ACCT_SITE_ATTRIBUTE_NUMBER2 SITE_ATTRIBUTE_NUMBER2, cext.ACCT_SITE_ATTRIBUTE_NUMBER3 SITE_ATTRIBUTE_NUMBER3, cext.ACCT_SITE_ATTRIBUTE_NUMBER4 SITE_ATTRIBUTE_NUMBER4, cext.ACCT_SITE_ATTRIBUTE_NUMBER5 SITE_ATTRIBUTE_NUMBER5, cext.ACCT_SITE_ATTRIBUTE_NUMBER6 SITE_ATTRIBUTE_NUMBER6, cext.ACCT_SITE_ATTRIBUTE_NUMBER7 SITE_ATTRIBUTE_NUMBER7, cext.ACCT_SITE_ATTRIBUTE_NUMBER8 SITE_ATTRIBUTE_NUMBER8, cext.ACCT_SITE_ATTRIBUTE_NUMBER9 SITE_ATTRIBUTE_NUMBER9, cext.ACCT_SITE_ATTRIBUTE_NUMBER10 SITE_ATTRIBUTE_NUMBER10, cext.ACCT_SITE_ATTRIBUTE_NUMBER11 SITE_ATTRIBUTE_NUMBER11, cext.ACCT_SITE_ATTRIBUTE_NUMBER12 SITE_ATTRIBUTE_NUMBER12, cext.ACCT_SITE_ATTRIBUTE_DATE1 SITE_ATTRIBUTE_DATE1, cext.ACCT_SITE_ATTRIBUTE_DATE2 SITE_ATTRIBUTE_DATE2, cext.ACCT_SITE_ATTRIBUTE_DATE3 SITE_ATTRIBUTE_DATE3, cext.ACCT_SITE_ATTRIBUTE_DATE4 SITE_ATTRIBUTE_DATE4, cext.ACCT_SITE_ATTRIBUTE_DATE5 SITE_ATTRIBUTE_DATE5, cext.ACCT_SITE_ATTRIBUTE_DATE6 SITE_ATTRIBUTE_DATE6, cext.ACCT_SITE_ATTRIBUTE_DATE7 SITE_ATTRIBUTE_DATE7, cext.ACCT_SITE_ATTRIBUTE_DATE8 SITE_ATTRIBUTE_DATE8, cext.ACCT_SITE_ATTRIBUTE_DATE9 SITE_ATTRIBUTE_DATE9, cext.ACCT_SITE_ATTRIBUTE_DATE10 SITE_ATTRIBUTE_DATE10, cext.ACCT_SITE_ATTRIBUTE_DATE11 SITE_ATTRIBUTE_DATE11, cext.ACCT_SITE_ATTRIBUTE_DATE12 SITE_ATTRIBUTE_DATE12, cext.ACCT_SITE_ATTRIBUTE1 SITE_ATTRIBUTE1, cext.ACCT_SITE_ATTRIBUTE2 SITE_ATTRIBUTE2, cext.ACCT_SITE_ATTRIBUTE3 SITE_ATTRIBUTE3, cext.ACCT_SITE_ATTRIBUTE4 SITE_ATTRIBUTE4, cext.ACCT_SITE_ATTRIBUTE5 SITE_ATTRIBUTE5, cext.ACCT_SITE_ATTRIBUTE6 SITE_ATTRIBUTE6, cext.ACCT_SITE_ATTRIBUTE7 SITE_ATTRIBUTE7, cext.ACCT_SITE_ATTRIBUTE8 SITE_ATTRIBUTE8, cext.ACCT_SITE_ATTRIBUTE9 SITE_ATTRIBUTE9, cext.ACCT_SITE_ATTRIBUTE10 SITE_ATTRIBUTE10, cext.ACCT_SITE_ATTRIBUTE11 SITE_ATTRIBUTE11, cext.ACCT_SITE_ATTRIBUTE12 SITE_ATTRIBUTE12, cext.ACCT_SITE_ATTRIBUTE13 SITE_ATTRIBUTE13, cext.ACCT_SITE_ATTRIBUTE14 SITE_ATTRIBUTE14, cext.ACCT_SITE_ATTRIBUTE15 SITE_ATTRIBUTE15, cext.ACCT_SITE_ATTRIBUTE16 SITE_ATTRIBUTE16, cext.ACCT_SITE_ATTRIBUTE17 SITE_ATTRIBUTE17, cext.ACCT_SITE_ATTRIBUTE18 SITE_ATTRIBUTE18, cext.ACCT_SITE_ATTRIBUTE19 SITE_ATTRIBUTE19, cext.ACCT_SITE_ATTRIBUTE20 SITE_ATTRIBUTE20, cext.ACCT_SITE_ATTRIBUTE21 SITE_ATTRIBUTE21, cext.ACCT_SITE_ATTRIBUTE22 SITE_ATTRIBUTE22, cext.ACCT_SITE_ATTRIBUTE23 SITE_ATTRIBUTE23, cext.ACCT_SITE_ATTRIBUTE24 SITE_ATTRIBUTE24, cext.ACCT_SITE_ATTRIBUTE25 SITE_ATTRIBUTE25, cext.ACCT_SITE_ATTRIBUTE26 SITE_ATTRIBUTE26, cext.ACCT_SITE_ATTRIBUTE27 SITE_ATTRIBUTE27, cext.ACCT_SITE_ATTRIBUTE28 SITE_ATTRIBUTE28, cext.ACCT_SITE_ATTRIBUTE29 SITE_ATTRIBUTE29, cext.ACCT_SITE_ATTRIBUTE30 SITE_ATTRIBUTE30, cext.TRANSLATED_CUSTOMER_NAME, cext.PROF_ATTRIBUTE_CATEGORY, cext.PROF_ATTRIBUTE1, cext.PROF_ATTRIBUTE2, cext.PROF_ATTRIBUTE3, cext.PROF_ATTRIBUTE4, cext.PROF_ATTRIBUTE5, cext.PROF_ATTRIBUTE6, cext.PROF_ATTRIBUTE7, cext.PROF_ATTRIBUTE8, cext.PROF_ATTRIBUTE9, cext.PROF_ATTRIBUTE10, cext.PROF_ATTRIBUTE11, cext.PROF_ATTRIBUTE12, cext.PROF_ATTRIBUTE13, cext.PROF_ATTRIBUTE14, cext.PROF_ATTRIBUTE15, cext.PROF_GLOBAL_ATTRIBUTE_CATEGORY, cext.PROF_GLOBAL_ATTRIBUTE1, cext.PROF_GLOBAL_ATTRIBUTE2, cext.PROF_GLOBAL_ATTRIBUTE3, cext.PROF_GLOBAL_ATTRIBUTE4, cext.PROF_GLOBAL_ATTRIBUTE5, cext.PROF_GLOBAL_ATTRIBUTE6, cext.PROF_GLOBAL_ATTRIBUTE7, cext.PROF_GLOBAL_ATTRIBUTE8, cext.PROF_GLOBAL_ATTRIBUTE9, cext.PROF_GLOBAL_ATTRIBUTE10, cext.PROF_GLOBAL_ATTRIBUTE11, cext.PROF_GLOBAL_ATTRIBUTE12, cext.PROF_GLOBAL_ATTRIBUTE13, cext.PROF_GLOBAL_ATTRIBUTE14, cext.PROF_GLOBAL_ATTRIBUTE15, cext.PROF_GLOBAL_ATTRIBUTE16, cext.PROF_GLOBAL_ATTRIBUTE17, cext.PROF_GLOBAL_ATTRIBUTE18, cext.PROF_GLOBAL_ATTRIBUTE19, cext.PROF_GLOBAL_ATTRIBUTE20, cext.PROF_GLOBAL_ATTRIBUTE_NUMBER1, cext.PROF_GLOBAL_ATTRIBUTE_NUMBER2, cext.PROF_GLOBAL_ATTRIBUTE_NUMBER3, cext.PROF_GLOBAL_ATTRIBUTE_NUMBER4, cext.PROF_GLOBAL_ATTRIBUTE_NUMBER5, cext.PROF_GLOBAL_ATTRIBUTE_DATE1, cext.PROF_GLOBAL_ATTRIBUTE_DATE2, cext.PROF_GLOBAL_ATTRIBUTE_DATE3, cext.PROF_GLOBAL_ATTRIBUTE_DATE4, cext.PROF_GLOBAL_ATTRIBUTE_DATE5, cext.ACCT_SITE_CONTACT_NAME, cext.ACCT_SITE_PHONE_COUNTRY_CODE, cext.ACCT_SITE_PHONE_AREACODE, cext.ACCT_SITE_PHONE_NUMBER, cext.ACCT_SITE_PHONE_EXTENSION, cext.ACCT_SITE_EMAIL_ADDRESS, cext.CONCATENATED_SITE_PURPOSE, cext.REQUEST_ID FROM AR_DOC_TRANSFER_HEADER_EXT hext, AR_DOC_TRANSFER_CUSTOMER_EXT cext WHERE cext.ACCOUNT_ID = hext.PAYING_CUSTOMER_ID AND cext.ACCOUNT_SITE_USE_ID = hext.PAYING_SITE_USE_ID AND cext.SHIP_TO_PARTY_ID = -1 AND cext.PARTY_SITE_USE_ID = -1 AND cext.CONTACT_ID = hext.PAYING_PRIMARY_ACCT_CONTACT_ID AND cext.REQUEST_ID = hext.REQUEST_ID