DBA Data[Home] [Help]

APPS.JMF_GTA_REPORTS_PKG dependencies on XMLAGG

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"