XML Publisher – Data Template Approach – Samples
XML Publisher Data Template Sample
<?xml version="1.0" encoding="WINDOWS-1252" ?>
<dataTemplate name="XXQA_SUPP_REP_DM" description="Supplier Details Report" Version="1.0">
<properties>
<property name="debug_mode" value="on"/>
</properties>
<dataQuery>
<sqlStatement name="Q1">
<![CDATA[
select asup.vendor_id, asup.vendor_name,
asup.segment1 vendor_num
, assa.vendor_site_code
, assa.address_line1
, assa.org_id
, hou.name org_name
from ap_suppliers asup , ap_supplier_sites_all assa,
hr_operating_units hou
where asup.vendor_id in ( 33169, 210, 314, 4, 9, 12, 355)
and assa.vendor_id = asup.vendor_id
and hou.organization_id = assa.org_id
]]></sqlStatement>
</dataQuery>
<dataStructure>
<group name="G_SUPP_DATA" source="Q1">
<element name="vendor_id" value="vendor_id"/>
<element name="vendor_name" value="vendor_name"/>
<element name="vendor_num" value="vendor_num"/>
<element name="vendor_site_code" value="vendor_site_code"/>
<element name="address_line1" value="address_line1"/>
<element name="org_name" value="org_name"/>
</group>
</dataStructure>
</dataTemplate>
Comments |0|
Category: EBS