Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2009-05-20
6
Medium Priority
?
2,038 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 2000 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 

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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Salesforce.com is a cloud-based customer relationship management (CRM) system. In this article, you will learn how to add and map custom lead and contact fields to your Salesforce instance.
"Disruption" is the most feared word for C-level executives these days. They agonize over their industry being disturbed by another player - most likely by startups.
Viewers will learn about the regular for loop in Java and how to use it. Definition: Break the for loop down into 3 parts: Syntax when using for loops: Example using a for loop:
The viewer will receive an overview of the basics of CSS showing inline styles. In the head tags set up your style tags: (CODE) Reference the nav tag and set your properties.: (CODE) Set the reference for the UL element and styles for it to ensu…
Suggested Courses

963 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