Solved

How to create XSLT for XML file generated from JDE SOA Web Service

Posted on 2009-05-20
6
1,994 Views
Last Modified: 2013-11-18
Hi experts,

I have the attached XML result returned from JDE SOA web Service and I would like to create an XSLT for it. Would it be possible as there are many things like "ns0:", "ans1:", "env:"...

I'm not familar with XML and XSLT, any expert can give me a hand? Thanks!!
<env:Envelope

  xmlns:env="http://schemas.xmlsoap.org/soap/envelope/"

  xmlns:xsd="http://www.w3.org/2001/XMLSchema"

  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

  xmlns:ns0="http://oracle.e1.bssv.JPF43111/types/">

 <env:Body>

  <ans1:getF4311ResponseElement

    xmlns:ans1="http://oracle.e1.bssv.JPF43111/"

    xsi:type="ns0:F4311_List">

   <ns0:e1MessageList/>

   <ns0:result

     xsi:type="ns0:F4311_Output">

    <ns0:companyKeyOrderNo>00001</ns0:companyKeyOrderNo>

    <ns0:orderType>OH</ns0:orderType>

    <ns0:documentOrderInvoiceE>6255</ns0:documentOrderInvoiceE>

    <ns0:lineNumber>2.000</ns0:lineNumber>

    <ns0:statusCodeLast>225</ns0:statusCodeLast>

    <ns0:costCenter> 19999</ns0:costCenter>

    <ns0:addressNumber>32773</ns0:addressNumber>

    <ns0:itemNumberRelatedKit/>

    <ns0:descriptionLine1>Stationery </ns0:descriptionLine1>

    <ns0:orderSuffix>000</ns0:orderSuffix>

    <ns0:identifier2ndItem>392-00 </ns0:identifier2ndItem>

   </ns0:result>

   <ns0:result

     xsi:type="ns0:F4311_Output">

    <ns0:companyKeyOrderNo>00001</ns0:companyKeyOrderNo>

    <ns0:orderType>OH</ns0:orderType>

    <ns0:documentOrderInvoiceE>6255</ns0:documentOrderInvoiceE>

    <ns0:lineNumber>1.000</ns0:lineNumber>

    <ns0:statusCodeLast>420</ns0:statusCodeLast>

    <ns0:costCenter> 19999</ns0:costCenter>

    <ns0:addressNumber>32773</ns0:addressNumber>

    <ns0:itemNumberRelatedKit/>

    <ns0:descriptionLine1>Stationery </ns0:descriptionLine1>

    <ns0:orderSuffix>000</ns0:orderSuffix>

    <ns0:identifier2ndItem>392-00 </ns0:identifier2ndItem>

   </ns0:result>

   <ns0:result

     xsi:type="ns0:F4311_Output">

    <ns0:companyKeyOrderNo>00001</ns0:companyKeyOrderNo>

    <ns0:orderType>OH</ns0:orderType>

    <ns0:documentOrderInvoiceE>6244</ns0:documentOrderInvoiceE>

    <ns0:lineNumber>1.000</ns0:lineNumber>

    <ns0:statusCodeLast>280</ns0:statusCodeLast>

    <ns0:costCenter> 19999</ns0:costCenter>

    <ns0:addressNumber>32324</ns0:addressNumber>

    <ns0:itemNumberRelatedKit/>

    <ns0:descriptionLine1>Printing </ns0:descriptionLine1>

    <ns0:orderSuffix>000</ns0:orderSuffix>

    <ns0:identifier2ndItem>390-00 </ns0:identifier2ndItem>

   </ns0:result>

  </ans1:getF4311ResponseElement>

 </env:Body>

</env:Envelope>

Open in new window

0
Comment
Question by:kennysflau
  • 3
  • 3
6 Comments
 
LVL 60

Accepted Solution

by:
Geert Bormans earned 500 total points
ID: 24430078
Some tools give you unpredictable prefixes for their namespaces, but you should not worry,
prefixes can be replaced by your own, as you see in this example
<?xml version="1.0" encoding="UTF-8"?>

<xsl:stylesheet 

    xmlns:xsl="http://www.w3.org/1999/XSL/Transform" 

    version="1.0"

    xmlns:env="http://schemas.xmlsoap.org/soap/envelope/"

    xmlns:xsd="http://www.w3.org/2001/XMLSchema"

    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

    xmlns:otyp="http://oracle.e1.bssv.JPF43111/types/"

    xmlns:ans1="http://oracle.e1.bssv.JPF43111/"

    >

    

    <xsl:template match="env:Envelope">

        <html>

            <body>

                <table border="1">

                    <tr>

                        <xsl:for-each select="//otyp:result[1]/*">

                            <th>

                                <xsl:value-of select="local-name()"/>

                            </th>

                        </xsl:for-each>

                    </tr>

                    <xsl:apply-templates select="//otyp:result"></xsl:apply-templates>

                 </table>

            </body>

        </html>

    </xsl:template>

    

    <xsl:template match="otyp:result">

        <tr>

            <xsl:for-each select="*">

                <td>

                    <xsl:value-of select="."/>

                </td>

            </xsl:for-each>

        </tr>

    </xsl:template>

    
 

</xsl:stylesheet>

Open in new window

0
 

Author Comment

by:kennysflau
ID: 24437380
Thanks

Is there any difference between xslt and xsl-fo? So how would it be if this is to present in xsl-fo format?
0
 
LVL 60

Expert Comment

by:Geert Bormans
ID: 24438935
XSL-T is some sort of programming language that allows you to transform XML documents into something else
XSL-FO is a description format for your XML, so that it can be rendered in PDF, eg.

One would typically use XSLT to transform XML into XSL-FO, so that a XSL-FO processor can take that FO and make PDF out of it
Does that make sense to you?

What exactly do you want to achiev from this question? I can transform this XML into XSL-FO, but what do you learn then?
0
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 

Author Comment

by:kennysflau
ID: 24438950
Actually I have an XML and an XSL-FO, but I can't get my PDF/HTML generated unless I remove all those "prefix" in the XML...

