Solved

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

Posted on 2009-05-20
6
2,016 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

 

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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
Read about achieving the basic levels of HRIS security in the workplace.
The viewer will learn how to count occurrences of each item in an array.
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

738 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