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
Solved

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

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

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

I'm not familar with XML and XSLT, any expert can give me a hand? Thanks!!
<env:Envelope
  xmlns:env="http://schemas.xmlsoap.org/soap/envelope/"
  xmlns:xsd="http://www.w3.org/2001/XMLSchema"
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xmlns:ns0="http://oracle.e1.bssv.JPF43111/types/">
 <env:Body>
  <ans1:getF4311ResponseElement
    xmlns:ans1="http://oracle.e1.bssv.JPF43111/"
    xsi:type="ns0:F4311_List">
   <ns0:e1MessageList/>
   <ns0:result
     xsi:type="ns0:F4311_Output">
    <ns0:companyKeyOrderNo>00001</ns0:companyKeyOrderNo>
    <ns0:orderType>OH</ns0:orderType>
    <ns0:documentOrderInvoiceE>6255</ns0:documentOrderInvoiceE>
    <ns0:lineNumber>2.000</ns0:lineNumber>
    <ns0:statusCodeLast>225</ns0:statusCodeLast>
    <ns0:costCenter> 19999</ns0:costCenter>
    <ns0:addressNumber>32773</ns0:addressNumber>
    <ns0:itemNumberRelatedKit/>
    <ns0:descriptionLine1>Stationery </ns0:descriptionLine1>
    <ns0:orderSuffix>000</ns0:orderSuffix>
    <ns0:identifier2ndItem>392-00 </ns0:identifier2ndItem>
   </ns0:result>
   <ns0:result
     xsi:type="ns0:F4311_Output">
    <ns0:companyKeyOrderNo>00001</ns0:companyKeyOrderNo>
    <ns0:orderType>OH</ns0:orderType>
    <ns0:documentOrderInvoiceE>6255</ns0:documentOrderInvoiceE>
    <ns0:lineNumber>1.000</ns0:lineNumber>
    <ns0:statusCodeLast>420</ns0:statusCodeLast>
    <ns0:costCenter> 19999</ns0:costCenter>
    <ns0:addressNumber>32773</ns0:addressNumber>
    <ns0:itemNumberRelatedKit/>
    <ns0:descriptionLine1>Stationery </ns0:descriptionLine1>
    <ns0:orderSuffix>000</ns0:orderSuffix>
    <ns0:identifier2ndItem>392-00 </ns0:identifier2ndItem>
   </ns0:result>
   <ns0:result
     xsi:type="ns0:F4311_Output">
    <ns0:companyKeyOrderNo>00001</ns0:companyKeyOrderNo>
    <ns0:orderType>OH</ns0:orderType>
    <ns0:documentOrderInvoiceE>6244</ns0:documentOrderInvoiceE>
    <ns0:lineNumber>1.000</ns0:lineNumber>
    <ns0:statusCodeLast>280</ns0:statusCodeLast>
    <ns0:costCenter> 19999</ns0:costCenter>
    <ns0:addressNumber>32324</ns0:addressNumber>
    <ns0:itemNumberRelatedKit/>
    <ns0:descriptionLine1>Printing </ns0:descriptionLine1>
    <ns0:orderSuffix>000</ns0:orderSuffix>
    <ns0:identifier2ndItem>390-00 </ns0:identifier2ndItem>
   </ns0:result>
  </ans1:getF4311ResponseElement>
 </env:Body>
</env:Envelope>

Open in new window

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

Accepted Solution

by:
Geert Bormans earned 500 total points
ID: 24430078
Some tools give you unpredictable prefixes for their namespaces, but you should not worry,
prefixes can be replaced by your own, as you see in this example
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet 
    xmlns:xsl="http://www.w3.org/1999/XSL/Transform" 
    version="1.0"
    xmlns:env="http://schemas.xmlsoap.org/soap/envelope/"
    xmlns:xsd="http://www.w3.org/2001/XMLSchema"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:otyp="http://oracle.e1.bssv.JPF43111/types/"
    xmlns:ans1="http://oracle.e1.bssv.JPF43111/"
    >
    
    <xsl:template match="env:Envelope">
        <html>
            <body>
                <table border="1">
                    <tr>
                        <xsl:for-each select="//otyp:result[1]/*">
                            <th>
                                <xsl:value-of select="local-name()"/>
                            </th>
                        </xsl:for-each>
                    </tr>
                    <xsl:apply-templates select="//otyp:result"></xsl:apply-templates>
                 </table>
            </body>
        </html>
    </xsl:template>
    
    <xsl:template match="otyp:result">
        <tr>
            <xsl:for-each select="*">
                <td>
                    <xsl:value-of select="."/>
                </td>
            </xsl:for-each>
        </tr>
    </xsl:template>
    
 
</xsl:stylesheet>

Open in new window

0
 

Author Comment

by:kennysflau
ID: 24437380
Thanks

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

Expert Comment

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

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

What exactly do you want to achiev from this question? I can transform this XML into XSL-FO, but what do you learn then?
0
Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

 

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: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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

Suggested Solutions

Title # Comments Views Activity
Extract XML Data from using TSQL 5 58
Formatting issues in XSL FO 3 44
Xsl-fo show PDF when no results are returned 2 20
write xml in vb.net 2 32
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
JavaScript has plenty of pieces of code people often just copy/paste from somewhere but never quite fully understand. Self-Executing functions are just one good example that I'll try to demystify here.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
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…

789 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