I was trying to make an XSL-FO from XSLT but the result is still the same...
<env:Envelope

  xmlns:env="http://schemas.xmlsoap.org/soap/envelope/"

  xmlns:xsd="http://www.w3.org/2001/XMLSchema"

  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

  xmlns:ns0="http://oracle.e1.bssv.JP430000/types/">

 <env:Body>

  <ns0:getPurchaseOrderResponseElement

    xsi:type="ns0:ShowPurchaseOrder">

   <ns0:e1MessageList/>

   <ns0:showPurchaseOrder

     xsi:type="ns0:PurchaseOrder">

    <ns0:header

      xsi:type="ns0:PurchaseOrderShowHeader">

     <ns0:userReservedData

       xsi:type="ns0:UserReservedData">

      <ns0:userReservedCode/>

      <ns0:userReservedNumber>2</ns0:userReservedNumber>

      <ns0:userReservedDate

        xsi:nil="1"/>

      <ns0:userReservedAmount>0</ns0:userReservedAmount>

      <ns0:userReservedReference/>

     </ns0:userReservedData>

     <ns0:numberOfInvoices>0</ns0:numberOfInvoices>

     <ns0:entityIdSupplier>32773</ns0:entityIdSupplier>

     <ns0:printMessageCode/>

     <ns0:adjustmentScheduleCode/>

     <ns0:entityIdMarkfor>0</ns0:entityIdMarkfor>

     <ns0:businessUnit> 19999</ns0:businessUnit>

     <ns0:languageCode/>

     <ns0:container/>

     <ns0:description1/>

     <ns0:purchaseOrderShowKey>

      <ns0:documentNumber>6255</ns0:documentNumber>

      <ns0:documentSuffix>000</ns0:documentSuffix>

      <ns0:documentCompany>00001</ns0:documentCompany>

      <ns0:documentTypeCode>OH</ns0:documentTypeCode>

     </ns0:purchaseOrderShowKey>

     <ns0:unitOfMeasureCodeWeight/>

     <ns0:amountOpen>0</ns0:amountOpen>

     <ns0:holdCode/>

     <ns0:sendMethodCode>1</ns0:sendMethodCode>

     <ns0:taxExplanationCode/>

     <ns0:deliveryInstruction1/>

     <ns0:typeMatch/>

     <ns0:voucherCode>N</ns0:voucherCode>

     <ns0:timePromisedDelivery>0</ns0:timePromisedDelivery>

     <ns0:activityReasonCode/>

     <ns0:dates

       xsi:type="ns0:PurchaseOrderShowDates">

      <ns0:dateTransaction>2009-03-19T00:00:00.000+08:00</ns0:dateTransaction>

      <ns0:dateShipment

        xsi:nil="1"/>

      <ns0:dateScheduledPick>2009-03-19T00:00:00.000+08:00</ns0:dateScheduledPick>

      <ns0:datePromisedShip

        xsi:nil="1"/>

      <ns0:datePromisedOriginal>2009-03-19T00:00:00.000+08:00</ns0:datePromisedOriginal>

      <ns0:datePromisedDelivery

        xsi:nil="1"/>

      <ns0:dateCancel

        xsi:nil="1"/>

      <ns0:datePriceEffective

        xsi:nil="1"/>

      <ns0:dateRequested>2009-03-19T00:00:00.000+08:00</ns0:dateRequested>

     </ns0:dates>

     <ns0:unitOfMeasureCodeVolume/>

     <ns0:freightHandlingCode/>

     <ns0:zoneNumber/>

     <ns0:paymentTermsCode>60A</ns0:paymentTermsCode>

     <ns0:taxExemptCertificate/>

     <ns0:retainageRule/>

     <ns0:percentRetainage>0.000</ns0:percentRetainage>

     <ns0:currencyCodeBase/>

     <ns0:orderTakenBy/>

     <ns0:purgeCode/>

     <ns0:transactionNature/>

     <ns0:taxRateAreaCode/>

     <ns0:currencyModeCode>D</ns0:currencyModeCode>

     <ns0:orderedBy>KENNYLAU </ns0:orderedBy>

     <ns0:timePromisedShip>0</ns0:timePromisedShip>

     <ns0:entityIdBuyer>0</ns0:entityIdBuyer>

     <ns0:statusOrderCode/>

     <ns0:amountGross>223455000.00</ns0:amountGross>

     <ns0:entityIdCarrier>0</ns0:entityIdCarrier>

     <ns0:currencyCodeFrom>HKD</ns0:currencyCodeFrom>

     <ns0:processingModeCode/>

     <ns0:entityIdShipTo>19999</ns0:entityIdShipTo>

     <ns0:detail

       xsi:type="ns0:PurchaseOrderShowDetail">

      <ns0:loadNumber>0</ns0:loadNumber>

      <ns0:userReservedData

        xsi:type="ns0:UserReservedData">

       <ns0:userReservedCode/>

       <ns0:userReservedNumber>0</ns0:userReservedNumber>

       <ns0:userReservedDate

         xsi:nil="1"/>

       <ns0:userReservedAmount>0</ns0:userReservedAmount>

       <ns0:userReservedReference/>

      </ns0:userReservedData>

      <ns0:unitOfMeasureCodeTransaction>NO</ns0:unitOfMeasureCodeTransaction>

      <ns0:timeScheduled>0</ns0:timeScheduled>

      <ns0:taxableCode>Y</ns0:taxableCode>

      <ns0:yearCode>9</ns0:yearCode>

      <ns0:priceExtendedForeign>0</ns0:priceExtendedForeign>

      <ns0:entityIdSupplier>32773</ns0:entityIdSupplier>

      <ns0:printMessageCode/>

      <ns0:purchaseOrderLineKey

        xsi:type="ns0:PurchaseOrderLineKey">

       <ns0:documentLineNumber>1.000</ns0:documentLineNumber>

       <ns0:documentSuffix>000</ns0:documentSuffix>

      </ns0:purchaseOrderLineKey>

      <ns0:statusCodeLast>420</ns0:statusCodeLast>

      <ns0:amountOnHoldDomestic>0</ns0:amountOnHoldDomestic>

      <ns0:landedCostRule/>

      <ns0:subledger

        xsi:type="ns0:Subledger">

       <ns0:subledger/>

       <ns0:subledgerTypeCode/>

      </ns0:subledger>

      <ns0:adjustmentScheduleCode/>

      <ns0:businessUnit> 19999</ns0:businessUnit>

      <ns0:freightRateType/>

      <ns0:container/>

      <ns0:amountRelievedDomestic>0</ns0:amountRelievedDomestic>

      <ns0:categoryCodeWorkOrder/>

      <ns0:description1>Stationery </ns0:description1>

      <ns0:unitOfMeasureCodeWeight>LB</ns0:unitOfMeasureCodeWeight>

      <ns0:location/>

      <ns0:priceCategoryLevel/>

      <ns0:unitOfMeasureCodePurchasing>NO</ns0:unitOfMeasureCodePurchasing>

      <ns0:statusCodeNext>225</ns0:statusCodeNext>

      <ns0:lotNumber/>

      <ns0:statusLocationTaxCode/>

      <ns0:commodityUnmaskedCode>00000000</ns0:commodityUnmaskedCode>

      <ns0:glClassCode>MOS </ns0:glClassCode>

      <ns0:componentLineNumber>0.0</ns0:componentLineNumber>

      <ns0:unitOfMeasureCodeVolume>GA</ns0:unitOfMeasureCodeVolume>

      <ns0:freightHandlingCode/>

      <ns0:zoneNumber/>

      <ns0:paymentTermsCode>60A</ns0:paymentTermsCode>

      <ns0:description2/>

      <ns0:isFreightCalculated>false</ns0:isFreightCalculated>

      <ns0:ruleRetainage/>

      <ns0:reasonCode/>

      <ns0:promotionId/>

      <ns0:componentId>0</ns0:componentId>

      <ns0:commodityClassCode2>UNKNOWN </ns0:commodityClassCode2>

      <ns0:isQuantityPosted

        xsi:nil="1"/>

      <ns0:reportingCodesPurchasing

        xsi:type="ns0:ReportingCodesPurchasing">

       <ns0:purchasingReportCode002/>

       <ns0:purchasingReportCode004/>

       <ns0:purchasingReportCode003/>

       <ns0:purchasingReportCode001>392</ns0:purchasingReportCode001>

      </ns0:reportingCodesPurchasing>

      <ns0:ledgerTypeCode/>

      <ns0:item

        xsi:type="ns0:ItemResponseSupplier">

       <ns0:itemSupplier

         xsi:nil="1"/>

       <ns0:itemProduct>392-00 </ns0:itemProduct>

       <ns0:itemId>11397</ns0:itemId>

       <ns0:itemCatalog>392-00 </ns0:itemCatalog>

      </ns0:item>

      <ns0:isFreightApplied

        xsi:nil="1"/>

      <ns0:transactionNature/>

      <ns0:purgeCode/>

      <ns0:amountTaxForeign>0</ns0:amountTaxForeign>

      <ns0:amountReceivedDomestic>0</ns0:amountReceivedDomestic>

      <ns0:costUnitPurchasingDomestic>1000.0000</ns0:costUnitPurchasingDomestic>

      <ns0:datesDetail

        xsi:type="ns0:PurchaseOrderShowDetailDates">

       <ns0:dateShipment

         xsi:nil="1"/>

       <ns0:dateLotEffective>2009-03-19T00:00:00.000+08:00</ns0:dateLotEffective>

       <ns0:dateScheduledPick>2009-03-19T00:00:00.000+08:00</ns0:dateScheduledPick>

       <ns0:datePromisedDelivery

         xsi:nil="1"/>

       <ns0:dateAccounting>2009-03-19T00:00:00.000+08:00</ns0:dateAccounting>

       <ns0:dateCancel

         xsi:nil="1"/>

       <ns0:dateTransaction>2009-03-19T00:00:00.000+08:00</ns0:dateTransaction>

       <ns0:datePromisedShip

         xsi:nil="1"/>

       <ns0:datePromisedOriginal>2009-03-19T00:00:00.000+08:00</ns0:datePromisedOriginal>

       <ns0:dateChange

         xsi:nil="1"/>

       <ns0:datePriceEffective

         xsi:nil="1"/>

       <ns0:dateRequested>2009-03-19T00:00:00.000+08:00</ns0:dateRequested>

       <ns0:dateServiceTax

         xsi:nil="1"/>

      </ns0:datesDetail>

      <ns0:priceExtendedDomestic>99999000.00</ns0:priceExtendedDomestic>

      <ns0:costUnitPurchasingForeign>0.0000</ns0:costUnitPurchasingForeign>

      <ns0:taxRateAreaCode/>

      <ns0:unitOfMeasureCodePrimary>NO</ns0:unitOfMeasureCodePrimary>

      <ns0:catalogName/>

      <ns0:unitOfMeasureCodeSecondary>NO</ns0:unitOfMeasureCodeSecondary>

      <ns0:overridePriceCode>1</ns0:overridePriceCode>

      <ns0:amountOpenDomestic>99999000.00</ns0:amountOpenDomestic>

      <ns0:discountFactor>0.0000</ns0:discountFactor>

      <ns0:century>20</ns0:century>

      <ns0:entityIdBuyer>0</ns0:entityIdBuyer>

      <ns0:glAccount

        xsi:type="ns0:GLAccount">

       <ns0:businessUnit> 19999</ns0:businessUnit>

       <ns0:objectAccount>139999</ns0:objectAccount>

       <ns0:subsidiary>29999999</ns0:subsidiary>

      </ns0:glAccount>

      <ns0:amountOnHoldForeign>0</ns0:amountOnHoldForeign>

      <ns0:amountReceivedForeign>0</ns0:amountReceivedForeign>

      <ns0:commodityClassCode/>

      <ns0:relatedOrderLineKey

        xsi:type="ns0:RelatedOrderLineKey">

       <ns0:documentNumber/>

       <ns0:documentLineNumber>0.000</ns0:documentLineNumber>

       <ns0:documentSuffix/>

       <ns0:documentCompany/>

       <ns0:documentTypeCode/>

      </ns0:relatedOrderLineKey>

      <ns0:quantity

        xsi:type="ns0:PurchaseOrderShowQuantity">

       <ns0:quantityRelieved>0.000</ns0:quantityRelieved>

       <ns0:quantityOrderedPrimary>99999.000</ns0:quantityOrderedPrimary>

       <ns0:quantityOrdered>99999.000</ns0:quantityOrdered>

       <ns0:quantityOpen>99999.000</ns0:quantityOpen>

       <ns0:quantityChanged>0.000</ns0:quantityChanged>

       <ns0:quantityOrderedSecondary>99999.000</ns0:quantityOrderedSecondary>

       <ns0:quantityReceived>0.000</ns0:quantityReceived>

       <ns0:quantityCumulative>0.000</ns0:quantityCumulative>

      </ns0:quantity>

      <ns0:shippingConditionCode/>

      <ns0:entityIdCarrier>0</ns0:entityIdCarrier>

      <ns0:currencyCodeFrom>HKD</ns0:currencyCodeFrom>

      <ns0:freightRateCode/>

      <ns0:entityIdMarkFor>0</ns0:entityIdMarkFor>

      <ns0:timeChange>0</ns0:timeChange>

      <ns0:orderLineUniqueKey>0</ns0:orderLineUniqueKey>

      <ns0:amountOpenForeign>0</ns0:amountOpenForeign>

      <ns0:entityIdShipTo>19999</ns0:entityIdShipTo>

      <ns0:orderLineStatus>C </ns0:orderLineStatus>

      <ns0:unitVolume>0.0000</ns0:unitVolume>

      <ns0:originalOrderLineKey

        xsi:type="ns0:OriginalOrderLineKey">

       <ns0:documentNumber/>

       <ns0:documentLineNumber>0.000</ns0:documentLineNumber>

       <ns0:documentSuffix/>

       <ns0:documentCompany/>

       <ns0:documentTypeCode/>

      </ns0:originalOrderLineKey>

      <ns0:costMethodPurchasing>0.0000</ns0:costMethodPurchasing>

      <ns0:shiftScheduledCode/>

      <ns0:unitWeight>0.0000</ns0:unitWeight>

      <ns0:lineTypeCode>N </ns0:lineTypeCode>

      <ns0:conditionsOfTransportCode/>

      <ns0:approvedRoutingBy>19999 </ns0:approvedRoutingBy>

      <ns0:serialNumber/>

      <ns0:grossWeight>0.0000</ns0:grossWeight>

      <ns0:reference/>

      <ns0:modeOfTransportCode/>

      <ns0:itemPriceGroupCode/>

     </ns0:detail>

     <ns0:detail

       xsi:type="ns0:PurchaseOrderShowDetail">

      <ns0:loadNumber>0</ns0:loadNumber>

      <ns0:userReservedData

        xsi:type="ns0:UserReservedData">

       <ns0:userReservedCode/>

       <ns0:userReservedNumber>0</ns0:userReservedNumber>

       <ns0:userReservedDate

         xsi:nil="1"/>

       <ns0:userReservedAmount>0</ns0:userReservedAmount>

       <ns0:userReservedReference/>

      </ns0:userReservedData>

      <ns0:unitOfMeasureCodeTransaction>NO</ns0:unitOfMeasureCodeTransaction>

      <ns0:timeScheduled>0</ns0:timeScheduled>

      <ns0:taxableCode>Y</ns0:taxableCode>

      <ns0:yearCode>9</ns0:yearCode>

      <ns0:priceExtendedForeign>0</ns0:priceExtendedForeign>

      <ns0:entityIdSupplier>32773</ns0:entityIdSupplier>

      <ns0:printMessageCode/>

      <ns0:purchaseOrderLineKey

        xsi:type="ns0:PurchaseOrderLineKey">

       <ns0:documentLineNumber>2.000</ns0:documentLineNumber>

       <ns0:documentSuffix>000</ns0:documentSuffix>

      </ns0:purchaseOrderLineKey>

      <ns0:statusCodeLast>225</ns0:statusCodeLast>

      <ns0:amountOnHoldDomestic>0</ns0:amountOnHoldDomestic>

      <ns0:landedCostRule/>

      <ns0:subledger

        xsi:type="ns0:Subledger">

       <ns0:subledger/>

       <ns0:subledgerTypeCode/>

      </ns0:subledger>

      <ns0:adjustmentScheduleCode/>

      <ns0:businessUnit> 19999</ns0:businessUnit>

      <ns0:freightRateType/>

      <ns0:container/>

      <ns0:amountRelievedDomestic>0</ns0:amountRelievedDomestic>

      <ns0:categoryCodeWorkOrder/>

      <ns0:description1>Stationery </ns0:description1>

      <ns0:unitOfMeasureCodeWeight>LB</ns0:unitOfMeasureCodeWeight>

      <ns0:location/>

      <ns0:priceCategoryLevel/>

      <ns0:unitOfMeasureCodePurchasing>NO</ns0:unitOfMeasureCodePurchasing>

      <ns0:statusCodeNext>225</ns0:statusCodeNext>

      <ns0:lotNumber/>

      <ns0:statusLocationTaxCode/>

      <ns0:commodityUnmaskedCode/>

      <ns0:glClassCode>MOS </ns0:glClassCode>

      <ns0:componentLineNumber>0.0</ns0:componentLineNumber>

      <ns0:unitOfMeasureCodeVolume>GA</ns0:unitOfMeasureCodeVolume>

      <ns0:freightHandlingCode/>

      <ns0:zoneNumber/>

      <ns0:paymentTermsCode>60A</ns0:paymentTermsCode>

      <ns0:description2/>

      <ns0:isFreightCalculated>false</ns0:isFreightCalculated>

      <ns0:ruleRetainage/>

      <ns0:reasonCode/>

      <ns0:promotionId/>

      <ns0:componentId>0</ns0:componentId>

      <ns0:commodityClassCode2>UNKNOWN </ns0:commodityClassCode2>

      <ns0:isQuantityPosted

        xsi:nil="1"/>

      <ns0:reportingCodesPurchasing

        xsi:type="ns0:ReportingCodesPurchasing">

       <ns0:purchasingReportCode002/>

       <ns0:purchasingReportCode004/>

       <ns0:purchasingReportCode003/>

       <ns0:purchasingReportCode001>392</ns0:purchasingReportCode001>

      </ns0:reportingCodesPurchasing>

      <ns0:ledgerTypeCode/>

      <ns0:item

        xsi:type="ns0:ItemResponseSupplier">

       <ns0:itemSupplier

         xsi:nil="1"/>

       <ns0:itemProduct>392-00 </ns0:itemProduct>

       <ns0:itemId>11397</ns0:itemId>

       <ns0:itemCatalog>392-00 </ns0:itemCatalog>

      </ns0:item>

      <ns0:isFreightApplied

        xsi:nil="1"/>

      <ns0:transactionNature/>

      <ns0:purgeCode/>

      <ns0:amountTaxForeign>0</ns0:amountTaxForeign>

      <ns0:amountReceivedDomestic>0</ns0:amountReceivedDomestic>

      <ns0:costUnitPurchasingDomestic>1000.0000</ns0:costUnitPurchasingDomestic>

      <ns0:datesDetail

        xsi:type="ns0:PurchaseOrderShowDetailDates">

       <ns0:dateShipment

         xsi:nil="1"/>

       <ns0:dateLotEffective>2009-03-19T00:00:00.000+08:00</ns0:dateLotEffective>

       <ns0:dateScheduledPick>2009-03-19T00:00:00.000+08:00</ns0:dateScheduledPick>

       <ns0:datePromisedDelivery

         xsi:nil="1"/>

       <ns0:dateAccounting>2009-05-07T00:00:00.000+08:00</ns0:dateAccounting>

       <ns0:dateCancel

         xsi:nil="1"/>

       <ns0:dateTransaction>2009-03-19T00:00:00.000+08:00</ns0:dateTransaction>

       <ns0:datePromisedShip

         xsi:nil="1"/>

       <ns0:datePromisedOriginal>2009-03-19T00:00:00.000+08:00</ns0:datePromisedOriginal>

       <ns0:dateChange

         xsi:nil="1"/>

       <ns0:datePriceEffective

         xsi:nil="1"/>

       <ns0:dateRequested>2009-03-19T00:00:00.000+08:00</ns0:dateRequested>

       <ns0:dateServiceTax

         xsi:nil="1"/>

      </ns0:datesDetail>

      <ns0:priceExtendedDomestic>123456000.00</ns0:priceExtendedDomestic>

      <ns0:costUnitPurchasingForeign>0.0000</ns0:costUnitPurchasingForeign>

      <ns0:taxRateAreaCode/>

      <ns0:unitOfMeasureCodePrimary>NO</ns0:unitOfMeasureCodePrimary>

      <ns0:catalogName/>

      <ns0:unitOfMeasureCodeSecondary>NO</ns0:unitOfMeasureCodeSecondary>

      <ns0:overridePriceCode>1</ns0:overridePriceCode>

      <ns0:amountOpenDomestic>123456000.00</ns0:amountOpenDomestic>

      <ns0:discountFactor>0.0000</ns0:discountFactor>

      <ns0:century>20</ns0:century>

      <ns0:entityIdBuyer>0</ns0:entityIdBuyer>

      <ns0:glAccount

        xsi:type="ns0:GLAccount">

       <ns0:businessUnit> 19999</ns0:businessUnit>

       <ns0:objectAccount>139999</ns0:objectAccount>

       <ns0:subsidiary>29999999</ns0:subsidiary>

      </ns0:glAccount>

      <ns0:amountOnHoldForeign>0</ns0:amountOnHoldForeign>

      <ns0:amountReceivedForeign>0</ns0:amountReceivedForeign>

      <ns0:commodityClassCode/>

      <ns0:relatedOrderLineKey

        xsi:type="ns0:RelatedOrderLineKey">

       <ns0:documentNumber/>

       <ns0:documentLineNumber>0.000</ns0:documentLineNumber>

       <ns0:documentSuffix/>

       <ns0:documentCompany/>

       <ns0:documentTypeCode/>

      </ns0:relatedOrderLineKey>

      <ns0:quantity

        xsi:type="ns0:PurchaseOrderShowQuantity">

       <ns0:quantityRelieved>0.000</ns0:quantityRelieved>

       <ns0:quantityOrderedPrimary>123456.000</ns0:quantityOrderedPrimary>

       <ns0:quantityOrdered>123456.000</ns0:quantityOrdered>

       <ns0:quantityOpen>123456.000</ns0:quantityOpen>

       <ns0:quantityChanged>0.000</ns0:quantityChanged>

       <ns0:quantityOrderedSecondary>123456.000</ns0:quantityOrderedSecondary>

       <ns0:quantityReceived>0.000</ns0:quantityReceived>

       <ns0:quantityCumulative>0.000</ns0:quantityCumulative>

      </ns0:quantity>

      <ns0:shippingConditionCode/>

      <ns0:entityIdCarrier>0</ns0:entityIdCarrier>

      <ns0:currencyCodeFrom>HKD</ns0:currencyCodeFrom>

      <ns0:freightRateCode/>

      <ns0:entityIdMarkFor>0</ns0:entityIdMarkFor>

      <ns0:timeChange>0</ns0:timeChange>

      <ns0:orderLineUniqueKey>0</ns0:orderLineUniqueKey>

      <ns0:amountOpenForeign>0</ns0:amountOpenForeign>

      <ns0:entityIdShipTo>19999</ns0:entityIdShipTo>

      <ns0:orderLineStatus/>

      <ns0:unitVolume>0.0000</ns0:unitVolume>

      <ns0:originalOrderLineKey

        xsi:type="ns0:OriginalOrderLineKey">

       <ns0:documentNumber/>

       <ns0:documentLineNumber>0.000</ns0:documentLineNumber>

       <ns0:documentSuffix/>

       <ns0:documentCompany/>

       <ns0:documentTypeCode/>

      </ns0:originalOrderLineKey>

      <ns0:costMethodPurchasing>0.0000</ns0:costMethodPurchasing>

      <ns0:shiftScheduledCode/>

      <ns0:unitWeight>0.0000</ns0:unitWeight>

      <ns0:lineTypeCode>N </ns0:lineTypeCode>

      <ns0:conditionsOfTransportCode/>

      <ns0:approvedRoutingBy>19999 </ns0:approvedRoutingBy>

      <ns0:serialNumber/>

      <ns0:grossWeight>0.0000</ns0:grossWeight>

      <ns0:reference/>

      <ns0:modeOfTransportCode/>

      <ns0:itemPriceGroupCode/>

     </ns0:detail>

     <ns0:nameRemark/>

     <ns0:rateExchangeOverride>0</ns0:rateExchangeOverride>

     <ns0:deliveryInstruction2/>

     <ns0:logicControl/>

     <ns0:conditionsOfTransportCode/>

     <ns0:approvedRoutingBy>19999 </ns0:approvedRoutingBy>

     <ns0:itemPriceGroupCode/>

     <ns0:modeOfTransportCode/>

    </ns0:header>

   </ns0:showPurchaseOrder>

  </ns0:getPurchaseOrderResponseElement>

 </env:Body>

