XML Publisher Report from XML Data Template(SQL Query)

                        XML Publisher Report from XML Data Template(SQL Query)

<?xml version="1.0"?><dataTemplate version="1.0" name="XXHRCUSTOMER"><properties></properties><parameters><parameter name="p_customer_id" datatype="NUMBER"> </parameter></parameters><dataQuery><sqlStatement name="XXHRCUSTSLT"><![CDATA[SELECT DISTINCT  (HP.PARTY_ID) CUSTOMER_ID,HCP.CUST_ACCOUNT_ID CUST_ACCOUNT_ID,HP.PARTY_NAME CUSTOMER_NAME,ARCPV.profile_class_name Profile_Name,(HP.ADDRESS1||','||HP.ADDRESS2||','||HP.ADDRESS3||','||HP.ADDRESS4 ||','||HP.CITY||','||HP.STATE||','||HP.COUNTRY||','||HP.POSTAL_CODE)ADDRESS, HP.PRIMARY_PHONE_NUMBER CONTACT_NUMBER,HP.EMAIL_ADDRESS EMAIL,HP.URL CUST_WEBSITE,HCA.ACCOUNT_NAME ACCOUNT_NAME,HCP.DISCOUNT_TERMS DISCOUNT_TERMS,HCP.DUNNING_LETTERS DUNNING_LETTERS,HCP.INTEREST_CHARGES INTEREST_CHARGES,HRS.OBJECT_TYPE OBJECT_TYPE,HPP.PERSON_NAME PERSON_NAME,IEPA.PAYMENT_FUNCTION PAYMENT_FUNCTION,IPIUA.INSTRUMENT_TYPE PAYMENT_TYPE,IEBA.BANK_ACCOUNT_NAME HOLDER_NAME,IEBA.BANK_ACCOUNT_NUM ACCOUNT_NUMBER,IEBA.CURRENCY_CODE BANK_ACCEPT_CURRENCY,HLS.CITY BILL_TO,HLS.CITY SHIP_TOFROM HZ_PARTIES HP,hz_party_sites hps,HZ_LOCATIONS HLS,HZ_CUST_ACCOUNTS HCA,HZ_CUSTOMER_PROFILES HCP,AR_CUSTOMER_PROFILE_CLASSES_V ARCPV,HZ_RELATIONSHIPS HRS,hz_person_profiles HPP,IBY_EXTERNAL_PAYERS_ALL IEPA,IBY_PMT_INSTR_USES_ALL IPIUA,IBY_EXT_BANK_ACCOUNTS IEBAwhere HP.PARTY_ID=HCA.PARTY_IDAND HP.PARTY_ID=HPS.PARTY_IDAND HPS.LOCATION_ID=HLS.LOCATION_IDAND HCA.CUST_ACCOUNT_ID=HCP.CUST_ACCOUNT_IDAND HCP.COLLECTOR_ID=ARCPV.COLLECTOR_IDAND HCA.PARTY_ID=HRS.SUBJECT_IDAND HRS.OBJECT_ID=HPP.PARTY_IDAND HCA.CUST_ACCOUNT_ID=IEPA.CUST_ACCOUNT_IDAND IEPA.EXT_PAYER_ID=IPIUA.EXT_PMT_PARTY_IDAND IPIUA.INSTRUMENT_ID=IEBA.EXT_BANK_ACCOUNT_ID(+)AND HP.party_id=:p_customer_id ]]></sqlStatement></dataQuery><dataStructure><group name="XXHRCUSTSLT" datatype="varchar2" source="XXHRCUSTSLT"><element name="CUSTOMER_ID" value="CUSTOMER_ID"/><element name="CUST_ACCOUNT_ID" value="CUST_ACCOUNT_ID"/><element name="CUSTOMER_NAME" value="CUSTOMER_NAME"/><element name="Profile_Name" value="Profile_Name"/><element name="ADDRESS" value="ADDRESS"/><element name="CONTACT_NUMBER" value="CONTACT_NUMBER"/><element name="EMAIL" value="EMAIL"/><element name="CUST_WEBSITE" value="CUST_WEBSITE"/><element name="ACCOUNT_NAME" value="ACCOUNT_NAME"/><element name="DISCOUNT_TERMS" value="DISCOUNT_TERMS"/><element name="DUNNING_LETTERS" value="DUNNING_LETTERS"/><element name="INTEREST_CHARGES" value="INTEREST_CHARGES"/><element name="OBJECT_TYPE" value="OBJECT_TYPE"/><element name="PERSON_NAME" value="PERSON_NAME"/><element name="PAYMENT_FUNCTION" value="PAYMENT_FUNCTION"/><element name="PAYMENT_TYPE" value="PAYMENT_TYPE"/><element name="HOLDER_NAME" value="HOLDER_NAME"/><element name="ACCOUNT_NUMBER" value="ACCOUNT_NUMBER"/><element name="BANK_ACCEPT_CURRENCY" value="BANK_ACCEPT_CURRENCY"/><element name="BILL_TO" value="BILL_TO"/><element name="SHIP_TO" value="SHIP_TO"/></group></dataStructure></dataTemplate>