<?xml version = '1.0' encoding = 'utf-8'?>
<DATA_DS>
<P_AIW>[1000,5000,9000,12000]</P_AIW>
<getAmt>
<return><amount>1000</amount>
<amountAr> آلف درهم إماراتى</amountAr>
</return>
<return><amount>5000</amount>
<amountAr>خمسة الآف درهم إماراتى</amountAr>
</return>
<return><amount>9000</amount>
<amountAr>تسعة الآف درهم إماراتى</amountAr>
</return>
<return><amount>12000</amount>
<amountAr>إثناعشر آلف درهم إماراتى</amountAr>
</return>
</getAmt>
<DATA_DS>
<G_PAYMENT_VOUCHER>
<ORG_ID>3000</ORG_ID><INVOICE_NUM>Invoice #1</INVOICE_NUM><PAYMENT_CURRENCY_CODE>AED</PAYMENT_CURRENCY_CODE><INVOICE_AMOUNT>1000</INVOICE_AMOUNT>
</G_PAYMENT_VOUCHER>
<G_PAYMENT_VOUCHER>
<ORG_ID>3000</ORG_ID><INVOICE_NUM>Invoice #2</INVOICE_NUM><PAYMENT_CURRENCY_CODE>AED</PAYMENT_CURRENCY_CODE><INVOICE_AMOUNT>5000</INVOICE_AMOUNT>
<G_PAYMENT_VOUCHER>
<G_PAYMENT_VOUCHER>
<ORG_ID>3000</ORG_ID><INVOICE_NUM>Invoice #3</INVOICE_NUM><PAYMENT_CURRENCY_CODE>AED</PAYMENT_CURRENCY_CODE><INVOICE_AMOUNT>9000</INVOICE_AMOUNT>
</G_PAYMENT_VOUCHER>
<G_PAYMENT_VOUCHER>
<ORG_ID>3000</ORG_ID><INVOICE_NUM>Invoice #4</INVOICE_NUM><PAYMENT_CURRENCY_CODE>AED</PAYMENT_CURRENCY_CODE><INVOICE_AMOUNT>12000</INVOICE_AMOUNT>
</G_PAYMENT_VOUCHER>
</DATA_DS>
</DATA_DS>
RTF template
<?xdoxslt:set_variable($_XDOCTX,
‘inv_amt2’, 0)?>
BU_NAME
|
INVOICE_NUM
|
Arabic
|
INVOICE_AMOUNT
|
<?xdoxslt:set_variable($_XDOCTX, 'inv_amt2', INVOICE_AMOUNT)?>
|
F1 <?for-each:G_PAYMENT_VOUCHER?>
F2 <?for-each://getAmt/return?>
E1 <?end for-each?>
E2 <?end for-each?>
if@inlines is used to suppress spaces or line breaks created by for-each loop
Oracle Apps R12 and Fusion Cloud Self Paced Training Videos Published on Udemy with Live Meeting Support. Please Check https://www.oracleappstechnical.com
ReplyDelete