</env:Envelope>

Open in new window

0
 

Author Comment

by:kennysflau
ID: 24438953

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

<!--Generated by Oracle BI Publisher 10.1.3.4.0-->

<xsl:stylesheet version="2.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:fo="http://www.w3.org/1999/XSL/Format" xmlns:ora="http://www.oracle.com/XSL/Transform/java/" xmlns:xdofo="http://xmlns.oracle.com/oxp/fo/extensions" xmlns:xdoxslt="http://www.oracle.com/XSL/Transform/java/oracle.apps.xdo.template.rtf.XSLTFunctions" xmlns:xdoxliff="urn:oasis:names:tc:xliff:document:1.1" xmlns:xlink="http://www.w3.org/1999/xlink">

   <xsl:param name="_XDOCALENDAR">GREGORIAN</xsl:param>

   <xsl:param name="_XDOLOCALE">en-US</xsl:param>

   <xsl:param name="_XDOTIMEZONE">GMT</xsl:param>

   <xsl:param name="_XDODFOVERRIDE">;</xsl:param>

   <xsl:param name="_XDOCURMASKS">;</xsl:param>

   <xsl:param name="_XDONFSEPARATORS"></xsl:param>

   <xsl:param name="_XDOCHARTTYPE">image/svg+xml</xsl:param>

   <xsl:param name="_XDOOUTPUTFORMAT">application/pdf</xsl:param>

   <xsl:param name="_XDOSVGFONTEMBED">true</xsl:param>

   <xsl:param name="_XDOCTX">#</xsl:param>

   <xsl:variable name="_XDOXSLTCTX" select="xdoxslt:set_xslt_locale($_XDOCTX, $_XDOLOCALE, $_XDOTIMEZONE, $_XDOCALENDAR, concat($_XDODFOVERRIDE,'',$_XDOCURMASKS,'',$_XDONFSEPARATORS))"/>

   <xsl:variable name="_XDOFOPOS" select="''"/>

   <xsl:variable name="_XDOFOPOS2" select="number(1)"/>

   <xsl:variable name="_XDOFOTOTAL" select="number(1)"/>

   <xsl:variable name="_XDOFOOSTOTAL" select="number(0)"/>

   <xsl:template match="/">

      <fo:root>

         <fo:layout-master-set>

            <fo:simple-page-master master-name="master0" margin-left="84.6pt" margin-right="84.6pt" page-height="792.0pt" page-width="612.0pt" margin-top="36.0pt" margin-bottom="36.0pt">

               <fo:region-before region-name="region-header" extent="36.0pt"/>

               <fo:region-body region-name="region-body" margin-top="36.0pt" margin-bottom="36.0pt"/>

               <fo:region-after region-name="region-footer" extent="36.0pt" display-align="after"/>

            </fo:simple-page-master>

         </fo:layout-master-set>

         <fo:page-sequence master-reference="master0">

            <fo:title>RTF Template</fo:title>

            <xsl:variable name="_PW" select="number(612.0)" xdofo:alt="internal"/>

            <xsl:variable name="_PH" select="number(792.0)" xdofo:alt="internal"/>

            <xsl:variable name="_ML" select="number(90.0)" xdofo:alt="internal"/>

            <xsl:variable name="_MR" select="number(90.0)" xdofo:alt="internal"/>

            <xsl:variable name="_MT" select="number(72.0)" xdofo:alt="internal"/>

            <xsl:variable name="_MB" select="number(72.0)" xdofo:alt="internal"/>

            <xsl:variable name="_HY" select="number(36.0)" xdofo:alt="internal"/>

            <xsl:variable name="_FY" select="number(36.0)" xdofo:alt="internal"/>

            <xsl:variable name="_SECTION_NAME" select="string('master0')" xdofo:alt="internal"/>

            <fo:static-content flow-name="region-header"/>

            <fo:static-content flow-name="region-footer"/>

            <fo:flow flow-name="region-body">

               <fo:block orphans="2" widows="2" linefeed-treatment="preserve" start-indent="5.4pt" text-align="start" padding-bottom="0.0pt" end-indent="5.4pt" padding-top="0.0pt" font-family="Times New Roman" font-size="12.0pt" height="13.392pt"/>

               <fo:block orphans="2" widows="2" linefeed-treatment="preserve" start-indent="5.4pt" text-align="start" padding-bottom="0.0pt" end-indent="5.4pt" padding-top="0.0pt" font-family="Times New Roman" font-size="12.0pt" height="13.392pt"/>

               <fo:block xdofo:header-level="1" orphans="2" widows="2" linefeed-treatment="preserve" start-indent="5.4pt" text-align="start" padding-bottom="0.0pt" end-indent="5.4pt" padding-top="0.0pt" height="0.0pt" keep-with-next.within-page="always">

                  <fo:inline font-weight="bold" color="#ff0000" font-size="16.0pt" height="18.448pt" white-space-collapse="false" text-decoration="underline" font-family="Times New Roman">Header Information</fo:inline>

               </fo:block>

               <fo:block orphans="2" widows="2" linefeed-treatment="preserve" start-indent="5.4pt" text-align="start" padding-bottom="0.0pt" end-indent="5.4pt" padding-top="0.0pt" font-family="Times New Roman" font-size="12.0pt" height="13.392pt"/>

               <fo:block xdofo:xliff-note="6500" orphans="2" widows="2" linefeed-treatment="preserve" start-indent="5.4pt" text-align="start" padding-bottom="0.0pt" end-indent="5.4pt" padding-top="0.0pt" height="0pt">

                  <fo:inline height="13.392pt" font-family="Times New Roman" white-space-collapse="false" font-size="12.0pt">BPO Number:</fo:inline>

                  <xdofo:tab font-size="12.0pt" font-family="Times New Roman"/>

                  <xdofo:tab font-size="12.0pt" font-family="Times New Roman"/>

                  <fo:inline height="13.392pt" font-family="Times New Roman" white-space-collapse="false" font-size="12.0pt">

                     <xsl:variable xdofo:ctx="17" xdofo:ctx2="wrapper" name="fv1">

                        <xsl:value-of select=".//documentNumber" xdofo:field-name="documentNumber"/>

                     </xsl:variable>

                     <xsl:value-of select="xdoxslt:ms_format_number($_XDOXSLTCTX, $fv1, '0')"/>

                  </fo:inline>

               </fo:block>

               <fo:block xdofo:xliff-note="00001" orphans="2" widows="2" linefeed-treatment="preserve" start-indent="5.4pt" text-align="start" padding-bottom="0.0pt" end-indent="5.4pt" padding-top="0.0pt" height="0.0pt">

                  <fo:inline xml:space="preserve" height="13.392pt" font-family="Times New Roman" white-space-collapse="false" font-size="12.0pt">BPO Company: </fo:inline>

                  <xdofo:tab font-size="12.0pt" font-family="Times New Roman"/>

                  <fo:inline height="13.392pt" font-family="Times New Roman" white-space-collapse="false" font-size="12.0pt">

                     <xsl:value-of select=".//documentCompany" xdofo:field-name="documentCompany"/>

                  </fo:inline>

               </fo:block>

               <fo:block xdofo:xliff-note="OB" orphans="2" widows="2" linefeed-treatment="preserve" start-indent="5.4pt" text-align="start" padding-bottom="0.0pt" end-indent="5.4pt" padding-top="0.0pt" height="0.0pt">

                  <fo:inline height="13.392pt" font-family="Times New Roman" white-space-collapse="false" font-size="12.0pt">BPO Type:</fo:inline>

                  <xdofo:tab font-size="12.0pt" font-family="Times New Roman"/>

                  <xdofo:tab font-size="12.0pt" font-family="Times New Roman"/>

                  <fo:inline height="13.392pt" font-family="Times New Roman" white-space-collapse="false" font-size="12.0pt">

                     <xsl:value-of select=".//documentTypeCode" xdofo:field-name="documentTypeCode"/>

                  </fo:inline>

               </fo:block>

               <fo:block orphans="2" widows="2" linefeed-treatment="preserve" start-indent="5.4pt" text-align="start" padding-bottom="0.0pt" end-indent="5.4pt" padding-top="0.0pt" font-family="Times New Roman" font-size="12.0pt" height="13.392pt"/>

               <fo:block orphans="2" widows="2" linefeed-treatment="preserve" start-indent="5.4pt" text-align="start" padding-bottom="0.0pt" end-indent="5.4pt" padding-top="0.0pt" font-family="Times New Roman" font-size="12.0pt" height="13.392pt"/>

               <fo:block xdofo:xliff-note="999.99" orphans="2" widows="2" linefeed-treatment="preserve" start-indent="5.4pt" text-align="start" padding-bottom="0.0pt" end-indent="5.4pt" padding-top="0.0pt" height="0pt">

                  <fo:inline height="13.392pt" font-family="Times New Roman" white-space-collapse="false" font-size="12.0pt">Amount Open:</fo:inline>

                  <xdofo:tab font-size="12.0pt" font-family="Times New Roman"/>

                  <xdofo:tab font-size="12.0pt" font-family="Times New Roman"/>

                  <fo:inline height="13.392pt" font-family="Times New Roman" white-space-collapse="false" font-size="12.0pt">

                     <xsl:variable xdofo:ctx="17" xdofo:ctx2="wrapper" name="fv2">

                        <xsl:value-of select=".//amountOpen" xdofo:field-name="amountOpen"/>

                     </xsl:variable>

                     <xsl:value-of select="xdoxslt:ms_format_number($_XDOXSLTCTX, $fv2, '#,##0.00')"/>

                  </fo:inline>

               </fo:block>

               <fo:block xdofo:xliff-note="32773" orphans="2" widows="2" linefeed-treatment="preserve" start-indent="5.4pt" text-align="start" padding-bottom="0.0pt" end-indent="5.4pt" padding-top="0.0pt" height="0pt">

                  <fo:inline height="13.392pt" font-family="Times New Roman" white-space-collapse="false" font-size="12.0pt">Vendor Code:</fo:inline>

                  <xdofo:tab font-size="12.0pt" font-family="Times New Roman"/>

                  <xdofo:tab font-size="12.0pt" font-family="Times New Roman"/>

                  <fo:inline height="13.392pt" font-family="Times New Roman" white-space-collapse="false" font-size="12.0pt">

                     <xsl:variable xdofo:ctx="17" xdofo:ctx2="wrapper" name="fv3">

                        <xsl:value-of select=".//voucherCode" xdofo:field-name="voucherCode"/>

                     </xsl:variable>

                     <xsl:value-of select="xdoxslt:ms_format_number($_XDOXSLTCTX, $fv3, '0')"/>

                  </fo:inline>

               </fo:block>

               <fo:block xdofo:xliff-note="60A" orphans="2" widows="2" linefeed-treatment="preserve" start-indent="5.4pt" text-align="start" padding-bottom="0.0pt" end-indent="5.4pt" padding-top="0.0pt" height="0.0pt">

                  <fo:inline height="13.392pt" font-family="Times New Roman" white-space-collapse="false" font-size="12.0pt">Payment Term:</fo:inline>

                  <xdofo:tab font-size="12.0pt" font-family="Times New Roman"/>

                  <fo:inline height="13.392pt" font-family="Times New Roman" white-space-collapse="false" font-size="12.0pt">

                     <xsl:value-of select=".//paymentTermsCode" xdofo:field-name="paymentTermsCode"/>

                  </fo:inline>

               </fo:block>

               <fo:block xdofo:xliff-note="HKD" orphans="2" widows="2" linefeed-treatment="preserve" start-indent="5.4pt" text-align="start" padding-bottom="0.0pt" end-indent="5.4pt" padding-top="0.0pt" height="0.0pt">

                  <fo:inline height="13.392pt" font-family="Times New Roman" white-space-collapse="false" font-size="12.0pt">Currency:</fo:inline>

                  <xdofo:tab font-size="12.0pt" font-family="Times New Roman"/>

                  <xdofo:tab font-size="12.0pt" font-family="Times New Roman"/>

                  <fo:inline height="13.392pt" font-family="Times New Roman" white-space-collapse="false" font-size="12.0pt">

                     <xsl:value-of select=".//currencyCodeFrom" xdofo:field-name="currencyCodeFrom"/>

                  </fo:inline>

               </fo:block>

               <fo:block orphans="2" widows="2" linefeed-treatment="preserve" start-indent="5.4pt" text-align="start" padding-bottom="0.0pt" end-indent="5.4pt" padding-top="0.0pt" font-family="Times New Roman" font-size="12.0pt" height="13.392pt"/>

               <fo:block xdofo:xliff-note="Lucy Wang" orphans="2" widows="2" linefeed-treatment="preserve" start-indent="5.4pt" text-align="start" padding-bottom="0.0pt" end-indent="5.4pt" padding-top="0.0pt" height="0.0pt">

                  <fo:inline height="13.392pt" font-family="Times New Roman" white-space-collapse="false" font-size="12.0pt">Order By:</fo:inline>

                  <xdofo:tab font-size="12.0pt" font-family="Times New Roman"/>

                  <xdofo:tab font-size="12.0pt" font-family="Times New Roman"/>

                  <fo:inline height="13.392pt" font-family="Times New Roman" white-space-collapse="false" font-size="12.0pt">

                     <xsl:value-of select=".//orderedBy" xdofo:field-name="orderedBy"/>

                  </fo:inline>

               </fo:block>

               <fo:block orphans="2" widows="2" linefeed-treatment="preserve" start-indent="5.4pt" text-align="start" padding-bottom="0.0pt" end-indent="5.4pt" padding-top="0.0pt" font-family="Times New Roman" font-size="12.0pt" height="13.392pt"/>

               <fo:block orphans="2" widows="2" linefeed-treatment="preserve" start-indent="5.4pt" text-align="start" padding-bottom="0.0pt" end-indent="5.4pt" padding-top="0.0pt" font-family="Times New Roman" font-size="12.0pt" height="13.392pt"/>

               <fo:block xdofo:header-level="1" orphans="2" widows="2" linefeed-treatment="preserve" start-indent="5.4pt" text-align="start" padding-bottom="0.0pt" end-indent="5.4pt" padding-top="0.0pt" height="0.0pt" keep-with-next.within-page="always">

                  <fo:inline font-weight="bold" color="#ff0000" font-size="16.0pt" height="18.448pt" white-space-collapse="false" text-decoration="underline" font-family="Times New Roman">Detail Information</fo:inline>

               </fo:block>

               <fo:block orphans="2" widows="2" linefeed-treatment="preserve" start-indent="5.4pt" text-align="start" padding-bottom="0.0pt" end-indent="5.4pt" padding-top="0.0pt" font-family="Times New Roman" font-size="12.0pt" height="13.392pt"/>

               <fo:block orphans="2" widows="2" linefeed-treatment="preserve" start-indent="5.4pt" text-align="start" padding-bottom="0.0pt" end-indent="5.4pt" padding-top="0.0pt" font-family="Times New Roman" font-size="12.0pt" height="13.392pt"/>

               <fo:block padding-bottom="0.25pt" text-align="start" orphans="2" widows="2" padding-top="0.25pt" end-indent="5.4pt" linefeed-treatment="preserve">

                  <fo:table start-indent="0.0pt" style-id="ts-1" xdofo:table-summary="Template Table 1" xdofo:row-header-count="0">

                     <xsl:variable name="_XDOFOPOS2" select="number(1)"/>

                     <xsl:variable name="_XDOFOTOTAL" select="number(1)"/>

                     <fo:table-column column-width="110.7pt"/>

                     <fo:table-column column-width="110.7pt"/>

                     <fo:table-column column-width="110.7pt"/>

                     <fo:table-column column-width="110.7pt"/>

                     <fo:table-header>

                        <fo:table-row keep-with-next="always">

                           <fo:table-cell padding-start="5.15pt" vertical-align="top" border-bottom="0.5pt solid #000000" border-end-color="#000000" padding-top="0.0pt" border-end-style="solid" border-start-color="#000000" padding-end="5.15pt" number-columns-spanned="1" border-top="0.5pt solid #000000" border-start-style="solid" height="0.0pt" border-end-width="0.5pt" padding-bottom="0.0pt" border-start-width="0.5pt" background-color="#e7f3fd">

                              <fo:block orphans="2" widows="2" linefeed-treatment="preserve" start-indent="0.0pt" text-align="start" padding-bottom="0.0pt" end-indent="0.0pt" padding-top="0.0pt">

                                 <fo:inline height="12.0pt" font-family="Times New Roman" white-space-collapse="false" font-size="12.0pt" font-weight="bold">Line Number</fo:inline>

                              </fo:block>

                           </fo:table-cell>

                           <fo:table-cell padding-start="5.15pt" vertical-align="top" border-bottom="0.5pt solid #000000" border-end-color="#000000" padding-top="0.0pt" border-end-style="solid" border-start-color="#000000" padding-end="5.15pt" number-columns-spanned="1" border-top="0.5pt solid #000000" border-start-style="solid" height="0.0pt" border-end-width="0.5pt" padding-bottom="0.0pt" border-start-width="0.5pt" background-color="#e7f3fd">

                              <fo:block orphans="2" widows="2" linefeed-treatment="preserve" start-indent="0.0pt" text-align="start" padding-bottom="0.0pt" end-indent="0.0pt" padding-top="0.0pt">

                                 <fo:inline height="12.0pt" font-family="Times New Roman" white-space-collapse="false" font-size="12.0pt" font-weight="bold">Item Descr</fo:inline>

                              </fo:block>

                           </fo:table-cell>

                           <fo:table-cell padding-start="5.15pt" vertical-align="top" border-bottom="0.5pt solid #000000" border-end-color="#000000" padding-top="0.0pt" border-end-style="solid" border-start-color="#000000" padding-end="5.15pt" number-columns-spanned="1" border-top="0.5pt solid #000000" border-start-style="solid" height="0.0pt" border-end-width="0.5pt" padding-bottom="0.0pt" border-start-width="0.5pt" background-color="#e7f3fd">

                              <fo:block orphans="2" widows="2" linefeed-treatment="preserve" start-indent="0.0pt" text-align="start" padding-bottom="0.0pt" end-indent="0.0pt" padding-top="0.0pt">

                                 <fo:inline height="12.0pt" font-family="Times New Roman" white-space-collapse="false" font-size="12.0pt" font-weight="bold">Unit Price</fo:inline>

                              </fo:block>

                           </fo:table-cell>

                           <fo:table-cell padding-start="5.15pt" vertical-align="top" border-bottom="0.5pt solid #000000" border-end-color="#000000" padding-top="0.0pt" border-end-style="solid" border-start-color="#000000" padding-end="5.15pt" number-columns-spanned="1" border-top="0.5pt solid #000000" border-start-style="solid" height="0.0pt" border-end-width="0.5pt" padding-bottom="0.0pt" border-start-width="0.5pt" background-color="#e7f3fd">

                              <fo:block orphans="2" widows="2" linefeed-treatment="preserve" start-indent="0.0pt" text-align="start" padding-bottom="0.0pt" end-indent="0.0pt" padding-top="0.0pt">

                                 <fo:inline height="12.0pt" font-family="Times New Roman" white-space-collapse="false" font-size="12.0pt" font-weight="bold">Quantity Open</fo:inline>

                              </fo:block>

                           </fo:table-cell>

                        </fo:table-row>

                     </fo:table-header>

                     <fo:table-body>

                        <xsl:variable name="_XDOFOOSTOTAL" select="(number(concat('0', $_XDOFOPOS2)) - 1) * number(concat('0', $_XDOFOTOTAL))"/>

                        <xsl:variable name="_XDOFOTOTAL" select="count(.//detail)"/>

                        <xsl:for-each select=".//detail" xdofo:ctx="3">

                           <xsl:variable name="_XDOFOPOS" select="concat($_XDOFOPOS, '_', position())"/>

                           <xsl:variable name="_XDOFOPOS2" select="number(concat('0', $_XDOFOOSTOTAL)) + position()"/>

                           <fo:table-row xdofo:repeat="R">

                              <fo:table-cell padding-start="5.15pt" vertical-align="top" border-bottom="0.5pt solid #000000" border-end-color="#000000" padding-top="0.0pt" border-end-style="solid" border-start-color="#000000" padding-end="5.15pt" number-columns-spanned="1" border-top="0.5pt solid #000000" border-start-style="solid" height="0.0pt" border-end-width="0.5pt" padding-bottom="0.0pt" border-start-width="0.5pt">

                                 <fo:block xdofo:xliff-note="F , 1.000" orphans="2" widows="2" linefeed-treatment="preserve" start-indent="0.0pt" text-align="start" padding-bottom="0.0pt" end-indent="0.0pt" padding-top="0.0pt" height="0pt">

                                    <fo:inline height="12.0pt" font-family="Times New Roman" white-space-collapse="false" font-size="12.0pt">

                                       <xsl:variable xdofo:ctx="17" xdofo:ctx2="wrapper" name="fv4">

                                          <xsl:value-of select=".//documentLineNumber" xdofo:field-name="documentLineNumber"/>

                                       </xsl:variable>

                                       <xsl:value-of select="xdoxslt:ms_format_number($_XDOXSLTCTX, $fv4, '0.000')"/>

                                    </fo:inline>

                                 </fo:block>

                              </fo:table-cell>

                              <fo:table-cell padding-start="5.15pt" vertical-align="top" border-bottom="0.5pt solid #000000" border-end-color="#000000" padding-top="0.0pt" border-end-style="solid" border-start-color="#000000" padding-end="5.15pt" number-columns-spanned="1" border-top="0.5pt solid #000000" border-start-style="solid" height="0.0pt" border-end-width="0.5pt" padding-bottom="0.0pt" border-start-width="0.5pt">

                                 <fo:block xdofo:xliff-note="Computer" orphans="2" widows="2" linefeed-treatment="preserve" start-indent="0.0pt" text-align="start" padding-bottom="0.0pt" end-indent="0.0pt" padding-top="0.0pt" height="0.0pt">

                                    <fo:inline height="12.0pt" font-family="Times New Roman" white-space-collapse="false" font-size="12.0pt">

                                       <xsl:value-of select=".//description1" xdofo:field-name="description1"/>

                                    </fo:inline>

                                 </fo:block>

                              </fo:table-cell>

                              <fo:table-cell padding-start="5.15pt" vertical-align="top" border-bottom="0.5pt solid #000000" border-end-color="#000000" padding-top="0.0pt" border-end-style="solid" border-start-color="#000000" padding-end="5.15pt" number-columns-spanned="1" border-top="0.5pt solid #000000" border-start-style="solid" height="0.0pt" border-end-width="0.5pt" padding-bottom="0.0pt" border-start-width="0.5pt">

                                 <fo:block xdofo:xliff-note="99.99" orphans="2" widows="2" linefeed-treatment="preserve" start-indent="0.0pt" text-align="start" padding-bottom="0.0pt" end-indent="0.0pt" padding-top="0.0pt" height="0pt">

                                    <fo:inline height="12.0pt" font-family="Times New Roman" white-space-collapse="false" font-size="12.0pt">

                                       <xsl:variable xdofo:ctx="17" xdofo:ctx2="wrapper" name="fv5">

                                          <xsl:value-of select=".//priceExtendedDomestic" xdofo:field-name="priceExtendedDomestic"/>

                                       </xsl:variable>

                                       <xsl:value-of select="xdoxslt:ms_format_number($_XDOXSLTCTX, $fv5, '#,##0.00')"/>

                                    </fo:inline>

                                 </fo:block>

                              </fo:table-cell>

                              <fo:table-cell padding-start="5.15pt" vertical-align="top" border-bottom="0.5pt solid #000000" border-end-color="#000000" padding-top="0.0pt" border-end-style="solid" border-start-color="#000000" padding-end="5.15pt" number-columns-spanned="1" border-top="0.5pt solid #000000" border-start-style="solid" height="0.0pt" border-end-width="0.5pt" padding-bottom="0.0pt" border-start-width="0.5pt">

                                 <fo:block xdofo:xliff-note="999.99,  E" orphans="2" widows="2" linefeed-treatment="preserve" start-indent="0.0pt" text-align="start" padding-bottom="0.0pt" end-indent="0.0pt" padding-top="0.0pt" height="0pt">

                                    <fo:inline height="12.0pt" font-family="Times New Roman" white-space-collapse="false" font-size="12.0pt" color="#000080">

                                       <xsl:variable xdofo:ctx="17" xdofo:ctx2="wrapper" name="fv6">

                                          <xsl:value-of select=".//quantityOpen" xdofo:field-name="quantityOpen"/>

                                       </xsl:variable>

                                       <xsl:value-of select="xdoxslt:ms_format_number($_XDOXSLTCTX, $fv6, '#,##0.00')"/>

                                    </fo:inline>

                                 </fo:block>

                              </fo:table-cell>

                           </fo:table-row>

                        </xsl:for-each>

                     </fo:table-body>

                  </fo:table>

               </fo:block>

               <fo:block orphans="2" widows="2" linefeed-treatment="preserve" start-indent="5.4pt" text-align="start" padding-bottom="0.0pt" end-indent="5.4pt" padding-top="0.0pt" font-family="Times New Roman" font-size="12.0pt" height="13.392pt"/>

               <fo:block orphans="2" widows="2" linefeed-treatment="preserve" start-indent="5.4pt" text-align="start" padding-bottom="0.0pt" end-indent="5.4pt" padding-top="0.0pt" font-family="Times New Roman" font-size="12.0pt" height="13.392pt"/>

               <fo:block orphans="2" widows="2" linefeed-treatment="preserve" start-indent="5.4pt" text-align="start" padding-bottom="0.0pt" end-indent="5.4pt" padding-top="0.0pt" font-family="Times New Roman" font-size="12.0pt" height="13.392pt"/>

               <fo:block orphans="2" widows="2" linefeed-treatment="preserve" start-indent="5.4pt" text-align="start" padding-bottom="0.0pt" end-indent="5.4pt" padding-top="0.0pt" font-family="Times New Roman" font-size="12.0pt" height="13.392pt"/>

               <fo:block orphans="2" widows="2" linefeed-treatment="preserve" start-indent="5.4pt" text-align="start" padding-bottom="0.0pt" end-indent="5.4pt" padding-top="0.0pt" font-family="Times New Roman" font-size="12.0pt" height="13.392pt"/>

               <fo:block orphans="2" widows="2" linefeed-treatment="preserve" start-indent="5.4pt" text-align="start" padding-bottom="0.0pt" end-indent="5.4pt" padding-top="0.0pt" font-family="Times New Roman" font-size="12.0pt" height="13.392pt"/>

               <fo:block orphans="2" widows="2" linefeed-treatment="preserve" start-indent="5.4pt" text-align="start" padding-bottom="0.0pt" end-indent="5.4pt" padding-top="0.0pt" font-family="Times New Roman" font-size="12.0pt" height="13.392pt">

                  <fo:inline id="{concat('page-total-', $_SECTION_NAME, $_XDOFOPOS)}"/>

                  <fo:inline id="{concat('page-total', $_XDOFOPOS)}"/>

               </fo:block>

            </fo:flow>

         </fo:page-sequence>

      </fo:root>

   </xsl:template>

</xsl:stylesheet>

Open in new window

0
 
LVL 60

Expert Comment

by:Geert Bormans
ID: 24439430
I am looking at this in your other question,
you should not duplicate questions.
I consider the original question here answered "how to deal with prefixes", well, I showed you how.
I will continue this particular problem in your other question
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

I found this questions asking how to do this in many different forums, so I will describe here how to implement a solution using PHP and AJAX. The logical flow for the problem should be: Write an event handler for the first drop down box to get …
Note: You must have administrative privileges in order to create/edit Sharing Rules. Salesforce.com (http://www.salesforce.com) (SFDC) is a cloud-based customer relationship management (CRM) system. It is a database most commonly used by sales an…
Viewers will learn about the regular for loop in Java and how to use it. Definition: Break the for loop down into 3 parts: Syntax when using for loops: Example using a for loop:
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

706 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now