View: IBY_PMT_FAILED_DOCS_XML_V

Product:	IBY - Payments
Description:
Implementation/DBA Data:	APPS.IBY_PMT_FAILED_DOCS_XML_V

View Text

SELECT XMLCONCAT( XMLELEMENT("DOCUMENTGROUP"
, XMLELEMENT("FNDAPPLICATIONID"
, REQ.CALLING_APP_ID)
, XMLAGG( XMLELEMENT("REJECTEDDOCUMENTS"
, XMLFOREST( DOCS.PAY_PROC_TRXN_TYPE_CODE AS "PAYMENTPROCESSTRXNTYPECODE"
, REQ.CALLING_APP_ID AS "CALLINGAPPID"
, DOCS.CALLING_APP_DOC_UNIQUE_REF1 AS "CALLINGAPPDOCUNIQUEREF1"
, DOCS.CALLING_APP_DOC_UNIQUE_REF2 AS "CALLINGAPPDOCUNIQUEREF2"
, DOCS.CALLING_APP_DOC_UNIQUE_REF3 AS "CALLINGAPPDOCUNIQUEREF3"
, DOCS.CALLING_APP_DOC_UNIQUE_REF4 AS "CALLINGAPPDOCUNIQUEREF4"
, DOCS.CALLING_APP_DOC_UNIQUE_REF5 AS "CALLINGAPPDOCUNIQUEREF5" ) ) ) ) )
, REQ.CALLING_APP_ID
, PMTS.PAYMENT_ID
, PMTS.PAYMENT_STATUS
, REQ.PAYMENT_SERVICE_REQUEST_ID
, REQ.PAYMENT_SERVICE_REQUEST_STATUS
FROM IBY_DOCS_PAYABLE_ALL DOCS
, IBY_PAYMENTS_ALL PMTS
, IBY_PAY_SERVICE_REQUESTS REQ
WHERE REQ.PAYMENT_SERVICE_REQUEST_ID = DOCS.PAYMENT_SERVICE_REQUEST_ID
AND DOCS.PAYMENT_SERVICE_REQUEST_ID = PMTS.PAYMENT_SERVICE_REQUEST_ID
AND DOCS.PAYMENT_ID = PMTS.PAYMENT_ID
AND DOCS.DOCUMENT_STATUS != 'PAYMENTS_CREATED' GROUP BY REQ.CALLING_APP_ID
, PMTS.PAYMENT_ID
, PMTS.PAYMENT_STATUS
, REQ.PAYMENT_SERVICE_REQUEST_ID
, REQ.PAYMENT_SERVICE_REQUEST_STATUS

Columns