Sample XML Data Template

 <?xml version="1.0" encoding="UTF-8" ?>
<dataTemplate name="XXTMPLTNAME_DD" defaultPackage="XX_RPT_PKG" version="1.0">
<properties>
<property name="xml_tag_case" value="upper" />
</properties>
<parameters>
<parameter name="PARAM1"  dataType="VARCHAR2"/>
</parameters>
<dataQuery>
<sqlStatement name="Q_MAILING_DTL">
<![CDATA[
 Select null TO_EMAIL,
        null CC_EMAIL,
        null BCC_EMAIL
  from dual
]]>
</sqlStatement>
<sqlStatement name="Q_PAYMENT_DETAILS">
<![CDATA[
SELECT  
hca.cust_account_id,
hca.account_number,
hca.account_name,
hp.party_id,
hp.party_number,
hp.party_name customer_name,
hp.email_address email_address,
  hp.PRIMARY_PHONE_COUNTRY_CODE
|| hp.PRIMARY_PHONE_COUNTRY_CODE
|| hp.PRIMARY_PHONE_NUMBER
  mobile_number,
pn.location_id,
pn.location_code,
hou.set_of_books_id,
trx.customer_trx_id,
trx.trx_number,
trx.trx_date,
apsa.amount_due_original ,
apsa.amount_due_remaining ,
(Select SUM(UNAPPLIED_AMOUNT) 
  from 
  ( Select  (CRA.AMOUNT - SUM(RAA.AMOUNT_APPLIED)) UNAPPLIED_AMOUNT 
          from  APPS.HZ_CUST_ACCOUNTS HCA2,
                  APPS.AR_CASH_RECEIPTS_ALL CRA,
                  APPS.AR_CASH_RECEIPT_HISTORY_ALL CRHA,
                  APPS.AR_RECEIVABLE_APPLICATIONS_ALL RAA
    where hca2.party_id = hp.party_id
      and CRA.PAY_FROM_CUSTOMER = HCA2.CUST_ACCOUNT_ID
  and cra.cash_receipt_id      = crha.cash_receipt_id
  AND crha.current_record_flag = 'Y'
  and crha.status              = 'CLEARED'                
  and cra.cash_receipt_id = raa.cash_receipt_id(+)
  and raa.application_type(+) = 'CASH'
  and raa.display(+) = 'Y'
  and raa.status(+) = 'APP' 
group by  cra.cash_receipt_id  , 
  cra.receipt_number , 
  CRA.PAY_FROM_CUSTOMER ,
  CRA.AMOUNT  )
   )   unapplied_amount_available
FROM pn_locations_all pn,
        ra_customer_trx_all trx,
        ar_payment_schedules_all apsa ,
        apps.hz_cust_accounts hca,
        apps.hz_parties hp,
        apps.hr_operating_units hou
WHERE     1 = 1
 trx.customer_trx_id = apsa.customer_trx_id
AND trx.bill_to_customer_id = hca.CUST_ACCOUNT_ID 
AND hca.account_name = pn.location_code
AND hca.party_id = hp.party_id
AND hp.party_id = :PARAM1
AND trx.org_id = hou.organization_id
AND (SELECT SUM (NVL (amount_due_remaining, 0))
  FROM ar_payment_schedules_all
WHERE customer_trx_id = trx.customer_trx_id) > 100
]]>
</sqlStatement>
</dataQuery>
<dataTrigger name="beforeReportTrigger" source="XX_RPT_PKG.BEFOREREPORT"/> 
<dataStructure>
  <group name="G_HEADERS" dataType="VARCHAR2" source="Q_MAILING_DTL">
<element name="TO_EMAIL" dataType="VARCHAR2" value="TO_EMAIL"/>
<element name="CC_EMAIL" dataType="VARCHAR2" value="CC_EMAIL"/>
<element name="BCC_EMAIL" dataType="VARCHAR2" value="BCC_EMAIL"/>
    <group name="G_DETAILS" dataType="VARCHAR2" source="Q_PAYMENT_DETAILS">
<element name="CUST_ACCOUNT_ID" dataType="VARCHAR2" value="CUST_ACCOUNT_ID"/>
<element name="ACCOUNT_NUMBER" dataType="VARCHAR2" value="ACCOUNT_NUMBER"/>
<element name="ACCOUNT_NAME" dataType="VARCHAR2" value="ACCOUNT_NAME"/>
<element name="PARTY_ID" dataType="VARCHAR2" value="PARTY_ID"/>
<element name="PARTY_NUMBER" dataType="VARCHAR2" value="PARTY_NUMBER"/>
<element name="CUSTOMER_NAME" dataType="VARCHAR2" value="CUSTOMER_NAME"/>
<element name="EMAIL_ADDRESS" dataType="VARCHAR2" value="EMAIL_ADDRESS"/>
<element name="MOBILE_NUMBER" dataType="VARCHAR2" value="MOBILE_NUMBER"/>
<element name="LOCATION_ID" dataType="VARCHAR2" value="LOCATION_ID"/>
<element name="LOCATION_CODE" dataType="VARCHAR2" value="LOCATION_CODE"/>
<element name="TRX_NUMBER" dataType="VARCHAR2" value="TRX_NUMBER"/>
<element name="TRX_DATE" dataType="VARCHAR2" value="TRX_DATE"/>
<element name="SET_OF_BOOKS_ID" dataType="VARCHAR2" value="SET_OF_BOOKS_ID"/>
<element name="ORG_ID" dataType="VARCHAR2" value="ORG_ID"/>
<element name="AMOUNT_DUE_ORIGINAL" dataType="VARCHAR2" value="AMOUNT_DUE_ORIGINAL"/>
<element name="AMOUNT_DUE_REMAINING" dataType="VARCHAR2" value="AMOUNT_DUE_REMAINING"/>
<element name="UNAPPLIED_AMOUNT_AVAILABLE" dataType="VARCHAR2" value="UNAPPLIED_AMOUNT_AVAILABLE"/>
   </group>
 </group>    
</dataStructure>
<dataTrigger name="afterReportTrigger" source="XX_RPT_PKG.AFTERREPORT"/> 
</dataTemplate>