[xsl] Conditional Merging of the node based child value match

[Senthilkumaravelan Krishnanatham <senthil@xxxxxxxxx>]

Hi All,
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> 000010 </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>YYYY</CTO_INFO>
</CTOS>
</TAB_ITEM>

	<TAB_ITEM>
<ITEM_NUMBER> 000020 </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>