Line 391: , Xmlagg(Xmlelement("GTInvoice",Xmlforest
387:
388: -- get GT invoices XML data for a given ar transaction
389: SELECT Xmlelement("GTInvoices",
390: Xmlconcat(Xmlelement("Count",l_count) 391: , Xmlagg(Xmlelement("GTInvoice",Xmlforest 392: ( Gt_Invoice_Number AS "InvoiceNo"
393: , jmf_gta_trx_util.To_Xsd_Date_String(Gt_Invoice_Date) AS "Date"
394: , Bill_To_Customer_Name AS "Customer"
395: , Gt_Invoice_Net_Amount AS "Amount"