[xsl] Grouping the node based on the child match

Hi
I have following xml as my input and I need to group the item number  
with the corresponding line item number and form the out as mentioned  
below.
I would like to how to group the nodes based the condition and form  
the output.
Thanks in advance .

Senthil

Input XML

<ORDER>
        <TAB_CTO>
<ITEM_NUMBER>000010</ITEM_NUMBER>
<CTO_INFO>YYYYY</CTO_INFO>
</TAB_CTO>

        <TAB_CTO>
<ITEM_NUMBER>000010</ITEM_NUMBER>
<CTO_INFO>XXXX</CTO_INFO>
</TAB_CTO>



        <TAB_ITEM>
<ITEM_NUMBER>000020</ITEM_NUMBER>
<PRODUCT_NUMBER>Z06M</PRODUCT_NUMBER>
<PRODUCT_DESCRIPTION>CTO - IBOOK 14.1 800MHZ</PRODUCT_DESCRIPTION>
<QTY>2.000</QTY>
<PRICE>1825.00</PRICE>
<EXT_PRICE>3650.00</EXT_PRICE>
</TAB_ITEM>

        <TAB_ITEM>
<ITEM_NUMBER>000010</ITEM_NUMBER>
<PRODUCT_NUMBER>XXXX</PRODUCT_NUMBER>
<PRODUCT_DESCRIPTION>PRODUCT1</PRODUCT_DESCRIPTION>
<QTY>2.000</QTY>
<PRICE>1825.00</PRICE>
<EXT_PRICE>3650.00</EXT_PRICE>
</TAB_ITEM>

</ORDER>

Expected output

<ORDER>

        <TAB_ITEM>
<ITEM_NUMBER>000020</ITEM_NUMBER>
<PRODUCT_NUMBER>Z06M</PRODUCT_NUMBER>
<PRODUCT_DESCRIPTION>CTO - IBOOK 14.1 800MHZ</PRODUCT_DESCRIPTION>
<QTY>2.000</QTY>
<PRICE>1825.00</PRICE>
<EXT_PRICE>3650.00</EXT_PRICE>
<CTOS>
<CTO_INFO>XXXX</CTO_INFO>
<CTO_INFO>XXXX</CTO_INFO>
</CTOS>
</TAB_ITEM>

        <TAB_ITEM>
<ITEM_NUMBER>000010</ITEM_NUMBER>
<PRODUCT_NUMBER>XXXX</PRODUCT_NUMBER>
<PRODUCT_DESCRIPTION>PRODUCT1</PRODUCT_DESCRIPTION>
<QTY>2.000</QTY>
<PRICE>1825.00</PRICE>
<EXT_PRICE>3650.00</EXT_PRICE>
</TAB_ITEM>

</ORDER>




--~------------------------------------------------------------------
XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--