Solved

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

Posted on 2009-05-20
6
1,996 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
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

 

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Getting attribute Values using xslt 4 41
Single ERP VS muttiple Application or Systems 6 64
JQuery tracking event. 3 57
Fixing Non-Standard characters in text 8 93
Preface This is the third article about the EE Collaborative Login Project. A Better Website Login System (http://www.experts-exchange.com/A_2902.html) introduces the Login System and shows how to implement a login page. The EE Collaborative Logi…
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
The viewer will learn the benefit of using external CSS files and the relationship between class and ID selectors. Create your external css file by saving it as style.css then set up your style tags: (CODE) Reference the nav tag and set your prop…
The viewer will the learn the benefit of plain text editors and code an HTML5 based template for use in further tutorials.

863 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

22 Experts available now in Live!

Get 1:1 Help Now