Re - Grouping input XML before applying to template

In this lesson we are going to construct an RDF with out any grouping but we can regroup it in the RTF which is shown below.

Now we have to construct an RDF by using below Query

SELECT pha.segment1 po_number, 

              pha.creation_date po_date,

              pha.type_lookup_code, 

              pv.segment1 vendor_number,

              pv.vendor_name,

              pla.line_num, 

              pla.unit_price unit_price, 

              pla.quantity quantity

  FROM po_headers_all pha,

               po_vendors pv,

               po_lines_all pla,

               po_line_locations_all plla,

               mtl_system_items_b msi

 WHERE pha.vendor_id = pv.vendor_id

   AND    pha.po_header_id = pla.po_header_id

   AND    pla.po_line_id = plla.po_line_id

   AND    pla.item_id = msi.inventory_item_id

   AND    plla.ship_to_location_id = msi.organization_id

   AND    ROWNUM < 101

Our RDF looks

Now we have to generate XML .

Our XML looks

Now we have to construct RTF.

Out RTF looks

In the Add Help Text we have to write below command for each field

 

Now we have to publish the report

Click on Template Builder => Preview => HTML/PDF/Excel/RTF (any format).

We can get below output