3 Replies Latest reply: Sep 12, 2013 10:52 AM by Yogi RSS

    BI Publisher XSL-XML Template - Nested Loops

    Yogi

      Hi There,

       

      I created an XML Publisher report in Oracle eBusiness Suite with the template of type XSL-XML to view the  output in EXCEL.

       

      The Nested FOR loops are not working for me.

       

      I cannot access the elements in the G_COST_CENTER group.

      Please help me on how to access the elements in the G_COST_CENTER and the groups below it.

       

      Below is the sample xml data:

       

      <FAS440>

        <LIST_G_SETUP>

          <G_SETUP>

            <CATEGORY_FLEX_STRUCTURE>101</CATEGORY_FLEX_STRUCTURE>

            <LOCATION_FLEX_STRUCTURE>101</LOCATION_FLEX_STRUCTURE>

            <ASSET_KEY_FLEX_STRUCTURE>101</ASSET_KEY_FLEX_STRUCTURE>

            <COMPANY_NAME>XXXXXXX</COMPANY_NAME>

            <BOOK_TYPE_CODE>XXXXXXXXXXX PROPERTY</BOOK_TYPE_CODE>

            <BOOK_CLASS>CORPORATE</BOOK_CLASS>

            <ACCOUNTING_FLEX_STRUCTURE>101</ACCOUNTING_FLEX_STRUCTURE>

            <DISTRIBUTION_SOURCE_BOOK>XXXXXXXXXXX PROPERTY</DISTRIBUTION_SOURCE_BOOK>

            <CURRENCY_CODE>USD</CURRENCY_CODE>

            <LIST_G_COMPANY>

              <G_COMPANY>

                <COMP_CODE>01</COMP_CODE>

                <LIST_G_ASSET_TYPE>

                  <G_ASSET_TYPE>

                    <ASSET_TYPE>Capitalized</ASSET_TYPE>

                    <LIST_G_ACCOUNT>

                      <G_ACCOUNT>

                        <ACCOUNT>12210</ACCOUNT>

                        <LIST_G_COST_CENTER>

                          <G_COST_CENTER>

                            <COST_CENTER>21122</COST_CENTER>

                            <LIST_G_RETIREMENTS>

                              <G_RETIREMENTS>

                                <CATEGORY_ID>8</CATEGORY_ID>

                                <RET_CODE>SALE</RET_CODE>

                                <TRANSACTION_TYPE_CODE>FULL RETIREMENT</TRANSACTION_TYPE_CODE>

                                <ASSET_ID>114011</ASSET_ID>

                                <ASSET_NUMBER>114011</ASSET_NUMBER>

                                <ASSET_NUM_DESC>114011 - 3.26 ACRES</ASSET_NUM_DESC>

                                <DATE_PLACED_IN_SERVICE>25-MAY-94</DATE_PLACED_IN_SERVICE>

                                <DATE_RETIRED>03-MAY-12</DATE_RETIRED>

                                <COST>32600</COST>

                                <NBV>32600</NBV>

                                <PROCEEDS>27716.93</PROCEEDS>

                                <REMOVAL>0</REMOVAL>

                                <REVAL_RSV_RET>0</REVAL_RSV_RET>

                                <TRANSACTION_HEADER_ID>608774</TRANSACTION_HEADER_ID>

                                <CODE></CODE>

                                <CF_CATEGORY_NAME>XXXX.XXXX.Z.00</CF_CATEGORY_NAME>

                                <D_COST>     32,600.00 </D_COST>

                                <D_NBV>     32,600.00 </D_NBV>

                                <D_PROCEEDS>     27,716.93 </D_PROCEEDS>

                                <D_REMOVAL>          0.00 </D_REMOVAL>

                                <GAIN_LOSS>-4883.07</GAIN_LOSS>

                                <D_GAIN_LOSS>     (4,883.07)</D_GAIN_LOSS>

                              </G_RETIREMENTS>

                            </LIST_G_RETIREMENTS>

                            <D_COST_CENTER>21122</D_COST_CENTER>

                            <CC_COST>32600</CC_COST>

                            <D_CC_COST>     32,600.00 </D_CC_COST>

                            <CC_NBV>32600</CC_NBV>

                            <D_CC_NBV>     32,600.00 </D_CC_NBV>

                            <CC_PROCEEDS>27716.93</CC_PROCEEDS>

                            <D_CC_PROCEEDS>     27,716.93 </D_CC_PROCEEDS>

                            <CC_REMOVAL>0</CC_REMOVAL>

                            <D_CC_REMOVAL>          0.00 </D_CC_REMOVAL>

                            <CC_GAIN_LOSS>-4883.07</CC_GAIN_LOSS>

                            <D_CC_GAIN_LOSS>     (4,883.07)</D_CC_GAIN_LOSS>

                          </G_COST_CENTER>

                        </LIST_G_COST_CENTER>

                        <AC_COST>32600</AC_COST>

                        <D_AC_COST>     32,600.00 </D_AC_COST>

                        <AC_NBV>32600</AC_NBV>

                        <D_AC_NBV>     32,600.00 </D_AC_NBV>

                        <AC_PROCEEDS>27716.93</AC_PROCEEDS>

                        <D_AC_PROCEEDS>     27,716.93 </D_AC_PROCEEDS>

                        <AC_REMOVAL>0</AC_REMOVAL>

                        <D_AC_REMOVAL>          0.00 </D_AC_REMOVAL>

                        <AC_GAIN_LOSS>-4883.07</AC_GAIN_LOSS>

                        <D_AC_GAIN_LOSS>     (4,883.07)</D_AC_GAIN_LOSS>

                      </G_ACCOUNT>

                    </LIST_G_ACCOUNT>            

                  </G_ASSET_TYPE>

                </LIST_G_ASSET_TYPE>        

              </G_COMPANY>

            </LIST_G_COMPANY>  

          </G_SETUP>

        </LIST_G_SETUP> 

      </FAS440>

       

      -------------------------------------------------------------------------------------------------

       

       

      Below is the XSL-XML template:

       

       

      ------------------------------------------------------------------------------------------------

       

       

      <?xml version="1.0"?>

      <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

      <xsl:template match="/">

      <?mso-application progid="Excel.Sheet"?>

      <Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"

      xmlns:o="urn:schemas-microsoft-com:office:office"

      xmlns:x="urn:schemas-microsoft-com:office:excel"

      xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"

      xmlns:html="http://www.w3.org/TR/REC-html40">

        <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">

        <Author>Garimella, Vishnu</Author>

        <LastAuthor>Windows User</LastAuthor>

        <Created>2013-07-19T19:05:05Z</Created>

        <LastSaved>2013-07-23T23:54:58Z</LastSaved>

        <Version>12.00</Version>

      </DocumentProperties>

      <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">

        <WindowHeight>6255</WindowHeight>

        <WindowWidth>15135</WindowWidth>

        <WindowTopX>90</WindowTopX>

        <WindowTopY>120</WindowTopY>

        <ProtectStructure>False</ProtectStructure>

        <ProtectWindows>False</ProtectWindows>

      </ExcelWorkbook>

      <Styles>

        <Style ss:ID="Default" ss:Name="Normal">

         <Alignment ss:Vertical="Bottom"/>

         <Borders/>

         <Font ss:FontName="Tahoma"/>

         <Interior/>

         <NumberFormat/>

         <Protection/>

        </Style>

        <Style ss:ID="s62">

         <Alignment ss:Vertical="Top"/>

         <Borders/>

         <Font ss:FontName="Tahoma" x:Family="Swiss" ss:Color="#000000"/>

         <Interior/>

        </Style>

        <Style ss:ID="s63">

         <Alignment ss:Horizontal="Right" ss:Vertical="Top"/>

         <Borders>

          <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"

           ss:Color="#969696"/>

          <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"

           ss:Color="#969696"/>

          <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"

           ss:Color="#969696"/>

          <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"

           ss:Color="#969696"/>

         </Borders>

         <Font ss:FontName="Tahoma" x:Family="Swiss" ss:Color="#000000"/>

         <Interior ss:Color="#C0C0C0" ss:Pattern="Solid"/>

        </Style>

        <Style ss:ID="s64">

         <Alignment ss:Horizontal="Left" ss:Vertical="Top"/>

         <Borders>

          <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"

           ss:Color="#969696"/>

          <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"

           ss:Color="#969696"/>

          <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"

           ss:Color="#969696"/>

          <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"

           ss:Color="#969696"/>

         </Borders>

         <Font ss:FontName="Tahoma" x:Family="Swiss" ss:Color="#000000"/>

         <Interior ss:Color="#C0C0C0" ss:Pattern="Solid"/>

        </Style>

        <Style ss:ID="s65">

         <Alignment ss:Horizontal="Right" ss:Vertical="Top"/>

         <Borders/>

         <Font ss:FontName="Tahoma" x:Family="Swiss" ss:Color="#000000"/>

         <Interior/>

         <NumberFormat ss:Format="0"/>

        </Style>

        <Style ss:ID="s66">

         <Alignment ss:Horizontal="Left" ss:Vertical="Top"/>

         <Borders/>

         <Font ss:FontName="Tahoma" x:Family="Swiss" ss:Color="#000000"/>

         <Interior/>

        </Style>

        <Style ss:ID="s67">

         <Alignment ss:Horizontal="Right" ss:Vertical="Top"/>

         <Borders/>

         <Font ss:FontName="Tahoma" x:Family="Swiss" ss:Color="#000000"/>

         <Interior/>

         <NumberFormat ss:Format="Fixed"/>

        </Style>

        <Style ss:ID="s68">

         <Font ss:FontName="Tahoma" x:Family="Swiss"/>

        </Style>

        <Style ss:ID="s69">

         <Alignment ss:Vertical="Top"/>

         <Borders/>

         <Font ss:FontName="Tahoma" x:Family="Swiss" ss:Color="#000000"/>

         <Interior/>

         <NumberFormat ss:Format="#,##0.00_);\(#,##0.00\)"/>

        </Style>

        <Style ss:ID="s70">

         <Alignment ss:Horizontal="Right" ss:Vertical="Top"/>

         <Borders>

          <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"

           ss:Color="#969696"/>

          <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"

           ss:Color="#969696"/>

          <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"

           ss:Color="#969696"/>

          <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"

           ss:Color="#969696"/>

         </Borders>

         <Font ss:FontName="Tahoma" x:Family="Swiss" ss:Color="#000000"/>

         <Interior ss:Color="#C0C0C0" ss:Pattern="Solid"/>

         <NumberFormat ss:Format="#,##0.00_);\(#,##0.00\)"/>

        </Style>

        <Style ss:ID="s71">

         <Alignment ss:Horizontal="Right" ss:Vertical="Top"/>

         <Borders/>

         <Font ss:FontName="Tahoma" x:Family="Swiss" ss:Color="#000000"/>

         <Interior/>

         <NumberFormat ss:Format="#,##0.00_);\(#,##0.00\)"/>

        </Style>

        <Style ss:ID="s72">

         <Alignment ss:Horizontal="Left" ss:Vertical="Top"/>

         <Borders>

          <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"

           ss:Color="#969696"/>

          <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"

           ss:Color="#969696"/>

          <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"

           ss:Color="#969696"/>

          <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"

           ss:Color="#969696"/>

         </Borders>

         <Font ss:FontName="Tahoma" x:Family="Swiss" ss:Color="#000000"/>

         <Interior ss:Color="#FFFF00" ss:Pattern="Solid"/>

        </Style>

        <Style ss:ID="s73">

         <Alignment ss:Horizontal="Left" ss:Vertical="Top"/>

         <Borders>

          <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"

           ss:Color="#969696"/>

          <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"

           ss:Color="#969696"/>

          <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"

           ss:Color="#969696"/>

          <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"

           ss:Color="#969696"/>

         </Borders>

         <Font ss:FontName="Tahoma" x:Family="Swiss" ss:Color="#000000"/>

         <Interior ss:Color="#92D050" ss:Pattern="Solid"/>

        </Style>

      </Styles>

      <Names>

        <NamedRange ss:Name="Untitled" ss:RefersTo="=AssetRetirement!R1C1:R90C14"/>

      </Names>

      <Worksheet ss:Name="AssetRetirement">

        <Names>

         <NamedRange ss:Name="Print_Area" ss:RefersTo="=AssetRetirement!R1C1:R90C14"/>

         <NamedRange ss:Name="Print_Titles" ss:RefersTo="=AssetRetirement!R1"/>

        </Names>

        <Table ss:ExpandedColumnCount="14" ss:ExpandedRowCount="90" x:FullColumns="1"

         x:FullRows="1">

         <Column ss:StyleID="s62" ss:AutoFitWidth="0" ss:Width="66"/>

         <Column ss:StyleID="s62" ss:AutoFitWidth="0" ss:Width="84"/>

         <Column ss:StyleID="s62" ss:AutoFitWidth="0" ss:Width="70.5"/>

         <Column ss:StyleID="s62" ss:AutoFitWidth="0" ss:Width="165"/>

         <Column ss:StyleID="s62" ss:AutoFitWidth="0" ss:Width="136.5"/>

         <Column ss:StyleID="s62" ss:Width="126"/>

         <Column ss:StyleID="s62" ss:AutoFitWidth="0" ss:Width="74.25"/>

         <Column ss:StyleID="s62" ss:AutoFitWidth="0" ss:Width="61.5"/>

         <Column ss:StyleID="s62" ss:AutoFitWidth="0" ss:Width="72"/>

         <Column ss:StyleID="s71" ss:AutoFitWidth="0" ss:Width="72"/>

         <Column ss:StyleID="s69" ss:AutoFitWidth="0" ss:Width="93"/>

         <Column ss:StyleID="s69" ss:AutoFitWidth="0" ss:Width="87.75"/>

         <Column ss:StyleID="s62" ss:AutoFitWidth="0" ss:Width="72"/>

         <Column ss:StyleID="s62" ss:AutoFitWidth="0" ss:Width="13.5"/>

         <Row ss:AutoFitHeight="0" ss:Height="13.6875">

          <Cell ss:StyleID="s63"><Data ss:Type="String">ACCT</Data><NamedCell

            ss:Name="Print_Titles"/><NamedCell ss:Name="Untitled"/><NamedCell

            ss:Name="Print_Area"/></Cell>

          <Cell ss:StyleID="s63"><Data ss:Type="String">CSCTR</Data><NamedCell

            ss:Name="Print_Titles"/><NamedCell ss:Name="Untitled"/><NamedCell

            ss:Name="Print_Area"/></Cell>

          <Cell ss:StyleID="s64"><Data ss:Type="String">ASSET TYPE</Data><NamedCell

            ss:Name="Print_Titles"/><NamedCell ss:Name="Untitled"/><NamedCell

            ss:Name="Print_Area"/></Cell>

          <Cell ss:StyleID="s64"><Data ss:Type="String">ASSET No/Description</Data><NamedCell

            ss:Name="Print_Titles"/><NamedCell ss:Name="Untitled"/><NamedCell

            ss:Name="Print_Area"/></Cell>

          <Cell ss:StyleID="s72"><Data ss:Type="String">CATEGORY</Data><NamedCell

            ss:Name="Print_Titles"/><NamedCell ss:Name="Untitled"/><NamedCell

            ss:Name="Print_Area"/></Cell>

          <Cell ss:StyleID="s64"><Data ss:Type="String">Date</Data><NamedCell

            ss:Name="Print_Titles"/><NamedCell ss:Name="Untitled"/><NamedCell

            ss:Name="Print_Area"/></Cell>

          <Cell ss:StyleID="s64"><Data ss:Type="String">Ret Date</Data><NamedCell

            ss:Name="Print_Titles"/><NamedCell ss:Name="Untitled"/><NamedCell

            ss:Name="Print_Area"/></Cell>

          <Cell ss:StyleID="s63"><Data ss:Type="String">Cost Retired</Data><NamedCell

            ss:Name="Print_Titles"/><NamedCell ss:Name="Untitled"/><NamedCell

            ss:Name="Print_Area"/></Cell>

          <Cell ss:StyleID="s63"><Data ss:Type="String">Sale Proceeds</Data><NamedCell

            ss:Name="Print_Titles"/><NamedCell ss:Name="Untitled"/><NamedCell

            ss:Name="Print_Area"/></Cell>

          <Cell ss:StyleID="s70"><Data ss:Type="String">Removal Cost</Data><NamedCell

            ss:Name="Print_Titles"/><NamedCell ss:Name="Untitled"/><NamedCell

            ss:Name="Print_Area"/></Cell>

          <Cell ss:StyleID="s70"><Data ss:Type="String">Gain/loss</Data><NamedCell

            ss:Name="Print_Titles"/><NamedCell ss:Name="Untitled"/><NamedCell

            ss:Name="Print_Area"/></Cell>

          <Cell ss:StyleID="s70"><Data ss:Type="String">NBV Ret'd</Data><NamedCell

            ss:Name="Print_Titles"/><NamedCell ss:Name="Untitled"/><NamedCell

            ss:Name="Print_Area"/></Cell>

          <Cell ss:StyleID="s73"><Data ss:Type="String">Retirement TP</Data><NamedCell

            ss:Name="Print_Titles"/><NamedCell ss:Name="Untitled"/><NamedCell

            ss:Name="Print_Area"/></Cell>

          <Cell ss:StyleID="s73"><Data ss:Type="String">T</Data><NamedCell

            ss:Name="Print_Titles"/><NamedCell ss:Name="Untitled"/><NamedCell

            ss:Name="Print_Area"/></Cell>

         </Row>  

         <xsl:for-each select=".//G_ASSET_TYPE">

         <xsl:for-each select=".//G_ACCOUNT">  

          <Row ss:AutoFitHeight="0" ss:Height="13.6875">   

            <Cell ss:StyleID="s65"><Data ss:Type="String"><xsl:value-of select="ACCOUNT"/></Data><NamedCell

            ss:Name="Untitled"/><NamedCell ss:Name="Print_Area"/></Cell>    

            <Cell ss:StyleID="s65"><Data ss:Type="String"><xsl:value-of select="ancestor::G_ASSET_TYPE/ASSET_TYPE"/></Data><NamedCell

            ss:Name="Untitled"/><NamedCell ss:Name="Print_Area"/></Cell>      

          </Row>

          <xsl:for-each select="./G_ACCOUNT/G_COST_CENTER">   

          <Row ss:AutoFitHeight="0" ss:Height="13.6875">     

            <Cell ss:StyleID="s65"><Data ss:Type="String"><xsl:value-of select="COST_CENTER"/></Data><NamedCell

            ss:Name="Untitled"/><NamedCell ss:Name="Print_Area"/></Cell>

          </Row>       

         </xsl:for-each> 

         </xsl:for-each>

         </xsl:for-each>

        </Table>

        <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">

         <PageSetup>

          <Layout x:Orientation="Landscape"/>

          <PageMargins x:Bottom="0.5" x:Left="0.5" x:Right="0.5" x:Top="0.5"/>

         </PageSetup>

         <Print>

          <ValidPrinterInfo/>

          <HorizontalResolution>600</HorizontalResolution>

          <VerticalResolution>600</VerticalResolution>

          <Gridlines/>

         </Print>

         <Selected/>

         <LeftColumnVisible>4</LeftColumnVisible>

         <FreezePanes/>

         <FrozenNoSplit/>

         <SplitHorizontal>1</SplitHorizontal>

         <TopRowBottomPane>1</TopRowBottomPane>

         <ActivePane>2</ActivePane>

         <Panes>

          <Pane>

           <Number>3</Number>

          </Pane>

          <Pane>

           <Number>2</Number>

           <ActiveRow>39</ActiveRow>

           <ActiveCol>4</ActiveCol>

          </Pane>

         </Panes>

         <ProtectObjects>False</ProtectObjects>

         <ProtectScenarios>False</ProtectScenarios>

        </WorksheetOptions>

        </Worksheet>

      </Workbook>

      </xsl:template>

      </xsl:stylesheet>

       

      Thanks

      Yogi

        • 1. Re: BI Publisher XSL-XML Template - Nested Loops
          Hilton

          Why are you using the ./ positional characters? Maybe try removing them.

          • 2. Re: BI Publisher XSL-XML Template - Nested Loops
            AlexAnd

            try

            <xsl:for-each select=".//G_ASSET_TYPE">

            <xsl:for-each select="./LIST_G_ACCOUNT/G_ACCOUNT">

            <xsl:for-each select="./LIST_G_COST_CENTER/G_COST_CENTER">

            • 3. Re: BI Publisher XSL-XML Template - Nested Loops
              Yogi

              Thank you for your replies.

              I made the following changes in my xsl and it started working.

               

              -------------------------------------------------------------------------------------------------------------------------------------------------------

               

              Before Modification:

               

              <Table ss:ExpandedColumnCount="14" ss:ExpandedRowCount="90" x:FullColumns="1"

                 x:FullRows="1">

               

              AfterModification:

               

              <Table x:FullColumns="1" x:FullRows="1">

               

              -------------------------------------------------------------------------------------------------------------------------------------------------------

               

               

              Header:


              ----------------------------------------------------------------------------------------------------------------------------------------------------------


              <?xml version = '1.0' encoding = 'utf-8'?>

              <xsl:stylesheet version="1.0" xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:user="urn:my-scripts" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet">

                <xsl:output method="xml" encoding="UTF-8" indent="yes" media-type="application/vnd.ms-excel"/>

                <xsl:template match="/">

                  <Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:html="http://www.w3.org/TR/REC-html40">

               

              --------------------------------------------------------------------------------------------------------------------------------------------------------------

               

              Nested For Loops:


              --------------------------------------------------------------------------------------------------------------------------------------------------------------

               

              <xsl:for-each select=".//G_ASSET_TYPE">

                 

                 <xsl:for-each select=".//G_ACCOUNT">

                  

                 <xsl:for-each select=".//G_COST_CENTER">

                     

                   <xsl:for-each select=".//G_RETIREMENTS">

                     <Row> 

                       <Cell ss:StyleID="s65"><Data ss:Type="String"><xsl:value-of select="ancestor::G_ASSET_TYPE/ASSET_TYPE"/></Data></Cell>

                       <Cell ss:StyleID="s65"><Data ss:Type="String"><xsl:value-of select="ancestor::G_ACCOUNT/ACCOUNT"/></Data></Cell>

                       <Cell ss:StyleID="s65"><Data ss:Type="String"><xsl:value-of select="ancestor::G_COST_CENTER/COST_CENTER"/></Data></Cell>

                       <Cell ss:StyleID="s65"><Data ss:Type="String"><xsl:value-of select="ASSET_NUM_DESC"/></Data></Cell>

                       <Cell ss:StyleID="s65"><Data ss:Type="String"><xsl:value-of select="CF_CATEGORY_NAME"/></Data></Cell>

                       <Cell ss:StyleID="s65"><Data ss:Type="String"><xsl:value-of select="DATE_PLACED_IN_SERVICE"/></Data></Cell>

                       <Cell ss:StyleID="s65"><Data ss:Type="String"><xsl:value-of select="DATE_RETIRED"/></Data></Cell>

                       <Cell ss:StyleID="s65"><Data ss:Type="String"><xsl:value-of select="D_COST"/></Data></Cell>

                       <Cell ss:StyleID="s65"><Data ss:Type="String"><xsl:value-of select="D_PROCEEDS"/></Data></Cell>

                       <Cell ss:StyleID="s65"><Data ss:Type="String"><xsl:value-of select="D_REMOVAL"/></Data></Cell>

                       <Cell ss:StyleID="s65"><Data ss:Type="String"><xsl:value-of select="D_GAIN_LOSS"/></Data></Cell>

                       <Cell ss:StyleID="s65"><Data ss:Type="String"><xsl:value-of select="D_NBV"/></Data></Cell>

                       <Cell ss:StyleID="s65"><Data ss:Type="String"><xsl:value-of select="RET_CODE"/></Data></Cell>        

                       <Cell ss:StyleID="s65"><Data ss:Type="String"><xsl:value-of select="CODE"/></Data></Cell>        

                     </Row>  

                 </xsl:for-each>

                 </xsl:for-each>

                 </xsl:for-each>

                 </xsl:for-each>

               

              ----------------------------------------------------------------------------------------------------------------------------------------------------------------------

               

              Thanks

              Yogi