DBA Data[Home] [Help]

APPS.AR_GTA_ARTRX_PROC dependencies on XMLAGG

Line 659: xmlagg(xmlelement("Invoice",

655: FROM dual;
656:
657: -- generate the xmltype for failed inv
658: SELECT XMLElement("Invoices",
659: xmlagg(xmlelement("Invoice",
660: xmlforest(seq AS "sequence",
661: Transaction_Num AS
662: "TransactionNum",
663: Transaction_Type AS

Line 676: xmlagg(xmlelement("Invoice",

672: WHERE SUCCEEDED = 'N';
673:
674: -- generate the xmltype for warning inv
675: SELECT XMLElement("Invoices",
676: xmlagg(xmlelement("Invoice",
677: xmlforest(seq AS "sequence",
678: Transaction_Num AS
679: "TransactionNum",
680: Transaction_Type AS

Line 693: xmlagg(xmlelement("Invoice",

689: WHERE SUCCEEDED = 'W';
690:
691: --generate the xmltype for succ inv
692: SELECT XMLElement("Invoices",
693: xmlagg(xmlelement("Invoice",
694: xmlforest(SEQ AS "sequence",
695: Transaction_Num AS
696: "TransactionNum",
697: Transaction_Type AS