This discussion is archived
0 Replies Latest reply: Mar 15, 2013 12:29 AM by 997086 RSS

Need writing good XQuery

997086 Newbie
Currently Being Moderated
Hi all,
I am kirankumar. i have written following xquery in assign activity in osb .to get better performance what i have to do in the following xquery.

Please tell me asap.because i am working on this xquery.today i nedd to finish this.
if want talk with me to resolve this please give me a missed call to this number(+91-9742672532) and i am unable to lunderstanding for let where if line return in XQuery.
Please give me the guidence to learn quickly.


<ns4:ApInvoicesInterfaceCollection xmlns:ns4="http://xmlns.oracle.com/pcbpel/adapter/db/top/CreatePayableInvoiceGFSStageEbiz">
<ns4:ApInvoicesInterface>
<ns4:invoiceNum> {$body/v2:CreatePayableInvoiceEBM/v2:DataArea/v2:CreatePayableInvoice/v21:Identification/v21:AlternateObjectKey[v21:ContextID = 'SOURCE_INVOICE_NUMBER']/v21:ID/text()} </ns4:invoiceNum>
<ns4:docCategoryCode> {$body/v2:CreatePayableInvoiceEBM/v2:DataArea/v2:CreatePayableInvoice/v21:Identification/v21:AlternateObjectKey[v21:ContextID = 'DOC_CATEGORY_CODEv21']/v21:ID/text()} </ns4:docCategoryCode>
<ns4:taxationCountry> {$body/v2:CreatePayableInvoiceEBM/v2:DataArea/v2:CreatePayableInvoice/v21:Identification/v21:AlternateObjectKey[v21:ContextID = 'TAXATION_COUNTRY']/v21:ID/text()} </ns4:taxationCountry>
<ns4:awtGroupName> {$body/v2:CreatePayableInvoiceEBM/v2:DataArea/v2:CreatePayableInvoice/v21:Identification/v21:AlternateObjectKey[v21:ContextID = 'AWT_GROUP_NAME']/v21:ID/text()} </ns4:awtGroupName>
<ns4:payAwtGroupName> {$body/v2:CreatePayableInvoiceEBM/v2:DataArea/v2:CreatePayableInvoice/v21:Identification/v21:AlternateObjectKe[v21:ContextID = 'PAY_AWT_GROUP_NAME']/v21:ID/text()} </ns4:payAwtGroupName>
<ns4:requesterEmployeeNum> {$body/v2:CreatePayableInvoiceEBM/v2:DataArea/v2:CreatePayableInvoice/v21:Identification/v21:AlternateObjectKey[v21:ContextID = 'REQUESTER_EMPLOYEE_NUM']/v21:ID/text()} </ns4:requesterEmployeeNum>
<ns4:orgId> { $body/v2:CreatePayableInvoiceEBM/v2:DataArea/v2:CreatePayableInvoice/v21:Identification/v21:AlternateObjectKey[v21:ContextID = 'GFS_ORGANIZATION_ID']/v21:ID/text()} </ns4:orgId>
<ns4:groupId> {$body/v2:CreatePayableInvoiceEBM/v2:DataArea/v2:CreatePayableInvoice/v21:Identification/v21:AlternateObjectKey[v21:ContextID = 'PROCESS_GROUP_ID']/v21:ID/text()} </ns4:groupId>
<ns4:source> {$body/v2:CreatePayableInvoiceEBM/v2:DataArea/v2:CreatePayableInvoice/v2:SourceCode/text()} </ns4:source>
<ns4:invoiceDate> {$body/v2:CreatePayableInvoiceEBM/v2:DataArea/v2:CreatePayableInvoice/v2:InvoiceDateTime/text()} </ns4:invoiceDate>
<ns4:invoiceTypeLookupCode> {$body/v2:CreatePayableInvoiceEBM/v2:DataArea/v2:CreatePayableInvoice/v2:TypeCode/text()} </ns4:invoiceTypeLookupCode>
<ns4:description> { $body/v2:CreatePayableInvoiceEBM/v2:DataArea/v2:CreatePayableInvoice/v2:Description/text()} </ns4:description>
<ns4:invoiceAmount> {$body/v2:CreatePayableInvoiceEBM/v2:DataArea/v2:CreatePayableInvoice/v2:TotalAmount/text()} </ns4:invoiceAmount>
<ns4:paymentMethodCode> {$body/v2:CreatePayableInvoiceEBM/v2:DataArea/v2:CreatePayableInvoice/v2:PaymentMethodCode/text()} </ns4:paymentMethodCode>
<ns4:paymentMethodLookupCode> {$body/v2:CreatePayableInvoiceEBM/v2:DataArea/v2:CreatePayableInvoice/v21:PaymentTerm/v21:TypeCode/text()} </ns4:paymentMethodLookupCode>
<ns4:termsName> {$body/v2:CreatePayableInvoiceEBM/v2:DataArea/v2:CreatePayableInvoice/v21:PaymentTerm/v21:Code/text()}</ns4:termsName>
<ns4:glDate> {$body/v2:CreatePayableInvoiceEBM/v2:DataArea/v2:CreatePayableInvoice/v21:PaymentTerm/v21:EffectiveDateTime/text()}</ns4:glDate>
<ns4:termsDate> {$body/v2:CreatePayableInvoiceEBM/v2:DataArea/v2:CreatePayableInvoice/v21:PaymentTerm/v21:DueDateTime/text()} </ns4:termsDate>
<ns4:invoiceCurrencyCode> {$body/v2:CreatePayableInvoiceEBM/v2:DataArea/v2:CreatePayableInvoice/v21:CurrencyExchange/v21:SourceCurrencyCode/text()} </ns4:invoiceCurrencyCode>
<ns4:paymentCurrencyCode> {$body/v2:CreatePayableInvoiceEBM/v2:DataArea/v2:CreatePayableInvoice/v21:CurrencyExchange/v21:TargetCurrencyCode/text()} </ns4:paymentCurrencyCode>
<ns4:exchangeRate> {$body/v2:CreatePayableInvoiceEBM/v2:DataArea/v2:CreatePayableInvoice/v21:CurrencyExchange/v21:ConversionRate/text()} </ns4:exchangeRate>
<ns4:exchangeRateType> {$body/v2:CreatePayableInvoiceEBM/v2:DataArea/v2:CreatePayableInvoice/v21:CurrencyExchange/v21:ConversionTypeCode/text()} </ns4:exchangeRateType>
<ns4:exchangeDate> {$body/v2:CreatePayableInvoiceEBM/v2:DataArea/v2:CreatePayableInvoice/v21:CurrencyExchange/v21:ConversionRateDateTime/text()} </ns4:exchangeDate>
<ns4:vendorNum> {$body/v2:CreatePayableInvoiceEBM/v2:DataArea/v2:CreatePayableInvoice/v21:SupplierPartyReference/v21:PartyIdentification/v21:AlternateObjectKey/v21:ID/text()} </ns4:vendorNum>
<ns4:vendorName> {$body/v2:CreatePayableInvoiceEBM/v2:DataArea/v2:CreatePayableInvoice/v21:SupplierPartyReference/v21:OrganizationName/text()}</ns4:vendorName>
<ns4:vendorSiteCode> {$body/v2:CreatePayableInvoiceEBM/v2:DataArea/v2:CreatePayableInvoice/v21:SupplierPartyReference/v21:LocationReference/v21:LocationIdentification/v21:AlternateObjectKey/v21:ID/text()} </ns4:vendorSiteCode>
<ns4:poNumber> {$body/v2:CreatePayableInvoiceEBM/v2:DataArea/v2:CreatePayableInvoice/v21:PurchaseOrderReference/v21:Identification/v21:AlternateObjectKey/v21:ID/text()} </ns4:poNumber>
<ns4:voucherNum> {$body/v2:CreatePayableInvoiceEBM/v2:DataArea/v2:CreatePayableInvoice/v21:PurchaseOrderReference/v21:Identification/v21:AlternateObjectKey/v21:ID/text()} </ns4:voucherNum>
<ns4:legalEntityName> {$body/v2:CreatePayableInvoiceEBM/v2:DataArea/v2:CreatePayableInvoice/v21:LegalEntityReference/v21:LegalEntityIdentification/v21:AlternateObjectKey/v21:ID/text()} </ns4:legalEntityName>
</ns4:ApInvoicesInterface>
<ns4:ApInvoiceLinesInterface>
<ns4:lineNumber> {$body/v2:CreatePayableInvoiceEBM/v2:DataArea/v2:CreatePayableInvoice/v2:PayableInvoiceLine/v21:Identification/v21:AlternateObjectKey/v21:ID/text()}</ns4:lineNumber>
<ns4:reference1> {$body/v2:CreatePayableInvoiceEBM/v2:DataArea/v2:CreatePayableInvoice/v2:PayableInvoiceLine/v21:Identification/v21:AlternateObjectKey/v21:ID/text()} </ns4:reference1>
<ns4:accountingDate> {$body/v2:CreatePayableInvoiceEBM/v2:DataArea/v2:CreatePayableInvoice/v2:PayableInvoiceLine/v21:Identification/v21:AlternateObjectKey/v21:ID/text()} </ns4:accountingDate>
<ns4:lineTypeLookupCode> {$body/v2:CreatePayableInvoiceEBM/v2:DataArea/v2:CreatePayableInvoice/v2:PayableInvoiceLine/v2:TypeCode/text ()} </ns4:lineTypeLookupCode>
<ns4:description> {$body/v2:CreatePayableInvoiceEBM/v2:DataArea/v2:CreatePayableInvoice/v2:PayableInvoiceLine/v2:Description/text()} </ns4:description>
<ns4:amount> {$body/v2:CreatePayableInvoiceEBM/v2:DataArea/v2:CreatePayableInvoice/v2:PayableInvoiceLine/v2:TotalAmount/text()} </ns4:amount>
<ns4:accountSegment> {$body/v2:CreatePayableInvoiceEBM/v2:DataArea/v2:CreatePayableInvoice/v2:PayableInvoiceLine/v2:PayableInvoiceLineAccountingDistribution/v21:Identification/v21:AlternateObjectKey/v21:ID/text()} </ns4:accountSegment>
<ns4:costCenterSegment> {$body/v2:CreatePayableInvoiceEBM/v2:DataArea/v2:CreatePayableInvoice/v2:PayableInvoiceLine/v2:PayableInvoiceLineAccountingDistribution/v21:AccountingDistribution/v21:CostCenterCode/text()} </ns4:costCenterSegment>
<ns4:taxCode> {$body/v2:CreatePayableInvoiceEBM/v2:DataArea/v2:CreatePayableInvoice/v2:PayableInvoiceLine/v2:PayableInvoiceLineTax/v21:Tax/text()}</ns4:taxCode>
</ns4:ApInvoiceLinesInterface>
</ns4:ApInvoicesInterfaceCollection>

Thanks,
Kiran Kumar.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points