XML Based Report Format

<?xml version="1.0" encoding="UTF-8"?>
<dataTemplate name="XXES_ECAT_ORDER_EXCEPTION" version="1.0">
  <properties> <property name="include_null_Element" value="True"/>
               <property name="xml_tag_case" value="upper"/>
               <property name="scalable_mode" value="on"/>
  </properties>
  <parameters>                  <parameter name="p_organization_id" include_in_output="TRUE" dataType="NUMBER"/>
<parameter name="p_parent_item" include_in_output="TRUE" dataType="VARCHAR2"/>
                             
  </parameters>
  <dataQuery>
         
     <sqlStatement name="Q_1">
     <![CDATA[SELECT msi.segment1 Parent_Item,
       msi.description Parent_Item_Description,
       msi1.segment1 Child_Item,
       msi1.description Child_Item_Description,
       BIC.component_quantity CHILD_ITEM_QUANTITY,
       bic.supply_subinventory,
        MIL.segment1
         || '.'
         || MIL.segment2
         || '.'
         || MIL.segment3
        ChildLocator
  FROM mtl_system_items_b msi,
       bom_bill_of_materials bom,
       bom_inventory_components bic,
       mtl_system_items_b msi1,
       MTL_ITEM_LOCATIONS mil
WHERE     1 = 1
       AND msi.organization_id = :p_organization_id
       AND msi.inventory_item_id = bom.assembly_item_id
       AND msi.organization_id = bom.organization_id
       AND bom.organization_id = :p_organization_id
       AND bom.alternate_bom_designator IS NULL
       AND bom.bill_sequence_id = bic.bill_sequence_id
       AND bic.disable_date IS NULL
       AND bic.component_item_id = msi1.inventory_item_id
       AND mil.inventory_location_id(+) = bic.supply_locator_id
       AND msi1.organization_id = :p_organization_id
    AND msi.segment1 = nvl(:p_parent_item,msi.segment1)   
    order by 1,3
    ]]>
            </sqlStatement>

  </dataQuery>
   <dataStructure> 
      <group name="G_PO_TYPE" source="Q_1">
                 <element name="Parent_Item" value="Parent_Item"/>
  <element name="Parent_Item_Description" value="Parent_Item_Description"/>
  <element name="Child_Item" value="Child_Item"/>
  <element name="Child_Item_Description" value="Child_Item_Description"/>
          <element name="CHILD_ITEM_QUANTITY" value="CHILD_ITEM_QUANTITY"/>
                  <element name="supply_subinventory" value="supply_subinventory"/>
  <element name="ChildLocator" value="ChildLocator"/>
     </group>
  </dataStructure>
</dataTemplate>